756: into lockingactid
757: from dual;
758:
759: -- insert the action record.
760: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
761:
762: -- insert an interlock to this action.
763: hr_nonrun_asact.insint(lockingactid,lockedactid);
764:
759: -- insert the action record.
760: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
761:
762: -- insert an interlock to this action.
763: hr_nonrun_asact.insint(lockingactid,lockedactid);
764:
765: End if;
766: else
767:
770: into lockingactid
771: from dual;
772:
773: -- insert the action record.
774: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
775:
776: -- insert an interlock to this action.
777: hr_nonrun_asact.insint(lockingactid,lockedactid);
778: end if;
773: -- insert the action record.
774: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
775:
776: -- insert an interlock to this action.
777: hr_nonrun_asact.insint(lockingactid,lockedactid);
778: end if;
779:
780: end loop;
781:
827: into lockingactid
828: from dual;
829:
830: -- insert the action record.
831: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
832:
833: -- insert an interlock to this action.
834: hr_nonrun_asact.insint(lockingactid,lockedactid);
835:
830: -- insert the action record.
831: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
832:
833: -- insert an interlock to this action.
834: hr_nonrun_asact.insint(lockingactid,lockedactid);
835:
836: end if;
837: else
838: hr_utility.set_location('procpyr',3);
840: into lockingactid
841: from dual;
842:
843: -- insert the action record.
844: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
845:
846: -- insert an interlock to this action.
847: hr_nonrun_asact.insint(lockingactid,lockedactid);
848: end if;
843: -- insert the action record.
844: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
845:
846: -- insert an interlock to this action.
847: hr_nonrun_asact.insint(lockingactid,lockedactid);
848: end if;
849:
850: end loop;
851: close c_bal_ini;
896: into lockingactid
897: from dual;
898:
899: -- insert the action record.
900: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
901:
902: -- insert an interlock to this action.
903: hr_nonrun_asact.insint(lockingactid,lockedactid);
904:
899: -- insert the action record.
900: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
901:
902: -- insert an interlock to this action.
903: hr_nonrun_asact.insint(lockingactid,lockedactid);
904:
905: end if;
906: else
907: hr_utility.set_location('procpyr',3);
909: into lockingactid
910: from dual;
911:
912: -- insert the action record.
913: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
914:
915: -- insert an interlock to this action.
916: hr_nonrun_asact.insint(lockingactid,lockedactid);
917: end if;
912: -- insert the action record.
913: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
914:
915: -- insert an interlock to this action.
916: hr_nonrun_asact.insint(lockingactid,lockedactid);
917: end if;
918:
919: end loop;
920: close c_bal_adj_ini;
965: into lockingactid
966: from dual;
967:
968: -- insert the action record.
969: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
970:
971: -- insert an interlock to this action.
972: hr_nonrun_asact.insint(lockingactid,lockedactid);
973:
968: -- insert the action record.
969: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
970:
971: -- insert an interlock to this action.
972: hr_nonrun_asact.insint(lockingactid,lockedactid);
973:
974: end if;
975: else
976: hr_utility.set_location('procpyr',3);
978: into lockingactid
979: from dual;
980:
981: -- insert the action record.
982: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
983:
984: -- insert an interlock to this action.
985: hr_nonrun_asact.insint(lockingactid,lockedactid);
986:
981: -- insert the action record.
982: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
983:
984: -- insert an interlock to this action.
985: hr_nonrun_asact.insint(lockingactid,lockedactid);
986:
987: end if;
988: end loop;
989: close c_run;
1036: into lockingactid
1037: from dual;
1038:
1039: -- insert the action record.
1040: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1041:
1042: -- insert an interlock to this action.
1043: hr_nonrun_asact.insint(lockingactid,lockedactid);
1044:
1039: -- insert the action record.
1040: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1041:
1042: -- insert an interlock to this action.
1043: hr_nonrun_asact.insint(lockingactid,lockedactid);
1044:
1045: end if;
1046: else
1047:
1050: into lockingactid
1051: from dual;
1052:
1053: -- insert the action record.
1054: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1055:
1056: -- insert an interlock to this action.
1057: hr_nonrun_asact.insint(lockingactid,lockedactid);
1058:
1053: -- insert the action record.
1054: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1055:
1056: -- insert an interlock to this action.
1057: hr_nonrun_asact.insint(lockingactid,lockedactid);
1058:
1059: end if;
1060: end loop;
1061:
1108: into lockingactid
1109: from dual;
1110:
1111: -- insert the action record.
1112: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1113:
1114: -- insert an interlock to this action.
1115: hr_nonrun_asact.insint(lockingactid,lockedactid);
1116:
1111: -- insert the action record.
1112: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1113:
1114: -- insert an interlock to this action.
1115: hr_nonrun_asact.insint(lockingactid,lockedactid);
1116:
1117: end if;
1118: else
1119:
1122: into lockingactid
1123: from dual;
1124: --
1125: -- insert the action record.
1126: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1127: --
1128: -- insert an interlock to this action.
1129: hr_nonrun_asact.insint(lockingactid,lockedactid);
1130: end if;
1125: -- insert the action record.
1126: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1127: --
1128: -- insert an interlock to this action.
1129: hr_nonrun_asact.insint(lockingactid,lockedactid);
1130: end if;
1131:
1132: end loop;
1133: close c_run_qp;
1179: into lockingactid
1180: from dual;
1181:
1182: -- insert the action record.
1183: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1184:
1185: -- insert an interlock to this action.
1186: hr_nonrun_asact.insint(lockingactid,lockedactid);
1187: end if;
1182: -- insert the action record.
1183: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1184:
1185: -- insert an interlock to this action.
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.
1195: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1196:
1197: -- insert an interlock to this action.
1198: hr_nonrun_asact.insint(lockingactid,lockedactid);
1199: end if;
1194: -- insert the action record.
1195: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1196:
1197: -- insert an interlock to this action.
1198: hr_nonrun_asact.insint(lockingactid,lockedactid);
1199: end if;
1200: end loop;
1201: close c_rev;
1202:
1250: into lockingactid
1251: from dual;
1252:
1253: -- insert the action record.
1254: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1255:
1256: -- insert an interlock to this action.
1257: hr_nonrun_asact.insint(lockingactid,lockedactid);
1258:
1253: -- insert the action record.
1254: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1255:
1256: -- insert an interlock to this action.
1257: hr_nonrun_asact.insint(lockingactid,lockedactid);
1258:
1259: end if;
1260: else
1261:
1267: into lockingactid
1268: from dual;
1269:
1270: -- insert the action record.
1271: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1272:
1273: -- insert an interlock to this action.
1274: hr_nonrun_asact.insint(lockingactid,lockedactid);
1275: end if;
1270: -- insert the action record.
1271: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1272:
1273: -- insert an interlock to this action.
1274: hr_nonrun_asact.insint(lockingactid,lockedactid);
1275: end if;
1276:
1277: end loop;
1278: close c_all;