APPS.IGS_EN_GEN_010 dependencies on IGS_EN_ENROLMENT_CAT

Line 1949: v_enrolment_cat IGS_EN_ENROLMENT_CAT.enrolment_cat%TYPE;

1945:
1946: -- output variables
1947: v_enr_cal_type IGS_CA_INST.cal_type%TYPE;
1948: v_enr_sequence_number IGS_CA_INST.sequence_number%TYPE;
1949: v_enrolment_cat IGS_EN_ENROLMENT_CAT.enrolment_cat%TYPE;
1950: v_description IGS_EN_ENROLMENT_CAT.description%TYPE;
1951: BEGIN
1952: p_warn_level := NULL;
1953: p_message_name := null;

Line 1950: v_description IGS_EN_ENROLMENT_CAT.description%TYPE;

1946: -- output variables
1947: v_enr_cal_type IGS_CA_INST.cal_type%TYPE;
1948: v_enr_sequence_number IGS_CA_INST.sequence_number%TYPE;
1949: v_enrolment_cat IGS_EN_ENROLMENT_CAT.enrolment_cat%TYPE;
1950: v_description IGS_EN_ENROLMENT_CAT.description%TYPE;
1951: BEGIN
1952: p_warn_level := NULL;
1953: p_message_name := null;
1954:

Line 4210: v_enrolment_cat IGS_EN_ENROLMENT_CAT.enrolment_cat%TYPE;

4206: susa.course_cd = p_course_cd AND
4207: susa.student_confirmed_ind = 'Y' AND
4208: susa.end_dt IS NULL;
4209: v_susa_rec c_susa%ROWTYPE;
4210: v_enrolment_cat IGS_EN_ENROLMENT_CAT.enrolment_cat%TYPE;
4211: v_enr_cat IGS_EN_ENROLMENT_CAT.enrolment_cat%TYPE;
4212: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;
4213: v_adm_cal_type IGS_AD_PS_APPL_INST_APLINST_V.adm_cal_type%TYPE;
4214: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;

Line 4211: v_enr_cat IGS_EN_ENROLMENT_CAT.enrolment_cat%TYPE;

4207: susa.student_confirmed_ind = 'Y' AND
4208: susa.end_dt IS NULL;
4209: v_susa_rec c_susa%ROWTYPE;
4210: v_enrolment_cat IGS_EN_ENROLMENT_CAT.enrolment_cat%TYPE;
4211: v_enr_cat IGS_EN_ENROLMENT_CAT.enrolment_cat%TYPE;
4212: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;
4213: v_adm_cal_type IGS_AD_PS_APPL_INST_APLINST_V.adm_cal_type%TYPE;
4214: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
4215: v_warn_level VARCHAR2(10) ;