[Home] [Help]
416: hr_utility.trace('Before inserting the action record');
417:
418: select pay_assignment_actions_s.nextval
419: into lockingactid
420: from dual;
421:
422: -- insert the action record.
423: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
424:
527: hr_utility.trace('Before inserting the action record');
528:
529: select pay_assignment_actions_s.nextval
530: into lockingactid
531: from dual;
532:
533: -- insert the action record.
534: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
535:
641: hr_utility.trace('Before inserting the action record');
642:
643: select pay_assignment_actions_s.nextval
644: into lockingactid
645: from dual;
646:
647: -- insert the action record.
648: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
649:
702: hr_utility.trace('Before inserting the action record');
703:
704: select pay_assignment_actions_s.nextval
705: into lockingactid
706: from dual;
707:
708: -- insert the action record.
709: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
710:
790: close c_state_ueid;
791:
792: hr_utility.set_location(l_procedure_name, 170);
793: c_actions_with_state_sql := c_actions_with_state_sql ||
794: ' AND exists ( select 1 from dual
795: where 1 =
796: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
797: from ff_archive_items fai,
798: ff_archive_item_contexts fic1,
840: hr_utility.trace('Before inserting the action record');
841:
842: select pay_assignment_actions_s.nextval
843: into lockingactid
844: from dual;
845:
846: -- insert the action record.
847: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
848:
949: hr_utility.set_location('procpyr',3);
950:
951: select pay_assignment_actions_s.nextval
952: into lockingactid
953: from dual;
954:
955: -- insert the action record.
956: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
957: