APPS.IGS_AD_GEN_002 dependencies on IGS_AD_OFRDFRMT_STAT

Line 2576: v_s_adm_offer_dfrmnt_status igs_ad_ofrdfrmt_stat.s_adm_offer_dfrmnt_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.
2579: v_s_adm_appl_status := IGS_AD_GEN_007.ADMP_GET_SAAS(p_adm_appl_status);
2580: -- Derive the admission application status.

Line 3249: FROM igs_ad_ofrdfrmt_stat aods

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')));
3251: l_count NUMBER;
3252: BEGIN
3253: OPEN c_ofr_resp_status(p_person_id,p_admission_appl_number);

Line 3597: v_s_adm_offer_dfrmnt_status igs_ad_ofrdfrmt_stat.s_adm_offer_dfrmnt_status%TYPE;

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;
3601: IF (c_acai%FOUND) THEN