[Home] [Help]
15: -- This modules validates the insert/update/delete of
16: -- IGS_AD_PS_APLINSTUNT.
17: DECLARE
18: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
19: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
20: CURSOR c_aa_aas IS
21: SELECT aas.s_adm_appl_status
22: FROM IGS_AD_APPL aa,
23: IGS_AD_APPL_STAT aas
27: aa.adm_appl_status = aas.adm_appl_status;
28: CURSOR c_acai_aos IS
29: SELECT aos.s_adm_outcome_status
30: FROM IGS_AD_PS_APPL_INST acai,
31: IGS_AD_OU_STAT aos
32: WHERE acai.person_id = p_person_id AND
33: acai.admission_appl_number = p_admission_appl_number AND
34: acai.nominated_course_cd = p_nominated_course_cd AND
35: acai.sequence_number = p_acai_sequence_number AND
417: cst_cond_offer CONSTANT VARCHAR2(10) :='COND-OFFER';
418: cst_withdrawn CONSTANT VARCHAR2(9) :='WITHDRAWN';
419: cst_voided CONSTANT VARCHAR2(6) :='VOIDED';
420: v_message_name VARCHAR2(30);
421: v_s_adm_outcome_status_aos IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
422: v_s_adm_outcome_status_auos IGS_AD_UNIT_OU_STAT.s_adm_outcome_status%TYPE;
423: CURSOR c_aos IS
424: SELECT aos.s_adm_outcome_status
425: FROM IGS_AD_PS_APPL_INST acai,
422: v_s_adm_outcome_status_auos IGS_AD_UNIT_OU_STAT.s_adm_outcome_status%TYPE;
423: CURSOR c_aos IS
424: SELECT aos.s_adm_outcome_status
425: FROM IGS_AD_PS_APPL_INST acai,
426: IGS_AD_OU_STAT aos
427: WHERE acai.adm_outcome_status = aos.adm_outcome_status AND
428: acai.person_id = p_person_id AND
429: acai.admission_appl_number = p_admission_appl_number AND
430: acai.nominated_course_cd = p_nominated_course_cd AND
714: App_Exception.Raise_Exception;
715: END admp_val_acaiu_restr;
716:
717: --
718: -- Validate if IGS_AD_OU_STAT.adm_outcome_status is closed.
719: FUNCTION admp_val_auos_closed(
720: p_adm_unit_outcome_status IN VARCHAR2 ,
721: p_message_name OUT NOCOPY VARCHAR2 )
722: RETURN BOOLEAN AS