[Home] [Help]
1391: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
1392: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
1393: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
1394: --Below Three variables added as part of Enrl Elgbl and Validation Build. Bug#2616692
1395: l_credit_points igs_en_config_enr_cp.min_cp_per_term%TYPE;
1396: l_min_credit_point igs_en_config_enr_cp.min_cp_per_term%TYPE;
1397: l_deny_warn VARCHAR2(20);
1398:
1399: l_att_type IGS_PS_OFR_OPT.ATTENDANCE_TYPE%TYPE;
1392: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
1393: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
1394: --Below Three variables added as part of Enrl Elgbl and Validation Build. Bug#2616692
1395: l_credit_points igs_en_config_enr_cp.min_cp_per_term%TYPE;
1396: l_min_credit_point igs_en_config_enr_cp.min_cp_per_term%TYPE;
1397: l_deny_warn VARCHAR2(20);
1398:
1399: l_att_type IGS_PS_OFR_OPT.ATTENDANCE_TYPE%TYPE;
1400:
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;
1641: l_ret_value BOOLEAN;
1642: l_dummy VARCHAR2(200);
1643:
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;
1641: l_ret_value BOOLEAN;
1642: l_dummy VARCHAR2(200);
1643:
1644: BEGIN
1820:
1821: -- Below three cursors added as part of Enrl Elgbl and Validation Build. Bug#2616692
1822: CURSOR cur_get_min_cp_ovr IS
1823: SELECT min_cp_per_term
1824: FROM igs_en_config_enr_cp
1825: WHERE course_cd = p_program_cd AND
1826: version_number = p_program_version AND
1827: cal_type = p_load_calendar_type;
1828:
1842: -- Table.Column Type Variables
1843: l_override_limit igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;
1844: l_min_cp_allowed igs_pe_persenc_effct.restricted_enrolment_cp%TYPE := NULL ;
1845:
1846: l_get_min_cp_ovr igs_en_config_enr_cp.min_cp_per_term%TYPE;
1847: l_return_value BOOLEAN;
1848: l_effective_date igs_ca_inst.start_dt%TYPE;
1849: l_prsid_min_cp igs_en_pig_cp_setup.prsid_min_cp%TYPE;
1850:
1991:
1992: -- Below cursor added as part of Enrl Elgbl and Validation Build. Bug#2616692
1993: CURSOR cur_get_max_cp_ovr IS
1994: SELECT max_cp_per_term
1995: FROM igs_en_config_enr_cp
1996: WHERE course_cd = p_program_cd AND
1997: version_number = p_program_version AND
1998: cal_type = p_load_calendar_type;
1999: