APPS.PAY_MX_PAYREG_PKG dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 650: SELECT pay_assignment_actions_s.nextval

646: FETCH c_payment_info INTO ln_source_action_id;
647: EXIT WHEN c_payment_info%NOTFOUND;
648: IF ln_source_action_id = -999 THEN
649: hr_utility.set_location(l_proc_name,120);
650: SELECT pay_assignment_actions_s.nextval
651: INTO lockingactid
652: FROM dual;
653: hr_utility.set_location(l_proc_name,125);
654: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);

Line 665: -- update pay_assignment_actions serial_number with runactid.

661: FETCH c_payroll_run INTO ln_master_action_id,lv_run_action_type;
662: CLOSE c_payroll_run;
663:
664: serialno := lv_run_action_type || to_char(ln_master_action_id);
665: -- update pay_assignment_actions serial_number with runactid.
666: UPDATE pay_assignment_actions
667: SET serial_number = serialno
668: WHERE assignment_action_id = lockingactid
669: AND tax_unit_id = greid;

Line 692: SELECT pay_assignment_actions_s.nextval

688: hr_utility.set_location(l_proc_name,145);
689: ELSIF ln_source_action_id <> -999 THEN
690: hr_utility.set_location(l_proc_name,150);
691: -- #16364431 Start
692: SELECT pay_assignment_actions_s.nextval
693: INTO lockingactid
694: FROM dual;
695: hr_utility.set_location(l_proc_name,152);
696:

Line 709: -- update pay_assignment_actions serial_number with runactid.

705: hr_nonrun_asact.insint(lockingactid,lockedactid);
706:
707: hr_utility.set_location(l_proc_name,155);
708: serialno := actiontype || to_char(ln_source_action_id);
709: -- update pay_assignment_actions serial_number with runactid.
710: UPDATE pay_assignment_actions
711: SET serial_number = serialno
712: WHERE assignment_action_id = lockingactid
713: AND tax_unit_id = greid;

Line 739: SELECT pay_assignment_actions_s.nextval

735: END LOOP;
736: CLOSE c_payment_info;
737: ELSE -- This is a void action.
738: hr_utility.set_location(l_proc_name,175);
739: SELECT pay_assignment_actions_s.nextval
740: INTO lockingactid
741: FROM dual;
742: hr_utility.set_location(l_proc_name,180);
743: -- insert the action record.

Line 754: -- update pay_assignment_actions serial_number with runactid.

750:
751: BEGIN
752: hr_utility.set_location(l_proc_name,205);
753: serialno := actiontype || to_char(lockedactid);
754: -- update pay_assignment_actions serial_number with runactid.
755: UPDATE pay_assignment_actions
756: SET serial_number = serialno
757: WHERE assignment_action_id = lockingactid
758: AND tax_unit_id = greid;