APPS.IGS_PR_STDNT_PR_OU_PKG dependencies on IGS_SC_GEN_001

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

783: x_org_id => igs_ge_gen_003.get_org_id
784: ) ;
785:
786: IF (x_mode = 'S') THEN
787: igs_sc_gen_001.set_ctx('R');
788: END IF;
789: INSERT INTO igs_pr_stdnt_pr_ou_all (
790: person_id,
791: course_cd,

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

867: x_last_update_login,
868: new_references.org_id
869: );
870: IF (x_mode = 'S') THEN
871: igs_sc_gen_001.unset_ctx('R');
872: END IF;
873:
874:
875: OPEN C;

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

886: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
887: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
888: fnd_message.set_token ('ERR_CD', SQLCODE);
889: igs_ge_msg_stack.add;
890: igs_sc_gen_001.unset_ctx('R');
891: app_exception.raise_exception;
892: ELSE
893: igs_sc_gen_001.unset_ctx('R');
894: RAISE;

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

889: igs_ge_msg_stack.add;
890: igs_sc_gen_001.unset_ctx('R');
891: app_exception.raise_exception;
892: ELSE
893: igs_sc_gen_001.unset_ctx('R');
894: RAISE;
895: END IF;
896: END INSERT_ROW;
897:

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

1182: x_last_update_login => x_last_update_login
1183: );
1184:
1185: IF (x_mode = 'S') THEN
1186: igs_sc_gen_001.set_ctx('R');
1187: END IF;
1188: UPDATE igs_pr_stdnt_pr_ou_all SET
1189: prg_cal_type = new_references.prg_cal_type,
1190: prg_ci_sequence_number = new_references.prg_ci_sequence_number,

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

1222: WHERE ROWID = X_ROWID;
1223: IF (SQL%NOTFOUND) THEN
1224: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1225: igs_ge_msg_stack.add;
1226: igs_sc_gen_001.unset_ctx('R');
1227: app_exception.raise_exception;
1228: END IF;
1229: IF (x_mode = 'S') THEN
1230: igs_sc_gen_001.unset_ctx('R');

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

1226: igs_sc_gen_001.unset_ctx('R');
1227: app_exception.raise_exception;
1228: END IF;
1229: IF (x_mode = 'S') THEN
1230: igs_sc_gen_001.unset_ctx('R');
1231: END IF;
1232:
1233: apply_appr_outcome;
1234:

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

1237: IF (SQLCODE = (-28115)) THEN
1238: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1239: fnd_message.set_token ('ERR_CD', SQLCODE);
1240: igs_ge_msg_stack.add;
1241: igs_sc_gen_001.unset_ctx('R');
1242: app_exception.raise_exception;
1243: ELSE
1244: igs_sc_gen_001.unset_ctx('R');
1245: RAISE;

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

1240: igs_ge_msg_stack.add;
1241: igs_sc_gen_001.unset_ctx('R');
1242: app_exception.raise_exception;
1243: ELSE
1244: igs_sc_gen_001.unset_ctx('R');
1245: RAISE;
1246: END IF;
1247: END UPDATE_ROW;
1248:

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

1385: x_rowid => X_ROWID
1386: ) ;
1387:
1388: IF (x_mode = 'S') THEN
1389: igs_sc_gen_001.set_ctx('R');
1390: END IF;
1391: DELETE FROM igs_pr_stdnt_pr_ou_all
1392: WHERE ROWID = x_rowid;
1393: IF (SQL%NOTFOUND) THEN

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

1392: WHERE ROWID = x_rowid;
1393: IF (SQL%NOTFOUND) THEN
1394: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1395: igs_ge_msg_stack.add;
1396: igs_sc_gen_001.unset_ctx('R');
1397: app_exception.raise_exception;
1398: END IF;
1399: IF (x_mode = 'S') THEN
1400: igs_sc_gen_001.unset_ctx('R');

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

1396: igs_sc_gen_001.unset_ctx('R');
1397: app_exception.raise_exception;
1398: END IF;
1399: IF (x_mode = 'S') THEN
1400: igs_sc_gen_001.unset_ctx('R');
1401: END IF;
1402:
1403:
1404: END DELETE_ROW;