40: BEGIN -- admpl_val_option
41: -- validate options
42: DECLARE
43: v_return_val BOOLEAN DEFAULT FALSE;
44: v_location_cd IGS_PS_OFR_PAT.location_cd%TYPE;
45: v_attendance_mode IGS_PS_OFR_PAT.attendance_mode%TYPE;
46: v_attendance_type IGS_PS_OFR_PAT.attendance_type%TYPE;
47: -- Validate option
48: CURSOR c_acov (
41: -- validate options
42: DECLARE
43: v_return_val BOOLEAN DEFAULT FALSE;
44: v_location_cd IGS_PS_OFR_PAT.location_cd%TYPE;
45: v_attendance_mode IGS_PS_OFR_PAT.attendance_mode%TYPE;
46: v_attendance_type IGS_PS_OFR_PAT.attendance_type%TYPE;
47: -- Validate option
48: CURSOR c_acov (
49: cp_s_admission_process_type
42: DECLARE
43: v_return_val BOOLEAN DEFAULT FALSE;
44: v_location_cd IGS_PS_OFR_PAT.location_cd%TYPE;
45: v_attendance_mode IGS_PS_OFR_PAT.attendance_mode%TYPE;
46: v_attendance_type IGS_PS_OFR_PAT.attendance_type%TYPE;
47: -- Validate option
48: CURSOR c_acov (
49: cp_s_admission_process_type
50: IGS_AD_PRCS_CAT.s_admission_process_type%TYPE) IS
50: IGS_AD_PRCS_CAT.s_admission_process_type%TYPE) IS
51: SELECT acov.location_cd,
52: acov.attendance_mode,
53: acov.attendance_type
54: FROM IGS_PS_OFR_PAT_APCOOD_V acov
55: WHERE acov.adm_cal_type = p_adm_cal_type AND
56: acov.adm_ci_sequence_number = p_adm_ci_sequence_number AND
57: acov.admission_cat = p_admission_cat AND
58: acov.s_admission_process_type = cp_s_admission_process_type AND
179: cop.cal_type,
180: cop.location_cd,
181: cop.attendance_mode,
182: cop.attendance_type
183: FROM IGS_PS_OFR_PAT cop,
184: IGS_CA_INST_REL cir
185: WHERE cir.sup_cal_type = cp_acad_cal_type AND
186: cir.sub_cal_type = cp_adm_cal_type AND
187: cir.sub_ci_sequence_number = cp_adm_ci_sequence_number AND