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_VAL_ACUS dependencies on IGS_GR_AWD_CEREMONY

Line 106: p_grd_cal_type IGS_GR_AWD_CEREMONY_ALL.grd_cal_type%TYPE ,

102: END grdp_val_acus_susa;
103: --
104: -- Validate if the award ceremony is closed.
105: FUNCTION grdp_val_awc_closed(
106: p_grd_cal_type IGS_GR_AWD_CEREMONY_ALL.grd_cal_type%TYPE ,
107: p_grd_ci_sequence_number IGS_GR_AWD_CEREMONY_ALL.grd_ci_sequence_number%TYPE ,
108: p_ceremony_number IGS_GR_AWD_CEREMONY_ALL.ceremony_number%TYPE ,
109: p_award_course_cd IGS_GR_AWD_CEREMONY_ALL.award_course_cd%TYPE ,
110: p_award_crs_version_number IGS_GR_AWD_CEREMONY_ALL.award_crs_version_number%TYPE ,

Line 107: p_grd_ci_sequence_number IGS_GR_AWD_CEREMONY_ALL.grd_ci_sequence_number%TYPE ,

103: --
104: -- Validate if the award ceremony is closed.
105: FUNCTION grdp_val_awc_closed(
106: p_grd_cal_type IGS_GR_AWD_CEREMONY_ALL.grd_cal_type%TYPE ,
107: p_grd_ci_sequence_number IGS_GR_AWD_CEREMONY_ALL.grd_ci_sequence_number%TYPE ,
108: p_ceremony_number IGS_GR_AWD_CEREMONY_ALL.ceremony_number%TYPE ,
109: p_award_course_cd IGS_GR_AWD_CEREMONY_ALL.award_course_cd%TYPE ,
110: p_award_crs_version_number IGS_GR_AWD_CEREMONY_ALL.award_crs_version_number%TYPE ,
111: p_award_cd IGS_GR_AWD_CEREMONY_ALL.award_cd%TYPE ,

Line 108: p_ceremony_number IGS_GR_AWD_CEREMONY_ALL.ceremony_number%TYPE ,

104: -- Validate if the award ceremony is closed.
105: FUNCTION grdp_val_awc_closed(
106: p_grd_cal_type IGS_GR_AWD_CEREMONY_ALL.grd_cal_type%TYPE ,
107: p_grd_ci_sequence_number IGS_GR_AWD_CEREMONY_ALL.grd_ci_sequence_number%TYPE ,
108: p_ceremony_number IGS_GR_AWD_CEREMONY_ALL.ceremony_number%TYPE ,
109: p_award_course_cd IGS_GR_AWD_CEREMONY_ALL.award_course_cd%TYPE ,
110: p_award_crs_version_number IGS_GR_AWD_CEREMONY_ALL.award_crs_version_number%TYPE ,
111: p_award_cd IGS_GR_AWD_CEREMONY_ALL.award_cd%TYPE ,
112: p_message_name OUT NOCOPY VARCHAR2 )

Line 109: p_award_course_cd IGS_GR_AWD_CEREMONY_ALL.award_course_cd%TYPE ,

105: FUNCTION grdp_val_awc_closed(
106: p_grd_cal_type IGS_GR_AWD_CEREMONY_ALL.grd_cal_type%TYPE ,
107: p_grd_ci_sequence_number IGS_GR_AWD_CEREMONY_ALL.grd_ci_sequence_number%TYPE ,
108: p_ceremony_number IGS_GR_AWD_CEREMONY_ALL.ceremony_number%TYPE ,
109: p_award_course_cd IGS_GR_AWD_CEREMONY_ALL.award_course_cd%TYPE ,
110: p_award_crs_version_number IGS_GR_AWD_CEREMONY_ALL.award_crs_version_number%TYPE ,
111: p_award_cd IGS_GR_AWD_CEREMONY_ALL.award_cd%TYPE ,
112: p_message_name OUT NOCOPY VARCHAR2 )
113: RETURN BOOLEAN AS

Line 110: p_award_crs_version_number IGS_GR_AWD_CEREMONY_ALL.award_crs_version_number%TYPE ,

106: p_grd_cal_type IGS_GR_AWD_CEREMONY_ALL.grd_cal_type%TYPE ,
107: p_grd_ci_sequence_number IGS_GR_AWD_CEREMONY_ALL.grd_ci_sequence_number%TYPE ,
108: p_ceremony_number IGS_GR_AWD_CEREMONY_ALL.ceremony_number%TYPE ,
109: p_award_course_cd IGS_GR_AWD_CEREMONY_ALL.award_course_cd%TYPE ,
110: p_award_crs_version_number IGS_GR_AWD_CEREMONY_ALL.award_crs_version_number%TYPE ,
111: p_award_cd IGS_GR_AWD_CEREMONY_ALL.award_cd%TYPE ,
112: p_message_name OUT NOCOPY VARCHAR2 )
113: RETURN BOOLEAN AS
114: BEGIN -- grdp_val_awc_closed

Line 111: p_award_cd IGS_GR_AWD_CEREMONY_ALL.award_cd%TYPE ,

107: p_grd_ci_sequence_number IGS_GR_AWD_CEREMONY_ALL.grd_ci_sequence_number%TYPE ,
108: p_ceremony_number IGS_GR_AWD_CEREMONY_ALL.ceremony_number%TYPE ,
109: p_award_course_cd IGS_GR_AWD_CEREMONY_ALL.award_course_cd%TYPE ,
110: p_award_crs_version_number IGS_GR_AWD_CEREMONY_ALL.award_crs_version_number%TYPE ,
111: p_award_cd IGS_GR_AWD_CEREMONY_ALL.award_cd%TYPE ,
112: p_message_name OUT NOCOPY VARCHAR2 )
113: RETURN BOOLEAN AS
114: BEGIN -- grdp_val_awc_closed
115: -- Description: Validate if the award ceremony is closed

Line 117: v_awc_rec IGS_GR_AWD_CEREMONY.closed_ind%TYPE;

113: RETURN BOOLEAN AS
114: BEGIN -- grdp_val_awc_closed
115: -- Description: Validate if the award ceremony is closed
116: DECLARE
117: v_awc_rec IGS_GR_AWD_CEREMONY.closed_ind%TYPE;
118: CURSOR c_awc IS
119: SELECT 'X'
120: FROM IGS_GR_AWD_CEREMONY awc
121: WHERE awc.grd_cal_type = p_grd_cal_type AND

Line 120: FROM IGS_GR_AWD_CEREMONY awc

116: DECLARE
117: v_awc_rec IGS_GR_AWD_CEREMONY.closed_ind%TYPE;
118: CURSOR c_awc IS
119: SELECT 'X'
120: FROM IGS_GR_AWD_CEREMONY awc
121: WHERE awc.grd_cal_type = p_grd_cal_type AND
122: awc.grd_ci_sequence_number = p_grd_ci_sequence_number AND
123: awc.ceremony_number = p_ceremony_number AND
124: NVL(awc.award_course_cd, 'NULL')= NVL(p_award_course_cd, 'NULL') AND