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_IMP_OFF_RESP_DATA dependencies on IGS_AD_GEN_009

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

360: igs_ad_prd_ad_prc_ca admprd
361: WHERE appl.person_id = aplinst.person_id
362: AND appl.admission_appl_number = aplinst.admission_appl_number
363: AND appl.person_id = p_person_id
364: AND igs_ad_gen_009.admp_get_sys_aors(aplinst.adm_offer_resp_status) = 'ACCEPTED'
365: AND admprd.adm_cal_type = NVL(aplinst.adm_cal_type,appl.adm_cal_type)
366: AND admprd.adm_ci_sequence_number = NVL(aplinst.adm_ci_sequence_number,appl.adm_ci_sequence_number)
367: AND admprd.admission_cat = appl.admission_cat
368: AND admprd.s_admission_process_type = appl.s_admission_process_type

Line 564: IF igs_ad_gen_009.admp_get_sys_aods(cst_pending) IS NULL THEN

560: -- ELSE Offer Response Status is not equal to 'DEFERRAL', then Default the Offer Deferment Status to 'NOT-APPLIC'.
561:
562: IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status) = cst_deferral AND
563: NVL(igs_ad_gen_008.admp_get_saods(acaiv_rec.adm_offer_dfrmnt_status), cst_not_applic) = cst_not_applic THEN
564: IF igs_ad_gen_009.admp_get_sys_aods(cst_pending) IS NULL THEN
565: insert_int_error(p_offresp_int_id, 'E625',NULL);
566: p_validation_success := 'N';
567: logdetail(p_offresp_int_id, 'E625', NULL, 'IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status)' ,NULL);
568: RETURN;

Line 570: p_adm_offer_defr_status := igs_ad_gen_009.admp_get_sys_aods(cst_pending);

566: p_validation_success := 'N';
567: logdetail(p_offresp_int_id, 'E625', NULL, 'IF igs_ad_gen_008.admp_get_saors(p_adm_offer_resp_status)' ,NULL);
568: RETURN;
569: ELSE
570: p_adm_offer_defr_status := igs_ad_gen_009.admp_get_sys_aods(cst_pending);
571: -- ADMISSION COURSE APPLICATION INSTANCE: Admission Offer Deferment Status.
572: IF p_adm_offer_defr_status <> acaiv_rec.adm_offer_dfrmnt_status THEN
573: -- Validate.
574: IF igs_ad_val_acai_status.admp_val_acai_aods (

Line 661: IF igs_ad_gen_009.admp_get_sys_aods(cst_not_applic) IS NULL THEN

657: END IF; --End of igs_ad_val_acai_status.admp_val_acai_aods
658: END IF; ---End of the deferred calendar validations here
659: END IF;
660: ELSE -- Of DEFERRAL check
661: IF igs_ad_gen_009.admp_get_sys_aods(cst_not_applic) IS NULL THEN
662: insert_int_error(p_offresp_int_id, 'E602',NULL);
663: p_validation_success := 'N';
664: logdetail(p_offresp_int_id,'E602', NULL, 'validate_off_resp_dtls: IF igs_ad_gen_009.admp_get_sys_aods' ,NULL);
665: RETURN;

Line 664: logdetail(p_offresp_int_id,'E602', NULL, 'validate_off_resp_dtls: IF igs_ad_gen_009.admp_get_sys_aods' ,NULL);

660: ELSE -- Of DEFERRAL check
661: IF igs_ad_gen_009.admp_get_sys_aods(cst_not_applic) IS NULL THEN
662: insert_int_error(p_offresp_int_id, 'E602',NULL);
663: p_validation_success := 'N';
664: logdetail(p_offresp_int_id,'E602', NULL, 'validate_off_resp_dtls: IF igs_ad_gen_009.admp_get_sys_aods' ,NULL);
665: RETURN;
666: ELSE
667: p_adm_offer_defr_status := igs_ad_gen_009.admp_get_sys_aods(cst_not_applic);
668: END IF;

Line 667: p_adm_offer_defr_status := igs_ad_gen_009.admp_get_sys_aods(cst_not_applic);

663: p_validation_success := 'N';
664: logdetail(p_offresp_int_id,'E602', NULL, 'validate_off_resp_dtls: IF igs_ad_gen_009.admp_get_sys_aods' ,NULL);
665: RETURN;
666: ELSE
667: p_adm_offer_defr_status := igs_ad_gen_009.admp_get_sys_aods(cst_not_applic);
668: END IF;
669: END IF; -- Of DEFERRAL check
670:
671: -- Validate all the Offer Response details here