APPS.IGS_AD_VAL_ACAI dependencies on IGS_AD_OFR_RESP_STAT

Line 2314: v_s_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;

2310: DECLARE
2311: cst_not_applic CONSTANT VARCHAR2(10) :='NOT-APPLIC';
2312: cst_pending CONSTANT VARCHAR2(7) :='PENDING';
2313: cst_lapsed CONSTANT VARCHAR2(6) :='LAPSED';
2314: v_s_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;
2315: BEGIN
2316: -- Set the default message number
2317: p_message_name := NULL;
2318: -- Validate the applicant acceptance condition against the admission

Line 2355: v_s_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.adm_offer_resp_status%TYPE;

2351: -- Validate the IGS_AD_PS_APPL_INST.cndtnl_offer_must_be_stsfd_ind.
2352: DECLARE
2353: v_s_adm_cndtnl_offer_status
2354: IGS_AD_CNDNL_OFRSTAT.adm_cndtnl_offer_status%TYPE;
2355: v_s_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.adm_offer_resp_status%TYPE;
2356: cst_not_applic CONSTANT VARCHAR2(10) := 'NOT-APPLIC';
2357: cst_accepted CONSTANT VARCHAR2(8) := 'ACCEPTED';
2358:
2359: BEGIN

Line 2441: IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE := 'DEFERRAL';

2437: -- and then the unit set must be valid for the deferred admission period.
2438: DECLARE
2439: cst_error CONSTANT VARCHAR2(1) := 'E';
2440: cst_deferral CONSTANT
2441: IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE := 'DEFERRAL';
2442: v_s_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;
2443: v_message_name VARCHAR2(30);
2444: v_return_type VARCHAR2(1);
2445: v_late_ind VARCHAR2(1);

Line 2442: v_s_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;

2438: DECLARE
2439: cst_error CONSTANT VARCHAR2(1) := 'E';
2440: cst_deferral CONSTANT
2441: IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE := 'DEFERRAL';
2442: v_s_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;
2443: v_message_name VARCHAR2(30);
2444: v_return_type VARCHAR2(1);
2445: v_late_ind VARCHAR2(1);
2446: BEGIN