1 PACKAGE IGS_AS_VAL_ESVS AUTHID CURRENT_USER AS
2 /* $Header: IGSAS21S.pls 115.4 2002/11/28 22:44:48 nsidana ship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --smadathi 28-AUG-2001 Bug No. 1956374 .The function declaration of genp_val_staff_prsn
7 -- removed
8 -------------------------------------------------------------------------------------------
9 --w.r.t BUG #1956374 , Procedure assp_val_est_inchrg is removed
10 --
11 -- As part of the bug# 1956374 procedure assp_val_actv ,assp_val_ese_inchrg are removed
12 --w.r.t BUG #1956374 , Procedure assp_val_est_closed , assp_val_esu_ese_lmt are removed
13 -- Validate exam instance exists for the session and IGS_GR_VENUE.
14 FUNCTION ASSP_VAL_EI_VENUE(
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_venue_cd IN VARCHAR2 ,
22 p_message_name OUT NOCOPY VARCHAR2 )
23 RETURN BOOLEAN;
24
25 --
26 -- Validate IGS_GR_VENUE is within the supervisor's exam IGS_AD_LOCATIONs
27 FUNCTION ASSP_VAL_ELS_VENUE(
28 p_person_id IN NUMBER ,
29 p_venue_cd IN VARCHAR2 ,
30 p_message_name OUT NOCOPY VARCHAR2 )
31 RETURN BOOLEAN;
32
33 --
34
35
36
37 --
38
39
40
41 --
42 -- Validate if supervisor allocated different exam IGS_AD_LOCATION for same day.
43 FUNCTION ASSP_VAL_ESU_ESE_EL(
44 p_person_id IN NUMBER ,
45 p_exam_cal_type IN VARCHAR2 ,
46 p_exam_ci_sequence_number IN NUMBER ,
47 p_dt_alias IN VARCHAR2 ,
48 p_dai_sequence_number IN NUMBER ,
49 p_start_time IN DATE ,
50 p_end_time IN DATE ,
51 p_venue_cd IN VARCHAR2 ,
52 p_message_name OUT NOCOPY VARCHAR2 )
53 RETURN BOOLEAN;
54
55 --
56
57 --
58 -- Supervisor cannot be allocated concurrent sessions at different IGS_GR_VENUEs
59 FUNCTION ASSP_VAL_ESU_ESE_VE(
60 p_person_id IN NUMBER ,
61 p_exam_cal_type IN VARCHAR2 ,
62 p_exam_ci_sequence_number IN NUMBER ,
63 p_dt_alias IN VARCHAR2 ,
64 p_dai_sequence_number IN NUMBER ,
65 p_start_time IN DATE ,
66 p_end_time IN DATE ,
67 p_override_start_time IN DATE ,
68 p_override_end_time IN DATE ,
69 p_venue_cd IN VARCHAR2 ,
70 p_message_name OUT NOCOPY VARCHAR2 )
71 RETURN BOOLEAN;
72
73 --
74
75 END IGS_AS_VAL_ESVS;