1 PACKAGE IGS_GR_VAL_ACUS AUTHID CURRENT_USER AS
2 /* $Header: IGSGR03S.pls 115.4 2002/11/29 00:39:57 nsidana ship $ */
3 --
4 -- Validate if the award ceremony unit set group is closed
5 FUNCTION grdp_val_acusg_close(
6 p_grd_cal_type IGS_GR_AWD_CRM_US_GP.grd_cal_type%TYPE ,
7 p_grd_ci_sequence_number IGS_GR_AWD_CRM_US_GP.grd_ci_sequence_number%TYPE ,
8 p_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE ,
9 p_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE ,
10 p_award_crs_version_number IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE ,
11 p_award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE ,
12 p_us_group_number IGS_GR_AWD_CRM_US_GP.us_group_number%TYPE ,
13 p_message_name OUT NOCOPY VARCHAR2 )
14 RETURN BOOLEAN;
15 --
16 -- Validate the award ceremony unit set has related unit set attempts
17 FUNCTION grdp_val_acus_susa(
18 p_unit_set_cd IN VARCHAR2 ,
19 p_us_version_number IN NUMBER ,
20 p_message_name OUT NOCOPY VARCHAR2 )
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 ,
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
35 FUNCTION grdp_val_crv_us(
36 p_award_course_cd IN VARCHAR2 ,
37 p_award_crs_version_number IN NUMBER ,
38 p_unit_set_cd IN VARCHAR2 ,
39 p_us_version_number IN NUMBER ,
40 p_message_name OUT NOCOPY VARCHAR2 )
41 RETURN BOOLEAN;
42 END IGS_GR_VAL_ACUS;