21: RETURN BOOLEAN;
22: --
23: -- Validate if the award ceremony is closed.
24: FUNCTION grdp_val_awc_closed(
25: p_grd_cal_type IGS_GR_AWD_CEREMONY_ALL.grd_cal_type%TYPE ,
26: p_grd_ci_sequence_number IGS_GR_AWD_CEREMONY_ALL.grd_ci_sequence_number%TYPE ,
27: p_ceremony_number IGS_GR_AWD_CEREMONY_ALL.ceremony_number%TYPE ,
28: p_award_course_cd IGS_GR_AWD_CEREMONY_ALL.award_course_cd%TYPE ,
29: p_award_crs_version_number IGS_GR_AWD_CEREMONY_ALL.award_crs_version_number%TYPE ,
22: --
23: -- Validate if the award ceremony is closed.
24: FUNCTION grdp_val_awc_closed(
25: p_grd_cal_type IGS_GR_AWD_CEREMONY_ALL.grd_cal_type%TYPE ,
26: p_grd_ci_sequence_number IGS_GR_AWD_CEREMONY_ALL.grd_ci_sequence_number%TYPE ,
27: p_ceremony_number IGS_GR_AWD_CEREMONY_ALL.ceremony_number%TYPE ,
28: p_award_course_cd IGS_GR_AWD_CEREMONY_ALL.award_course_cd%TYPE ,
29: p_award_crs_version_number IGS_GR_AWD_CEREMONY_ALL.award_crs_version_number%TYPE ,
30: p_award_cd IGS_GR_AWD_CEREMONY_ALL.award_cd%TYPE ,
23: -- Validate if the award ceremony is closed.
24: FUNCTION grdp_val_awc_closed(
25: p_grd_cal_type IGS_GR_AWD_CEREMONY_ALL.grd_cal_type%TYPE ,
26: p_grd_ci_sequence_number IGS_GR_AWD_CEREMONY_ALL.grd_ci_sequence_number%TYPE ,
27: p_ceremony_number IGS_GR_AWD_CEREMONY_ALL.ceremony_number%TYPE ,
28: p_award_course_cd IGS_GR_AWD_CEREMONY_ALL.award_course_cd%TYPE ,
29: p_award_crs_version_number IGS_GR_AWD_CEREMONY_ALL.award_crs_version_number%TYPE ,
30: p_award_cd IGS_GR_AWD_CEREMONY_ALL.award_cd%TYPE ,
31: p_message_name OUT NOCOPY VARCHAR2 )
24: FUNCTION grdp_val_awc_closed(
25: p_grd_cal_type IGS_GR_AWD_CEREMONY_ALL.grd_cal_type%TYPE ,
26: p_grd_ci_sequence_number IGS_GR_AWD_CEREMONY_ALL.grd_ci_sequence_number%TYPE ,
27: p_ceremony_number IGS_GR_AWD_CEREMONY_ALL.ceremony_number%TYPE ,
28: p_award_course_cd IGS_GR_AWD_CEREMONY_ALL.award_course_cd%TYPE ,
29: p_award_crs_version_number IGS_GR_AWD_CEREMONY_ALL.award_crs_version_number%TYPE ,
30: p_award_cd IGS_GR_AWD_CEREMONY_ALL.award_cd%TYPE ,
31: p_message_name OUT NOCOPY VARCHAR2 )
32: RETURN BOOLEAN;
25: p_grd_cal_type IGS_GR_AWD_CEREMONY_ALL.grd_cal_type%TYPE ,
26: p_grd_ci_sequence_number IGS_GR_AWD_CEREMONY_ALL.grd_ci_sequence_number%TYPE ,
27: p_ceremony_number IGS_GR_AWD_CEREMONY_ALL.ceremony_number%TYPE ,
28: p_award_course_cd IGS_GR_AWD_CEREMONY_ALL.award_course_cd%TYPE ,
29: p_award_crs_version_number IGS_GR_AWD_CEREMONY_ALL.award_crs_version_number%TYPE ,
30: p_award_cd IGS_GR_AWD_CEREMONY_ALL.award_cd%TYPE ,
31: p_message_name OUT NOCOPY VARCHAR2 )
32: RETURN BOOLEAN;
33: --
26: p_grd_ci_sequence_number IGS_GR_AWD_CEREMONY_ALL.grd_ci_sequence_number%TYPE ,
27: p_ceremony_number IGS_GR_AWD_CEREMONY_ALL.ceremony_number%TYPE ,
28: p_award_course_cd IGS_GR_AWD_CEREMONY_ALL.award_course_cd%TYPE ,
29: p_award_crs_version_number IGS_GR_AWD_CEREMONY_ALL.award_crs_version_number%TYPE ,
30: p_award_cd IGS_GR_AWD_CEREMONY_ALL.award_cd%TYPE ,
31: p_message_name OUT NOCOPY VARCHAR2 )
32: RETURN BOOLEAN;
33: --
34: -- Validate the unit set has related course offering unit set records