1 PACKAGE IGS_AS_VAL_SEI AUTHID CURRENT_USER AS
2 /* $Header: IGSAS29S.pls 115.5 2003/05/27 18:45:02 anilk ship $ */
3
4 -- Routine to clear rowids saved in a PL/SQL TABLE from a prior commit.
5 --
6 -- Validate IGS_AS_STD_EXM_INSTN teaching calendar instance
7 FUNCTION ASSP_VAL_SEI_CI(
8 p_cal_type IN VARCHAR2 ,
9 p_ci_sequence_number IN NUMBER ,
10 p_exam_cal_type IN VARCHAR2 ,
11 p_exam_ci_sequence_number IN NUMBER ,
12 p_message_name OUT NOCOPY VARCHAR2 )
13 RETURN boolean;
14
15 --
16 -- Validate for IGS_AS_STD_EXM_INSTN duplicate within exam period
17 FUNCTION ASSP_VAL_SEI_DPLCT(
18 p_person_id IN NUMBER ,
19 p_course_cd IN VARCHAR2 ,
20 p_unit_cd IN VARCHAR2 ,
21 p_cal_type IN VARCHAR2 ,
22 p_ci_sequence_number IN NUMBER ,
23 p_exam_cal_type IN VARCHAR2 ,
24 p_exam_ci_sequence_number IN NUMBER ,
25 p_dt_alias IN VARCHAR2 ,
26 p_dai_sequence_number IN NUMBER ,
27 p_start_time IN DATE ,
28 p_end_time IN DATE ,
29 p_ass_id IN NUMBER ,
30 p_venue_cd IN VARCHAR2 ,
31 p_message_name OUT NOCOPY VARCHAR2 ,
32 -- anilk, 22-Apr-2003, Bug# 2829262
33 p_uoo_id IN NUMBER DEFAULT NULL )
34 RETURN boolean;
35
36 --
37 -- Routine to process rowids in a PL/SQL TABLE for the current commit.
38
39 --
40 -- Validate seat not allocated twice within an examination and IGS_GR_VENUE.
41 FUNCTION ASSP_VAL_SEI_SEAT(
42 p_ese_id IN NUMBER ,
43 p_venue_cd IN VARCHAR2 ,
44 p_person_id OUT NOCOPY NUMBER ,
45 p_seat_number OUT NOCOPY NUMBER ,
46 p_message_name OUT NOCOPY VARCHAR2 )
47 RETURN BOOLEAN;
48
49 END IGS_AS_VAL_SEI;