[Home] [Help]
480: -------------------------------------------------------------------------------------
481:
482: l_drop_uoo_ids VARCHAR2(255);
483: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
484: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
485: l_unit_version igs_ps_unit_ver.version_number%TYPE;
486: lv_message_name VARCHAR2(2000);
487: lv_message_name2 VARCHAR2(2000);
488: lv_return_type VARCHAR2(2);
481:
482: l_drop_uoo_ids VARCHAR2(255);
483: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
484: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
485: l_unit_version igs_ps_unit_ver.version_number%TYPE;
486: lv_message_name VARCHAR2(2000);
487: lv_message_name2 VARCHAR2(2000);
488: lv_return_type VARCHAR2(2);
489: l_enr_method IGS_EN_METHOD_TYPE.enr_method_type%TYPE;
825: FROM igs_en_su_attempt sua,
826: igs_en_usec_stat_dsp_v enusecstat,
827: igs_ps_unit_ofr_opt uoo,
828: igs_ps_usec_cps cps,
829: igs_ps_unit_ver uv
830: WHERE sua.person_id = cp_person_id AND
831: sua.course_cd = cp_course_cd AND
832: sua.uoo_id = uoo.uoo_id AND
833: uoo.uoo_id = cps.uoo_id(+) AND
1003: l_coreq_failed_units VARCHAR2(2000);
1004: l_prereq_failed_units VARCHAR2(2000);
1005: l_drop_uoo_ids VARCHAR2(2000);
1006:
1007: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
1008: l_unit_version_number igs_ps_unit_ver.VERSION_NUMBER%TYPE;
1009:
1010: l_enr_meth_type igs_en_method_type.enr_method_type%TYPE;
1011: l_enr_cal_type VARCHAR2(20);
1004: l_prereq_failed_units VARCHAR2(2000);
1005: l_drop_uoo_ids VARCHAR2(2000);
1006:
1007: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
1008: l_unit_version_number igs_ps_unit_ver.VERSION_NUMBER%TYPE;
1009:
1010: l_enr_meth_type igs_en_method_type.enr_method_type%TYPE;
1011: l_enr_cal_type VARCHAR2(20);
1012: l_enr_ci_seq NUMBER(20);
2127: --dummy variables to pick up audit, billing, enrolled credit points
2128: --due to signature change by EN308 Billing credit hours Bug 3782329
2129: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
2130: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
2131: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
2132:
2133: BEGIN
2134:
2135: SAVEPOINT upd_sua_cp;
2177: -- Below code is added as part of Bug 2401891
2178: -- Checking Load Incurred as user can re-instate a discontinued unit and change CP in one transaction
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,
2684: -- Added as part of Enrollment Eligibility and validations
2685: l_eftsu_total igs_en_su_attempt.override_eftsu%type;
2686: l_total_credit_points NUMBER;
2687: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE := 0;
2688: l_unit_version_number igs_ps_unit_ver.VERSION_NUMBER%TYPE;
2689: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
2690: l_acad_start_dt igs_ca_inst.start_dt%type;
2691: l_acad_end_dt igs_ca_inst.end_dt%type;
2692: l_alternate_code igs_ca_inst.alternate_code%type;
4077: -------------------------------------------------------------------
4078: CURSOR c_usec_audit_lim IS
4079: SELECT NVL (usec.max_auditors_allowed, NVL(uv.max_auditors_allowed,999999) )
4080: FROM igs_ps_usec_lim_wlst usec,
4081: igs_ps_unit_ver uv,
4082: igs_ps_unit_ofr_opt uoo
4083: WHERE uoo.unit_cd = uv.unit_cd
4084: AND uoo.version_number = uv.version_number
4085: AND uoo.uoo_id = usec.uoo_id (+)