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