1 PACKAGE IGS_GR_VAL_GC AUTHID CURRENT_USER AS
2 /* $Header: IGSGR02S.pls 115.4 2002/11/29 00:39:41 nsidana ship $ */
3 --
4 --
5 -- Validate the graduation ceremony date aliases
6 FUNCTION grdp_val_gc_dai(
7 p_grd_cal_type IN VARCHAR2 ,
8 p_grd_ci_sequence_number IN NUMBER ,
9 p_ceremony_dt_alias IN VARCHAR2 ,
10 p_ceremony_dai_sequence_number IN NUMBER ,
11 p_closing_dt_alias IN VARCHAR2 ,
12 p_closing_dai_sequence_number IN NUMBER ,
13 p_message_name OUT NOCOPY VARCHAR2 )
14 RETURN BOOLEAN;
15 --
16 -- Validate the graduation ceremony can be updated
17 FUNCTION grdp_val_gc_upd(
18 p_grd_cal_type IN VARCHAR2 ,
19 p_grd_ci_sequence_number IN NUMBER ,
20 p_ceremony_number IN NUMBER ,
21 p_message_name OUT NOCOPY VARCHAR2 )
22 RETURN BOOLEAN;
23 --
24 -- Validate the ceremony round linked to the graduation ceremony
25 FUNCTION grdp_val_gc_crd(
26 p_grd_cal_type IN VARCHAR2 ,
27 p_grd_ci_sequence_number IN NUMBER ,
28 p_message_name OUT NOCOPY VARCHAR2 )
29 RETURN BOOLEAN;
30 --
31 -- Validate the start and end time of the graduation ceremony
32 FUNCTION grdp_val_gc_times(
33 p_grd_cal_type IN VARCHAR2 ,
34 p_grd_ci_sequence_number IN NUMBER ,
35 p_ceremony_number IN NUMBER ,
36 p_venue_cd IN VARCHAR2 ,
37 p_ceremony_dt_alias IN VARCHAR2 ,
38 p_ceremony_dai_sequence_number IN NUMBER ,
39 p_ceremony_start_time IN DATE ,
40 p_ceremony_end_time IN DATE ,
41 p_message_name OUT NOCOPY VARCHAR2 )
42 RETURN BOOLEAN;
43 --
44 -- Validate the ins/upd/del to the graduation ceremony
45 FUNCTION grdp_val_gc_iud(
46 p_grd_cal_type IN VARCHAR2 ,
47 p_grd_ci_sequence_number IN NUMBER ,
48 p_ceremony_number IN NUMBER ,
49 p_message_name OUT NOCOPY VARCHAR2 )
50 RETURN BOOLEAN;
51 --
52 -- Validate if the venue has a system location type of CRD_CTR
53 FUNCTION grdp_val_ve_lot(
54 p_venue_cd IN VARCHAR2 ,
55 p_message_name OUT NOCOPY VARCHAR2 )
56 RETURN BOOLEAN;
57 --
58 -- To validate the venue closed indicator
59 FUNCTION ASSP_VAL_VE_CLOSED(
60 p_venue_cd IN VARCHAR2 ,
61 p_message_name OUT NOCOPY VARCHAR2 )
62 RETURN BOOLEAN;
63 END IGS_GR_VAL_GC;
[Home] [Help]