543: select pay_assignment_actions_s.nextval
544: into lockingactid
545: from dual;
546:
547: hr_nonrun_asact.insact(lockingactid,
548: l_primary_asg,
549: pactid,
550: chunk,
551: l_pre_organization_id);
549: pactid,
550: chunk,
551: l_pre_organization_id);
552:
553: hr_utility.trace('after hr_nonrun_asact.insact'||to_char(l_asg_id));
554:
555: lv_serial_number := 'QC' ||lpad(to_char(ln_arch_asgact_id),14,0)||
556: lpad(to_char(ln_arch_pact_id),14,0);
557:
721: select pay_assignment_actions_s.nextval
722: into lockingactid
723: from dual;
724:
725: hr_nonrun_asact.insact(lockingactid,
726: l_primary_asg,
727: pactid,
728: chunk,
729: l_pre_organization_id);
727: pactid,
728: chunk,
729: l_pre_organization_id);
730:
731: hr_utility.trace('after calling hr_nonrun_asact.insact '||to_char(lockingactid));
732:
733: lv_serial_number := 'QC' ||lpad(to_char(ln_arch_asgact_id),14,0)||
734: lpad(to_char(ln_arch_pact_id),14,0);
735: