DBA Data[Home] [Help]

APPS.IGS_AS_PRC_TRANSCRPT dependencies on IGS_PS_UNIT_VER_ALL

Line 21: v_title IGS_PS_UNIT_VER_ALL.TITLE%TYPE,

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,

Line 22: v_short_title IGS_PS_UNIT_VER_ALL.SHORT_TITLE%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,

Line 23: v_cp_achievable IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%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,

Line 24: v_cp_achieved IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%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,

Line 25: v_unit_level IGS_PS_UNIT_VER_ALL.UNIT_LEVEL%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,

Line 52: v_unit_level IGS_PS_UNIT_VER_ALL.UNIT_LEVEL%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: --

Line 53: v_cp_achievable IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%TYPE,

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: --

Line 54: v_title IGS_PS_UNIT_VER_ALL.TITLE%TYPE,

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

Line 55: v_short_title IGS_PS_UNIT_VER_ALL.SHORT_TITLE%TYPE);

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: (

Line 79: v_title IGS_PS_UNIT_VER_ALL.TITLE%TYPE,

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,

Line 80: v_short_title IGS_PS_UNIT_VER_ALL.SHORT_TITLE%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,

Line 81: v_cp_achievable IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%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,

Line 82: v_cp_achieved IGS_PS_UNIT_VER_ALL.ACHIEVABLE_CREDIT_POINTS%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,

Line 83: v_unit_level IGS_PS_UNIT_VER_ALL.UNIT_LEVEL%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);