[Home] [Help]
787:
788: -- Cursor to validate Location Code
789: CURSOR c_location(p_location_cd VARCHAR2) IS
790: SELECT location_cd
791: FROM IGS_AD_LOCATION
792: WHERE location_cd = p_location_cd;
793:
794: -- Cursor to validate Attendance Type
795: CURSOR c_att_type(p_attendance_type VARCHAR2) IS
807: -- Cursor to validate Program Offering Options
808: CURSOR c_off_pattern(p_admission_cat VARCHAR2, p_s_adm_process_type VARCHAR2,p_location_cd VARCHAR2, p_attendance_type VARCHAR2,p_attendance_mode VARCHAR2) IS
809: SELECT acopv.ACAD_CAL_TYPE
810: FROM IGS_PS_OFR_PAT_OFERPAT_V acopv,
811: IGS_AD_LOCATION loc,
812: IGS_EN_ATD_MODE atd_mode,
813: IGS_EN_ATD_TYPE atd_type
814: WHERE
815: (IGS_AD_GEN_013.ADMS_GET_COO_CRV(
855:
856: /* ******************* Put additional parameters here ******************************************** */
857: l_admappl_rec c_admappl%ROWTYPE := NULL;
858: l_sch_apl_to_rec IGS_AD_SCHL_APLY_TO.sch_apl_to_id%TYPE := NULL;
859: l_location_rec IGS_AD_LOCATION.location_cd%TYPE := NULL;
860: l_att_type_rec IGS_EN_ATD_TYPE.ATTENDANCE_TYPE%TYPE := NULL;
861: l_att_mode_rec IGS_EN_ATD_MODE.ATTENDANCE_MODE%TYPE := NULL;
862: l_off_pattern_rec IGS_PS_OFR_PAT_OFERPAT_V.ACAD_CAL_TYPE%TYPE := NULL;
863: l_pref_limit_rec IGS_AD_PRCS_CAT_STEP.S_ADMISSION_STEP_TYPE%TYPE := NULL;
1422:
1423:
1424: /*
1425: For the parameters p_sch_apl_to_id, p_location_cd, p_attendance_type and p_attendance_mode there will be 2 kinds of validations:
1426: a) That the individual values exist in OSS Tables IGS_AD_SCHL_APLY_TO, IGS_AD_LOCATION, IGS_EN_ATD_MODE, IGS_EN_ATD_TYPE resp.
1427: b) That the combination of these parameter values is a part of a valid Offering Option corresponding to this Application's Calendar and Application Type.
1428: */
1429:
1430: -- validate p_sch_apl_to_id