[Home] [Help]
1405: v_unit_attempt_status IGS_AD_ADM_UNIT_STAT.unit_attempt_status%TYPE;
1406: v_alias_val DATE;
1407: v_admin_unit_status_str VARCHAR2(2000);
1408: v_first_char NUMBER;
1409: v_grading_schema_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE;
1410: v_version_number IGS_AS_GRD_SCHEMA.version_number%TYPE;
1411: v_message_name varchar2(30);
1412: v_string_found BOOLEAN := FALSE;
1413: v_current_string IGS_AD_ADM_UNIT_STAT.administrative_unit_status%TYPE;
1406: v_alias_val DATE;
1407: v_admin_unit_status_str VARCHAR2(2000);
1408: v_first_char NUMBER;
1409: v_grading_schema_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE;
1410: v_version_number IGS_AS_GRD_SCHEMA.version_number%TYPE;
1411: v_message_name varchar2(30);
1412: v_string_found BOOLEAN := FALSE;
1413: v_current_string IGS_AD_ADM_UNIT_STAT.administrative_unit_status%TYPE;
1414: v_administrative_unit_status VARCHAR2(2000);
1587:
1588: BEGIN
1589: DECLARE
1590: TYPE t_schema_dtls IS RECORD (
1591: grading_schema_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE,
1592: version_number IGS_AS_GRD_SCHEMA.version_number%TYPE );
1593: CURSOR c_get_schema_dtls IS
1594: SELECT DISTINCT gs.grading_schema_cd,
1595: gs.version_number
1588: BEGIN
1589: DECLARE
1590: TYPE t_schema_dtls IS RECORD (
1591: grading_schema_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE,
1592: version_number IGS_AS_GRD_SCHEMA.version_number%TYPE );
1593: CURSOR c_get_schema_dtls IS
1594: SELECT DISTINCT gs.grading_schema_cd,
1595: gs.version_number
1596: FROM IGS_AS_GRD_SCHEMA gs,
1592: version_number IGS_AS_GRD_SCHEMA.version_number%TYPE );
1593: CURSOR c_get_schema_dtls IS
1594: SELECT DISTINCT gs.grading_schema_cd,
1595: gs.version_number
1596: FROM IGS_AS_GRD_SCHEMA gs,
1597: IGS_AS_GRD_SCH_GRADE gsg,
1598: IGS_AD_ADM_UT_STA_GD ausg
1599: WHERE gs.start_dt <= TRUNC(p_effective_dt) AND
1600: (gs.end_dt IS NULL OR
1690: WHERE ausg.administrative_unit_status = cp_admin_unit_status;
1691:
1692: CURSOR c_ausg_count
1693: (cp_admin_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE,
1694: cp_effective_dt IGS_AS_GRD_SCHEMA.start_dt%TYPE,
1695: cp_no_assessment_ind IGS_EN_SU_ATTEMPT.NO_ASSESSMENT_IND%TYPE) IS
1696: SELECT COUNT(*)
1697: FROM igs_ad_adm_ut_sta_gd ausg,
1698: igs_as_grd_schema gs,
1694: cp_effective_dt IGS_AS_GRD_SCHEMA.start_dt%TYPE,
1695: cp_no_assessment_ind IGS_EN_SU_ATTEMPT.NO_ASSESSMENT_IND%TYPE) IS
1696: SELECT COUNT(*)
1697: FROM igs_ad_adm_ut_sta_gd ausg,
1698: igs_as_grd_schema gs,
1699: igs_as_grd_sch_grade gsg
1700: WHERE ausg.administrative_unit_status = cp_admin_unit_status AND
1701: gs.grading_schema_cd = ausg.grading_schema_cd AND
1702: gs.version_number = ausg.version_number AND
1712: );
1713:
1714: CURSOR c_ausg
1715: (cp_admin_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE,
1716: cp_effective_dt IGS_AS_GRD_SCHEMA.start_dt%TYPE,
1717: cp_no_assessment_ind IGS_EN_SU_ATTEMPT.NO_ASSESSMENT_IND%TYPE) IS
1718: SELECT ausg.grading_schema_cd,
1719: ausg.version_number,
1720: ausg.grade
1718: SELECT ausg.grading_schema_cd,
1719: ausg.version_number,
1720: ausg.grade
1721: FROM igs_ad_adm_ut_sta_gd ausg,
1722: igs_as_grd_schema gs,
1723: igs_as_grd_sch_grade gsg
1724: WHERE ausg.administrative_unit_status = cp_admin_unit_status AND
1725: gs.grading_schema_cd = ausg.grading_schema_cd AND
1726: gs.version_number = ausg.version_number AND
1737:
1738: CURSOR c_sua_ausg
1739: (cp_admin_unit_status
1740: IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE,
1741: cp_effective_dt IGS_AS_GRD_SCHEMA.start_dt%TYPE) IS
1742: SELECT ausg.grading_schema_cd,
1743: ausg.version_number,
1744: ausg.grade
1745: FROM IGS_EN_SU_ATTEMPT sua,
1744: ausg.grade
1745: FROM IGS_EN_SU_ATTEMPT sua,
1746: IGS_PS_UNIT_OFR_OPT uoo,
1747: IGS_AD_ADM_UT_STA_GD ausg,
1748: IGS_AS_GRD_SCHEMA gs,
1749: igs_as_grd_sch_grade gsg
1750: WHERE sua.person_id = p_person_id AND
1751: sua.course_cd = p_course_cd AND
1752: sua.uoo_id = p_uoo_id AND