PACKAGE: APPS.IGS_AS_VAL_ESE

Source

1 PACKAGE IGS_AS_VAL_ESE AUTHID CURRENT_USER AS
2 /* $Header: IGSAS19S.pls 115.3 2002/11/28 22:44:19 nsidana ship $ */
3 
4   --
5   -- To validate the uniqueness of the exam session number
6   FUNCTION ASSP_VAL_ESE_NUM(
7   p_exam_cal_type IN VARCHAR2 ,
8   p_exam_ci_sequence_number IN NUMBER ,
9   p_message_name OUT NOCOPY VARCHAR2 )
10 RETURN boolean;
11 
12   --
13   -- To validate for overlap in start/end times of exam sessions
14   FUNCTION ASSP_VAL_ESE_OVRLP(
15   p_exam_cal_type IN VARCHAR2 ,
16   p_exam_ci_sequence_number IN NUMBER ,
17   p_dt_alias IN VARCHAR2 ,
18   p_dai_sequence_number IN NUMBER ,
19   p_start_time IN DATE ,
20   p_end_time IN DATE ,
21   p_message_name OUT NOCOPY VARCHAR2 )
22 RETURN boolean;
23 
24   --
25   -- Validate the IGS_AS_EXAM_SESSION calendar instance
26   FUNCTION ASSP_VAL_ESE_CI(
27   p_cal_type IN VARCHAR2 ,
28   p_sequence_number IN NUMBER ,
29   p_message_name OUT NOCOPY VARCHAR2 )
30 RETURN boolean;
31 
32   --
33   -- Compare time component of two dates and start time is before end time.
34   FUNCTION GENP_VAL_STRT_END_TM(
35   p_start_time IN DATE ,
36   p_end_time IN DATE ,
37   p_message_name OUT NOCOPY VARCHAR2 )
38 RETURN BOOLEAN;
39 
40 END IGS_AS_VAL_ESE;