APPS.PAY_PAYACT_PKG dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 755: select pay_assignment_actions_s.nextval

751:
752: If ass_flag = 'Y' then
753:
754: hr_utility.set_location('procpyr',3);
755: select pay_assignment_actions_s.nextval
756: into lockingactid
757: from dual;
758:
759: -- insert the action record.

Line 769: select pay_assignment_actions_s.nextval

765: End if;
766: else
767:
768: hr_utility.set_location('procpyr',30);
769: select pay_assignment_actions_s.nextval
770: into lockingactid
771: from dual;
772:
773: -- insert the action record.

Line 826: select pay_assignment_actions_s.nextval

822:
823: If ass_flag = 'Y' then
824:
825: hr_utility.set_location('procpyr',3);
826: select pay_assignment_actions_s.nextval
827: into lockingactid
828: from dual;
829:
830: -- insert the action record.

Line 839: select pay_assignment_actions_s.nextval

835:
836: end if;
837: else
838: hr_utility.set_location('procpyr',3);
839: select pay_assignment_actions_s.nextval
840: into lockingactid
841: from dual;
842:
843: -- insert the action record.

Line 895: select pay_assignment_actions_s.nextval

891:
892: If ass_flag = 'Y' then
893:
894: hr_utility.set_location('procpyr',3);
895: select pay_assignment_actions_s.nextval
896: into lockingactid
897: from dual;
898:
899: -- insert the action record.

Line 908: select pay_assignment_actions_s.nextval

904:
905: end if;
906: else
907: hr_utility.set_location('procpyr',3);
908: select pay_assignment_actions_s.nextval
909: into lockingactid
910: from dual;
911:
912: -- insert the action record.

Line 964: select pay_assignment_actions_s.nextval

960:
961: If ass_flag = 'Y' then
962:
963: hr_utility.set_location('procpyr',3);
964: select pay_assignment_actions_s.nextval
965: into lockingactid
966: from dual;
967:
968: -- insert the action record.

Line 977: select pay_assignment_actions_s.nextval

973:
974: end if;
975: else
976: hr_utility.set_location('procpyr',3);
977: select pay_assignment_actions_s.nextval
978: into lockingactid
979: from dual;
980:
981: -- insert the action record.

Line 1035: select pay_assignment_actions_s.nextval

1031:
1032: If ass_flag = 'Y' then
1033:
1034: hr_utility.set_location('procpyr',3);
1035: select pay_assignment_actions_s.nextval
1036: into lockingactid
1037: from dual;
1038:
1039: -- insert the action record.

Line 1049: select pay_assignment_actions_s.nextval

1045: end if;
1046: else
1047:
1048: hr_utility.set_location('procpyr',3);
1049: select pay_assignment_actions_s.nextval
1050: into lockingactid
1051: from dual;
1052:
1053: -- insert the action record.

Line 1107: select pay_assignment_actions_s.nextval

1103:
1104: If ass_flag = 'Y' then
1105:
1106: hr_utility.set_location('procpyr',3);
1107: select pay_assignment_actions_s.nextval
1108: into lockingactid
1109: from dual;
1110:
1111: -- insert the action record.

Line 1121: select pay_assignment_actions_s.nextval

1117: end if;
1118: else
1119:
1120: hr_utility.set_location('procpyr',3);
1121: select pay_assignment_actions_s.nextval
1122: into lockingactid
1123: from dual;
1124: --
1125: -- insert the action record.

Line 1178: select pay_assignment_actions_s.nextval

1174:
1175: If ass_flag = 'Y' then
1176:
1177: hr_utility.set_location('procpyr',3);
1178: select pay_assignment_actions_s.nextval
1179: into lockingactid
1180: from dual;
1181:
1182: -- insert the action record.

Line 1190: select pay_assignment_actions_s.nextval

1186: hr_nonrun_asact.insint(lockingactid,lockedactid);
1187: end if;
1188: else
1189: hr_utility.set_location('procpyr',3);
1190: select pay_assignment_actions_s.nextval
1191: into lockingactid
1192: from dual;
1193:
1194: -- insert the action record.

Line 1249: select pay_assignment_actions_s.nextval

1245: -- we need to insert one action for each of the
1246: -- rows that we return from the cursor (i.e. one
1247: -- for each assignment/pre-payment/reversal).
1248: hr_utility.set_location('procpyr',3);
1249: select pay_assignment_actions_s.nextval
1250: into lockingactid
1251: from dual;
1252:
1253: -- insert the action record.

Line 1266: select pay_assignment_actions_s.nextval

1262: -- we need to insert one action for each of the
1263: -- rows that we return from the cursor (i.e. one
1264: -- for each assignment/pre-payment/reversal).
1265: hr_utility.set_location('procpyr',3);
1266: select pay_assignment_actions_s.nextval
1267: into lockingactid
1268: from dual;
1269:
1270: -- insert the action record.