APPS.IGS_AD_APPL_EVAL_PKG dependencies on IGS_SC_GEN_001

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

925: x_evaluation_sequence=>X_EVALUATION_SEQUENCE,
926: x_rating_scale_id=>X_RATING_SCALE_ID,
927: x_closed_ind => X_CLOSED_IND);
928: IF (x_mode = 'S') THEN
929: igs_sc_gen_001.set_ctx('R');
930: END IF;
931: INSERT INTO igs_ad_appl_eval (
932: appl_eval_id
933: ,person_id

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

979: ,x_rating_scale_id
980: ,x_closed_ind
981: )RETURNING appl_eval_id INTO x_appl_eval_id;
982: IF (x_mode = 'S') THEN
983: igs_sc_gen_001.unset_ctx('R');
984: END IF;
985:
986: OPEN c;
987: FETCH c INTO x_rowid;

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

995: x_rowid => X_ROWID );
996: EXCEPTION
997: WHEN OTHERS THEN
998: IF (x_mode = 'S') THEN
999: igs_sc_gen_001.unset_ctx('R');
1000: END IF;
1001: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
1002: -- Code to handle Security Policy error raised
1003: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

1197: end if;
1198: end if;
1199:
1200: IF (x_mode = 'S') THEN
1201: igs_sc_gen_001.set_ctx('R');
1202: END IF;
1203: UPDATE igs_ad_appl_eval SET
1204: person_id = new_references.person_id,
1205: admission_appl_number = new_references.admission_appl_number,

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

1226: IF (sql%NOTFOUND) THEN
1227: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1228: igs_ge_msg_stack.add;
1229: IF (x_mode = 'S') THEN
1230: igs_sc_gen_001.unset_ctx('R');
1231: END IF;
1232: app_exception.raise_exception;
1233: END IF;
1234: IF (x_mode = 'S') THEN

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

1231: END IF;
1232: app_exception.raise_exception;
1233: END IF;
1234: IF (x_mode = 'S') THEN
1235: igs_sc_gen_001.unset_ctx('R');
1236: END IF;
1237:
1238:
1239: After_DML (

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

1257:
1258: EXCEPTION
1259: WHEN OTHERS THEN
1260: IF (x_mode = 'S') THEN
1261: igs_sc_gen_001.unset_ctx('R');
1262: END IF;
1263: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
1264: -- Code to handle Security Policy error raised
1265: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

1513: FETCH c_del_appl_eval INTO l_del_appl_eval;
1514: CLOSE c_del_appl_eval;
1515:
1516: IF (x_mode = 'S') THEN
1517: igs_sc_gen_001.set_ctx('R');
1518: END IF;
1519: DELETE FROM igs_ad_appl_eval
1520: WHERE rowid = x_rowid;
1521: IF (sql%NOTFOUND) THEN

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

1521: IF (sql%NOTFOUND) THEN
1522: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1523: igs_ge_msg_stack.add;
1524: IF (x_mode = 'S') THEN
1525: igs_sc_gen_001.unset_ctx('R');
1526: END IF;
1527: app_exception.raise_exception;
1528: END IF;
1529: IF (x_mode = 'S') THEN

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

1526: END IF;
1527: app_exception.raise_exception;
1528: END IF;
1529: IF (x_mode = 'S') THEN
1530: igs_sc_gen_001.unset_ctx('R');
1531: END IF;
1532:
1533: After_DML (
1534: p_action => 'DELETE',

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

1545:
1546: EXCEPTION
1547: WHEN OTHERS THEN
1548: IF (x_mode = 'S') THEN
1549: igs_sc_gen_001.unset_ctx('R');
1550: END IF;
1551: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
1552: -- Code to handle Security Policy error raised
1553: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.