APPS.IGS_AD_PS_APPL_PKG dependencies on IGS_SC_GEN_001

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

972: x_last_update_login =>X_LAST_UPDATE_LOGIN
973: );
974:
975: IF (x_mode = 'S') THEN
976: igs_sc_gen_001.set_ctx('R');
977: END IF;
978: insert into IGS_AD_PS_APPL_ALL (
979: ORG_ID,
980: PERSON_ID,

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

1018: X_PROGRAM_APPLICATION_ID,
1019: X_PROGRAM_UPDATE_DATE
1020: );
1021: IF (x_mode = 'S') THEN
1022: igs_sc_gen_001.unset_ctx('R');
1023: END IF;
1024:
1025:
1026: open c;

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

1038:
1039: EXCEPTION
1040: WHEN OTHERS THEN
1041: IF (x_mode = 'S') THEN
1042: igs_sc_gen_001.unset_ctx('R');
1043: END IF;
1044: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
1045: -- Code to handle Security Policy error raised
1046: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

1195: X_PROGRAM_UPDATE_DATE := SYSDATE;
1196: end if;
1197: end if;
1198: IF (x_mode = 'S') THEN
1199: igs_sc_gen_001.set_ctx('R');
1200: END IF;
1201: update IGS_AD_PS_APPL_ALL set
1202: TRANSFER_COURSE_CD = NEW_REFERENCES.TRANSFER_COURSE_CD,
1203: BASIS_FOR_ADMISSION_TYPE = NEW_REFERENCES.BASIS_FOR_ADMISSION_TYPE,

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

1218: if (sql%notfound) then
1219: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1220: igs_ge_msg_stack.add;
1221: IF (x_mode = 'S') THEN
1222: igs_sc_gen_001.unset_ctx('R');
1223: END IF;
1224: app_exception.raise_exception;
1225: end if;
1226: IF (x_mode = 'S') THEN

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

1223: END IF;
1224: app_exception.raise_exception;
1225: end if;
1226: IF (x_mode = 'S') THEN
1227: igs_sc_gen_001.unset_ctx('R');
1228: END IF;
1229:
1230:
1231: After_DML(

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

1235:
1236: EXCEPTION
1237: WHEN OTHERS THEN
1238: IF (x_mode = 'S') THEN
1239: igs_sc_gen_001.unset_ctx('R');
1240: END IF;
1241: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
1242: -- Code to handle Security Policy error raised
1243: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

1321: x_rowid => X_ROWID
1322: );
1323:
1324: IF (x_mode = 'S') THEN
1325: igs_sc_gen_001.set_ctx('R');
1326: END IF;
1327: delete from IGS_AD_PS_APPL_ALL
1328: where ROWID = X_ROWID;
1329: if (sql%notfound) then

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

1329: if (sql%notfound) then
1330: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1331: igs_ge_msg_stack.add;
1332: IF (x_mode = 'S') THEN
1333: igs_sc_gen_001.unset_ctx('R');
1334: END IF;
1335: app_exception.raise_exception;
1336: end if;
1337: IF (x_mode = 'S') THEN

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

1334: END IF;
1335: app_exception.raise_exception;
1336: end if;
1337: IF (x_mode = 'S') THEN
1338: igs_sc_gen_001.unset_ctx('R');
1339: END IF;
1340:
1341:
1342: After_DML(

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

1346:
1347: EXCEPTION
1348: WHEN OTHERS THEN
1349: IF (x_mode = 'S') THEN
1350: igs_sc_gen_001.unset_ctx('R');
1351: END IF;
1352: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
1353: -- Code to handle Security Policy error raised
1354: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.