710: --
711: -- Get Grading Schema details
712: --
713: CURSOR c_gsg (
714: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
715: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE
716: ) IS
717: SELECT gsg.lower_mark_range,
718: gsg.upper_mark_range,
711: -- Get Grading Schema details
712: --
713: CURSOR c_gsg (
714: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
715: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE
716: ) IS
717: SELECT gsg.lower_mark_range,
718: gsg.upper_mark_range,
719: gsg.s_result_type
716: ) IS
717: SELECT gsg.lower_mark_range,
718: gsg.upper_mark_range,
719: gsg.s_result_type
720: FROM igs_as_grd_sch_grade gsg
721: WHERE gsg.grading_schema_cd = cp_grading_schema_cd
722: AND gsg.version_number = cp_gs_version_number
723: AND gsg.grade = p_grade
724: AND gsg.system_only_ind = 'N';
725: --
726: -- Derive Grade
727: --
728: CURSOR c_gsg_derive (
729: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
730: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE
731: ) IS
732: SELECT gsg.grade
733: FROM igs_as_grd_sch_grade gsg
726: -- Derive Grade
727: --
728: CURSOR c_gsg_derive (
729: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
730: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE
731: ) IS
732: SELECT gsg.grade
733: FROM igs_as_grd_sch_grade gsg
734: WHERE gsg.grading_schema_cd = cp_grading_schema_cd
729: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
730: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE
731: ) IS
732: SELECT gsg.grade
733: FROM igs_as_grd_sch_grade gsg
734: WHERE gsg.grading_schema_cd = cp_grading_schema_cd
735: AND gsg.version_number = cp_gs_version_number
736: AND gsg.system_only_ind = 'N'
737: AND p_mark BETWEEN lower_mark_range AND upper_mark_range + 0.999;
792: -- Get the Minimum of the Lower and Maximum of the Upper Mark limits
793: -- as setup in the Grading Schema
794: --
795: CURSOR c_gsg_min_max (
796: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
797: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE
798: ) IS
799: SELECT NVL (MIN (gsg.lower_mark_range), 0) min_lower_mark_range,
800: NVL (MAX (gsg.upper_mark_range), 1000) max_upper_mark_range
793: -- as setup in the Grading Schema
794: --
795: CURSOR c_gsg_min_max (
796: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
797: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE
798: ) IS
799: SELECT NVL (MIN (gsg.lower_mark_range), 0) min_lower_mark_range,
800: NVL (MAX (gsg.upper_mark_range), 1000) max_upper_mark_range
801: FROM igs_as_grd_sch_grade gsg
797: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE
798: ) IS
799: SELECT NVL (MIN (gsg.lower_mark_range), 0) min_lower_mark_range,
800: NVL (MAX (gsg.upper_mark_range), 1000) max_upper_mark_range
801: FROM igs_as_grd_sch_grade gsg
802: WHERE gsg.grading_schema_cd = cp_grading_schema_cd
803: AND gsg.version_number = cp_gs_version_number;
804: rec_gsg_min_max c_gsg_min_max%ROWTYPE;
805: --