eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_GR_PRC_GAC dependencies on IGS_GR_AWD_CEREMONY

Line 61: grd_cal_type IGS_GR_AWD_CEREMONY.grd_cal_type%TYPE,

57: t_acusg_match_blank t_acusg_match_typ;
58: -- table to hold awc matching graduand award course_cd and version_num with
59: -- links through graduation ceremony - venue - location - sca location
60: TYPE r_awc_match_typ IS RECORD(
61: grd_cal_type IGS_GR_AWD_CEREMONY.grd_cal_type%TYPE,
62: grd_ci_sequence_number IGS_GR_AWD_CEREMONY.grd_ci_sequence_number%TYPE,
63: ceremony_number IGS_GR_AWD_CEREMONY.ceremony_number%TYPE,
64: award_course_cd IGS_GR_AWD_CEREMONY.award_course_cd%TYPE,
65: award_crs_version_number IGS_GR_AWD_CEREMONY.award_crs_version_number%TYPE,

Line 62: grd_ci_sequence_number IGS_GR_AWD_CEREMONY.grd_ci_sequence_number%TYPE,

58: -- table to hold awc matching graduand award course_cd and version_num with
59: -- links through graduation ceremony - venue - location - sca location
60: TYPE r_awc_match_typ IS RECORD(
61: grd_cal_type IGS_GR_AWD_CEREMONY.grd_cal_type%TYPE,
62: grd_ci_sequence_number IGS_GR_AWD_CEREMONY.grd_ci_sequence_number%TYPE,
63: ceremony_number IGS_GR_AWD_CEREMONY.ceremony_number%TYPE,
64: award_course_cd IGS_GR_AWD_CEREMONY.award_course_cd%TYPE,
65: award_crs_version_number IGS_GR_AWD_CEREMONY.award_crs_version_number%TYPE,
66: award_cd IGS_GR_AWD_CEREMONY.award_cd%TYPE,

Line 63: ceremony_number IGS_GR_AWD_CEREMONY.ceremony_number%TYPE,

59: -- links through graduation ceremony - venue - location - sca location
60: TYPE r_awc_match_typ IS RECORD(
61: grd_cal_type IGS_GR_AWD_CEREMONY.grd_cal_type%TYPE,
62: grd_ci_sequence_number IGS_GR_AWD_CEREMONY.grd_ci_sequence_number%TYPE,
63: ceremony_number IGS_GR_AWD_CEREMONY.ceremony_number%TYPE,
64: award_course_cd IGS_GR_AWD_CEREMONY.award_course_cd%TYPE,
65: award_crs_version_number IGS_GR_AWD_CEREMONY.award_crs_version_number%TYPE,
66: award_cd IGS_GR_AWD_CEREMONY.award_cd%TYPE,
67: dflt_ind IGS_AD_LOCATION_REL.dflt_ind%TYPE);

Line 64: award_course_cd IGS_GR_AWD_CEREMONY.award_course_cd%TYPE,

60: TYPE r_awc_match_typ IS RECORD(
61: grd_cal_type IGS_GR_AWD_CEREMONY.grd_cal_type%TYPE,
62: grd_ci_sequence_number IGS_GR_AWD_CEREMONY.grd_ci_sequence_number%TYPE,
63: ceremony_number IGS_GR_AWD_CEREMONY.ceremony_number%TYPE,
64: award_course_cd IGS_GR_AWD_CEREMONY.award_course_cd%TYPE,
65: award_crs_version_number IGS_GR_AWD_CEREMONY.award_crs_version_number%TYPE,
66: award_cd IGS_GR_AWD_CEREMONY.award_cd%TYPE,
67: dflt_ind IGS_AD_LOCATION_REL.dflt_ind%TYPE);
68: r_awc_match r_awc_match_typ;

Line 65: award_crs_version_number IGS_GR_AWD_CEREMONY.award_crs_version_number%TYPE,

61: grd_cal_type IGS_GR_AWD_CEREMONY.grd_cal_type%TYPE,
62: grd_ci_sequence_number IGS_GR_AWD_CEREMONY.grd_ci_sequence_number%TYPE,
63: ceremony_number IGS_GR_AWD_CEREMONY.ceremony_number%TYPE,
64: award_course_cd IGS_GR_AWD_CEREMONY.award_course_cd%TYPE,
65: award_crs_version_number IGS_GR_AWD_CEREMONY.award_crs_version_number%TYPE,
66: award_cd IGS_GR_AWD_CEREMONY.award_cd%TYPE,
67: dflt_ind IGS_AD_LOCATION_REL.dflt_ind%TYPE);
68: r_awc_match r_awc_match_typ;
69: TYPE t_awc_match_typ IS TABLE OF r_awc_match%TYPE

Line 66: award_cd IGS_GR_AWD_CEREMONY.award_cd%TYPE,

62: grd_ci_sequence_number IGS_GR_AWD_CEREMONY.grd_ci_sequence_number%TYPE,
63: ceremony_number IGS_GR_AWD_CEREMONY.ceremony_number%TYPE,
64: award_course_cd IGS_GR_AWD_CEREMONY.award_course_cd%TYPE,
65: award_crs_version_number IGS_GR_AWD_CEREMONY.award_crs_version_number%TYPE,
66: award_cd IGS_GR_AWD_CEREMONY.award_cd%TYPE,
67: dflt_ind IGS_AD_LOCATION_REL.dflt_ind%TYPE);
68: r_awc_match r_awc_match_typ;
69: TYPE t_awc_match_typ IS TABLE OF r_awc_match%TYPE
70: INDEX BY BINARY_INTEGER;

Line 100: IGS_GR_AWD_CEREMONY awc,

