APPS.PAY_PAYRG_PKG dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 749: select pay_assignment_actions_s.nextval

745: fetch c_payments into runactid;
746: exit when c_payments%NOTFOUND;
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.

Line 766: -- update pay_assignment_actions serial_number with runactid.

762: lv_sep_check ||
763: lv_multi_asg_flag ||
764: to_char(runactid);
765:
766: -- update pay_assignment_actions serial_number with runactid.
767:
768: update pay_assignment_actions
769: set serial_number = serialno
770: where assignment_action_id = lockingactid

Line 826: select pay_assignment_actions_s.nextval

822: fetch c_multi_asg_acts into runactid;
823:
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.

Line 860: -- update pay_assignment_actions serial_number with runactid.

856: lv_sep_check ||
857: lv_multi_asg_flag ||
858: to_char(l_asg_act_id);
859:
860: -- update pay_assignment_actions serial_number with runactid.
861:
862: update pay_assignment_actions
863: set serial_number = serialno
864: where assignment_action_id = lockingactid

Line 883: -- update pay_assignment_actions serial_number with runactid.

879: lv_sep_check ||
880: lv_multi_asg_flag ||
881: to_char(runactid);
882:
883: -- update pay_assignment_actions serial_number with runactid.
884:
885: update pay_assignment_actions
886: set serial_number = serialno
887: where assignment_action_id = lockingactid

Line 928: select pay_assignment_actions_s.nextval

924: end if; -- source action id is null
925:
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) );

Line 944: -- update pay_assignment_actions serial_number with runactid.

940:
941: begin
942: --serialno := 'V'||to_char(runactid);
943: serialno := actiontype || 'NN' || to_char(lockedactid);
944: -- update pay_assignment_actions serial_number with runactid.
945: update pay_assignment_actions
946: set serial_number = serialno
947: where assignment_action_id = lockingactid
948: and tax_unit_id = greid;

Line 1010: select pay_assignment_actions_s.nextval

1006: -- we have a zero net pay pre-pay assignment_action
1007: -- insert one row for the action creation.
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.

Line 1043: -- update pay_assignment_actions serial_number with runactid.

1039: lv_sep_check ||
1040: 'N' || -- multi_asg_flag
1041: to_char(runactid);
1042:
1043: -- update pay_assignment_actions serial_number with runactid.
1044:
1045: update pay_assignment_actions
1046: set serial_number = serialno
1047: where assignment_action_id = lockingactid

Line 1090: select pay_assignment_actions_s.nextval

1086: ln_source_action_id <> ln_prev_source_action_id or
1087: ln_source_action_id = -999) then
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';

Line 1110: -- update pay_assignment_actions serial_number with runactid.

1106: lv_sep_check ||
1107: 'N' || -- multi_asg_flag
1108: to_char(runactid);
1109:
1110: -- update pay_assignment_actions serial_number with runactid.
1111:
1112: update pay_assignment_actions
1113: set serial_number = serialno
1114: where assignment_action_id = lockingactid

Line 1164: -- update pay_assignment_actions serial_number with runactid.

1160: lv_sep_check ||
1161: 'N' || -- multi_asg_flag
1162: to_char(runactid);
1163:
1164: -- update pay_assignment_actions serial_number with runactid.
1165:
1166: update pay_assignment_actions
1167: set serial_number = serialno
1168: where assignment_action_id = lockingactid

Line 1207: select pay_assignment_actions_s.nextval

1203: close c_payment_info;
1204:
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) );

Line 1223: -- update pay_assignment_actions serial_number with runactid.

1219:
1220: begin
1221: --serialno := 'V'||to_char(runactid);
1222: serialno := actiontype || 'NN' || to_char(lockedactid);
1223: -- update pay_assignment_actions serial_number with runactid.
1224: update pay_assignment_actions
1225: set serial_number = serialno
1226: where assignment_action_id = lockingactid
1227: and tax_unit_id = greid;