430: -- for each assignment/pre-payment/reversal).
431: hr_utility.set_location(l_procedure_name, 25);
432: hr_utility.trace('Before inserting the action record');
433:
434: select pay_assignment_actions_s.nextval
435: into lockingactid
436: from dual;
437:
438: -- insert the action record.
541:
542: hr_utility.set_location(l_procedure_name, 45);
543: hr_utility.trace('Before inserting the action record');
544:
545: select pay_assignment_actions_s.nextval
546: into lockingactid
547: from dual;
548:
549: -- insert the action record.
655:
656: hr_utility.set_location(l_procedure_name, 90);
657: hr_utility.trace('Before inserting the action record');
658:
659: select pay_assignment_actions_s.nextval
660: into lockingactid
661: from dual;
662:
663: -- insert the action record.
716:
717: hr_utility.set_location(l_procedure_name, 110);
718: hr_utility.trace('Before inserting the action record');
719:
720: select pay_assignment_actions_s.nextval
721: into lockingactid
722: from dual;
723:
724: -- insert the action record.
854:
855: hr_utility.set_location(l_procedure_name, 220);
856: hr_utility.trace('Before inserting the action record');
857:
858: select pay_assignment_actions_s.nextval
859: into lockingactid
860: from dual;
861:
862: -- insert the action record.
963: hr_utility.trace('Before inserting the action record');
964:
965: hr_utility.set_location('procpyr',3);
966:
967: select pay_assignment_actions_s.nextval
968: into lockingactid
969: from dual;
970:
971: -- insert the action record.