747: if runactid is not null then -- Bug 3928632
748:
749: select pay_assignment_actions_s.nextval
750: into lockingactid
751: from dual;
752:
753: -- insert the action record.
754: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
755:
824: close c_multi_asg_acts;
825:
826: select pay_assignment_actions_s.nextval
827: into lockingactid
828: from dual;
829:
830: -- insert the action record.
831: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
832:
926: ELSE -- This is a void action.
927:
928: select pay_assignment_actions_s.nextval
929: into lockingactid
930: from dual;
931:
932: hr_utility.trace('B4 insact'||to_char(lockingactid) ||','||to_char(greid)||','||actiontype||','||to_char(runactid) );
933:
934: -- insert the action record.
1008: -- insert the action record.
1009:
1010: select pay_assignment_actions_s.nextval
1011: into lockingactid
1012: from dual;
1013:
1014: -- insert the action record.
1015: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1016:
1088:
1089: -- insert the action record.
1090: select pay_assignment_actions_s.nextval
1091: into lockingactid
1092: from dual;
1093:
1094: l_action_insert := 'Y';
1095: -- insert the action record.
1096: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1205: ELSE -- This is a void action.
1206:
1207: select pay_assignment_actions_s.nextval
1208: into lockingactid
1209: from dual;
1210:
1211: hr_utility.trace('B4 insact'||to_char(lockingactid) ||','||to_char(greid)||','||actiontype||','||to_char(runactid) );
1212:
1213: -- insert the action record.