DBA Data[Home] [Help]

PACKAGE: APPS.IGS_GR_VAL_AWC

Source


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;