APPS.IGS_AD_VAL_ECM dependencies on IGS_EN_CAT_MAPPING

Line 51: cp_admission_cat IGS_EN_CAT_MAPPING.admission_cat%TYPE)IS

47: cst_warn CONSTANT CHAR := 'W';
48: v_record_found BOOLEAN DEFAULT FALSE;
49: v_yes_found BOOLEAN DEFAULT FALSE;
50: CURSOR c_ecm(
51: cp_admission_cat IGS_EN_CAT_MAPPING.admission_cat%TYPE)IS
52: SELECT ecm.dflt_cat_ind
53: FROM IGS_EN_CAT_MAPPING ecm
54: WHERE ecm.admission_cat = cp_admission_cat;
55: BEGIN

Line 53: FROM IGS_EN_CAT_MAPPING ecm

49: v_yes_found BOOLEAN DEFAULT FALSE;
50: CURSOR c_ecm(
51: cp_admission_cat IGS_EN_CAT_MAPPING.admission_cat%TYPE)IS
52: SELECT ecm.dflt_cat_ind
53: FROM IGS_EN_CAT_MAPPING ecm
54: WHERE ecm.admission_cat = cp_admission_cat;
55: BEGIN
56: --- Set the default message number
57: p_message_name := null;

Line 97: v_dflt_cat_ind IGS_EN_CAT_MAPPING.dflt_cat_ind%TYPE;

93: -- Validate if the enrolment category can be marked as the default for the
94: -- admission category
95: -- (only one enrolment category can be marked as the default)
96: DECLARE
97: v_dflt_cat_ind IGS_EN_CAT_MAPPING.dflt_cat_ind%TYPE;
98: cst_yes CONSTANT CHAR := 'Y';
99: CURSOR c_ecm(cp_admission_cat IGS_EN_CAT_MAPPING.admission_cat%TYPE,
100: cp_enrolment_cat IGS_EN_CAT_MAPPING.enrolment_cat%TYPE)IS
101: SELECT ecm.dflt_cat_ind

Line 99: CURSOR c_ecm(cp_admission_cat IGS_EN_CAT_MAPPING.admission_cat%TYPE,

95: -- (only one enrolment category can be marked as the default)
96: DECLARE
97: v_dflt_cat_ind IGS_EN_CAT_MAPPING.dflt_cat_ind%TYPE;
98: cst_yes CONSTANT CHAR := 'Y';
99: CURSOR c_ecm(cp_admission_cat IGS_EN_CAT_MAPPING.admission_cat%TYPE,
100: cp_enrolment_cat IGS_EN_CAT_MAPPING.enrolment_cat%TYPE)IS
101: SELECT ecm.dflt_cat_ind
102: FROM IGS_EN_CAT_MAPPING ecm
103: WHERE ecm.admission_cat = cp_admission_cat AND

Line 100: cp_enrolment_cat IGS_EN_CAT_MAPPING.enrolment_cat%TYPE)IS

96: DECLARE
97: v_dflt_cat_ind IGS_EN_CAT_MAPPING.dflt_cat_ind%TYPE;
98: cst_yes CONSTANT CHAR := 'Y';
99: CURSOR c_ecm(cp_admission_cat IGS_EN_CAT_MAPPING.admission_cat%TYPE,
100: cp_enrolment_cat IGS_EN_CAT_MAPPING.enrolment_cat%TYPE)IS
101: SELECT ecm.dflt_cat_ind
102: FROM IGS_EN_CAT_MAPPING ecm
103: WHERE ecm.admission_cat = cp_admission_cat AND
104: ecm.enrolment_cat <> cp_enrolment_cat AND

Line 102: FROM IGS_EN_CAT_MAPPING ecm

98: cst_yes CONSTANT CHAR := 'Y';
99: CURSOR c_ecm(cp_admission_cat IGS_EN_CAT_MAPPING.admission_cat%TYPE,
100: cp_enrolment_cat IGS_EN_CAT_MAPPING.enrolment_cat%TYPE)IS
101: SELECT ecm.dflt_cat_ind
102: FROM IGS_EN_CAT_MAPPING ecm
103: WHERE ecm.admission_cat = cp_admission_cat AND
104: ecm.enrolment_cat <> cp_enrolment_cat AND
105: ecm.dflt_cat_ind = cst_yes;
106: BEGIN