APPS.IGS_PE_MIL_SERVICES_PKG dependencies on IGS_SC_GEN_001

Line 697: igs_sc_gen_001.set_ctx('R');

693: x_last_update_date=>X_LAST_UPDATE_DATE,
694: x_last_updated_by=>X_LAST_UPDATED_BY,
695: x_last_update_login=>X_LAST_UPDATE_LOGIN);
696: IF (x_mode = 'S') THEN
697: igs_sc_gen_001.set_ctx('R');
698: END IF;
699: insert into IGS_PE_MIL_SERVICES_ALL (
700: MILIT_SERVICE_ID
701: ,PERSON_ID

Line 773: igs_sc_gen_001.unset_ctx('R');

769: ,X_LAST_UPDATED_BY
770: ,X_LAST_UPDATE_LOGIN
771: );
772: IF (x_mode = 'S') THEN
773: igs_sc_gen_001.unset_ctx('R');
774: END IF;
775:
776: open c;
777: fetch c into X_ROWID;

Line 792: igs_sc_gen_001.unset_ctx('R');

788: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
789: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
790: fnd_message.set_token ('ERR_CD', SQLCODE);
791: igs_ge_msg_stack.add;
792: igs_sc_gen_001.unset_ctx('R');
793: app_exception.raise_exception;
794: ELSE
795: igs_sc_gen_001.unset_ctx('R');
796: RAISE;

Line 795: igs_sc_gen_001.unset_ctx('R');

791: igs_ge_msg_stack.add;
792: igs_sc_gen_001.unset_ctx('R');
793: app_exception.raise_exception;
794: ELSE
795: igs_sc_gen_001.unset_ctx('R');
796: RAISE;
797: END IF;
798:
799: end INSERT_ROW;

Line 1091: igs_sc_gen_001.set_ctx('R');

1087: x_last_update_date=>X_LAST_UPDATE_DATE,
1088: x_last_updated_by=>X_LAST_UPDATED_BY,
1089: x_last_update_login=>X_LAST_UPDATE_LOGIN);
1090: IF (x_mode = 'S') THEN
1091: igs_sc_gen_001.set_ctx('R');
1092: END IF;
1093: update IGS_PE_MIL_SERVICES_ALL set
1094: PERSON_ID = NEW_REFERENCES.PERSON_ID,
1095: -- MILITARY_TYPE_ID = NEW_REFERENCES.MILITARY_TYPE_ID,

Line 1133: igs_sc_gen_001.unset_ctx('R');

1129: where ROWID = X_ROWID;
1130: if (sql%notfound) then
1131: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1132: igs_ge_msg_stack.add;
1133: igs_sc_gen_001.unset_ctx('R');
1134: app_exception.raise_exception;
1135: end if;
1136: IF (x_mode = 'S') THEN
1137: igs_sc_gen_001.unset_ctx('R');

Line 1137: igs_sc_gen_001.unset_ctx('R');

1133: igs_sc_gen_001.unset_ctx('R');
1134: app_exception.raise_exception;
1135: end if;
1136: IF (x_mode = 'S') THEN
1137: igs_sc_gen_001.unset_ctx('R');
1138: END IF;
1139:
1140:
1141: After_DML (

Line 1151: igs_sc_gen_001.unset_ctx('R');

1147: IF (SQLCODE = (-28115)) THEN
1148: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1149: fnd_message.set_token ('ERR_CD', SQLCODE);
1150: igs_ge_msg_stack.add;
1151: igs_sc_gen_001.unset_ctx('R');
1152: app_exception.raise_exception;
1153: ELSE
1154: igs_sc_gen_001.unset_ctx('R');
1155: RAISE;

Line 1154: igs_sc_gen_001.unset_ctx('R');

1150: igs_ge_msg_stack.add;
1151: igs_sc_gen_001.unset_ctx('R');
1152: app_exception.raise_exception;
1153: ELSE
1154: igs_sc_gen_001.unset_ctx('R');
1155: RAISE;
1156: END IF;
1157:
1158: end UPDATE_ROW;

Line 1312: igs_sc_gen_001.set_ctx('R');

1308: p_action => 'DELETE',
1309: x_rowid => X_ROWID
1310: );
1311: IF (x_mode = 'S') THEN
1312: igs_sc_gen_001.set_ctx('R');
1313: END IF;
1314: delete from IGS_PE_MIL_SERVICES_ALL
1315: where ROWID = X_ROWID;
1316: if (sql%notfound) then

Line 1319: igs_sc_gen_001.unset_ctx('R');

1315: where ROWID = X_ROWID;
1316: if (sql%notfound) then
1317: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1318: igs_ge_msg_stack.add;
1319: igs_sc_gen_001.unset_ctx('R');
1320: app_exception.raise_exception;
1321: end if;
1322: IF (x_mode = 'S') THEN
1323: igs_sc_gen_001.unset_ctx('R');

Line 1323: igs_sc_gen_001.unset_ctx('R');

1319: igs_sc_gen_001.unset_ctx('R');
1320: app_exception.raise_exception;
1321: end if;
1322: IF (x_mode = 'S') THEN
1323: igs_sc_gen_001.unset_ctx('R');
1324: END IF;
1325:
1326: After_DML (
1327: p_action => 'DELETE',