96: awc.award_crs_version_number,
97: awc.award_cd,
98: lr.dflt_ind
99: FROM IGS_GR_GRADUAND gr,
100: IGS_GR_AWD_CEREMONY awc,
101: IGS_EN_STDNT_PS_ATT sca,
102: IGS_GR_CRMN gc,
103: IGS_GR_VENUE ve,
104: IGS_AD_LOCATION_REL lr,

Line 136: cp_grd_cal_type IGS_GR_AWD_CEREMONY.grd_cal_type%TYPE,

132: awc.award_course_cd,
133: awc.award_crs_version_number,
134: awc.award_cd;
135: CURSOR c_acusg (
136: cp_grd_cal_type IGS_GR_AWD_CEREMONY.grd_cal_type%TYPE,
137: cp_grd_ci_sequence_number IGS_GR_AWD_CEREMONY.grd_ci_sequence_number%TYPE,
138: cp_ceremony_number IGS_GR_AWD_CEREMONY.ceremony_number%TYPE,
139: cp_award_course_cd IGS_GR_AWD_CEREMONY.award_course_cd%TYPE,
140: cp_award_crs_version_number IGS_GR_AWD_CEREMONY.award_crs_version_number%TYPE,

Line 137: cp_grd_ci_sequence_number IGS_GR_AWD_CEREMONY.grd_ci_sequence_number%TYPE,

133: awc.award_crs_version_number,
134: awc.award_cd;
135: CURSOR c_acusg (
136: cp_grd_cal_type IGS_GR_AWD_CEREMONY.grd_cal_type%TYPE,
137: cp_grd_ci_sequence_number IGS_GR_AWD_CEREMONY.grd_ci_sequence_number%TYPE,
138: cp_ceremony_number IGS_GR_AWD_CEREMONY.ceremony_number%TYPE,
139: cp_award_course_cd IGS_GR_AWD_CEREMONY.award_course_cd%TYPE,
140: cp_award_crs_version_number IGS_GR_AWD_CEREMONY.award_crs_version_number%TYPE,
141: cp_award_cd IGS_GR_AWD_CEREMONY.award_cd%TYPE) IS

Line 138: cp_ceremony_number IGS_GR_AWD_CEREMONY.ceremony_number%TYPE,

134: awc.award_cd;
135: CURSOR c_acusg (
136: cp_grd_cal_type IGS_GR_AWD_CEREMONY.grd_cal_type%TYPE,
137: cp_grd_ci_sequence_number IGS_GR_AWD_CEREMONY.grd_ci_sequence_number%TYPE,
138: cp_ceremony_number IGS_GR_AWD_CEREMONY.ceremony_number%TYPE,
139: cp_award_course_cd IGS_GR_AWD_CEREMONY.award_course_cd%TYPE,
140: cp_award_crs_version_number IGS_GR_AWD_CEREMONY.award_crs_version_number%TYPE,
141: cp_award_cd IGS_GR_AWD_CEREMONY.award_cd%TYPE) IS
142: SELECT acusg.grd_cal_type,

Line 139: cp_award_course_cd IGS_GR_AWD_CEREMONY.award_course_cd%TYPE,

135: CURSOR c_acusg (
136: cp_grd_cal_type IGS_GR_AWD_CEREMONY.grd_cal_type%TYPE,
137: cp_grd_ci_sequence_number IGS_GR_AWD_CEREMONY.grd_ci_sequence_number%TYPE,
138: cp_ceremony_number IGS_GR_AWD_CEREMONY.ceremony_number%TYPE,
139: cp_award_course_cd IGS_GR_AWD_CEREMONY.award_course_cd%TYPE,
140: cp_award_crs_version_number IGS_GR_AWD_CEREMONY.award_crs_version_number%TYPE,
141: cp_award_cd IGS_GR_AWD_CEREMONY.award_cd%TYPE) IS
142: SELECT acusg.grd_cal_type,
143: acusg.grd_ci_sequence_number,

Line 140: cp_award_crs_version_number IGS_GR_AWD_CEREMONY.award_crs_version_number%TYPE,

136: cp_grd_cal_type IGS_GR_AWD_CEREMONY.grd_cal_type%TYPE,
137: cp_grd_ci_sequence_number IGS_GR_AWD_CEREMONY.grd_ci_sequence_number%TYPE,
138: cp_ceremony_number IGS_GR_AWD_CEREMONY.ceremony_number%TYPE,
139: cp_award_course_cd IGS_GR_AWD_CEREMONY.award_course_cd%TYPE,
140: cp_award_crs_version_number IGS_GR_AWD_CEREMONY.award_crs_version_number%TYPE,
141: cp_award_cd IGS_GR_AWD_CEREMONY.award_cd%TYPE) IS
142: SELECT acusg.grd_cal_type,
143: acusg.grd_ci_sequence_number,
144: acusg.ceremony_number,

Line 141: cp_award_cd IGS_GR_AWD_CEREMONY.award_cd%TYPE) IS

137: cp_grd_ci_sequence_number IGS_GR_AWD_CEREMONY.grd_ci_sequence_number%TYPE,
138: cp_ceremony_number IGS_GR_AWD_CEREMONY.ceremony_number%TYPE,
139: cp_award_course_cd IGS_GR_AWD_CEREMONY.award_course_cd%TYPE,
140: cp_award_crs_version_number IGS_GR_AWD_CEREMONY.award_crs_version_number%TYPE,
141: cp_award_cd IGS_GR_AWD_CEREMONY.award_cd%TYPE) IS
142: SELECT acusg.grd_cal_type,
143: acusg.grd_ci_sequence_number,
144: acusg.ceremony_number,
145: acusg.award_course_cd,