eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_PS_APPL_INST_PKG dependencies on IGS_AD_GEN_009

Line 435: AND igs_ad_gen_009.admp_get_sys_aors(aplinst.adm_offer_resp_status) = 'ACCEPTED'

431: igs_ad_prd_ad_prc_ca admprd
432: WHERE appl.person_id = aplinst.person_id
433: AND appl.admission_appl_number = aplinst.admission_appl_number
434: AND appl.person_id = new_references.person_id
435: AND igs_ad_gen_009.admp_get_sys_aors(aplinst.adm_offer_resp_status) = 'ACCEPTED'
436: AND admprd.adm_cal_type = NVL(aplinst.adm_cal_type,appl.adm_cal_type)
437: AND admprd.adm_ci_sequence_number = NVL(aplinst.adm_ci_sequence_number,appl.adm_ci_sequence_number)
438: AND admprd.admission_cat = appl.admission_cat
439: AND admprd.s_admission_process_type = appl.s_admission_process_type

Line 565: igs_ad_gen_009.admp_get_sys_aors (new_references.adm_offer_resp_status) = 'ACCEPTED') THEN

561: v_adm_fee_status);
562:
563: -- Start of Single Response validations Bug:3132406
564: IF (old_references.adm_offer_resp_status <> new_references.adm_offer_resp_status AND
565: igs_ad_gen_009.admp_get_sys_aors (new_references.adm_offer_resp_status) = 'ACCEPTED') THEN
566: OPEN get_single_response (v_admission_cat,v_s_admission_process_type);
567: FETCH get_single_response INTO l_single_response_flag;
568: CLOSE get_single_response;
569:

Line 1214: NVL(old_references.adm_outcome_status, IGS_AD_GEN_009.ADMP_GET_SYS_AOS('PENDING')),

1210: new_references.fee_cat,
1211: new_references.correspondence_cat,
1212: new_references.enrolment_cat,
1213: new_references.adm_outcome_status,
1214: NVL(old_references.adm_outcome_status, IGS_AD_GEN_009.ADMP_GET_SYS_AOS('PENDING')),
1215: new_references.adm_doc_status,
1216: v_adm_fee_status,
1217: new_references.late_adm_fee_status,
1218: new_references.adm_cndtnl_offer_status,

Line 1221: NVL(old_references.adm_offer_resp_status, IGS_AD_GEN_009.ADMP_GET_SYS_AORS('NOT-APPLIC')),

1217: new_references.late_adm_fee_status,
1218: new_references.adm_cndtnl_offer_status,
1219: new_references.adm_entry_qual_status,
1220: new_references.adm_offer_resp_status,
1221: NVL(old_references.adm_offer_resp_status, IGS_AD_GEN_009.ADMP_GET_SYS_AORS('NOT-APPLIC')),
1222: new_references.adm_outcome_status_auth_dt,
1223: v_set_outcome_allowed_ind,
1224: v_cond_offer_ass_allowed_ind,
1225: v_cond_offer_fee_allowed_ind,

Line 1248: NVL(old_references.adm_outcome_status, IGS_AD_GEN_009.ADMP_GET_SYS_AOS('PENDING')),

1244: IF IGS_AD_VAL_ACAI_STATUS.admp_val_aos_update (
1245: new_references.person_id,
1246: new_references.admission_appl_number,
1247: new_references.adm_outcome_status,
1248: NVL(old_references.adm_outcome_status, IGS_AD_GEN_009.ADMP_GET_SYS_AOS('PENDING')),
1249: v_message_name,
1250: v_return_type) = FALSE THEN
1251: IF NVL(v_return_type, '-1') = cst_error THEN
1252: FND_MESSAGE.SET_NAME('IGS',v_message_name);

Line 1291: NVL(old_references.adm_offer_resp_status, IGS_AD_GEN_009.ADMP_GET_SYS_AORS('NOT-APPLIC')),

1287: new_references.nominated_course_cd,
1288: new_references.sequence_number,
1289: new_references.course_cd,
1290: new_references.adm_offer_resp_status,
1291: NVL(old_references.adm_offer_resp_status, IGS_AD_GEN_009.ADMP_GET_SYS_AORS('NOT-APPLIC')),
1292: new_references.adm_outcome_status,
1293: new_references.adm_offer_dfrmnt_status,
1294: NVL(old_references.adm_offer_dfrmnt_status, IGS_AD_GEN_009.ADMP_GET_SYS_AODS('NOT-APPLIC')),
1295: new_references.adm_outcome_status_auth_dt,

Line 1294: NVL(old_references.adm_offer_dfrmnt_status, IGS_AD_GEN_009.ADMP_GET_SYS_AODS('NOT-APPLIC')),

1290: new_references.adm_offer_resp_status,
1291: NVL(old_references.adm_offer_resp_status, IGS_AD_GEN_009.ADMP_GET_SYS_AORS('NOT-APPLIC')),
1292: new_references.adm_outcome_status,
1293: new_references.adm_offer_dfrmnt_status,
1294: NVL(old_references.adm_offer_dfrmnt_status, IGS_AD_GEN_009.ADMP_GET_SYS_AODS('NOT-APPLIC')),
1295: new_references.adm_outcome_status_auth_dt,
1296: new_references.actual_response_dt,
1297: v_adm_cal_type,
1298: v_adm_ci_sequence_number,

Line 1324: NVL(old_references.adm_cndtnl_offer_status, IGS_AD_GEN_009.ADMP_GET_SYS_ACOS('NOT-APPLIC')),

1320: IF NVL(old_references.adm_cndtnl_offer_status, '-1') <> new_references.adm_cndtnl_offer_status OR
1321: NVL(old_references.adm_outcome_status, '-1') <> new_references.adm_outcome_status THEN
1322: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_acos (
1323: new_references.adm_cndtnl_offer_status,
1324: NVL(old_references.adm_cndtnl_offer_status, IGS_AD_GEN_009.ADMP_GET_SYS_ACOS('NOT-APPLIC')),
1325: new_references.adm_outcome_status,
1326: new_references.adm_outcome_status,
1327: new_references.late_adm_fee_status,
1328: v_adm_fee_status,

Line 1352: NVL(old_references.adm_offer_dfrmnt_status, IGS_AD_GEN_009.ADMP_GET_SYS_AODS('NOT-APPLIC')),

1348: new_references.nominated_course_cd,
1349: new_references.sequence_number,
1350: new_references.course_cd,
1351: new_references.adm_offer_dfrmnt_status,
1352: NVL(old_references.adm_offer_dfrmnt_status, IGS_AD_GEN_009.ADMP_GET_SYS_AODS('NOT-APPLIC')),
1353: new_references.adm_offer_resp_status,
1354: v_deferral_allowed_ind,
1355: v_s_admission_process_type,
1356: v_message_name) = FALSE THEN