DBA Data[Home] [Help]

APPS.IGS_EN_ELGBL_PROGRAM dependencies on IGS_CA_INST_ALL

Line 611: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;

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:
615: BEGIN

Line 1635: l_enrol_cal_type igs_ca_inst_all.cal_type%TYPE;

1631:
1632: l_acad_ci_seq_number igs_ca_inst_rel.sup_ci_sequence_number%TYPE;
1633: l_commencement_type VARCHAR2(10);
1634: l_enrollment_cat igs_en_cat_prc_dtl.enrolment_cat%TYPE;
1635: l_enrol_cal_type igs_ca_inst_all.cal_type%TYPE;
1636: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1637: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
1638: l_message fnd_new_messages.message_name%TYPE;
1639: l_credit_points igs_en_config_enr_cp.min_cp_per_term%TYPE;

Line 1636: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;

1632: l_acad_ci_seq_number igs_ca_inst_rel.sup_ci_sequence_number%TYPE;
1633: l_commencement_type VARCHAR2(10);
1634: l_enrollment_cat igs_en_cat_prc_dtl.enrolment_cat%TYPE;
1635: l_enrol_cal_type igs_ca_inst_all.cal_type%TYPE;
1636: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1637: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
1638: l_message fnd_new_messages.message_name%TYPE;
1639: l_credit_points igs_en_config_enr_cp.min_cp_per_term%TYPE;
1640: l_min_credit_point igs_en_config_enr_cp.min_cp_per_term%TYPE;

Line 2019: l_enrol_sequence_number igs_ca_inst_all.sequence_number%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:
2023: l_return_value := igs_en_gen_015.validation_step_is_overridden ( p_eligibility_step_type => 'FMAX_CRDT',