1 PACKAGE OTA_TRNG_ENROLL_SS AUTHID CURRENT_USER as
2 /* $Header: ottrnenr.pkh 115.1 2003/05/08 13:14:22 dbatra noship $ */
3
4
5
6 --
7 -- CSR_BOOKING_STATUS_ID retrieves a single booking_status_type_id for
8 -- a particular BG of the reqired type.
9 -- It selects using the following priority :-
13 --
10 -- 1) The name is like 'W:%' -- This indicates it is seeded for the web
11 -- 2) The default flag is set
12 -- 3) The first row retrieved that is of the type required.
14 CURSOR csr_booking_status_id (p_business_group_id IN NUMBER
15 ,p_web_booking_status_type IN VARCHAR2) IS
16 SELECT bst.BOOKING_STATUS_TYPE_ID,bst.BUSINESS_GROUP_ID,bst.ACTIVE_FLAG,bst.DEFAULT_FLAG,bst.PLACE_USED_FLAG,
17 bstt.NAME,bst.OBJECT_VERSION_NUMBER,bst.TYPE,bst.COMMENTS,bstt.DESCRIPTION,bst.LAST_UPDATE_DATE,
18 bst.LAST_UPDATED_BY,bst.LAST_UPDATE_LOGIN,bst.CREATED_BY,bst.CREATION_DATE,
19 bst.BST_INFORMATION_CATEGORY,bst.BST_INFORMATION1,bst.BST_INFORMATION2,
20 bst.BST_INFORMATION3,bst.BST_INFORMATION4,bst.BST_INFORMATION5,
21 bst.BST_INFORMATION6,bst.BST_INFORMATION7,bst.BST_INFORMATION8,
22 bst.BST_INFORMATION9,bst.BST_INFORMATION10,bst.BST_INFORMATION11,
23 bst.BST_INFORMATION12,bst.BST_INFORMATION13,bst.BST_INFORMATION14,
24 bst.BST_INFORMATION15,bst.BST_INFORMATION16,bst.BST_INFORMATION17,
25 bst.BST_INFORMATION18,bst.BST_INFORMATION19,bst.BST_INFORMATION20
26 FROM ota_booking_status_types bst, ota_booking_status_types_tl bstt
27 WHERE bst.business_group_id = p_business_group_id
28 AND bst.booking_status_type_id = bstt.booking_status_type_id
29 AND bstt.language=userenv('LANG')
30 AND rownum=1
31 AND bst.type = DECODE(p_web_booking_status_type, 'REQUESTED', 'R'
32 , 'WAITLISTED','W'
33 , 'CANCELLED', 'C'
34 , 'ATTENDED' , 'A'
35 , 'PLACED' , 'P')
36 -- The name is like W: ( highest priority choice)
37 AND ( (bstt.name like 'W:%')
38 -- There are no names like W:, so a defaulted required status is
39 -- the second choice.
40 OR ( NOT EXISTS (SELECT 1
41 FROM ota_booking_status_types bst1, ota_booking_status_types_tl bstt1
42 WHERE bst1.business_group_id = p_business_group_id
43 AND bst1.booking_status_type_id = bstt1.booking_status_type_id
44 AND bstt1.language=userenv('LANG')
45 AND bst1.type =
46 DECODE(p_web_booking_status_type, 'REQUESTED', 'R'
47 , 'WAITLISTED','W'
48 , 'CANCELLED', 'C'
49 , 'ATTENDED' , 'A'
50 , 'PLACED' , 'P')
51 AND bstt1.name like 'W:%')
52 AND ( (bst.default_flag = 'Y')
53 -- If there are no names like 'W:%' and no defaulted status of type
54 -- required, then select one that is of type required
55 OR NOT EXISTS (SELECT 1
56 FROM ota_booking_status_types
57 WHERE business_group_id = p_business_group_id
58 AND type =
59 DECODE(p_web_booking_status_type, 'REQUESTED', 'R'
60 , 'WAITLISTED','W'
61 , 'CANCELLED', 'C'
62 , 'ATTENDED' , 'A'
63 , 'PLACED' , 'P')
64 AND default_flag ='Y')
65 )
66 )
67 );
68
69 --
70 -- Cursor to retrieve necessary information in order to save the enrollment
71 -- NOTE : Removed the address section as it appears that a person doesn't
72 -- need to have a primary address (however, I've only commented it out
73 -- just incase)
74
75 CURSOR csr_person_to_enroll_details (p_person_id number) IS
76 SELECT pp.last_name
77 ,pp.first_name
78 ,pp.full_name
79 ,pp.business_group_id
80 ,pp.email_address
81 ,pp.work_telephone
82 -- ,p2.email_address super_email
83 -- ,p2.work_telephone super_phone
84 ,p2.person_id super_id
85 ,asg2.assignment_id super_asg_id
86 -- ,ad.address_id
87 -- ,ad.address_line1
88 ,pp.object_version_number per_object_version_number
89 ,asg.assignment_id
90 ,asg.internal_address_line work_line
91 ,asg.organization_id
92 ,loc.address_line_1 work_line1
93 ,loc.town_or_city work_city
94 FROM per_all_people_f pp
95 ,per_all_assignments_f asg
96 ,per_all_people_f p2
97 ,per_all_assignments_f asg2
98 -- ,per_addresses ad
99 ,hr_locations loc
100 ,hr_all_organization_units org
101 WHERE pp.person_id = p_person_id
102 AND trunc(sysdate) BETWEEN pp.effective_start_date AND pp.effective_end_date
103 and asg.person_id = pp.person_id
104 AND asg.primary_flag = 'Y'
105 AND trunc(sysdate) BETWEEN asg.effective_start_date AND asg.effective_end_date
106 and p2.person_id(+) = asg.supervisor_id
107 AND trunc(sysdate) BETWEEN p2.effective_start_date(+) AND p2.effective_end_date(+)
108 and asg2.person_id(+) = asg.supervisor_id
109 AND asg2.primary_flag(+) = 'Y'
110 AND trunc(sysdate) BETWEEN asg2.effective_start_date(+) AND asg2.effective_end_date(+)
111 -- AND ad.person_id = pp.person_id
112 -- AND ad.primary_flag = 'Y'
113 -- AND trunc(sysdate)BETWEEN ad.date_from AND nvl(ad.date_to, trunc(sysdate))
114 and asg.organization_id = org.organization_id
115 and org.location_id = loc.location_id (+);
116
117
118 g_mesg_on_stack_exception EXCEPTION;
119 PRAGMA EXCEPTION_INIT(g_mesg_on_stack_exception, -20002);
120
121 --
122 -- ----------------------------------------------------------------------------
126 --
123 -- |-----------------------------<ProcessSaveEnrollment>----------------------|
124 -- ----------------------------------------------------------------------------
125 -- {Start Of Comments}
127 -- Description:
128 -- This package is used for self service application to create enrollment
129 -- data when user enroll in the class.
130 --
131 -- Prerequisites:
132 --
133 -- In Parameters:
134 --
135 -- Post Success:
136 -- Enrollment data will be created.
137 --
138 -- Post Failure:
139 -- Status will be passed to the caller and the caller will raise a notification.
140 --
141 -- Developer Implementation Notes:
142 -- The attrbute in parameters should be modified as to the business process
143 -- requirements.
144 --
145 -- Access Status:
146 -- Internal Development Use Only.
147 --
148 -- {End Of Comments}
149 -- ----------------------------------------------------------------------------
150 PROCEDURE ProcessSaveEnrollment( p_event_id IN VARCHAR2
151 ,p_extra_information IN VARCHAR2 DEFAULT NULL
152 ,p_mode IN VARCHAR2
153 ,p_cost_centers IN VARCHAR2 DEFAULT NULL
154 ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE
155 ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
156 ,p_business_group_name IN PER_BUSINESS_GROUPS.name%TYPE
157 ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
158 --,p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE
159 ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type
160 ,p_booking_id out nocopy OTA_DELEGATE_BOOKINGS.Booking_id%type
161 , p_message_name out nocopy varchar2
162 -- ,p_item_key IN WF_ITEMS.ITEM_TYPE%TYPE
163 ,p_tdb_information_category in varchar2 default null
164 ,p_tdb_information1 in varchar2 default null
165 ,p_tdb_information2 in varchar2 default null
166 ,p_tdb_information3 in varchar2 default null
167 ,p_tdb_information4 in varchar2 default null
168 ,p_tdb_information5 in varchar2 default null
169 ,p_tdb_information6 in varchar2 default null
170 ,p_tdb_information7 in varchar2 default null
171 ,p_tdb_information8 in varchar2 default null
172 ,p_tdb_information9 in varchar2 default null
173 ,p_tdb_information10 in varchar2 default null
174 ,p_tdb_information11 in varchar2 default null
175 ,p_tdb_information12 in varchar2 default null
176 ,p_tdb_information13 in varchar2 default null
177 ,p_tdb_information14 in varchar2 default null
178 ,p_tdb_information15 in varchar2 default null
179 ,p_tdb_information16 in varchar2 default null
180 ,p_tdb_information17 in varchar2 default null
181 ,p_tdb_information18 in varchar2 default null
182 ,p_tdb_information19 in varchar2 default null
183 ,p_tdb_information20 in varchar2 default null);
184
185 --
186 -- ----------------------------------------------------------------------------
187 -- |-----------------------------<Cancel_finance>-----------------------------|
188 -- ----------------------------------------------------------------------------
189 -- {Start Of Comments}
190 --
191 -- Description:
192 -- This package is used for self service application to cancel finance if
193 -- user re-enroll in the class.
194 --
195 -- Prerequisites:
196 --
197 -- In Parameters:
198 --
199 -- Post Success:
200 -- Finance will be canceled.
201 --
202 -- Post Failure:
203 -- Status will be passed to the caller and the caller will raise a notification.
204 --
205 -- Developer Implementation Notes:
206 -- The attrbute in parameters should be modified as to the business process
207 -- requirements.
208 --
209 -- Access Status:
210 -- Internal Development Use Only.
211 --
212 -- {End Of Comments}
213 -- ----------------------------------------------------------------------------
214
215 PROCEDURE cancel_finance(p_booking_id in number);
216
217
218 --
219 --
220 -- ----------------------------------------------------------------------------
221 -- |----------------------<Get_Booking_Status_For_Web >-----------------------|
222 -- ----------------------------------------------------------------------------
223 -- {Start Of Comments}
224 --
225 -- Description:
226 -- This package is used for self service application to create enrollment
227 -- data when user enroll in the class.
228 --
229 -- Prerequisites:
230 --
231 -- In Parameters:
232 --
233 -- Post Success:
234 -- Enrollment data will be created.
235 --
236 -- Post Failure:
237 -- Status will be passed to the caller and the caller will raise a notification.
238 --
239 -- Developer Implementation Notes:
243 -- Access Status:
240 -- The attrbute in parameters should be modified as to the business process
241 -- requirements.
242 --
244 -- Internal Development Use Only.
245 --
246 -- {End Of Comments}
247 -- ----------------------------------------------------------------------------
248
249
250 FUNCTION Get_Booking_Status_For_Web (p_web_booking_status_type VARCHAR2
251 ,p_business_group_id NUMBER)
252 RETURN OTA_BOOKING_STATUS_TYPES%ROWTYPE;
253
254 --
255 -- ----------------------------------------------------------------------------
256 -- |-----------------------------<Check_Cost_Center>--------------------------|
257 -- ----------------------------------------------------------------------------
258 -- {Start Of Comments}
259 --
260 -- Description:
261 -- This package is used for self service application to create enrollment
262 -- data when user enroll in the class.
263 --
264 -- Prerequisites:
265 --
266 -- In Parameters:
267 --
268 -- Post Success:
269 -- Enrollment data will be created.
270 --
271 -- Post Failure:
272 -- Status will be passed to the caller and the caller will raise a notification.
273 --
274 -- Developer Implementation Notes:
275 -- The attrbute in parameters should be modified as to the business process
276 -- requirements.
277 --
278 -- Access Status:
279 -- Internal Development Use Only.
280 --
281 -- {End Of Comments}
282 -- ----------------------------------------------------------------------------
283 Procedure check_cost_center
284 (p_person_id in number,
285 p_no_cost_center out nocopy number,
286 p_cost_alloc_keyflex_id out nocopy number,
287 p_business_group_id out nocopy number,
288 p_assignment_id out nocopy number,
289 p_organization_id out nocopy number,
290 p_cost_center out nocopy varchar2 );
291 --
292 -- ----------------------------------------------------------------------------
293 -- |----------------------<Create_enroll_wf_process>--------------------------|
294 -- ----------------------------------------------------------------------------
295 -- {Start Of Comments}
296 --
297 -- Description:
298 -- This package is used for self service application to create enrollment
299 -- data when user enroll in the class.
300 --
301 -- Prerequisites:
302 --
303 -- In Parameters:
304 --
305 -- Post Success:
306 -- Enrollment data will be created.
307 --
308 -- Post Failure:
309 -- Status will be passed to the caller and the caller will raise a notification.
310 --
311 -- Developer Implementation Notes:
312 -- The attrbute in parameters should be modified as to the business process
313 -- requirements.
314 --
315 -- Access Status:
316 -- Internal Development Use Only.
317 --
318 -- {End Of Comments}
319 -- ----------------------------------------------------------------------------
320 /*Procedure create_enroll_wf_process
321 (p_process in wf_process_activities.process_name%type,
322 p_itemtype in wf_items.item_type%type,
323 p_person_id in number default null,
324 p_called_from in varchar2 default null,
325 p_itemkey out nocopy wf_items.item_key%type
326 );
327 */
328
329 --
330 -- ----------------------------------------------------------------------------
331 -- |----------------------<Get_Person_To_Enroll_Details >----------------------|
332 -- ----------------------------------------------------------------------------
333 -- {Start Of Comments}
334 --
335 -- Description:
336 -- This package is used for self service application to create enrollment
337 -- data when user enroll in the class.
338 --
339 -- Prerequisites:
340 --
341 -- In Parameters:
342 --
343 -- Post Success:
344 -- Enrollment data will be created.
345 --
346 -- Post Failure:
347 -- Status will be passed to the caller and the caller will raise a notification.
348 --
349 -- Developer Implementation Notes:
350 -- The attrbute in parameters should be modified as to the business process
351 -- requirements.
352 --
353 -- Access Status:
354 -- Internal Development Use Only.
355 --
356 -- {End Of Comments}
357 -- ----------------------------------------------------------------------------
358
359 FUNCTION Get_Person_To_Enroll_Details (p_person_id per_all_people_f.PERSON_ID%TYPE)
360 RETURN csr_person_to_enroll_details%ROWTYPE;
361
362
363 --
364 -- ----------------------------------------------------------------------------
365 -- |-------------------------------<Validate_Enrollment>----------------------|
366 -- ----------------------------------------------------------------------------
367 -- {Start Of Comments}
368 --
369 -- Description:
370 -- This package is used for self service application to create enrollment
371 -- data when user enroll in the class.
372 --
373 -- Prerequisites:
374 --
375 -- In Parameters:
376 --
377 -- Post Success:
378 -- Enrollment data will be created.
379 --
380 -- Post Failure:
381 -- Status will be passed to the caller and the caller will raise a notification.
382 --
383 -- Developer Implementation Notes:
384 -- The attrbute in parameters should be modified as to the business process
385 -- requirements.
386 --
387 -- Access Status:
388 -- Internal Development Use Only.
389 --
390 -- {End Of Comments}
391 -- ----------------------------------------------------------------------------
392
393 PROCEDURE Validate_enrollment(p_person_id IN per_all_people_f.PERSON_ID%TYPE,
397 -- |--------------------------------------------------------------------------|
394 p_event_id IN VARCHAR2,
395 p_double_book OUT nocopy VARCHAR2);
396
398 -- |--< Chk_Event_Cancelled_for_Person >--------------------------------------|
399 -- |--------------------------------------------------------------------------|
400 --
401 -- {Start Of Comments}
402 --
403 -- Description:
404 -- This package is used for self service application to create enrollment
405 -- data when user enroll in the class.
406 --
407 -- Prerequisites:
408 --
409 -- In Parameters:
410 --
411 -- Post Success:
412 -- Enrollment data will be created.
413 --
414 -- Post Failure:
415 -- Status will be passed to the caller and the caller will raise a notification.
416 --
417 -- Developer Implementation Notes:
418 -- The attrbute in parameters should be modified as to the business process
419 -- requirements.
420 --
421 -- Access Status:
422 -- Internal Development Use Only.
423 --
424 -- {End Of Comments}
425 -- ----------------------------------------------------------------------------
426 FUNCTION Chk_Event_Cancelled_for_Person (p_event_id IN NUMBER
427 ,p_delegate_person_id IN NUMBER
428 ,p_booking_id OUT nocopy NUMBER)
429 RETURN BOOLEAN;
430
431 procedure Chk_booking_clash (p_event_id IN NUMBER
432 ,p_person_id IN NUMBER
433 ,p_booking_Clash OUT nocopy varchar2)
434 ;
435 --|--------------------------------------------------------------------------|
436 --|--< CHK_FOR_SECURE_EVT >-------------------------------------------|
437 --|--------------------------------------------------------------------------|
438
439 -- {Start Of Comments}
440 --
441 -- Description:
442 -- Called by dynamic sql to determine whether event is secure and it is OK to show the delegate
443 -- the event in question. Only the events that they can enroll onto are
444 -- shown.
445 -- Prerequisites:
446 -- none
447 --
448 -- Post Success:
449 --
450 -- Post Failure:
451 -- an exception is raised
452 --
453 -- Access Status:
454 -- Public
455 --
456 -- {End Of Comments}
457 --
458 ----------------------------------------------------------------------------
459
460 FUNCTION CHK_FOR_SECURE_EVT (
461 p_delegate_id IN PER_PEOPLE_F.PERSON_ID%TYPE
462 , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE)
463 RETURN VARCHAR2;
464 PRAGMA RESTRICT_REFERENCES(CHK_FOR_SECURE_EVT, WNDS, WNPS);
465 --|--------------------------------------------------------------------------|
466 --|--< CHK_DELEGATE_OK_FOR_EVENT>-----------------------------------------|
467 --|--------------------------------------------------------------------------|
468
469 -- {Start Of Comments}
470 --
471 -- Description:
472 -- Called by dynamic sql to determine whether it is OK to show the delegate
473 -- the event in question. Only the events that they can enroll onto are
474 -- shown.
475 -- Prerequisites:
476 -- none
477 --
478 -- Post Success:
479 --
480 -- Post Failure:
481 -- an exception is raised
482 --
483 -- Access Status:
484 -- Public
485 --
486 -- {End Of Comments}
487 --
488 ----------------------------------------------------------------------------
489
490 FUNCTION CHK_DELEGATE_OK_FOR_EVENT (
491 p_delegate_id IN PER_PEOPLE_F.PERSON_ID%TYPE
492 , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE
493 , p_event_start_date IN OTA_EVENTS.COURSE_START_DATE%TYPE
494 default null)
495 RETURN VARCHAR2;
496 PRAGMA RESTRICT_REFERENCES(CHK_DELEGATE_OK_FOR_EVENT, WNDS, WNPS);
497
498 --|--------------------------------------------------------------------------|
499 --|--< GET_CURRENT_PERSON_ID>-----------------------------------------|
500 --|--------------------------------------------------------------------------|
501
502 -- {Start Of Comments}
503 --
504 -- Description:
505 -- Called by dynamic sql to determine whether it is OK to show the delegate
506 -- the event in question. Only the events that they can enroll onto are
507 -- shown.
508 -- Prerequisites:
509 -- none
510 --
511 -- Post Success:
512 --
513 -- Post Failure:
514 -- an exception is raised
515 --
516 -- Access Status:
517 -- Public
518 --
519 -- {End Of Comments}
520 --
521 ----------------------------------------------------------------------------
522 /*
523 FUNCTION Get_Current_Person_ID
524 (p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE
525 ,p_item_key IN WF_ITEMS.ITEM_KEY%TYPE)
526 RETURN NUMBER;
527
528 -- ----------------------------------------------------------------------------
529 -- |---------------------< CHECK_ENROLLMENT_CREATION>----------------------|
530 -- ----------------------------------------------------------------------------
531 -- {Start Of Comments}
532 --
533 -- Description:
534 -- This procedure will be a concurrent process which run in the background.
535 --
536 -- This procedure will only be used for OTA and OM integration. Basically this
537 -- procedure will select all delegate booking data that has daemon_flag='Y' and
538 -- Daemon_type is not nul. If the enrollment got canceled and there is a
539 -- waitlisted student then the automatic waitlist processing will be called.
540 --
541 -- Pre Conditions:
542 -- None.
543 --
544 -- IN
545 -- itemtype - type of the current item
546 -- itemkey - key of the current item
547 -- actid - process activity instance id
548 -- funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...)
549 -- OUT
550 -- result
551 -- - COMPLETE[:<result>]
552 -- activity has completed with the indicated result
553 -- - WAITING
554 -- activity is waiting for additional transitions
555 -- - DEFERED
556 -- execution should be defered to background
557 -- - NOTIFIED[:<notification_id>:<assigned_user>]
558 -- activity has notified an external entity that this
559 -- step must be performed. A call to wf_engine.CompleteActivty
560 -- will signal when this step is complete. Optional
561 -- return of notification ID and assigned user.
562 -- - ERROR[:<error_code>]
563 -- function encountered an err--
564 --
565 -- Post Success:
566 -- Processing continues.
567 --
568 --
569 -- Post Failure:
570 -- None.
571 --
572 -- Access Status:
573 -- Public.
574 --
575 -- {End Of Comments}
576 ----------------------------------------------------------------------------
577 PROCEDURE CHECK_ENROLLMENT_CREATION(
578 Itemtype IN VARCHAR2
579 ,Itemkey IN VARCHAR2
580 ,actid IN NUMBER
581 ,funcmode IN VARCHAR2
582 ,resultout OUT nocopy VARCHAR2
583 );
584
585 --
586 -- ----------------------------------------------------------------------------
587 -- |--------------------------------< CHECK_WF_STATUS>-------------------------|
588 -- ----------------------------------------------------------------------------
589 -- {Start Of Comments}
590 --
591 -- Description:
592 -- This function will be a used to check the workflow status of Order Line.
593 --
594 -- IN
595 -- p_line_id
596 --
597 -- OUT
598 -- p_exist
599 --
600 -- Post Failure:
601 -- None.
602 --
603 -- Access Status:
604 -- Public.
605 --
606 -- {End Of Comments}
607 ----------------------------------------------------------------------------
608
609 FUNCTION Check_wf_Status (
610 p_item_key NUMBER,
611 p_activity varchar2,
612 p_item_type VARCHAR2
613 ) RETURN Boolean;
614
615 --
616 -- ----------------------------------------
617 -- Workflow Cross Charges Notifications
618 -- ----------------------------------------
619 --
620
621 PROCEDURE Cross_Charges_Notifications ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
622 itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
623 actid IN NUMBER,
624 funcmode IN VARCHAR2,
625 resultout OUT nocopy VARCHAR2 );
626
627
628 PROCEDURE APPROVED ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
629 itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
630 actid IN NUMBER,
631 funcmode IN VARCHAR2,
632 resultout OUT VARCHAR2 );
633 */
634
635 --
636 -- ----------------------------------------------------------------------------
637 -- |--------------------------------< Get_Booking_OVN >-----------------------|
638 -- ----------------------------------------------------------------------------
639 -- {Start Of Comments}
640 --
641 -- Description:
642 -- This function will be used to return object version number of an enrollment.
643 --
644 -- IN
645 -- p_booking_id
646 --
647 -- OUT
648 -- p_ovn
649 --
650 -- Post Failure:
651 -- None.
652 --
653 -- Access Status:
654 -- Public.
655 --
656 -- {End Of Comments}
657 ----------------------------------------------------------------------------
658
659 FUNCTION Get_Booking_OVN (p_booking_id IN NUMBER)
660 RETURN NUMBER;
661
662
663 --
664 --|--------------------------------------------------------------------------|
665 --|--< CHK_FOR_RESTRICTED_EVT >-------------------------------------------|
666 --|--------------------------------------------------------------------------|
667
668 -- {Start Of Comments}
669 --
670 -- Description:
671 -- Called by dynamic sql to determine whether event is restricted and it is OK to show the delegate
672 -- the event in question. Only the events that they can enroll onto are
673 -- shown.
674 -- Prerequisites:
675 -- none
676 --
677 -- Post Success:
678 --
679 -- Post Failure:
680 -- an exception is raised
681 --
682 -- Access Status:
683 -- Public
684 --
685 -- {End Of Comments}
686 --
687 ----------------------------------------------------------------------------
688
689 FUNCTION CHK_FOR_RESTRICTED_EVT (
690 p_event_id IN OTA_EVENTS.EVENT_ID%TYPE)
691 RETURN VARCHAR2;
692 PRAGMA RESTRICT_REFERENCES(CHK_FOR_RESTRICTED_EVT, WNDS, WNPS);
693
694 end ota_trng_enroll_ss ;