DBA Data[Home] [Help]

APPS.IGS_AS_PRC_TRANSCRPT dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 7: v_course_cd IGS_EN_STDNT_PS_ATT_ALL.COURSE_CD%TYPE,

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,

Line 14: v_commencement_dt IGS_EN_STDNT_PS_ATT_ALL.COMMENCEMENT_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: (

Line 36: v_course_cd IGS_EN_STDNT_PS_ATT_ALL.COURSE_CD%TYPE,

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,

Line 39: v_lapsed_dt IGS_EN_STDNT_PS_ATT_ALL.LAPSED_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: --

Line 40: v_discontinued_dt IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUED_DT%TYPE,

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

Line 104: v_course_cd IGS_EN_STDNT_PS_ATT_ALL.COURSE_CD%TYPE,

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

Line 112: v_course_cd IGS_EN_STDNT_PS_ATT_ALL.COURSE_CD%TYPE,

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));

Line 113: v_completion_dt IGS_EN_STDNT_PS_ATT_ALL.COURSE_RQRMNTS_COMPLETE_DT%TYPE,

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