APPS.IGS_EN_ENROLL_WLST dependencies on IGS_CA_TYPE

Line 488: l_enrol_cal_type igs_ca_type.cal_type%TYPE;

484: lv_message VARCHAR2(2000);
485: lv_deny_warn VARCHAR2(20);
486: l_commencement_type igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
487: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;
488: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
489: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
490: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
491: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
492: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;

Line 1734: l_load_cal_type igs_ca_type.cal_type%TYPE;

1730: AND ctl.teach_ci_sequence_number = uoo.ci_sequence_number
1731: AND ctl.load_end_dt >= TRUNC(SYSDATE)
1732: ORDER BY ctl.load_start_dt;
1733:
1734: l_load_cal_type igs_ca_type.cal_type%TYPE;
1735:
1736: --
1737: -- Cursor to Check if Waitlisting is allowed at the institution level. Enh Bug# 3052426 (ptandon)
1738: --

Line 1981: l_enrol_cal_type igs_ca_type.cal_type%TYPE;

1977: -- lv_deny_warn VARCHAR2(20);
1978: l_commencement_type igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
1979: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;
1980: l_enr_method igs_en_cat_prc_dtl.enr_method_type%TYPE;
1981: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
1982: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1983: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1984: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1985: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;