1110: INTO lockingactid
1111: FROM dual;
1112: hr_utility.set_location(
1113: 'pay_us_magw2_reporting.create_assignement_act', 60);
1114: hr_nonrun_asact.insact(lockingactid, l_assignment_id, p_pactid,
1115: p_chunk, l_tax_unit_id);
1116: hr_utility.set_location(
1117: 'pay_us_magw2_reporting.create_assignement_act', 70);
1118: --update serial number for highly compensated people for the
1125: SET serial_number = 999999
1126: WHERE assignment_action_id = lockingactid;
1127: END IF;
1128: END IF;
1129: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
1130: hr_utility.set_location(
1131: 'pay_us_magw2_reporting.create_assignement_act', 90);
1132: hr_utility.trace('Interlock Created - ');
1133: hr_utility.trace('Locking Action : '|| to_char(lockingactid));