APPS.IGS_EN_ELGBL_PROGRAM dependencies on IGS_CA_TYPE

Line 610: l_enrol_cal_type igs_ca_type.cal_type%TYPE;

606: WHERE person_id = p_person_id
607: AND course_cd = p_program_cd
608: AND uoo_id = p_uoo_id;
609:
610: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
611: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
612: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
613:
614:

Line 2018: l_enrol_cal_type igs_ca_type.cal_type%TYPE;

2014: l_prsid_max_cp igs_en_pig_cp_setup.prsid_max_cp%TYPE;
2015: l_message VARCHAR2(30);
2016: l_max_cp_allowed igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;
2017:
2018: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
2019: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2020:
2021: BEGIN
2022:

Line 2381: l_acad_cal_type IGS_CA_TYPE.CAL_TYPE%TYPE;

2377: l_cow_version_number IGS_PS_OWN.version_number%TYPE;
2378: l_cow_org_unit_cd IGS_PS_OWN.org_unit_cd%TYPE;
2379: v_cow_ou_start_dt IGS_PS_OWN.ou_start_dt%TYPE;
2380:
2381: l_acad_cal_type IGS_CA_TYPE.CAL_TYPE%TYPE;
2382: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2383: l_acad_start_dt IGS_CA_INST.START_DT%TYPE;
2384: l_acad_end_dt IGS_CA_INST.END_DT%TYPE;
2385: l_acad_message VARCHAR2(30);