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.

[Home] [Help]

APPS.IGS_GR_VAL_AWC dependencies on IGS_GR_AWD_CRM_US_GP

Line 160: v_acusg_grd_cal_type IGS_GR_AWD_CRM_US_GP.grd_cal_type%TYPE;

156: RETURN BOOLEAN AS
157: BEGIN -- grdp_val_awc_order
158: DECLARE
159: v_awc_exists VARCHAR2(1);
160: v_acusg_grd_cal_type IGS_GR_AWD_CRM_US_GP.grd_cal_type%TYPE;
161: v_acusg_grd_ci_sequence_number
162: IGS_GR_AWD_CRM_US_GP.grd_ci_sequence_number%TYPE;
163: v_acusg_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE;
164: v_acusg_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE;

Line 162: IGS_GR_AWD_CRM_US_GP.grd_ci_sequence_number%TYPE;

158: DECLARE
159: v_awc_exists VARCHAR2(1);
160: v_acusg_grd_cal_type IGS_GR_AWD_CRM_US_GP.grd_cal_type%TYPE;
161: v_acusg_grd_ci_sequence_number
162: IGS_GR_AWD_CRM_US_GP.grd_ci_sequence_number%TYPE;
163: v_acusg_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE;
164: v_acusg_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE;
165: v_acusg_award_crs_version_num
166: IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE;

Line 163: v_acusg_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE;

159: v_awc_exists VARCHAR2(1);
160: v_acusg_grd_cal_type IGS_GR_AWD_CRM_US_GP.grd_cal_type%TYPE;
161: v_acusg_grd_ci_sequence_number
162: IGS_GR_AWD_CRM_US_GP.grd_ci_sequence_number%TYPE;
163: v_acusg_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE;
164: v_acusg_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE;
165: v_acusg_award_crs_version_num
166: IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE;
167: v_acusg_award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE;

Line 164: v_acusg_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE;

160: v_acusg_grd_cal_type IGS_GR_AWD_CRM_US_GP.grd_cal_type%TYPE;
161: v_acusg_grd_ci_sequence_number
162: IGS_GR_AWD_CRM_US_GP.grd_ci_sequence_number%TYPE;
163: v_acusg_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE;
164: v_acusg_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE;
165: v_acusg_award_crs_version_num
166: IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE;
167: v_acusg_award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE;
168: v_acusg_us_group_number IGS_GR_AWD_CRM_US_GP.us_group_number%TYPE;

Line 166: IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE;

162: IGS_GR_AWD_CRM_US_GP.grd_ci_sequence_number%TYPE;
163: v_acusg_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE;
164: v_acusg_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE;
165: v_acusg_award_crs_version_num
166: IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE;
167: v_acusg_award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE;
168: v_acusg_us_group_number IGS_GR_AWD_CRM_US_GP.us_group_number%TYPE;
169: v_message_name VARCHAR2(30);
170: CURSOR c_awc IS

Line 167: v_acusg_award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE;

163: v_acusg_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE;
164: v_acusg_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE;
165: v_acusg_award_crs_version_num
166: IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE;
167: v_acusg_award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE;
168: v_acusg_us_group_number IGS_GR_AWD_CRM_US_GP.us_group_number%TYPE;
169: v_message_name VARCHAR2(30);
170: CURSOR c_awc IS
171: SELECT 'X'

Line 168: v_acusg_us_group_number IGS_GR_AWD_CRM_US_GP.us_group_number%TYPE;

164: v_acusg_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE;
165: v_acusg_award_crs_version_num
166: IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE;
167: v_acusg_award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE;
168: v_acusg_us_group_number IGS_GR_AWD_CRM_US_GP.us_group_number%TYPE;
169: v_message_name VARCHAR2(30);
170: CURSOR c_awc IS
171: SELECT 'X'
172: FROM IGS_GR_AWD_CEREMONY awc

Line 186: FROM IGS_GR_AWD_CRM_US_GP acusg

182: acusg.award_course_cd,
183: acusg.award_crs_version_number,
184: acusg.award_cd,
185: acusg.us_group_number
186: FROM IGS_GR_AWD_CRM_US_GP acusg
187: WHERE acusg.grd_cal_type = p_grd_cal_type AND
188: acusg.grd_ci_sequence_number = p_grd_ci_sequence_number AND
189: acusg.ceremony_number = p_ceremony_number AND
190: acusg.award_course_cd = p_award_course_cd AND

Line 279: IGS_GR_AWD_CRM_US_GP acusg1,

275: CURSOR c_awc_acusg IS
276: SELECT 'x'
277: FROM IGS_GR_AWD_CEREMONY awc1,
278: IGS_GR_AWD_CEREMONY awc2,
279: IGS_GR_AWD_CRM_US_GP acusg1,
280: IGS_GR_AWD_CRM_US_GP acusg2
281: WHERE acusg1.grd_cal_type = p_grd_cal_type AND
282: acusg1.grd_ci_sequence_number = p_grd_ci_sequence_number AND
283: acusg1.ceremony_number = p_ceremony_number AND

Line 280: IGS_GR_AWD_CRM_US_GP acusg2

276: SELECT 'x'
277: FROM IGS_GR_AWD_CEREMONY awc1,
278: IGS_GR_AWD_CEREMONY awc2,
279: IGS_GR_AWD_CRM_US_GP acusg1,
280: IGS_GR_AWD_CRM_US_GP acusg2
281: WHERE acusg1.grd_cal_type = p_grd_cal_type AND
282: acusg1.grd_ci_sequence_number = p_grd_ci_sequence_number AND
283: acusg1.ceremony_number = p_ceremony_number AND
284: acusg1.award_course_cd = p_award_course_cd AND