[Home] [Help]
1833: sca.course_attempt_status NOT IN (cst_deleted, cst_unconfirmed);
1834:
1835: CURSOR c_sap(cp_person_id NUMBER, cp_admission_appl_number NUMBER) IS
1836: SELECT s_admission_process_type
1837: FROM igs_ad_appl
1838: WHERE person_id = cp_person_id
1839: AND admission_appl_number = cp_admission_appl_number;
1840: c_sap_rec c_sap%ROWTYPE;
1841: BEGIN
1911: -- Validate a non-fee conditional offer.
1912: IF(v_s_adm_outcome_status = cst_cond_offer AND
1913: p_cond_offer_fee_allowed = 'N' AND
1914: v_s_adm_fee_status NOT IN (cst_received, cst_exempt, cst_not_applic)) THEN
1915: p_message_name := 'IGS_AD_APPLFEES_OUTSTANDING';
1916: RETURN FALSE;
1917: END IF;
1918: RETURN TRUE;
1919: EXCEPTION
2148: v_prpsd_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
2149: v_ca_sequence_number NUMBER;
2150: CURSOR c_aal IS
2151: SELECT 'x'
2152: FROM IGS_AD_APPL_LTR aal
2153: WHERE aal.person_id = p_person_id AND
2154: aal.admission_appl_number = p_admission_appl_number AND
2155: aal.correspondence_type = cst_outcome_lt;
2156: CURSOR c_acai_aos IS
2711: acaiv.adm_offer_resp_status = aors.adm_offer_resp_status;
2712: CURSOR c_cnt_acaiv_aa_aos IS
2713: SELECT count(*)
2714: FROM IGS_AD_PS_APPL_INST acaiv, /* References to IGS_AD_PS_APPL_INST_APLINST_V replaced with IGS_AD_PS_APPL_INST Bug 3150054 */
2715: IGS_AD_APPL aa,
2716: IGS_AD_OU_STAT aos,
2717: IGS_AD_OFR_RESP_STAT aors
2718: WHERE acaiv.person_id = p_person_id AND
2719: (acaiv.admission_appl_number <> p_admission_appl_number OR
2824: v_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;
2825: CURSOR c_aaaa IS
2826: SELECT 'x'
2827: FROM IGS_AD_PS_APPL_INST acaiv, /* References to IGS_AD_PS_APPL_INST_APLINST_V replaced with IGS_AD_PS_APPL_INST Bug 3150054 */
2828: IGS_AD_APPL aa,
2829: IGS_AD_OU_STAT aos,
2830: IGS_AD_OFR_RESP_STAT aors
2831: WHERE acaiv.person_id = p_person_id AND
2832: (acaiv.admission_appl_number <> p_admission_appl_number OR
2898: -- On update of the admission outcome status warn if outcome letter
2899: -- correspondence is yet to be issued and phrases relating to the old status
2900: -- are attached
2901: DECLARE
2902: v_aal_seq_no IGS_AD_APPL_LTR.sequence_number%TYPE;
2903: v_sent_dt DATE;
2904: cst_warn CONSTANT VARCHAR2(1) := 'W';
2905: cst_error CONSTANT VARCHAR2(1) := 'E';
2906: CURSOR c_seq_no IS
2904: cst_warn CONSTANT VARCHAR2(1) := 'W';
2905: cst_error CONSTANT VARCHAR2(1) := 'E';
2906: CURSOR c_seq_no IS
2907: SELECT aal.sequence_number
2908: FROM IGS_AD_APPL_LTR aal,
2909: IGS_AD_APPL_LTR_PHR aalp
2910: WHERE aalp.person_id = p_person_id AND
2911: aalp.admission_appl_number = p_admission_appl_number AND
2912: aalp.correspondence_type = 'OUTCOME-LT' AND
2905: cst_error CONSTANT VARCHAR2(1) := 'E';
2906: CURSOR c_seq_no IS
2907: SELECT aal.sequence_number
2908: FROM IGS_AD_APPL_LTR aal,
2909: IGS_AD_APPL_LTR_PHR aalp
2910: WHERE aalp.person_id = p_person_id AND
2911: aalp.admission_appl_number = p_admission_appl_number AND
2912: aalp.correspondence_type = 'OUTCOME-LT' AND
2913: aal.person_id = aalp.person_id AND
3377: FUNCTION admp_val_ais_closed( --arvsrini igsm
3378: p_appl_inst_status IN VARCHAR2 ,
3379: p_message_name OUT NOCOPY VARCHAR2 )
3380: RETURN BOOLEAN AS
3381: v_closed_ind igs_ad_appl_stat.closed_ind%TYPE;
3382: CURSOR c_ais IS
3383: SELECT ais.closed_ind
3384: FROM igs_ad_appl_stat ais
3385: WHERE ais.adm_appl_status = p_appl_inst_status;
3380: RETURN BOOLEAN AS
3381: v_closed_ind igs_ad_appl_stat.closed_ind%TYPE;
3382: CURSOR c_ais IS
3383: SELECT ais.closed_ind
3384: FROM igs_ad_appl_stat ais
3385: WHERE ais.adm_appl_status = p_appl_inst_status;
3386: BEGIN
3387: -- Validate if igs_ad_appl_stat.adm_appl_status is closed.
3388: OPEN c_ais;
3383: SELECT ais.closed_ind
3384: FROM igs_ad_appl_stat ais
3385: WHERE ais.adm_appl_status = p_appl_inst_status;
3386: BEGIN
3387: -- Validate if igs_ad_appl_stat.adm_appl_status is closed.
3388: OPEN c_ais;
3389: FETCH c_ais INTO v_closed_ind;
3390: IF (c_ais%FOUND) THEN
3391: IF (v_closed_ind = 'Y') THEN