APPS.IGS_AD_VAL_APCOOD dependencies on IGS_AD_PRCS_CAT

Line 24: v_s_admission_process_type IGS_AD_PRCS_CAT.s_admission_process_type%TYPE;

20: gv_other_detail VARCHAR2(255);
21: BEGIN -- admp_val_apcood_opt
22: -- Validate the admission period course offering option date details
23: DECLARE
24: v_s_admission_process_type IGS_AD_PRCS_CAT.s_admission_process_type%TYPE;
25: v_message_name varchar2(30);
26: v_valid_optn BOOLEAN DEFAULT NULL;
27: v_apapc_found BOOLEAN DEFAULT FALSE;
28: CURSOR c_apapc IS

Line 37: IGS_AD_PRCS_CAT.s_admission_process_type%TYPE)

33: admission_cat = p_admission_cat;
34: ----------------------------------------- SUBFUNCTION -------------------------
35: ------------------------------
36: FUNCTION admpl_val_option (v_s_admission_process_type
37: IGS_AD_PRCS_CAT.s_admission_process_type%TYPE)
38: RETURN BOOLEAN
39: IS
40: BEGIN -- admpl_val_option
41: -- validate options

Line 50: IGS_AD_PRCS_CAT.s_admission_process_type%TYPE) IS

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
51: SELECT acov.location_cd,
52: acov.attendance_mode,
53: acov.attendance_type
54: FROM IGS_PS_OFR_PAT_APCOOD_V acov