[Home] [Help]
92: NVL(acaiv.adm_cal_type, aav.adm_cal_type) = cp_adm_cal_type AND
93: NVL(acaiv.adm_ci_sequence_number, aav.adm_ci_sequence_number)
94: = cp_adm_ci_sequence_number AND
95: -- Check for CANCELLED added for bug 2678766
96: NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(acaiv.adm_outcome_status),'x') <> 'CANCELLED';
97:
98: -- Added the following cursor definitions for UK Bug 2462198
99: -- by rrengara on 24-JUL-2002
100:
130: = cp_adm_ci_sequence_number AND
131: NVL(aav.choice_number, 0) = NVL(cp_choice_number,0) AND
132: NVL(aav.alt_appl_id, 0) = NVL(cp_alt_appl_id,0) AND
133: -- Check for CANCELLED added for bug 2678766
134: NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(acaiv.adm_outcome_status),'x') <> 'CANCELLED';
135:
136: CURSOR c_aav_uk(cp_person_id igs_ad_appl.person_id%TYPE, cp_admission_appl_number igs_ad_appl.admission_appl_number%TYPE) IS
137: SELECT
138: choice_number, alt_appl_id
474: v_aal_exists VARCHAR2(1);
475: v_aas_exists VARCHAR2(1);
476: cst_error CONSTANT VARCHAR2(1) := 'E';
477: cst_warn CONSTANT VARCHAR2(1) := 'W';
478: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE := IGS_AD_GEN_008.ADMP_GET_SAOS(p_adm_outcome_status);
479: BEGIN
480: -- Set the default message number
481: p_message_name := NULL;
482: -- Validate the system admission application status.
2080: v_course_start_dt DATE;
2081: BEGIN
2082: p_message_name := NULL;
2083: -- Validate offer date against the admission outcome status.
2084: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS (
2085: p_adm_outcome_status);
2086: -- Offer date must be not be set for a pending admission course application
2087: -- instance.
2088: IF v_s_adm_outcome_status = 'PENDING' AND
2123: v_s_adm_outcome_status VARCHAR2(255);
2124: BEGIN
2125: p_message_name := NULL;
2126: -- Validate offer response date against the admission outcome status.
2127: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS (
2128: p_adm_outcome_status);
2129: -- Offer response date must be not be set for a pending admission course
2130: -- application instance.
2131: IF v_s_adm_outcome_status = 'PENDING' AND
2168: v_s_adm_offer_resp_status VARCHAR2(255);
2169: BEGIN
2170: p_message_name := NULL;
2171: -- Validate actual response date against the admission offer response status.
2172: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS (
2173: p_adm_offer_resp_status);
2174: -- Actual response date must be not be set for an admission course application
2175: -- instance with an offer response status of pending, lapsed or not-applicable.
2176: IF v_s_adm_offer_resp_status IN ('PENDING', 'LAPSED', 'NOT-APPLIC') THEN
2317: p_message_name := NULL;
2318: -- Validate the applicant acceptance condition against the admission
2319: -- offer response status.
2320: IF p_applicant_acptnce_cndtn IS NOT NULL THEN
2321: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS (
2322: p_adm_offer_resp_status);
2323: -- The applicant acceptance condition may only be specified when an
2324: -- applicant has responded to an offer of admission.
2325: IF v_s_adm_offer_resp_status IN (cst_pending,
2368: -- the conditional offer status is not applicable.
2369: p_message_name := 'IGS_AD_SATISFIEDINDICATOR_SET';
2370: RETURN FALSE;
2371: END IF;
2372: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS (
2373: p_adm_offer_resp_status);
2374: IF v_s_adm_offer_resp_status = cst_accepted AND
2375: p_cndtnl_offer_satisfied_dt IS NULL THEN
2376: -- The conditional offer must be satisfied before it can be accepted.
2454: p_return_type := cst_error;
2455: RETURN FALSE;
2456: END IF;
2457: -- Validate that the deferred admission calendar has been specified.
2458: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS(p_adm_offer_resp_status);
2459: IF (v_s_adm_offer_resp_status = cst_deferral AND
2460: (p_deferred_adm_cal_type IS NULL OR
2461: p_deferred_adm_ci_sequence_num IS NULL)) THEN
2462: -- The deferred admission calendar must be