[Home] [Help]
567: DECLARE
568: CURSOR c_acai IS
569: SELECT aos.s_adm_outcome_status,
570: aors.s_adm_offer_resp_status
571: FROM IGS_AD_PS_APPL_INST acai,
572: IGS_AD_OU_STAT aos,
573: IGS_AD_OFR_RESP_STAT aors
574: WHERE acai.person_id = p_person_id AND
575: acai.admission_appl_number = p_admission_appl_number AND
623: p_message_name := 'IGS_AD_APPLST_CANNOT_WITHDRAW';
624: RETURN FALSE;
625: END IF;
626: -- Validate if the admission application can be withdrawn.
627: -- Loop through IGS_AD_PS_APPL_INST records:
628: FOR v_acai_rec IN c_acai LOOP
629: -- If any admission IGS_PS_COURSE application instance has been
630: -- made an offer that has not been resolved or accepted
631: -- (including deferral), then the admission application
716: -- If fee's are required the adm_fee_status must not have a system value of
717: -- not-applicable.
718: -- If fee's are not required the adm_fee_status must have a system value of
719: -- not-applicable.
720: -- The IGS_AD_PS_APPL_INST relating to the admission application have
721: -- valid statuses for adm_fee_status.
722: DECLARE
723: cst_not_applic CONSTANT VARCHAR2(10) :='NOT-APPLIC';
724: cst_pending CONSTANT VARCHAR2(7) :='PENDING';
732: v_s_adm_fee_status IGS_AD_FEE_STAT.s_adm_fee_status%TYPE;
733: v_message_name VARCHAR2(30);
734: CURSOR c_chk_offer_pend IS
735: SELECT 'x'
736: FROM IGS_AD_PS_APPL_INST acai,
737: IGS_AD_OU_STAT aos
738: WHERE acai.person_id = p_person_id AND
739: acai.admission_appl_number = p_admission_appl_number AND
740: aos.s_adm_outcome_status IN (
744: cst_voided) AND
745: acai.adm_outcome_status = aos.adm_outcome_status;
746: CURSOR c_chk_offer_ass IS
747: SELECT 'x'
748: FROM IGS_AD_PS_APPL_INST acai,
749: IGS_AD_OU_STAT aos
750: WHERE acai.person_id = p_person_id AND
751: acai.admission_appl_number = p_admission_appl_number AND
752: aos.s_adm_outcome_status = cst_offer AND
752: aos.s_adm_outcome_status = cst_offer AND
753: acai.adm_outcome_status = aos.adm_outcome_status;
754: CURSOR c_chk_cond_fee IS
755: SELECT 'x'
756: FROM IGS_AD_PS_APPL_INST acai,
757: IGS_AD_OU_STAT aos
758: WHERE acai.person_id = p_person_id AND
759: acai.admission_appl_number = p_admission_appl_number AND
760: aos.s_adm_outcome_status = cst_cond_offer AND
760: aos.s_adm_outcome_status = cst_cond_offer AND
761: acai.adm_outcome_status = aos.adm_outcome_status;
762: CURSOR c_check_cndtnl IS
763: SELECT 'x'
764: FROM IGS_AD_PS_APPL_INST acai,
765: IGS_AD_OU_STAT aos,
766: IGS_AD_CNDNL_OFRSTAT acos
767: WHERE acai.person_id = p_person_id AND
768: acai.admission_appl_number = p_admission_appl_number AND