[Home] [Help]
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.
439: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
440:
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.
550: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
551:
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.
664: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
665:
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.
725: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
726:
806: close c_state_ueid;
807:
808: hr_utility.set_location(l_procedure_name, 170);
809: c_actions_with_state_sql := c_actions_with_state_sql ||
810: ' AND exists ( select 1 from dual
811: where 1 =
812: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
813: from ff_archive_items fai,
814: ff_archive_item_contexts fic1,
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.
863: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
864:
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.
972: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
973: