680: select pay_assignment_actions_s.nextval
681: into lockingactid
682: from dual;
683:
684: hr_nonrun_asact.insact(lockingactid,
685: -- l_asg_id, -- commented by sneelapa, for bug 7572889
686: l_primary_asg,
687: pactid,
688: chunk,
688: chunk,
689: l_pre_org_id);
690:
691: hr_utility.trace('in if loop after calling '||
692: 'hr_nonrun_asact.insact pkg 9 '||to_char(l_asg_id));
693:
694: /* Added this to implement RL1 Register and RL1 Amendment Register
695: using the same report file */
696: lv_serial_number := 'QC' ||lpad(to_char(ln_arch_asgact_id),14,0)||
869: select pay_assignment_actions_s.nextval
870: into lockingactid
871: from dual;
872:
873: hr_nonrun_asact.insact(lockingactid,
874: -- l_asg_id, -- commented by sneelapa, for bug 7572889
875: l_primary_asg,
876: pactid,
877: chunk,
876: pactid,
877: chunk,
878: l_pre_org_id);
879: hr_utility.trace('in if loop after calling '||
880: 'hr_nonrun_asact.insact pkg 11 '||to_char(lockingactid));
881:
882: /* Added this to implement RL1 Register and RL1 Amendment Register
883: using the same report file */
884: lv_serial_number := 'QC' ||lpad(to_char(ln_arch_asgact_id),14,0)||