APPS.IGS_RE_CANDIDATURE_PKG dependencies on IGS_SC_GEN_001

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

988: x_last_update_login => X_LAST_UPDATE_LOGIN,
989: x_org_id => igs_ge_gen_003.get_org_id
990: ) ;
991: IF (x_mode = 'S') THEN
992: igs_sc_gen_001.set_ctx('R');
993: END IF;
994: insert into IGS_RE_CANDIDATURE_ALL (
995: PERSON_ID,
996: SEQUENCE_NUMBER,

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

1038: X_PROGRAM_UPDATE_DATE,
1039: NEW_REFERENCES.ORG_ID
1040: );
1041: IF (x_mode = 'S') THEN
1042: igs_sc_gen_001.unset_ctx('R');
1043: END IF;
1044:
1045: open c;
1046: fetch c into X_ROWID;

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

1058: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1059: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1060: fnd_message.set_token ('ERR_CD', SQLCODE);
1061: igs_ge_msg_stack.add;
1062: igs_sc_gen_001.unset_ctx('R');
1063: app_exception.raise_exception;
1064: ELSE
1065: igs_sc_gen_001.unset_ctx('R');
1066: RAISE;

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

1061: igs_ge_msg_stack.add;
1062: igs_sc_gen_001.unset_ctx('R');
1063: app_exception.raise_exception;
1064: ELSE
1065: igs_sc_gen_001.unset_ctx('R');
1066: RAISE;
1067: END IF;
1068:
1069: end INSERT_ROW;

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

1221: X_PROGRAM_UPDATE_DATE := SYSDATE;
1222: end if;
1223: end if;
1224: IF (x_mode = 'S') THEN
1225: igs_sc_gen_001.set_ctx('R');
1226: END IF;
1227: update IGS_RE_CANDIDATURE_ALL set
1228: SCA_COURSE_CD = NEW_REFERENCES.SCA_COURSE_CD,
1229: ACAI_ADMISSION_APPL_NUMBER = NEW_REFERENCES.ACAI_ADMISSION_APPL_NUMBER,

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

1245: where ROWID = X_ROWID;
1246: if (sql%notfound) then
1247: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1248: igs_ge_msg_stack.add;
1249: igs_sc_gen_001.unset_ctx('R');
1250: app_exception.raise_exception;
1251: end if;
1252: IF (x_mode = 'S') THEN
1253: igs_sc_gen_001.unset_ctx('R');

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

1249: igs_sc_gen_001.unset_ctx('R');
1250: app_exception.raise_exception;
1251: end if;
1252: IF (x_mode = 'S') THEN
1253: igs_sc_gen_001.unset_ctx('R');
1254: END IF;
1255:
1256: After_DML (
1257: p_action => 'UPDATE',

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

1262: IF (SQLCODE = (-28115)) THEN
1263: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1264: fnd_message.set_token ('ERR_CD', SQLCODE);
1265: igs_ge_msg_stack.add;
1266: igs_sc_gen_001.unset_ctx('R');
1267: app_exception.raise_exception;
1268: ELSE
1269: igs_sc_gen_001.unset_ctx('R');
1270: RAISE;

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

1265: igs_ge_msg_stack.add;
1266: igs_sc_gen_001.unset_ctx('R');
1267: app_exception.raise_exception;
1268: ELSE
1269: igs_sc_gen_001.unset_ctx('R');
1270: RAISE;
1271: END IF;
1272:
1273: end UPDATE_ROW;

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

1341: p_action => 'DELETE',
1342: x_rowid => X_ROWID
1343: );
1344: IF (x_mode = 'S') THEN
1345: igs_sc_gen_001.set_ctx('R');
1346: END IF;
1347: delete from IGS_RE_CANDIDATURE_ALL
1348: where ROWID = X_ROWID;
1349: if (sql%notfound) then

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

1348: where ROWID = X_ROWID;
1349: if (sql%notfound) then
1350: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1351: igs_ge_msg_stack.add;
1352: igs_sc_gen_001.unset_ctx('R');
1353: app_exception.raise_exception;
1354: end if;
1355: IF (x_mode = 'S') THEN
1356: igs_sc_gen_001.unset_ctx('R');

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

1352: igs_sc_gen_001.unset_ctx('R');
1353: app_exception.raise_exception;
1354: end if;
1355: IF (x_mode = 'S') THEN
1356: igs_sc_gen_001.unset_ctx('R');
1357: END IF;
1358:
1359: After_DML (
1360: p_action => 'DELETE',