1 PACKAGE IGS_AS_VAL_EIS AUTHID CURRENT_USER AS
2 /* $Header: IGSAS17S.pls 115.4 2002/11/28 22:43:50 nsidana ship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --smadathi 24-AUG-2001 Bug No. 1956374 .The function declaration of genp_val_staff_prsn removed
7 -------------------------------------------------------------------------------------------
8 --w.r.t BUG #1956374 , Procedures assp_val_els_venue ,assp_val_esu_ese_ve are removed
9 --w.r.t BUG #1956374 , Procedures assp_val_est_closed , assp_val_esu_ese_el are removed
10 -- Validate if a person is an active student.
11 FUNCTION ASSP_VAL_ACTV_STDNT(
12 p_person_id IN NUMBER ,
13 p_message_name OUT NOCOPY VARCHAR2 )
14 RETURN BOOLEAN;
15 --PRAGMA RESTRICT_REFERENCES(ASSP_VAL_ACTV_STDNT,WNDS);
16
17 --
18
19
20
21 --
22 -- Validate if more than one person incharge at a session and venue.
23 FUNCTION ASSP_VAL_ESE_INCHRG(
24 p_person_id IN NUMBER ,
25 p_exam_cal_type IN VARCHAR2 ,
26 p_exam_ci_sequence_number IN NUMBER ,
27 p_dt_alias IN VARCHAR2 ,
28 p_dai_sequence_number IN NUMBER ,
29 p_start_time IN DATE ,
30 p_end_time IN DATE ,
31 p_venue_cd IN VARCHAR2 ,
32 p_exam_supervisor_type IN VARCHAR2 ,
33 p_message_name OUT NOCOPY VARCHAR2 )
34 RETURN BOOLEAN;
35 --PRAGMA RESTRICT_REFERENCES(ASSP_VAL_ESE_INCHRG,WNDS);
36
37 --
38
39 --
40 -- Validate if person allocated as incharge when not normally incharge.
41 FUNCTION ASSP_VAL_EST_INCHRG(
42 p_person_id IN NUMBER ,
43 p_exam_supervisor_type IN VARCHAR2 ,
44 p_message_name OUT NOCOPY VARCHAR2 )
45 RETURN BOOLEAN;
46 --PRAGMA RESTRICT_REFERENCES(ASSP_VAL_EST_INCHRG,WNDS);
47
48 --
49
50
51 --
52 -- Validate if the supervisor limit exceeded for the session and venue.
53 FUNCTION ASSP_VAL_ESU_ESE_LMT(
54 p_person_id IN NUMBER ,
55 p_exam_cal_type IN VARCHAR2 ,
56 p_exam_ci_sequence_number IN NUMBER ,
57 p_dt_alias IN VARCHAR2 ,
58 p_dai_sequence_number IN NUMBER ,
59 p_start_time IN DATE ,
60 p_end_time IN DATE ,
61 p_venue_cd IN VARCHAR2 ,
62 p_message_name OUT NOCOPY VARCHAR2 )
63 RETURN BOOLEAN;
64 --PRAGMA RESTRICT_REFERENCES(ASSP_VAL_ESU_ESE_LMT,WNDS);
65
66 END IGS_AS_VAL_EIS;