DBA Data[Home] [Help]

APPS.IGS_AS_PRC_TRANSCRPT dependencies on IGS_CA_INST_ALL

Line 9: v_acad_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE,

5: (
6: v_acad_alternate_code VARCHAR2(10),
7: v_course_cd IGS_EN_STDNT_PS_ATT_ALL.COURSE_CD%TYPE,
8: v_title IGS_PS_VER_ALL.TITLE%TYPE,
9: v_acad_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE,
10: v_acad_ci_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE,
11: v_acad_start_dt IGS_CA_INST_ALL.START_DT%TYPE,
12: v_attendance_type IGS_PS_OFR_PAT.ATTENDANCE_TYPE%TYPE,
13: v_location_cd IGS_PS_OFR_PAT.LOCATION_CD%TYPE,

Line 10: v_acad_ci_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE,

6: v_acad_alternate_code VARCHAR2(10),
7: v_course_cd IGS_EN_STDNT_PS_ATT_ALL.COURSE_CD%TYPE,
8: v_title IGS_PS_VER_ALL.TITLE%TYPE,
9: v_acad_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE,
10: v_acad_ci_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE,
11: v_acad_start_dt IGS_CA_INST_ALL.START_DT%TYPE,
12: v_attendance_type IGS_PS_OFR_PAT.ATTENDANCE_TYPE%TYPE,
13: v_location_cd IGS_PS_OFR_PAT.LOCATION_CD%TYPE,
14: v_commencement_dt IGS_EN_STDNT_PS_ATT_ALL.COMMENCEMENT_DT%TYPE);

Line 11: v_acad_start_dt IGS_CA_INST_ALL.START_DT%TYPE,

7: v_course_cd IGS_EN_STDNT_PS_ATT_ALL.COURSE_CD%TYPE,
8: v_title IGS_PS_VER_ALL.TITLE%TYPE,
9: v_acad_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE,
10: v_acad_ci_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE,
11: v_acad_start_dt IGS_CA_INST_ALL.START_DT%TYPE,
12: v_attendance_type IGS_PS_OFR_PAT.ATTENDANCE_TYPE%TYPE,
13: v_location_cd IGS_PS_OFR_PAT.LOCATION_CD%TYPE,
14: v_commencement_dt IGS_EN_STDNT_PS_ATT_ALL.COMMENCEMENT_DT%TYPE);
15: --

Line 19: v_teach_alternate_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE,

15: --
16: --
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,

Line 67: v_teach_alternate_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE,

63: --
64: --
65: TYPE r_sct_dtl IS RECORD
66: (
67: v_teach_alternate_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE,
68: v_from_course IGS_PS_STDNT_TRN.TRANSFER_COURSE_CD%TYPE,
69: v_to_course IGS_PS_STDNT_TRN.COURSE_CD%TYPE,
70: v_transfer_dt IGS_PS_STDNT_TRN.TRANSFER_DT%TYPE,
71: v_unit_ind VARCHAR2(1));

Line 76: v_teach_alternate_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE,

72: --
73: --
74: TYPE r_sut_dtl IS RECORD
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,

Line 77: v_acad_alternate_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE,

73: --
74: TYPE r_sut_dtl IS RECORD
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,

Line 103: v_teach_alternate_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE,

99: --
100: --
101: TYPE r_res_dtl IS RECORD
102: (
103: v_teach_alternate_code IGS_CA_INST_ALL.ALTERNATE_CODE%TYPE,
104: v_course_cd IGS_EN_STDNT_PS_ATT_ALL.COURSE_CD%TYPE,
105: v_title IGS_RE_THESIS_ALL.TITLE%TYPE,
106: v_final_title_ind IGS_RE_THESIS_ALL.FINAL_TITLE_IND%TYPE);
107: --