APPS.IGS_AD_GEN_002 dependencies on IGS_AD_OU_STAT

Line 2573: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;

2569: v_acai_records_found BOOLEAN DEFAULT FALSE;
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

Line 3595: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;

3591: cst_approved CONSTANT VARCHAR2(10) := 'APPROVED';
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;