575: into lockingactid
576: from dual;
577:
578: -- insert the action record.
579: hr_nonrun_asact.insact(lockingactid,
580: ln_assignment_id,
581: pactid,
582: chunk,
583: ln_tax_unit_id);
582: chunk,
583: ln_tax_unit_id);
584:
585: -- insert an interlock to this action.
586: hr_nonrun_asact.insint(lockingactid,ln_pp_aaid);
587:
588: begin
589:
590: serialno := nvl(lv_run_action_type,'R') ||
709: hr_utility.trace('B4 insact'||to_char(lockingactid) ||','||
710: to_char(greid)||','||actiontype||','||to_char(runactid) );
711:
712: -- insert the action record.
713: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
714: hr_utility.trace('A4 insact'||to_char(lockingactid) ||','||
715: to_char(greid)||','||actiontype||','||to_char(runactid) );
716:
717: -- insert an interlock to this action.
714: hr_utility.trace('A4 insact'||to_char(lockingactid) ||','||
715: to_char(greid)||','||actiontype||','||to_char(runactid) );
716:
717: -- insert an interlock to this action.
718: hr_nonrun_asact.insint(lockingactid,lockedactid);
719:
720: begin
721: --serialno := 'V'||to_char(runactid);
722: serialno := actiontype || 'NN' || to_char(lockedactid);