1 PACKAGE IGS_CA_VAL_QLITY AS
2 /* $Header: IGSCA14S.pls 120.0 2005/06/01 22:43:24 appldev noship $ */
3 -- To validate research calendar instance (part of the quality check)
4 PROCEDURE CALP_VAL_RESEARCH_CI(
5 p_acad_cal_type IN VARCHAR2 ,
6 p_acad_sequence_number IN NUMBER ,
7 p_s_log_type IN VARCHAR2 ,
8 p_log_creation_dt IN DATE )
9 ;
10 --
11 -- To quality check admission calendar instances
12 PROCEDURE CALP_VAL_ADM_CI(
13 p_acad_cal_type IN VARCHAR2 ,
14 p_acad_sequence_number IN NUMBER ,
15 p_s_log_type IN VARCHAR2 ,
16 p_log_creation_dt IN DATE )
17 ;
18 --
19 -- To quality check calendar data structures
20 FUNCTION CALP_VAL_QUAL_CHK(
21 p_acad_cal_type IN VARCHAR2 ,
22 p_acad_sequence_number IN NUMBER ,
23 p_calendar_category IN VARCHAR2 )
24 RETURN DATE;
25
26 --
27 -- To quality check system control dates within calendar instances.
28 PROCEDURE CALP_VAL_DATES_CI(
29 p_acad_cal_type IN VARCHAR2 ,
30 p_acad_sequence_number IN NUMBER ,
31 p_s_log_type IN VARCHAR2 ,
32 p_log_creation_dt IN DATE )
33 ;
34 --
35 -- To quality check enrolment calendar instances
36 PROCEDURE CALP_VAL_ENROL_CI(
37 p_acad_cal_type IN VARCHAR2 ,
38 p_acad_sequence_number IN NUMBER ,
39 p_s_log_type IN VARCHAR2 ,
40 p_log_creation_dt IN DATE )
41 ;
42 --
43 -- To quality check load calendar instances
44 PROCEDURE CALP_VAL_LOAD_CI(
45 p_acad_cal_type IN VARCHAR2 ,
46 p_acad_sequence_number IN NUMBER ,
47 p_s_log_type IN VARCHAR2 ,
48 p_log_creation_dt IN DATE )
49 ;
50 --
51 -- To quality check teaching calendar instances
52 PROCEDURE CALP_VAL_TEACH_CI(
53 p_acad_cal_type IN VARCHAR2 ,
54 p_acad_sequence_number IN NUMBER ,
55 p_s_log_type IN VARCHAR2 ,
56 p_log_creation_dt IN DATE )
57 ;
58
59 PROCEDURE CHK_ONE_PER_CAL(p_acad_cal_type IN VARCHAR2,
60 p_acad_sequence_number IN NUMBER,
61 p_cal_cat IN VARCHAR2,
62 p_s_log_type IN VARCHAR2,
63 p_log_creation_dt IN DATE);
64
65 g_cal_cat VARCHAR2(30);
66
67 END IGS_CA_VAL_QLITY;