650: SELECT pay_assignment_actions_s.nextval
651: INTO lockingactid
652: FROM dual;
653: hr_utility.set_location(l_proc_name,125);
654: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
655:
656: hr_utility.set_location(l_proc_name,130);
657: hr_nonrun_asact.insint(lockingactid,lockedactid);
658:
653: hr_utility.set_location(l_proc_name,125);
654: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
655:
656: hr_utility.set_location(l_proc_name,130);
657: hr_nonrun_asact.insint(lockingactid,lockedactid);
658:
659: hr_utility.set_location(l_proc_name,135);
660: OPEN c_payroll_run (lockedactid);
661: FETCH c_payroll_run INTO ln_master_action_id,lv_run_action_type;
693: INTO lockingactid
694: FROM dual;
695: hr_utility.set_location(l_proc_name,152);
696:
697: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
698:
699: hr_utility.set_location(l_proc_name,153);
700: -- #16364431 End
701: /**************************************************************
701: /**************************************************************
702: ** we need to insert one action for each of the rows that we
703: ** return from the cursor (i.e. one for each assignment/pre-payment source).
704: **************************************************************/
705: hr_nonrun_asact.insint(lockingactid,lockedactid);
706:
707: hr_utility.set_location(l_proc_name,155);
708: serialno := actiontype || to_char(ln_source_action_id);
709: -- update pay_assignment_actions serial_number with runactid.
740: INTO lockingactid
741: FROM dual;
742: hr_utility.set_location(l_proc_name,180);
743: -- insert the action record.
744: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
745:
746: hr_utility.set_location(l_proc_name,190);
747: -- insert an interlock to this action.
748: hr_nonrun_asact.insint(lockingactid,lockedactid);
744: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
745:
746: hr_utility.set_location(l_proc_name,190);
747: -- insert an interlock to this action.
748: hr_nonrun_asact.insint(lockingactid,lockedactid);
749: hr_utility.set_location(l_proc_name,200);
750:
751: BEGIN
752: hr_utility.set_location(l_proc_name,205);