316: from dual;
317:
318: hr_utility.set_location(l_procedure_name, 30);
319: -- insert the action record.
320: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
321:
322: /* update pay_assignment_actions with the year end assignment_actions into serial number
323: this might help in faster processing at report level and avoid some joins */
324:
328:
329:
330: -- insert an interlock to this action.
331: -- Bug fix 1850043
332: -- hr_nonrun_asact.insint(lockingactid,lockedactid);
333:
334: -- end if;
335:
336: end loop;
519: into lockingactid
520: from dual;
521:
522: -- insert the action record.
523: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
524:
525: update pay_assignment_actions
526: set serial_number = lockedactid
527: where assignment_action_id = lockingactid;
558: into lockingactid
559: from dual;
560:
561: -- insert the action record.
562: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
563:
564: /* update pay_assignment_actions with the year end assignment_actions into serial number
565: this might help in faster processing at report level and avoid some joins */
566:
570:
571:
572: -- insert an interlock to this action.
573: -- Bug fix 1850043
574: -- hr_nonrun_asact.insint(lockingactid,lockedactid);
575:
576: -- end if;
577:
578: end loop;