471: select pay_assignment_actions_s.nextval
472: into lockingactid
473: from dual;
474:
475: hr_nonrun_asact.insact(lockingactid,
476: l_asg_id,
477: pactid,
478: chunk,
479: l_pre_org_id);
478: chunk,
479: l_pre_org_id);
480:
481: hr_utility.trace('in if loop after calling '||
482: 'hr_nonrun_asact.insact pkg 9 '||to_char(l_asg_id));
483:
484: /* Added this to implement RL1 Register and RL1 Amendment Register
485: using the same report file */
486: lv_serial_number := 'QC' ||lpad(to_char(ln_arch_asgact_id),14,0)||
592: select pay_assignment_actions_s.nextval
593: into lockingactid
594: from dual;
595:
596: hr_nonrun_asact.insact(lockingactid,
597: l_asg_id,
598: pactid,
599: chunk,
600: l_pre_org_id);
598: pactid,
599: chunk,
600: l_pre_org_id);
601: hr_utility.trace('in if loop after calling '||
602: 'hr_nonrun_asact.insact pkg 11 '||to_char(lockingactid));
603:
604: /* Added this to implement RL1 Register and RL1 Amendment Register
605: using the same report file */
606: lv_serial_number := 'QC' ||lpad(to_char(ln_arch_asgact_id),14,0)||