1 PACKAGE IGS_EN_VAL_PEE AUTHID CURRENT_USER AS
2 /* $Header: IGSEN53S.pls 115.4 2002/11/29 00:03:12 nsidana ship $ */
3
4 -- Validate the cp restriction on the person exclusion effect table.
5 FUNCTION enrp_val_pee_crs_cp(
6 p_person_id IN NUMBER ,
7 p_s_encmb_effect_type IN VARCHAR2 ,
8 p_sequence_number IN NUMBER ,
9 p_course_cd IN VARCHAR2 ,
10 p_message_name OUT NOCOPY VARCHAR2)
11 RETURN BOOLEAN;
12 -- PRAGMA RESTRICT_REFERENCES( enrp_val_pee_crs_cp , WNDS);
13 --
14 -- Validate the att type on the person exclusion effect table.
15 FUNCTION enrp_val_pee_crs_att(
16 p_person_id IN NUMBER ,
17 p_s_encmb_effect_type IN VARCHAR2 ,
18 p_sequence_number IN NUMBER ,
19 p_course_cd IN VARCHAR2 ,
20 p_message_name OUT NOCOPY VARCHAR2)
21 RETURN BOOLEAN;
22 -- PRAGMA RESTRICT_REFERENCES( enrp_val_pee_crs_att , WNDS);
23 --
24 -- bug id : 1956374
25 -- sjadhav , 28-aug-2001
26 -- removed FUNCTION enrp_val_encmb_dt
27 -- removed FUNCTION enrp_val_encmb_dts
28 --
29 -- Validate that person doesn't already have a matching encumb effect.
30 FUNCTION enrp_val_pee_chk(
31 p_person_id IN NUMBER ,
32 p_encumbrance_type IN VARCHAR2 ,
33 p_pen_start_dt IN DATE ,
34 p_s_encmb_effect_type IN VARCHAR2 ,
35 p_pee_start_dt IN DATE ,
36 p_course_cd IN VARCHAR2 ,
37 p_message_name OUT NOCOPY VARCHAR2)
38 RETURN BOOLEAN;
39 -- PRAGMA RESTRICT_REFERENCES( enrp_val_pee_chk , WNDS);
40 --
41 --
42 -- Validate that person doesn't already have an open encumbrance effect.
43 FUNCTION enrp_val_pee_open(
44 p_person_id IN NUMBER ,
45 p_encumbrance_type IN VARCHAR2 ,
46 p_pen_start_dt IN DATE ,
47 p_s_encmb_effect_type IN VARCHAR2 ,
48 p_sequence_number IN NUMBER ,
49 p_course_cd IN VARCHAR2 ,
50 p_message_name OUT NOCOPY VARCHAR2)
51 RETURN BOOLEAN;
52 -- PRAGMA RESTRICT_REFERENCES( enrp_val_pee_open , WNDS);
53 --
54 -- Validate the COURSE code on the person exclusion effect table.
55 FUNCTION enrp_val_pee_crs(
56 p_person_id IN NUMBER ,
57 p_course_cd IN VARCHAR2 ,
58 p_message_name OUT NOCOPY VARCHAR2)
59 RETURN BOOLEAN;
60 -- PRAGMA RESTRICT_REFERENCES( enrp_val_pee_crs , WNDS);
61 --
62 -- Validate whether or not a person is enrolled in any COURSE.
63 FUNCTION enrp_val_pee_sca(
64 p_person_id IN NUMBER ,
65 p_message_name OUT NOCOPY VARCHAR2)
66 RETURN BOOLEAN;
67 -- PRAGMA RESTRICT_REFERENCES( enrp_val_pee_crs, WNDS);
68 --
69 -- Validate person is enrolled for encumbrance purposes
70 FUNCTION enrp_val_pee_enrol(
71 p_person_id IN NUMBER ,
72 p_effect_type IN VARCHAR2 ,
73 p_message_name OUT NOCOPY VARCHAR2)
74 RETURN BOOLEAN;
75 -- PRAGMA RESTRICT_REFERENCES( enrp_val_pee_enrol , WNDS);
76 --
77 -- Validate the encumbrance effect COURSE code
78 FUNCTION enrp_val_pee_crs_cd(
79 p_effect_type IN VARCHAR2 ,
80 p_course_cd IN VARCHAR2 ,
81 p_message_name OUT NOCOPY VARCHAR2)
82 RETURN BOOLEAN;
83 -- PRAGMA RESTRICT_REFERENCES( enrp_val_pee_crs_cd, WNDS);
84 --
85 -- Validate the encumbrance effect restricted credit points
86 FUNCTION enrp_val_pee_rstr_cp(
87 p_effect_type IN VARCHAR2 ,
88 p_restricted_enrolment_cp IN NUMBER ,
89 p_message_name OUT NOCOPY VARCHAR2)
90 RETURN BOOLEAN;
91 -- PRAGMA RESTRICT_REFERENCES( enrp_val_pee_rstr_cp , WNDS);
92 --
93 -- Validate the encumbrance effect attendance type
94 FUNCTION enrp_val_pee_rstr_at(
95 p_effect_type IN VARCHAR2 ,
96 p_restricted_attendance_type IN VARCHAR2 ,
97 p_message_name OUT NOCOPY VARCHAR2)
98 RETURN BOOLEAN;
99 -- PRAGMA RESTRICT_REFERENCES( enrp_val_pee_rstr_at, WNDS);
100 --
101 -- bug id : 1956374
102 -- sjadhav , 28-aug-2001
103 -- removed FUNCTION enrp_val_encmb_dts
104 --
105 -- Validate the attendance type closed indicator.
106 FUNCTION enrp_val_att_closed(
107 p_attend_type IN VARCHAR2 ,
108 p_message_name OUT NOCOPY VARCHAR2)
109 RETURN BOOLEAN;
110 -- PRAGMA RESTRICT_REFERENCES( enrp_val_att_closed, WNDS);
111 --
112 END IGS_EN_VAL_PEE;