APPS.IGS_AD_APP_REQ_PKG dependencies on IGS_SC_GEN_001

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

852: x_credit_card_payee_cd => x_credit_card_payee_cd,
853: x_credit_card_status_code => x_credit_card_status_code
854: );
855: IF (x_mode = 'S') THEN
856: igs_sc_gen_001.set_ctx('R');
857: END IF;
858: INSERT INTO IGS_AD_APP_REQ (
859: APP_REQ_ID
860: ,PERSON_ID

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

916:
917: ) RETURNING APP_REQ_ID INTO X_APP_REQ_ID;
918: new_references.APP_REQ_ID := X_APP_REQ_ID;
919: IF (x_mode = 'S') THEN
920: igs_sc_gen_001.unset_ctx('R');
921: END IF;
922:
923: open c;
924: fetch c into X_ROWID;

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

932: x_rowid => X_ROWID );
933: EXCEPTION
934: WHEN OTHERS THEN
935: IF (x_mode = 'S') THEN
936: igs_sc_gen_001.unset_ctx('R');
937: END IF;
938: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
939: -- Code to handle Security Policy error raised
940: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

1161: x_credit_card_payee_cd => x_credit_card_payee_cd,
1162: x_credit_card_status_code => x_credit_card_status_code
1163: );
1164: IF (x_mode = 'S') THEN
1165: igs_sc_gen_001.set_ctx('R');
1166: END IF;
1167: UPDATE igs_ad_app_req SET
1168: PERSON_ID = NEW_REFERENCES.PERSON_ID,
1169: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,

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

1194: IF (SQL%NOTFOUND) THEN
1195: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1196: igs_ge_msg_stack.add;
1197: IF (x_mode = 'S') THEN
1198: igs_sc_gen_001.unset_ctx('R');
1199: END IF;
1200: app_exception.raise_exception;
1201: END IF;
1202: IF (x_mode = 'S') THEN

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

1199: END IF;
1200: app_exception.raise_exception;
1201: END IF;
1202: IF (x_mode = 'S') THEN
1203: igs_sc_gen_001.unset_ctx('R');
1204: END IF;
1205:
1206:
1207: After_DML (

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

1210: );
1211: EXCEPTION
1212: WHEN OTHERS THEN
1213: IF (x_mode = 'S') THEN
1214: igs_sc_gen_001.unset_ctx('R');
1215: END IF;
1216: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
1217: -- Code to handle Security Policy error raised
1218: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

1360: p_action => 'DELETE',
1361: x_rowid => X_ROWID
1362: );
1363: IF (x_mode = 'S') THEN
1364: igs_sc_gen_001.set_ctx('R');
1365: END IF;
1366: DELETE FROM IGS_AD_APP_REQ
1367: WHERE rowid = x_rowid;
1368: IF (SQL%NOTFOUND) THEN

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

1368: IF (SQL%NOTFOUND) THEN
1369: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1370: igs_ge_msg_stack.add;
1371: IF (x_mode = 'S') THEN
1372: igs_sc_gen_001.set_ctx('R');
1373: END IF;
1374: app_exception.raise_exception;
1375: END IF;
1376: IF (x_mode = 'S') THEN

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

1373: END IF;
1374: app_exception.raise_exception;
1375: END IF;
1376: IF (x_mode = 'S') THEN
1377: igs_sc_gen_001.unset_ctx('R');
1378: END IF;
1379:
1380: After_DML (
1381: p_action => 'DELETE',

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

1383: );
1384: EXCEPTION
1385: WHEN OTHERS THEN
1386: IF (x_mode = 'S') THEN
1387: igs_sc_gen_001.set_ctx('R');
1388: END IF;
1389: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
1390: -- Code to handle Security Policy error raised
1391: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.