APPS.IGS_AD_GEN_002 dependencies on IGS_AD_OFR_RESP_STAT

Line 2574: v_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;

2570: v_rej_lap BOOLEAN DEFAULT FALSE;
2571: v_s_appl_inst_stat igs_ad_ps_appl_inst.appl_inst_status%TYPE;
2572: v_s_adm_appl_status igs_ad_appl_stat.s_adm_appl_status%TYPE;
2573: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
2574: v_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;
2575: -- v_exit_loop NUMBER DEFAULT 0;
2576: v_s_adm_offer_dfrmnt_status igs_ad_ofrdfrmt_stat.s_adm_offer_dfrmnt_status%TYPE;
2577: BEGIN
2578: -- Determine the system admission application status.

Line 3243: FROM igs_ad_ofr_resp_stat

3239: FROM igs_ad_ps_appl_inst
3240: WHERE person_id = cp_person_id AND
3241: admission_appl_number =cp_admission_appl_number AND
3242: (( adm_offer_resp_status IN ( SELECT adm_offer_resp_status
3243: FROM igs_ad_ofr_resp_stat
3244: WHERE s_adm_offer_resp_status = 'ACCEPTED')) OR
3245: ( adm_offer_resp_status IN ( SELECT adm_offer_resp_status
3246: FROM igs_ad_ofr_resp_stat
3247: WHERE s_adm_offer_resp_status = 'DEFERRAL' ) AND

Line 3246: FROM igs_ad_ofr_resp_stat

3242: (( adm_offer_resp_status IN ( SELECT adm_offer_resp_status
3243: FROM igs_ad_ofr_resp_stat
3244: WHERE s_adm_offer_resp_status = 'ACCEPTED')) OR
3245: ( adm_offer_resp_status IN ( SELECT adm_offer_resp_status
3246: FROM igs_ad_ofr_resp_stat
3247: WHERE s_adm_offer_resp_status = 'DEFERRAL' ) AND
3248: adm_offer_dfrmnt_status IN (SELECT aods.adm_offer_dfrmnt_status
3249: FROM igs_ad_ofrdfrmt_stat aods
3250: WHERE aods.s_adm_offer_dfrmnt_status ='CONFIRM')));

Line 3596: v_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;

3592: cst_cancelled CONSTANT VARCHAR2(10) := 'CANCELLED';
3593: v_completed_appl VARCHAR2(1) DEFAULT 'N';
3594: v_aca_rec c_acai%ROWTYPE;
3595: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
3596: v_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;
3597: v_s_adm_offer_dfrmnt_status igs_ad_ofrdfrmt_stat.s_adm_offer_dfrmnt_status%TYPE;
3598: BEGIN
3599: OPEN c_acai;
3600: FETCH c_acai INTO v_aca_rec;