1 PACKAGE igs_en_elgbl_unit AS
2 /* $Header: IGSEN80S.pls 120.5 2005/10/10 05:40:27 appldev ship $ */
3 /*--------------------------------------------------------------------------------+
4 | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, California, USA |
5 | All rights reserved. |
6 +================================================================================+
7 | |
8 | DESCRIPTION |
9 | PL/SQL spec for package: igs_en_elgbl_unit |
10 | |
11 | NOTES |
12 | |
13 | |
14 | HISTORY |
15 | Who When What
16 |bdeviset 17-JUN-2005 Modified for SSUI build.Bug# 4377985
17 | ctyagi 20-SEPT-2005 Modified eval_rsv_seat for Bug 4362302
18 |ctyagi 22-sept-2005 Added p_enroll_from_waitlsit_flag as a part of bug 4580204
19 ctyagi 26-sept-2005 Removed p_enroll_from_waitlsit_flag as a part of bug 4580204
20 | amuthu 10-Oct-2005 Added new function eval_award_prog_only for bug 4381229
21 */
22 --
23 FUNCTION eval_unit_steps (
24 p_person_id IN NUMBER,
25 p_person_type IN VARCHAR2,
26 p_load_cal_type IN VARCHAR2,
27 p_load_sequence_number IN VARCHAR2,
28 p_uoo_id IN NUMBER,
29 p_course_cd IN VARCHAR2,
30 p_course_version IN NUMBER,
31 p_enrollment_category IN VARCHAR2,
32 p_enr_method_type IN VARCHAR2,
33 p_comm_type IN VARCHAR2,
34 p_message OUT NOCOPY VARCHAR2,
35 p_deny_warn OUT NOCOPY VARCHAR2,
36 p_calling_obj IN VARCHAR2
37 ) RETURN BOOLEAN;
38 --
39 FUNCTION eval_unit_ss_allowed (
40 p_person_id IN NUMBER,
41 p_course_cd IN VARCHAR2,
42 p_person_type IN VARCHAR2,
43 p_load_cal_type IN VARCHAR2,
44 p_load_sequence_number IN VARCHAR2,
45 p_uoo_id IN NUMBER,
46 p_message IN OUT NOCOPY VARCHAR2,
47 p_deny_warn IN VARCHAR2,
48 p_calling_obj IN VARCHAR2
49 ) RETURN BOOLEAN;
50 --
51 FUNCTION eval_program_check (
52 p_person_id IN NUMBER,
53 p_load_cal_type IN VARCHAR2,
54 p_load_sequence_number IN VARCHAR2,
55 p_uoo_id IN NUMBER,
56 p_course_cd IN VARCHAR2,
57 p_course_version IN NUMBER,
58 p_message IN OUT NOCOPY VARCHAR2,
59 p_deny_warn IN VARCHAR2,
60 p_rule_seq_number IN NUMBER,
61 p_calling_obj IN VARCHAR2
62 ) RETURN BOOLEAN;
63 --
64 FUNCTION eval_unit_forced_location (
65 p_person_id IN NUMBER,
66 p_load_cal_type IN VARCHAR2,
67 p_load_sequence_number IN VARCHAR2,
68 p_uoo_id IN NUMBER,
69 p_course_cd IN VARCHAR2,
70 p_course_version IN NUMBER,
71 p_message IN OUT NOCOPY VARCHAR2,
72 p_deny_warn IN VARCHAR2,
73 p_calling_obj IN VARCHAR2
74 ) RETURN BOOLEAN;
75 --
76 FUNCTION eval_unit_forced_mode (
77 p_person_id IN NUMBER,
78 p_load_cal_type IN VARCHAR2,
79 p_load_sequence_number IN VARCHAR2,
80 p_uoo_id IN NUMBER,
81 p_course_cd IN VARCHAR2,
82 p_course_version IN NUMBER,
83 p_message IN OUT NOCOPY VARCHAR2,
84 p_deny_warn IN VARCHAR2,
85 p_calling_obj IN VARCHAR2
86 ) RETURN BOOLEAN;
87 --
88 --smaddali added two new parameters for PSCR014 ccr on academic records maintenance dld
89 --also modified p_program_version from varchar2 to number
90 FUNCTION eval_unit_repeat (
91 p_person_id IN NUMBER,
92 p_load_cal_type IN VARCHAR2,
93 p_load_cal_seq_number IN NUMBER,
94 p_uoo_id IN NUMBER,
95 p_program_cd IN VARCHAR2,
96 p_program_version IN NUMBER,
97 p_message IN OUT NOCOPY VARCHAR2,
98 p_deny_warn IN VARCHAR2,
99 p_repeat_tag OUT NOCOPY VARCHAR2,
100 p_unit_cd IN VARCHAR2 DEFAULT NULL,
101 p_unit_version IN NUMBER DEFAULT NULL,
102 p_calling_obj IN VARCHAR2
103 ) RETURN BOOLEAN;
104
105 --
106 FUNCTION eval_time_conflict
107 (
108 p_person_id IN NUMBER,
109 p_load_cal_type IN VARCHAR2,
110 p_load_cal_seq_number IN NUMBER,
111 p_uoo_id IN NUMBER,
112 p_program_cd IN VARCHAR2,
113 p_program_version IN VARCHAR2,
114 p_message IN OUT NOCOPY VARCHAR2,
115 p_deny_warn IN VARCHAR2,
116 p_calling_obj IN VARCHAR2
117 ) RETURN BOOLEAN;
118 --
119 FUNCTION eval_prereq (
120 p_person_id IN NUMBER,
121 p_load_cal_type IN VARCHAR2,
122 p_load_sequence_number IN VARCHAR2,
123 p_uoo_id IN NUMBER,
124 p_course_cd IN VARCHAR2,
125 p_course_version IN NUMBER,
126 p_message IN OUT NOCOPY VARCHAR2,
127 p_deny_warn IN VARCHAR2,
128 p_calling_obj IN VARCHAR2
129 ) RETURN BOOLEAN;
130 --
131 FUNCTION eval_coreq (
132 p_person_id IN NUMBER,
133 p_load_cal_type IN VARCHAR2,
134 p_load_sequence_number IN VARCHAR2,
135 p_uoo_id IN NUMBER,
136 p_course_cd IN VARCHAR2,
137 p_course_version IN NUMBER,
138 p_message IN OUT NOCOPY VARCHAR2,
139 p_deny_warn IN VARCHAR2,
140 p_calling_obj IN VARCHAR2
141 ) RETURN BOOLEAN;
142 --
143 FUNCTION eval_incompatible (
144 p_person_id IN NUMBER,
145 p_load_cal_type IN VARCHAR2,
146 p_load_sequence_number IN VARCHAR2,
147 p_uoo_id IN NUMBER,
148 p_course_cd IN VARCHAR2,
149 p_course_version IN NUMBER,
150 p_message IN OUT NOCOPY VARCHAR2,
151 p_deny_warn IN VARCHAR2,
152 p_calling_obj IN VARCHAR2
153 ) RETURN BOOLEAN;
154 --
155 FUNCTION eval_spl_permission (
156 p_person_id IN NUMBER,
157 p_load_cal_type IN VARCHAR2,
158 p_load_sequence_number IN VARCHAR2,
159 p_uoo_id IN NUMBER,
160 p_course_cd IN VARCHAR2,
161 p_course_version IN NUMBER,
162 p_message IN OUT NOCOPY VARCHAR2,
163 p_deny_warn IN VARCHAR2
164 ) RETURN BOOLEAN;
165 --
166 FUNCTION eval_rsv_seat (
167 p_person_id IN NUMBER,
168 p_load_cal_type IN VARCHAR2,
169 p_load_sequence_number IN VARCHAR2,
170 p_uoo_id IN NUMBER,
171 p_course_cd IN VARCHAR2,
172 p_course_version IN NUMBER,
173 p_message IN OUT NOCOPY VARCHAR2,
174 p_deny_warn IN VARCHAR2,
175 p_calling_obj IN VARCHAR2,
176 p_deny_enrollment OUT NOCOPY VARCHAR2
177 ) RETURN BOOLEAN;
178 --
179 FUNCTION eval_cart_max (
180 p_person_id IN NUMBER,
181 p_load_cal_type IN VARCHAR2,
182 p_load_sequence_number IN VARCHAR2,
183 p_uoo_id IN NUMBER,
184 p_course_cd IN VARCHAR2,
185 p_course_version IN NUMBER,
186 p_message IN OUT NOCOPY VARCHAR2,
187 p_deny_warn IN VARCHAR2,
188 p_rule_seq_number IN NUMBER
189 ) RETURN BOOLEAN;
190 --
191 FUNCTION eval_intmsn_unit_lvl (
192 p_person_id IN NUMBER,
193 p_load_cal_type IN VARCHAR2,
194 p_load_cal_seq_number IN NUMBER,
195 p_uoo_id IN NUMBER,
196 p_program_cd IN VARCHAR2,
197 p_program_version IN VARCHAR2,
198 p_message IN OUT NOCOPY VARCHAR2,
199 p_deny_warn IN VARCHAR2,
200 p_rule_seq_number IN NUMBER,
201 p_calling_obj IN VARCHAR2
202 ) RETURN BOOLEAN;
203 --
204 FUNCTION eval_visa_unit_lvl (
205 p_person_id IN NUMBER,
206 p_load_cal_type IN VARCHAR2,
207 p_load_cal_seq_number IN NUMBER,
208 p_uoo_id IN NUMBER,
209 p_program_cd IN VARCHAR2,
210 p_program_version IN VARCHAR2,
211 p_message IN OUT NOCOPY VARCHAR2,
212 p_deny_warn IN VARCHAR2,
213 p_rule_seq_number IN NUMBER,
214 p_calling_obj IN VARCHAR2
215 ) RETURN BOOLEAN;
216 --
217
218 FUNCTION eval_audit_permission (
219 p_person_id IN NUMBER,
220 p_load_cal_type IN VARCHAR2,
221 p_load_sequence_number IN VARCHAR2,
222 p_uoo_id IN NUMBER,
223 p_course_cd IN VARCHAR2,
224 p_course_version IN NUMBER,
225 p_message IN OUT NOCOPY VARCHAR2,
226 p_deny_warn IN VARCHAR2
227 ) RETURN BOOLEAN ;
228
229 FUNCTION eval_unit_reenroll (
230 p_person_id IN NUMBER,
231 p_load_cal_type IN VARCHAR2,
232 p_load_cal_seq_number IN NUMBER,
233 p_uoo_id IN NUMBER,
234 p_program_cd IN VARCHAR2,
235 p_program_version IN NUMBER,
236 p_deny_warn IN VARCHAR2,
237 p_upd_cp IN NUMBER,
238 p_message IN OUT NOCOPY VARCHAR2,
239 p_val_level IN VARCHAR2 DEFAULT 'ALL',
240 p_calling_obj IN VARCHAR2
241 ) RETURN BOOLEAN;
242
243 FUNCTION eval_student_audit_limit(
244 p_person_id IN NUMBER,
245 p_load_cal_type IN VARCHAR2,
246 p_load_sequence_number IN VARCHAR2,
247 p_uoo_id IN NUMBER,
248 p_course_cd IN VARCHAR2,
249 p_course_version IN NUMBER,
250 p_message IN OUT NOCOPY VARCHAR2,
251 p_deny_warn IN VARCHAR2,
252 p_stud_audit_lim IN NUMBER,
253 p_calling_obj IN VARCHAR2
254 ) RETURN BOOLEAN;
255
256 FUNCTION eval_award_prog_only(
257 p_person_id IN NUMBER,
258 p_person_type IN VARCHAR2,
259 p_load_cal_type IN VARCHAR2,
260 p_load_sequence_number IN VARCHAR2,
261 p_uoo_id IN NUMBER,
262 p_course_cd IN VARCHAR2,
263 p_course_version IN NUMBER,
264 p_message OUT NOCOPY VARCHAR2,
265 p_calling_obj IN VARCHAR2
266 ) RETURN BOOLEAN;
267
268 END igs_en_elgbl_unit;