[Home] [Help]
1440: CLOSE cur_uoo_id ;
1441:
1442: IF l_deny_warn_min_cp IS NOT NULL THEN -- Min CP validation step is defined
1443:
1444: -- A call to igs_en_prc_load.enrp_clc_eftsu_total as part of- Enrollment Eligibility and validations .
1445: -- The Total enrolled CP of the student has to be determined before the unit is dropped(l_total_credit_points) .
1446: -- The unit is then dropped , and eval_min_cp is called with the value of l_total_enrolled_cp.
1447: -- The value of l_total_enrolled_cp is essential to determine if the Min Credit Points is already reached
1448: -- by the student before that Unit is dropped.
1446: -- The unit is then dropped , and eval_min_cp is called with the value of l_total_enrolled_cp.
1447: -- The value of l_total_enrolled_cp is essential to determine if the Min Credit Points is already reached
1448: -- by the student before that Unit is dropped.
1449:
1450: l_eftsu_total := igs_en_prc_load.enrp_clc_eftsu_total(
1451: p_person_id => p_person_id,
1452: p_course_cd => p_program_cd ,
1453: p_acad_cal_type => l_acad_cal_type,
1454: p_acad_sequence_number => l_acad_ci_sequence_number,
2043: --kkillams 27-Mar-03 Modified cur_su Cursor, replaced * with relevant columns w.r.t. bug 2749648
2044: --svenkata 6-Jun-2003 Added new validations for checking Cross element Restrictions. The validations Cross location, cross faculty amd cross mode are introduced
2045: -- as part of deny/ warn build. Bug 2829272.Modifications have been made in such a way that only DENY OR only WARN messages will be returned.
2046: --myoganat 16-Jun-2003 Removed the reference to profile IGS_EN_INCL_AUDIT_CP.
2047: --sarakshi 27-Jun-2003 Enh#2930935,added p_uoo_id parameter to IGS_EN_PRC_LOAD.ENRP_CLC_SUA_LOAD
2048: --vkarthik 22-Jul-2004 Added three dummy variables l_audit_cp, l_billing_cp, l_enrolled_cp for all the calls to
2049: -- igs_en_prc_load.enrp_clc_sua_load towards EN308 Billable credit points build Enh#3782329
2050:
2051: CURSOR cur_su IS
2045: -- as part of deny/ warn build. Bug 2829272.Modifications have been made in such a way that only DENY OR only WARN messages will be returned.
2046: --myoganat 16-Jun-2003 Removed the reference to profile IGS_EN_INCL_AUDIT_CP.
2047: --sarakshi 27-Jun-2003 Enh#2930935,added p_uoo_id parameter to IGS_EN_PRC_LOAD.ENRP_CLC_SUA_LOAD
2048: --vkarthik 22-Jul-2004 Added three dummy variables l_audit_cp, l_billing_cp, l_enrolled_cp for all the calls to
2049: -- igs_en_prc_load.enrp_clc_sua_load towards EN308 Billable credit points build Enh#3782329
2050:
2051: CURSOR cur_su IS
2052: SELECT unit_cd,
2053: version_number,
2179: --
2180: -- Getting the current cp and passing this against parameter p_override_enrolled_cp to get Incurred CP.
2181: -- (As the current CP can be from igs_ps_unit_ver or from igs_en_su_attempt)
2182: l_current_cp := igs_ss_enr_details.get_credit_points(x_person_id,x_uoo_id,l_su_rec.unit_cd,l_su_rec.version_number,x_program_cd);
2183: IF Igs_En_Prc_Load.ENRP_GET_LOAD_INCUR(
2184: l_su_rec.cal_type,
2185: l_su_rec.ci_sequence_number,
2186: l_su_rec.discontinued_dt,
2187: l_su_rec.administrative_unit_status ,
2193: NULL, -- for p_uoo_id
2194: 'N') = 'Y' THEN
2195: -- calculate CP incurred in the given Load calendar for Enrolled credit points.
2196:
2197: l_enr_incurred_cp := Igs_En_Prc_Load.enrp_clc_sua_load(
2198: p_unit_cd => l_su_rec.unit_cd,
2199: p_version_number => l_su_rec.version_number,
2200: p_cal_type => l_su_rec.cal_type,
2201: p_ci_sequence_number => l_su_rec.ci_sequence_number,
2213:
2214: END IF;
2215: --
2216: -- calculate CP incurred in the given Load calendar for Override Enrolled credit points.
2217: l_over_incurred_cp := Igs_En_Prc_Load.enrp_clc_sua_load(
2218: p_unit_cd => l_su_rec.unit_cd,
2219: p_version_number => l_su_rec.version_number,
2220: p_cal_type => l_su_rec.cal_type,
2221: p_ci_sequence_number => l_su_rec.ci_sequence_number,
2351: x_return_status := 'DENY';
2352: RETURN;
2353: END IF;
2354:
2355: -- A call to igs_en_prc_load.enrp_clc_eftsu_total as part of- Enrollment Eligibility and validations .The Total enrolled CP
2356: -- of the student has to be determined before the credit points of the unit is changed.The Credit Points of the unit is then
2357: -- changed, and eval_min_cp is called with the value l_total_credit_points passed to the parameter l_total_enrolled_cp.The
2358: -- value of l_total_enrolled_cp is essential to determine if the Min Credit Points is already reached by the student before
2359: -- the Credit points are changed.
2359: -- the Credit points are changed.
2360:
2361: IF l_deny_warn_min_cp ='DENY' THEN
2362:
2363: l_eftsu_total := igs_en_prc_load.enrp_clc_eftsu_total(
2364: p_person_id => x_person_id,
2365: p_course_cd => x_program_cd ,
2366: p_acad_cal_type => l_acad_cal_type,
2367: p_acad_sequence_number => l_acad_ci_sequence_number,
2982: END IF;
2983:
2984: IF l_deny_warn_min_cp IS NOT NULL THEN -- Min CP validation step is defined
2985:
2986: -- A call to igs_en_prc_load.enrp_clc_eftsu_total as part of- Enrollment Eligibility and validations .
2987: -- The Total enrolled CP of the student has to be determined before the unit is dropped(l_total_credit_points) .
2988: -- The unit is then dropped , and eval_min_cp is called with the value of l_total_enrolled_cp.
2989: -- The value of l_total_enrolled_cp is essential to determine if the Min Credit Points is already reached
2990: -- by the student before that Unit is dropped.