[Home] [Help]
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 ,
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 ,
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 )
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
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
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