17: TYPE r_sua_dtl IS RECORD
18: (
19: v_teach_alternate_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE,
20: v_unit_cd IGS_EN_SU_ATTEMPT_ALL.UNIT_CD%TYPE,
21: v_title IGS_PS_UNIT_VER_ALL.TITLE%TYPE,
22: v_short_title IGS_PS_UNIT_VER_ALL.SHORT_TITLE%TYPE,
23: v_cp_achievable IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
24: v_cp_achieved IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
25: v_unit_level IGS_PS_UNIT_VER_ALL.UNIT_LEVEL%TYPE,
18: (
19: v_teach_alternate_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE,
20: v_unit_cd IGS_EN_SU_ATTEMPT_ALL.UNIT_CD%TYPE,
21: v_title IGS_PS_UNIT_VER_ALL.TITLE%TYPE,
22: v_short_title IGS_PS_UNIT_VER_ALL.SHORT_TITLE%TYPE,
23: v_cp_achievable IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
24: v_cp_achieved IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
25: v_unit_level IGS_PS_UNIT_VER_ALL.UNIT_LEVEL%TYPE,
26: v_mark IGS_AS_SU_STMPTOUT_ALL.MARK%TYPE,
19: v_teach_alternate_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE,
20: v_unit_cd IGS_EN_SU_ATTEMPT_ALL.UNIT_CD%TYPE,
21: v_title IGS_PS_UNIT_VER_ALL.TITLE%TYPE,
22: v_short_title IGS_PS_UNIT_VER_ALL.SHORT_TITLE%TYPE,
23: v_cp_achievable IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
24: v_cp_achieved IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
25: v_unit_level IGS_PS_UNIT_VER_ALL.UNIT_LEVEL%TYPE,
26: v_mark IGS_AS_SU_STMPTOUT_ALL.MARK%TYPE,
27: v_grade IGS_AS_SU_STMPTOUT_ALL.GRADE%TYPE,
20: v_unit_cd IGS_EN_SU_ATTEMPT_ALL.UNIT_CD%TYPE,
21: v_title IGS_PS_UNIT_VER_ALL.TITLE%TYPE,
22: v_short_title IGS_PS_UNIT_VER_ALL.SHORT_TITLE%TYPE,
23: v_cp_achievable IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
24: v_cp_achieved IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
25: v_unit_level IGS_PS_UNIT_VER_ALL.UNIT_LEVEL%TYPE,
26: v_mark IGS_AS_SU_STMPTOUT_ALL.MARK%TYPE,
27: v_grade IGS_AS_SU_STMPTOUT_ALL.GRADE%TYPE,
28: v_grading_schema_cd IGS_AS_SU_STMPTOUT_ALL.GRADING_SCHEMA_CD%TYPE,
21: v_title IGS_PS_UNIT_VER_ALL.TITLE%TYPE,
22: v_short_title IGS_PS_UNIT_VER_ALL.SHORT_TITLE%TYPE,
23: v_cp_achievable IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
24: v_cp_achieved IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
25: v_unit_level IGS_PS_UNIT_VER_ALL.UNIT_LEVEL%TYPE,
26: v_mark IGS_AS_SU_STMPTOUT_ALL.MARK%TYPE,
27: v_grade IGS_AS_SU_STMPTOUT_ALL.GRADE%TYPE,
28: v_grading_schema_cd IGS_AS_SU_STMPTOUT_ALL.GRADING_SCHEMA_CD%TYPE,
29: v_gs_version_number IGS_AS_SU_STMPTOUT_ALL.VERSION_NUMBER%TYPE,
48: --
49: TYPE r_asu_dtl IS RECORD
50: (
51: v_unit_cd IGS_AV_STND_UNIT_ALL.UNIT_CD%TYPE,
52: v_unit_level IGS_PS_UNIT_VER_ALL.UNIT_LEVEL%TYPE,
53: v_cp_achievable IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
54: v_title IGS_PS_UNIT_VER_ALL.TITLE%TYPE,
55: v_short_title IGS_PS_UNIT_VER_ALL.SHORT_TITLE%TYPE);
56: --
49: TYPE r_asu_dtl IS RECORD
50: (
51: v_unit_cd IGS_AV_STND_UNIT_ALL.UNIT_CD%TYPE,
52: v_unit_level IGS_PS_UNIT_VER_ALL.UNIT_LEVEL%TYPE,
53: v_cp_achievable IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
54: v_title IGS_PS_UNIT_VER_ALL.TITLE%TYPE,
55: v_short_title IGS_PS_UNIT_VER_ALL.SHORT_TITLE%TYPE);
56: --
57: --
50: (
51: v_unit_cd IGS_AV_STND_UNIT_ALL.UNIT_CD%TYPE,
52: v_unit_level IGS_PS_UNIT_VER_ALL.UNIT_LEVEL%TYPE,
53: v_cp_achievable IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
54: v_title IGS_PS_UNIT_VER_ALL.TITLE%TYPE,
55: v_short_title IGS_PS_UNIT_VER_ALL.SHORT_TITLE%TYPE);
56: --
57: --
58: TYPE r_asule_dtl IS RECORD
51: v_unit_cd IGS_AV_STND_UNIT_ALL.UNIT_CD%TYPE,
52: v_unit_level IGS_PS_UNIT_VER_ALL.UNIT_LEVEL%TYPE,
53: v_cp_achievable IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
54: v_title IGS_PS_UNIT_VER_ALL.TITLE%TYPE,
55: v_short_title IGS_PS_UNIT_VER_ALL.SHORT_TITLE%TYPE);
56: --
57: --
58: TYPE r_asule_dtl IS RECORD
59: (
75: (
76: v_teach_alternate_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE,
77: v_acad_alternate_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE,
78: v_unit_cd IGS_PS_STDNT_UNT_TRN.UNIT_CD%TYPE,
79: v_title IGS_PS_UNIT_VER_ALL.TITLE%TYPE,
80: v_short_title IGS_PS_UNIT_VER_ALL.SHORT_TITLE%TYPE,
81: v_cp_achievable IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
82: v_cp_achieved IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
83: v_unit_level IGS_PS_UNIT_VER_ALL.UNIT_LEVEL%TYPE,
76: v_teach_alternate_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE,
77: v_acad_alternate_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE,
78: v_unit_cd IGS_PS_STDNT_UNT_TRN.UNIT_CD%TYPE,
79: v_title IGS_PS_UNIT_VER_ALL.TITLE%TYPE,
80: v_short_title IGS_PS_UNIT_VER_ALL.SHORT_TITLE%TYPE,
81: v_cp_achievable IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
82: v_cp_achieved IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
83: v_unit_level IGS_PS_UNIT_VER_ALL.UNIT_LEVEL%TYPE,
84: v_mark IGS_AS_SU_STMPTOUT_ALL.MARK%TYPE,
77: v_acad_alternate_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE,
78: v_unit_cd IGS_PS_STDNT_UNT_TRN.UNIT_CD%TYPE,
79: v_title IGS_PS_UNIT_VER_ALL.TITLE%TYPE,
80: v_short_title IGS_PS_UNIT_VER_ALL.SHORT_TITLE%TYPE,
81: v_cp_achievable IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
82: v_cp_achieved IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
83: v_unit_level IGS_PS_UNIT_VER_ALL.UNIT_LEVEL%TYPE,
84: v_mark IGS_AS_SU_STMPTOUT_ALL.MARK%TYPE,
85: v_grade IGS_AS_SU_STMPTOUT_ALL.GRADE%TYPE,
78: v_unit_cd IGS_PS_STDNT_UNT_TRN.UNIT_CD%TYPE,
79: v_title IGS_PS_UNIT_VER_ALL.TITLE%TYPE,
80: v_short_title IGS_PS_UNIT_VER_ALL.SHORT_TITLE%TYPE,
81: v_cp_achievable IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
82: v_cp_achieved IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
83: v_unit_level IGS_PS_UNIT_VER_ALL.UNIT_LEVEL%TYPE,
84: v_mark IGS_AS_SU_STMPTOUT_ALL.MARK%TYPE,
85: v_grade IGS_AS_SU_STMPTOUT_ALL.GRADE%TYPE,
86: v_grading_schema_cd IGS_AS_SU_STMPTOUT_ALL.GRADING_SCHEMA_CD%TYPE,
79: v_title IGS_PS_UNIT_VER_ALL.TITLE%TYPE,
80: v_short_title IGS_PS_UNIT_VER_ALL.SHORT_TITLE%TYPE,
81: v_cp_achievable IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
82: v_cp_achieved IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,
83: v_unit_level IGS_PS_UNIT_VER_ALL.UNIT_LEVEL%TYPE,
84: v_mark IGS_AS_SU_STMPTOUT_ALL.MARK%TYPE,
85: v_grade IGS_AS_SU_STMPTOUT_ALL.GRADE%TYPE,
86: v_grading_schema_cd IGS_AS_SU_STMPTOUT_ALL.GRADING_SCHEMA_CD%TYPE,
87: v_gs_version_number IGS_AS_SU_STMPTOUT_ALL.VERSION_NUMBER%TYPE);