[Home] [Help]
3: --
4: TYPE r_sca_dtl IS RECORD
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,
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: --
16: --
17: TYPE r_sua_dtl IS RECORD
18: (
32: --
33: TYPE r_stdg_dtl IS RECORD
34: (
35: v_acad_alternate_code VARCHAR2(10),
36: v_course_cd IGS_EN_STDNT_PS_ATT_ALL.COURSE_CD%TYPE,
37: v_int_start_dt IGS_EN_STDNT_PS_INTM.START_DT%TYPE,
38: v_int_end_dt IGS_EN_STDNT_PS_INTM.END_DT%TYPE,
39: v_lapsed_dt IGS_EN_STDNT_PS_ATT_ALL.LAPSED_DT%TYPE,
40: v_discontinued_dt IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUED_DT%TYPE,
35: v_acad_alternate_code VARCHAR2(10),
36: v_course_cd IGS_EN_STDNT_PS_ATT_ALL.COURSE_CD%TYPE,
37: v_int_start_dt IGS_EN_STDNT_PS_INTM.START_DT%TYPE,
38: v_int_end_dt IGS_EN_STDNT_PS_INTM.END_DT%TYPE,
39: v_lapsed_dt IGS_EN_STDNT_PS_ATT_ALL.LAPSED_DT%TYPE,
40: v_discontinued_dt IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUED_DT%TYPE,
41: v_type VARCHAR2(10));
42: --
43: --
36: v_course_cd IGS_EN_STDNT_PS_ATT_ALL.COURSE_CD%TYPE,
37: v_int_start_dt IGS_EN_STDNT_PS_INTM.START_DT%TYPE,
38: v_int_end_dt IGS_EN_STDNT_PS_INTM.END_DT%TYPE,
39: v_lapsed_dt IGS_EN_STDNT_PS_ATT_ALL.LAPSED_DT%TYPE,
40: v_discontinued_dt IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUED_DT%TYPE,
41: v_type VARCHAR2(10));
42: --
43: --
44: TYPE r_adv_dtl IS RECORD
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: --
108: --
108: --
109: TYPE r_grd_dtl IS RECORD
110: (
111: v_acad_alternate_code VARCHAR2(10),
112: v_course_cd IGS_EN_STDNT_PS_ATT_ALL.COURSE_CD%TYPE,
113: v_completion_dt IGS_EN_STDNT_PS_ATT_ALL.COURSE_RQRMNTS_COMPLETE_DT%TYPE,
114: v_conferral_dt IGS_GR_GRADUAND.CONFERRAL_DT%TYPE,
115: v_award_title IGS_PS_AWD.AWARD_TITLE%TYPE,
116: v_type VARCHAR2(10));
109: TYPE r_grd_dtl IS RECORD
110: (
111: v_acad_alternate_code VARCHAR2(10),
112: v_course_cd IGS_EN_STDNT_PS_ATT_ALL.COURSE_CD%TYPE,
113: v_completion_dt IGS_EN_STDNT_PS_ATT_ALL.COURSE_RQRMNTS_COMPLETE_DT%TYPE,
114: v_conferral_dt IGS_GR_GRADUAND.CONFERRAL_DT%TYPE,
115: v_award_title IGS_PS_AWD.AWARD_TITLE%TYPE,
116: v_type VARCHAR2(10));
117: --