use DBI qw( :sql_types );

my $sth = $dbh->prepare('
    ...
');

$sth->bind_param(1, $_[1]);
$sth->bind_param(2, $hdr_tran_seq_nbr);
$sth->bind_param(3, $loader_start_time, SQL_DATETIME);
$sth->bind_param(4, $loader_start_time, SQL_DATETIME);
$sth->bind_param(5, $loader_start_time, SQL_DATETIME);
$sth->bind_param(6, $master_job_no);
$sth->bind_param(7, $_[0]);

$sth->execute();