1 PACKAGE IGS_EN_VAL_ENCMB AS
2 /* $Header: IGSEN37S.pls 120.1 2006/05/18 11:31:57 amuthu noship $ */
3
4 /*------------------------------------------------------------------------------+
5 | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, California, USA |
6 | All rights reserved. |
7 +==============================================================================+
8 | |
9 | DESCRIPTION |
10 | PL/SQL Spec for package: IGS_EN_VAL_ENCMB |
11 | |
12 | |
13 | HISTORY |
14 | Who When What |
15 | amuthu 18-May-2006 Modified the spec for ENRP_VAL_ENR_ENCMB to pass the |
16 | the effective date |
17 |-----------------------------------------------------------------------------*/
18 --
19 -- Validate whether a IGS_PE_PERSON is excluded from a IGS_PS_UNIT.
20 FUNCTION enrp_val_excld_unit(
21 p_person_id IN NUMBER ,
22 p_course_cd IN VARCHAR2 ,
23 p_unit_cd IN VARCHAR2 ,
24 p_effective_dt IN DATE ,
25 p_message_name OUT NOCOPY VARCHAR2 )
26 RETURN BOOLEAN;
27 --PRAGMA RESTRICT_REFERENCES (enrp_val_excld_unit,WNDS);
28 --
29 -- Validate whether or not a IGS_PE_PERSON is excluded from the university.
30 FUNCTION enrp_val_excld_prsn(
31 p_person_id IN NUMBER ,
32 p_course_cd IN VARCHAR2 ,
33 p_effective_dt IN DATE ,
34 p_message_name OUT NOCOPY VARCHAR2 )
35 RETURN BOOLEAN;
36 PRAGMA RESTRICT_REFERENCES (enrp_val_excld_prsn,WNDS,WNPS);
37 --
38 -- Validate whether a IGS_PE_PERSON is excluded from a IGS_PS_COURSE.
39 FUNCTION enrp_val_excld_crs(
40 p_person_id IN NUMBER ,
41 p_course_cd IN VARCHAR2 ,
42 p_effective_dt IN DATE ,
43 p_message_name OUT NOCOPY VARCHAR2 )
44 RETURN BOOLEAN;
45 PRAGMA RESTRICT_REFERENCES (enrp_val_excld_crs,WNDS,WNPS);
46 --
47 -- Validate whether a IGS_PE_PERSON is excluded from a IGS_PS_UNIT set.
48 FUNCTION enrp_val_excld_us(
49 p_person_id IN NUMBER ,
50 p_course_cd IN VARCHAR2 ,
51 p_unit_set_cd IN VARCHAR2 ,
52 p_us_version_number IN NUMBER ,
53 p_effective_dt IN DATE ,
54 p_message_name OUT NOCOPY VARCHAR2)
55 RETURN BOOLEAN;
56 --PRAGMA RESTRICT_REFERENCES (enrp_val_excld_us,WNDS);
57 --
58 -- Validate whether a IGS_PE_PERSON is enrolled in all required units.
59 FUNCTION enrp_val_rqrd_units(
60 p_person_id IN NUMBER ,
61 p_course_cd IN VARCHAR2 ,
62 p_effective_dt IN DATE ,
63 p_message_name OUT NOCOPY VARCHAR2 ,
64 p_return_type OUT NOCOPY VARCHAR2 )
65 RETURN BOOLEAN;
66 --PRAGMA RESTRICT_REFERENCES (enrp_val_rqrd_units,WNDS);
67 --
68 -- Validate whether or not a IGS_PE_PERSON is restricted to an attendance type.
69 FUNCTION enrp_val_rstrct_atyp(
70 p_person_id IN NUMBER ,
71 p_course_cd IN VARCHAR2 ,
72 p_effective_dt IN DATE ,
73 p_restricted_attendance_type OUT NOCOPY VARCHAR2 ,
74 p_message_name OUT NOCOPY VARCHAR2 )
75 RETURN BOOLEAN;
76 --PRAGMA RESTRICT_REFERENCES (enrp_val_rstrct_atyp,WNDS);
77 --
78 -- Validate whether or not a IGS_PE_PERSON is restricted to an enrolment cp.
79 FUNCTION enrp_val_rstrct_cp(
80 p_person_id IN NUMBER ,
81 p_course_cd IN VARCHAR2 ,
82 p_effective_dt IN DATE ,
83 p_rstrct_le_cp_value OUT NOCOPY NUMBER ,
84 p_rstrct_ge_cp_value OUT NOCOPY NUMBER ,
85 p_message_name OUT NOCOPY VARCHAR2 )
86 RETURN BOOLEAN;
87 --PRAGMA RESTRICT_REFERENCES (enrp_val_rstrct_cp,WNDS);
88 --
89 -- Validate whether a IGS_PE_PERSON has an encumbrance blocking IGS_PS_COURSE material.
90 FUNCTION enrp_val_blk_crsmtrl(
91 p_person_id IN NUMBER ,
92 p_course_cd VARCHAR2 ,
93 p_effective_dt IN DATE ,
94 p_message_name OUT NOCOPY VARCHAR2 )
95 RETURN BOOLEAN;
96 --PRAGMA RESTRICT_REFERENCES (enrp_val_blk_crsmtrl,WNDS);
97 --
98 -- Validate whether a IGS_PE_PERSON has an encumbrance blocking graduation.
99 FUNCTION enrp_val_blk_grd(
100 p_person_id IN NUMBER ,
101 p_course_cd IN VARCHAR2 ,
102 p_effective_dt IN DATE ,
103 p_message_name OUT NOCOPY VARCHAR2 )
104 RETURN BOOLEAN;
105 --PRAGMA RESTRICT_REFERENCES (enrp_val_blk_grd,WNDS);
106 --
107 -- Validate whether a IGS_PE_PERSON has an encumbrance blocking their ID card.
108 FUNCTION enrp_val_blk_id_card(
109 p_person_id IN NUMBER ,
110 p_course_cd IN VARCHAR2 ,
111 p_effective_dt IN DATE ,
112 p_message_name OUT NOCOPY VARCHAR2 )
113 RETURN BOOLEAN;
114 --PRAGMA RESTRICT_REFERENCES (enrp_val_blk_id_card,WNDS);
115 --
116 -- Validate whether a IGS_PE_PERSON has an encumbrance blocking the info booth.
117 FUNCTION enrp_val_blk_inf_bth(
118 p_person_id IN NUMBER ,
119 p_course_cd IN VARCHAR2 ,
120 p_effective_dt IN DATE ,
121 p_message_name OUT NOCOPY VARCHAR2 )
122 RETURN BOOLEAN;
123 --PRAGMA RESTRICT_REFERENCES (enrp_val_blk_inf_bth,WNDS);
124 --
125 -- Validate whether a IGS_PE_PERSON has an encumbrance blocking issue of results
126 FUNCTION enrp_val_blk_result(
127 p_person_id IN NUMBER ,
128 p_course_cd IN VARCHAR2 ,
129 p_effective_dt IN DATE ,
130 p_message_name OUT NOCOPY VARCHAR2 )
131 RETURN BOOLEAN;
132 --PRAGMA RESTRICT_REFERENCES (enrp_val_blk_result,WNDS);
133 --
134 -- Validate whether a IGS_PE_PERSON has an encumbrance blocking system corresp.
135 FUNCTION enrp_val_blk_sys_cor(
136 p_person_id IN NUMBER ,
137 p_course_cd IN VARCHAR2 ,
138 p_effective_dt IN DATE ,
139 p_message_name OUT NOCOPY VARCHAR2 )
140 RETURN BOOLEAN;
141 --PRAGMA RESTRICT_REFERENCES (enrp_val_blk_sys_cor,WNDS);
142 --
143 -- Validate whether a IGS_PE_PERSON has an encumbrance blocking acad transcript.
144 FUNCTION enrp_val_blk_trscrpt(
145 p_person_id IN NUMBER ,
146 p_course_cd IN VARCHAR2 ,
147 p_effective_dt IN DATE ,
148 p_message_name OUT NOCOPY VARCHAR2 )
149 RETURN BOOLEAN;
150 --PRAGMA RESTRICT_REFERENCES (enrp_val_blk_trscrpt,WNDS);
151 --
152 -- Valiate enrolment encumbrances related to load periods
153 FUNCTION ENRP_VAL_ENR_ENCMB(
154 p_person_id IN NUMBER ,
155 p_course_cd IN VARCHAR2 ,
156 p_cal_type IN VARCHAR2 ,
157 p_ci_sequence_number IN NUMBER ,
158 p_message_name OUT NOCOPY VARCHAR2 ,
159 p_message_name2 OUT NOCOPY VARCHAR2 ,
160 p_return_type OUT NOCOPY VARCHAR2,
161 p_effective_dt IN DATE DEFAULT NULL)
162 RETURN BOOLEAN;
163 --PRAGMA RESTRICT_REFERENCES (ENRP_VAL_ENR_ENCMB,WNDS);
164
165 END IGS_EN_VAL_ENCMB;