[Home] [Help]
95: -- variables
96: l_deny_warn l_cur_program_steps.notification_flag%TYPE;
97: l_return_val BOOLEAN;
98: l_message VARCHAR2(2000);
99: l_upd_cp IGS_PS_UNIT_VER.POINTS_MAX%TYPE;
100:
101: l_deny_prg_steps BOOLEAN;
102: l_warn_prg_steps BOOLEAN;
103: l_calling_obj VARCHAR2(2000);
569: l_override_limit igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;
570: l_max_cp_allowed igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;
571: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
572: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
573: l_unit_cp igs_ps_unit_ver.enrolled_credit_points%TYPE;
574: l_rule_message igs_ru_item.value%TYPE;
575: l_acad_message VARCHAR2(30);
576: l_dummy_c VARCHAR2(200);
577:
593: --dummy variable to pick up audit, billing, enrolled credit points
594: --due to signature change by EN308 Billing credit hours Bug 3782329
595: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
596: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
597: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
598:
599: l_message_text VARCHAR2(2000);
600: l_message_icon VARCHAR2(1);
601:
1001: l_override_limit igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;
1002: l_min_cp_allowed igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;
1003: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1004: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1005: l_unit_cp igs_ps_unit_ver.enrolled_credit_points%TYPE;
1006: l_rule_message igs_ru_item.value%TYPE;
1007: -- Below two local variables added as part of Enrl Elgbl and Validation Build. Bug#2616692
1008:
1009: l_get_alias_val igs_ca_da_inst_v.alias_val%TYPE;
1027: --dummy variable to pick up audit, billing, enrolled credit points
1028: --due to signature change by EN308 Billing credit hours Bug 3782329
1029: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
1030: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
1031: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
1032:
1033: l_message VARCHAR2(2000);
1034: l_message_text VARCHAR2(2000);
1035: l_message_icon VARCHAR2(1);
2323: --
2324: -- Cursor to check if the Organization Unit associated with the Course is the same as the Organization associated with the Unit.
2325: CURSOR c_cow (cp_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2326: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
2327: cp_uv_owner_org_unit_cd IGS_PS_UNIT_VER.owner_org_unit_cd%TYPE,
2328: cp_uv_owner_ou_start_dt IGS_PS_UNIT_VER.owner_ou_start_dt%TYPE) IS
2329: SELECT cow.course_cd,
2330: cow.version_number,
2331: cow.org_unit_cd,
2324: -- Cursor to check if the Organization Unit associated with the Course is the same as the Organization associated with the Unit.
2325: CURSOR c_cow (cp_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2326: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
2327: cp_uv_owner_org_unit_cd IGS_PS_UNIT_VER.owner_org_unit_cd%TYPE,
2328: cp_uv_owner_ou_start_dt IGS_PS_UNIT_VER.owner_ou_start_dt%TYPE) IS
2329: SELECT cow.course_cd,
2330: cow.version_number,
2331: cow.org_unit_cd,
2332: cow.ou_start_dt
2358: l_cop_cross_location_cp IGS_PS_OFR_PAT.max_cross_location_cp%TYPE;
2359: l_cross_location_cp IGS_PS_OFR_PAT.max_cross_location_cp%TYPE := 0;
2360: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
2361:
2362: l_sua_cp IGS_PS_UNIT_VER.POINTS_MAX%TYPE;
2363: l_return_value BOOLEAN;
2364: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
2365: l_override_limit igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;
2366: l_return_eftsu NUMBER := 0;
2387: --dummy variable to pick up audit, billing, enrolled credit points
2388: --due to signature change by EN308 Billing credit hours Bug 3782329
2389: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
2390: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
2391: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
2392:
2393: l_message VARCHAR2(2000);
2394: l_message_text VARCHAR2(2000);
2395: l_message_icon VARCHAR2(1);