APPS.IGS_EN_VAL_SCT dependencies on IGS_AD_PS_APPL_INST

Line 375: -- IGS_AD_PS_APPL_INST.IGS_AD_OU_STAT must map to

371: -- admission_course_appl matching transfer details exist).
372: -- NOTE: also allow 'DISCONTIN' to prevent invalid lifting of discontinuation
373: -- through ENRF3000.
374: -- If IGS_EN_STDNT_PS_ATT is created through Admissions, the related
375: -- IGS_AD_PS_APPL_INST.IGS_AD_OU_STAT must map to
376: -- s_adm_outcome_status 'OFFER', 'COND-OFFER'.
377: -- If IGS_EN_STDNT_PS_ATT is created through Admissions, the related
378: -- IGS_AD_PS_APPL_INST.IGS_AD_OFR_RESP_STAT must map to
379: -- s_adm_offer_resp_status 'REJECTED', 'LAPSED'.

Line 378: -- IGS_AD_PS_APPL_INST.IGS_AD_OFR_RESP_STAT must map to

374: -- If IGS_EN_STDNT_PS_ATT is created through Admissions, the related
375: -- IGS_AD_PS_APPL_INST.IGS_AD_OU_STAT must map to
376: -- s_adm_outcome_status 'OFFER', 'COND-OFFER'.
377: -- If IGS_EN_STDNT_PS_ATT is created through Admissions, the related
378: -- IGS_AD_PS_APPL_INST.IGS_AD_OFR_RESP_STAT must map to
379: -- s_adm_offer_resp_status 'REJECTED', 'LAPSED'.
380: -- Course_cd must not have existing IGS_PS_STDNT_TRN mapping whose
381: -- transfer_dt is >= this transfer_dt.
382: -- Transfer_dt >= IGS_EN_STDNT_PS_ATT.commencement_dt and <= today's date

Line 392: v_adm_outcome_status IGS_AD_PS_APPL_INST.adm_outcome_status%TYPE;

388: cst_unconfirm CONSTANT VARCHAR2(9) := 'UNCONFIRM';
389: v_dummy VARCHAR2(1);
390: v_generic_course_ind IGS_PS_VER.generic_course_ind%TYPE;
391: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
392: v_adm_outcome_status IGS_AD_PS_APPL_INST.adm_outcome_status%TYPE;
393: v_adm_offer_resp_status IGS_AD_PS_APPL_INST.adm_offer_resp_status%TYPE;
394: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
395: CURSOR c_cv IS
396: SELECT generic_course_ind

Line 393: v_adm_offer_resp_status IGS_AD_PS_APPL_INST.adm_offer_resp_status%TYPE;

389: v_dummy VARCHAR2(1);
390: v_generic_course_ind IGS_PS_VER.generic_course_ind%TYPE;
391: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
392: v_adm_outcome_status IGS_AD_PS_APPL_INST.adm_outcome_status%TYPE;
393: v_adm_offer_resp_status IGS_AD_PS_APPL_INST.adm_offer_resp_status%TYPE;
394: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
395: CURSOR c_cv IS
396: SELECT generic_course_ind
397: FROM IGS_PS_VER cv

Line 408: FROM IGS_AD_PS_APPL_INST acai

404: aa.admission_appl_number = p_admission_appl_number;
405: CURSOR c_acai IS
406: SELECT adm_outcome_status,
407: adm_offer_resp_status
408: FROM IGS_AD_PS_APPL_INST acai
409: WHERE acai.person_id = p_person_id AND
410: acai.admission_appl_number = p_admission_appl_number AND
411: acai.nominated_course_cd = p_nominated_course_cd AND
412: acai.sequence_number = p_acai_sequence_number;