1 PACKAGE IGS_GR_VAL_AWC AUTHID CURRENT_USER AS
2 /* $Header: IGSGR05S.pls 115.4 2002/11/29 00:40:13 nsidana ship $ */
3 --
4 -- Validate the award has the correct system award type
5 FUNCTION grdp_val_award_type(
6 p_award_cd IN VARCHAR2 ,
7 p_s_award_type IN VARCHAR2 ,
8 p_message_name OUT NOCOPY VARCHAR2 )
9 RETURN BOOLEAN;
10 --
11 -- Validate the award ceremony has related student course attempts
12 FUNCTION grdp_val_awc_sca(
13 p_course_cd IN VARCHAR2 ,
14 p_version_number IN NUMBER ,
15 p_message_name OUT NOCOPY VARCHAR2 )
16 RETURN BOOLEAN;
17 --
18 -- Validate the award is not closed.
19 FUNCTION crsp_val_aw_closed(
20 p_award_cd IN VARCHAR2 ,
21 p_message_name OUT NOCOPY VARCHAR2 )
22 RETURN BOOLEAN;
23 --
24 -- Validate the award ceremony order in ceremony
25 FUNCTION grdp_val_awc_order(
26 p_grd_cal_type IN VARCHAR2 ,
27 p_grd_ci_sequence_number IN NUMBER ,
28 p_ceremony_number IN NUMBER ,
29 p_award_course_cd IN VARCHAR2 ,
30 p_award_crs_version_number IN NUMBER ,
31 p_award_cd IN VARCHAR2 ,
32 p_order_in_ceremony IN NUMBER ,
33 p_message_name OUT NOCOPY VARCHAR2 )
34 RETURN BOOLEAN;
35 --
36 -- Validate if the award ceremony us group order in award.
37 FUNCTION grdp_val_acusg_order(
38 p_grd_cal_type IN VARCHAR2 ,
39 p_grd_ci_sequence_number IN NUMBER ,
40 p_ceremony_number IN NUMBER ,
41 p_award_course_cd IN VARCHAR2 ,
42 p_award_crs_version_number IN NUMBER ,
43 p_award_cd IN VARCHAR2 ,
44 p_us_group_number IN NUMBER ,
45 p_message_name OUT NOCOPY VARCHAR2 )
46 RETURN BOOLEAN;
47 END IGS_GR_VAL_AWC;