1 Package ota_utility AUTHID CURRENT_USER as
2 /* $Header: ottomint.pkh 120.30 2010/05/25 05:37:48 shwnayak ship $ */
3
4
5 function get_resource_count(peventid number)
6 return varchar2;
7
8 function is_con_prog_periodic(p_name in varchar2)
9 return boolean;
10
11 Function get_delivery_method (p_offering_id in number)
12 return varchar2;
13
14 Function get_test_time(p_lo_time number)
15 return varchar2;
16
17 function get_default_comp_upd_level(p_obj_id in number,
18 p_obj_type varchar2)
19 return varchar2 ;
20
21 -- ----------------------------------------------------------------
22 -- ------------------<get_session_count >--------------------
23 -- ----------------------------------------------------------------
24 function get_session_count(peventid number)
25 return varchar2;
26
27 -- ----------------------------------------------------------------
28 -- ------------------<get_child_count >----------------------
29 -- ----------------------------------------------------------------
30 function get_child_count(p_object_id IN NUMBER,
31 p_object_type IN VARCHAR2)
32 return varchar2;
33
34 -- ----------------------------------------------------------------------------
35 -- |-----------------------------< ignore_dff_validation >---------------------------|
36 -- ----------------------------------------------------------------------------
37 Procedure ignore_dff_validation(p_dff_name in varchar2);
38 -- ----------------------------------------------------------------------------
39 -- |-----------------------------< GET_DESCIRPTION >---------------------------|
40 -- ----------------------------------------------------------------------------
41 -- {Start Of Comments}
42 --
43 -- Description:
44 -- This procedure will be used to retrieve enrollment and event information
45 -- for AR interface.
46 --
47 --
48 -- Pre Conditions:
49 -- None.
50 --
51 -- In Arguments:
52 -- p_line_id,
53 -- p_uom
54 --
55 -- Out Arguments:
56 -- p_description
57 -- p_course_end_date
58 -- e_return_status
59 --
60 -- Post Success:
61 -- Processing continues.
62 --
63 --
64 -- Post Failure:
65 -- None.
66 --
67 -- Access Status:
68 -- Public.
69 --
70 -- {End Of Comments}
71 ----------------------------------------------------------------------------
72
73 Procedure GET_DESCRIPTION (p_line_id in number,
74 p_uom in varchar2,
75 x_description out nocopy varchar2,
76 x_course_end_date out nocopy date,
77 x_return_status out nocopy varchar2);
78
79
80
81 -- ----------------------------------------------------------------------------
82 -- |------------------------< get_invoice_rule >----------------------------|
83 -- ----------------------------------------------------------------------------
84 -- {Start Of Comments}
85 --
86 -- Description:
87 -- This procedure is used to retrieve invoicing rule for Order Line.
88 --
89 --
90 -- Pre Conditions:
91 -- None.
92 --
93 -- In Arguments:
94 -- p_line_id
95 --
96 -- Out Argument
97 -- p_invoice_rule
98 --
99 -- Post Success:
100 -- Processing continues.
101 --
102 --
103 -- Post Failure:
104 -- None.
105 --
106 -- Access Status:
107 -- Public.
108 --
109 -- {End Of Comments}
110 ----------------------------------------------------------------------------
111
112 PROCEDURE GET_INVOICE_RULE
113 (
114 p_line_id IN NUMBER,
115 p_invoice_rule OUT NOCOPY VARCHAR2
116 );
117
118 -- ----------------------------------------------------------------------------
119 -- |----------------------< get_booking_status_type >-------------------------|
120 -- ----------------------------------------------------------------------------
121 -- {Start Of Comments}
122 --
123 -- Description:
124 -- This procedure will retrieve enrollment Status Type.
125 --
126 --
127 -- Pre Conditions:
128 -- None.
129 --
130 -- In Arguments:
131 -- p_status_type_id,
132 --
133 -- Out Arguments:
134 -- p_type
135 --
136 -- Post Success:
137 -- Processing continues.
138 --
139 --
140 -- Post Failure:
141 -- None.
142 --
143 -- Access Status:
144 -- Public.
145 --
146 -- {End Of Comments}
147 ----------------------------------------------------------------------------
148
149
150 PROCEDURE get_booking_status_type(
151 p_status_type_id IN number,
152 p_type OUT NOCOPY Varchar2) ;
153
154 -- ----------------------------------------------------------------------------
155 -- |----------------------< get_booking_status >-------------------------|
156 -- ----------------------------------------------------------------------------
157 -- {Start Of Comments}
158 --
159 -- Description:
160 -- This procedure will retrieve enrollment Status.
161 --
162 --
163 -- Pre Conditions:
164 -- None.
165 --
166 -- In Arguments:
167 -- p_status_type_id,
168 --
169 -- Out Arguments:
170 -- p_status
171 --
172 -- Post Success:
173 -- Processing continues.
174 --
175 --
176 -- Post Failure:
177 -- None.
178 --
179 -- Access Status:
180 -- Public.
181 --
182 -- {End Of Comments}
183 ----------------------------------------------------------------------------
184
185
186 PROCEDURE get_booking_status(
187 p_status_type_id IN number,
188 p_status OUT NOCOPY Varchar2) ;
189
190 -- ----------------------------------------------------------------------------
191 -- |-----------------------------< Check_enrollment>-------------------------|
192 -- ----------------------------------------------------------------------------
193 -- {Start Of Comments}
194 --
195 -- Description:
196 -- This procedure will be used to check whether Enrollment exist or not.
197 --
198 --
199 -- Pre Conditions:
200 -- None.
201 --
202 -- In Arguments:
203 -- p_line_id,
204 --
205 -- In Arguments:
206 -- x_valid,
207 -- x_return_status
208
209 -- Post Success:
210 -- Processing continues.
211 --
212 --
213 -- Post Failure:
214 -- None.
215 --
216 -- Access Status:
217 -- Public.
218 --
219 -- {End Of Comments}
220 ----------------------------------------------------------------------------
221 Procedure check_enrollment (p_line_id IN Number ,
222 x_valid OUT NOCOPY varchar2,
223 x_return_status OUT NOCOPY varchar2 );
224 --
225
226 -- ----------------------------------------------------------------------------
227 -- |-----------------------------------< Check_event>-------------------------|
228 -- ----------------------------------------------------------------------------
229 -- {Start Of Comments}
230 --
231 -- Description:
232 -- This Procedure will be used to check Whether Event exist.
233 --
234 --
235 -- Pre Conditions:
236 -- None.
237 --
238 -- In Arguments:
239 -- p_line_id,
240 --
241 -- In Arguments:
242 -- x_valid,
243 -- x_return_status
244 --
245 -- Post Success:
246 -- Processing continues.
247 --
248 --
249 -- Post Failure:
250 -- None.
251 --
252 -- Access Status:
253 -- Public.
254 --
255 -- {End Of Comments}
256 ----------------------------------------------------------------------------
257 Procedure check_event (p_line_id IN Number,
258 x_valid OUT NOCOPY varchar2,
259 x_return_status OUT NOCOPY varchar2 );
260
261 --
262 -- ----------------------------------------------------------------------------
263 -- |----------------------------< get_lookup_meaning>-------------------------|
264 -- ----------------------------------------------------------------------------
265 -- {Start Of Comments}
266 --
267 -- Description:
268 -- This function will be used to get lookup meaning.
269 --
270 --
271 -- Pre Conditions:
272 -- None.
273 --
274 -- In Arguments:
275 -- p_lookup_type
276 -- p_lookup_code
277 -- p_application_id
278 --
279 -- Post Success:
280 -- Processing continues.
281 --
282 --
283 -- Post Failure:
284 -- None.
285 --
286 -- Access Status:
287 -- Public.
288 --
289 -- {End Of Comments}
290 ----------------------------------------------------------------------------
291
292 Function Get_Lookup_meaning(p_lookup_type varchar2,
293 p_lookup_code varchar2,
294 p_application_id number) return varchar2;
295
296 -- ----------------------------------------------------------------------------
297 -- |--------------------------------< CHECK_INVOICE >-------------------------|
298 -- ----------------------------------------------------------------------------
299 -- {Start Of Comments}
300 --
301 -- Description:
302 -- This procedure will be a used to check the invoice of Order Line.
303 --
304 -- IN
305 -- p_line_id
306 -- p_org_id
307 --
308 -- OUT
309 -- p_exist
310 --
311 -- Post Failure:
312 -- None.
313 --
314 -- Access Status:
315 -- Public.
316 --
317 -- {End Of Comments}
318 ----------------------------------------------------------------------------
319
320 PROCEDURE CHECK_INVOICE (
321 p_Line_id IN NUMBER,
322 p_Org_id IN NUMBER,
323 p_exist OUT NOCOPY VARCHAR2);
324
325
326 -- ----------------------------------------------------------------------------
327 -- |--------------------------------< CHECK_WF_STATUS>-------------------------|
328 -- ----------------------------------------------------------------------------
329 -- {Start Of Comments}
330 --
331 -- Description:
332 -- This function will be a used to check the workflow status of Order Line.
333 --
334 -- IN
335 -- p_line_id
336 -- p_activity
337 --
338 --
339 -- Post Failure:
340 -- None.
341 --
342 -- Access Status:
343 -- Public.
344 --
345 -- {End Of Comments}
346 ----------------------------------------------------------------------------
347
348 FUNCTION Check_wf_Status (
349 p_Line_id IN NUMBER,
350 p_activity varchar2)
351
352 return boolean;
353
354 -- ----------------------------------------------------------------------------
355 -- |-------------------------< other_bookings_clash >-------------------------|
356 -- ----------------------------------------------------------------------------
357 --
358 -- PUBLIC
359 -- Description: Other Bookings Clash
360 --
361 -- Checks if the booking being made clashes with any other
362 -- bookings for the delegate
363 -- Note - bookings only clash if they are confirmed
364 --
365 Procedure other_bookings_clash (p_delegate_person_id in varchar2,
366 p_delegate_contact_id in varchar2,
367 p_event_id in number,
368 p_booking_status_type_id in varchar2,
369 p_return_status out nocopy boolean,
370 p_warn out nocopy boolean) ;
371
372 -- ----------------------------------------------------------------
373 -- -------------------------<GET_BG_NAME >-------------------------
374 -- ----------------------------------------------------------------
375 -- {Start of Comments}
376 --
377 -- Description:
378 -- This function will be used to get the Business Group Name for the
379 -- Organization_ID passed in.
380 -- IN
381 -- p_organization_id
382 --
383 --
384 -- Post Failure:
385 -- None.
386 -- Access Status
387 -- Public
388 -- {End of Comments}
389 ------------------------------------------------------------------
390 FUNCTION get_bg_name (
391 p_organization_id IN NUMBER)
392 RETURN VARCHAR2;
393
394 -- ----------------------------------------------------------------
395 -- ---------------------<get_commitment_detail >-------------------
396 -- ----------------------------------------------------------------
397 -- {Start of Comments}
398 --
399 -- Description:
400 -- This procedure calls the OM procedure which returns the commitment
401 -- details when a line_id and UOM is passed as a parameter.
402 -- IN Reqd Type
403 -- p_line_id NUMBER
404 -- OUT
405 -- x_commitment_id NUMBER
406 -- x_commitment_number VARCHAR2
407 -- x_commitment_start_date DATE
408 -- x_commitment_end_date DATE
409 --
410 -- Post Failure:
411 -- None.
412 -- Access Status
413 -- Public
414 -- {End of Comments}
415 ------------------------------------------------------------------
416 PROCEDURE get_commitment_detail
417 (p_line_id IN NUMBER,
418 p_commitment_id OUT NOCOPY NUMBER,
419 p_commitment_number OUT NOCOPY VARCHAR2,
420 p_commitment_start_date OUT NOCOPY DATE,
421 p_commitment_end_date OUT NOCOPY DATE
422 );
423
424 -- ----------------------------------------------------------------
425 -- ------------------<check_product_installed >--------------------
426 -- ----------------------------------------------------------------
427 -- {Start of Comments}
428 --
429 -- Description:
430 -- This function will be used to check if a particular product is installed
431 -- or not.
432 -- IN
433 -- p_application_id
434 --
435 --
436 -- Post Failure:
437 -- None.
438 -- Access Status
439 -- Public
440 -- {End of Comments}
441 ------------------------------------------------------------------
442 FUNCTION check_product_installed(p_application_id IN NUMBER)
443 RETURN VARCHAR2;
444 -- ----------------------------------------------------------------
445 -- ------------------<get_delivery_method >--------------------
446 -- ----------------------------------------------------------------
447 -- {Start of Comments}
448 --
449 -- Description:
450 -- This function will be used to find the delivery method name
451 -- for the particular activity
452 -- IN
453 -- p_Activity_version_id
454 -- p_return_value
455 --
456 -- Post Failure:
457 -- None.
458 -- Access Status
459 -- Public
460 -- {End of Comments}
461 ------------------------------------------------------------------
462 FUNCTION get_delivery_method(p_activity_version_id IN NUMBER,
463 p_return_value IN VARCHAR2)
464 RETURN VARCHAR2;
465
466
467 -- ----------------------------------------------------------------
468 -- ------------------<students_on_waitlist >--------------------
469 -- ----------------------------------------------------------------
470 -- {Start of Comments}
471 --
472 -- Description:
473 -- This function will be used to find the number of students waitlisted
474 -- in a particular event
475 -- IN
476 -- p_event_id
477 --
478 --
479 -- Post Failure:
480 -- None.
481 -- Access Status
482 -- Public
483 -- {End of Comments}
484 ------------------------------------------------------------------
485 FUNCTION students_on_waitlist(p_event_id IN NUMBER)
486 RETURN NUMBER;
487
488 -- ----------------------------------------------------------------
489 -- ------------------<Place_on_waitlist >--------------------
490 -- ----------------------------------------------------------------
491 -- {Start of Comments}
492 --
493 -- Description:
494 -- This function will be used to check the place on waitlist for a particular enrollment
495 -- in the particular event.
496 -- IN
497 -- p_event_id
498 -- p_booking_id
499 --
500 -- Post Failure:
501 -- None.
502 -- Access Status
503 -- Public
504 -- {End of Comments}
505 ------------------------------------------------------------------
506 FUNCTION place_on_waitlist(p_event_id IN NUMBER,
507 p_booking_id IN NUMBER)
508 RETURN NUMBER;
509
510 -- ----------------------------------------------------------------
514 --
511 -- ------------------<get_event_location >--------------------
512 -- ----------------------------------------------------------------
513 -- {Start of Comments}
515 -- Description:
516 -- This function will be used to return the location id for the event.
517 -- IN
518 -- p_event_id
519 --
520 --
521 -- Post Failure:
522 -- None.
523 -- Access Status
524 -- Public
525 -- {End of Comments}
526 ------------------------------------------------------------------
527 FUNCTION get_event_location(p_event_id IN NUMBER)
528 RETURN NUMBER;
529
530
531 -- ----------------------------------------------------------------
532 -- ------------------<get_play_button >--------------------
533 -- ----------------------------------------------------------------
534 -- {Start of Comments}
535 --
536 -- Description:
537 -- This function will be used to return a varchar to indicate if
538 -- Play button will be displayed or not.
539 -- IN
540 -- p_person_id
541 -- p_offering_id
542 -- p_enrollment_status
543 -- p_course_start_date
544 -- p_course_end_date
545 --
546 -- Post Failure:
547 -- None.
548 -- Access Status
549 -- Public
550 -- {End of Comments}
551 ------------------------------------------------------------------
552 FUNCTION get_play_button(p_person_id IN NUMBER,
553 p_offering_id IN NUMBER,
554 p_enrollment_status IN VARCHAR2,
555 p_course_start_date IN DATE,
556 p_course_end_date IN DATE)
557 RETURN VARCHAR2;
558
559 -- ----------------------------------------------------------------
560 -- --------------------< get_authorizer_name >---------------------
561 -- ----------------------------------------------------------------
562 -- {Start of Comments}
563 --
564 -- Description:
565 -- This function will be used to find the name of the person who
566 -- authorized enrollment in an eventy
567 -- IN
568 -- p_authorizer_id
569 -- p_course_start_date
570 -- p_course_end_date
571 --
572 -- Post Failure:
573 -- None.
574 -- Access Status
575 -- Public
576 -- {End of Comments}
577 ------------------------------------------------------------------
578 FUNCTION get_authorizer_name(p_authorizer_id IN NUMBER,
579 p_course_start_date IN DATE,
580 p_course_end_date IN DATE)
581 RETURN VARCHAR2;
582
583 -- ----------------------------------------------------------------
584 -- --------------------< get_message >---------------------
585 -- ----------------------------------------------------------------
586 -- {Start of Comments}
587 --
588 -- Description:
589 -- This function will be used to get the message for the code passed in.
590 -- IN
591 -- p_application_code
592 -- p_message_code
593 -- OUT
594 -- p_message_text
595 --
596 -- Post Failure:
597 -- None.
598 -- Access Status
599 -- Public
600 -- {End of Comments}
601 ------------------------------------------------------------------
602 FUNCTION get_message(p_application_code IN VARCHAR2,
603 p_message_code IN VARCHAR2)
604 RETURN VARCHAR2;
605
606 -- ----------------------------------------------------------------
607 -- --------------------< get_date_time >---------------------
608 -- ----------------------------------------------------------------
609 -- {Start of Comments}
610 --
611 -- Description:
612 -- This function will be used to return date and time.
613 -- IN
614 -- p_date
615 -- p_time
616 -- p_time_of_day (Added for Bug 2201420)
617 -- OUT
618 -- p_date_time
619 --
620 -- Post Failure:
621 -- None.
622 -- Access Status
623 -- Public
624 -- {End of Comments}
625 ------------------------------------------------------------------
626 FUNCTION get_date_time(p_date IN DATE,
627 p_time IN VARCHAR2,
628 p_time_of_day IN VARCHAR2)
629 RETURN DATE;
630
631
632 -- ----------------------------------------------------------------
633 -- ------------------<get_category_name >--------------------
634 -- ----------------------------------------------------------------
635 -- {Start of Comments}
636 --
637 -- Description:
638 -- This function will be used to find the category name
639 -- for the particular activity
640 -- IN
641 -- p_Activity_version_id
642 --
643 -- OUT
644 -- category name
645 -- Post Failure:
646 -- None.
647 -- Access Status
648 -- Public
649 -- {End of Comments}
650 ------------------------------------------------------------------
651
652 FUNCTION get_category_name(p_activity_version_id IN NUMBER)
653 RETURN VARCHAR2;
654
655 -- ----------------------------------------------------------------
656 -- ------------------<get_lo_offering_count >--------------------
657 -- ----------------------------------------------------------------
658 -- {Start of Comments}
659 --
660 -- Description:
661 -- This function will be used to find the number of offerings for the particular
662 -- learning object
663 -- IN
664 -- p_learning_object_id
665 --
666 -- OUT
667 -- offering count
668 -- Post Failure:
669 -- None.
670 -- Access Status
671 -- Public
672 -- {End of Comments}
673 ------------------------------------------------------------------
674 FUNCTION get_lo_offering_count (p_learning_object_id in number)
675 RETURN varchar2;
676
677 -- ----------------------------------------------------------------
681 --
678 -- ------------------<get_course_offering_count >--------------------
679 -- ----------------------------------------------------------------
680 -- {Start of Comments}
682 -- Description:
683 -- This function will be used to find the number of offerings for the particular
684 -- course
685 -- IN
686 -- p_activity_version_id
687 --
688 -- OUT
689 -- offering count
690 -- Post Failure:
691 -- None.
692 -- Access Status
693 -- Public
694 -- {End of Comments}
695 ------------------------------------------------------------------
696 FUNCTION get_course_offering_count (p_activity_version_id in number)
697 RETURN varchar2;
698
699
700 -- ----------------------------------------------------------------
701 -- ------------------<get_iln_rco_id >--------------------
702 -- ----------------------------------------------------------------
703 -- {Start of Comments}
704 --
705 -- Description:
706 -- This function will be used to find rco_id for course
707 -- IN
708 -- p_activity_version_id
709 --
710 -- OUT
711 -- l_rco_id
712 -- Post Failure:
713 -- None.
714 -- Access Status
715 -- Public
716 -- {End of Comments}
717 ------------------------------------------------------------------
718 function get_iln_rco_id (p_activity_version_id in number
719 ) return varchar2;
720
721
722 -- ----------------------------------------------------------------
723 -- ------------------<get_event_count >--------------------
724 -- ----------------------------------------------------------------
725 -- {Start of Comments}
726 --
727 -- Description:
728 -- This function will be used to find the number of of events the particular
729 -- offering
730 -- IN
731 -- p_offering_id
732 -- p_event_type
733 --
734 -- OUT
735 -- event count
736 -- Post Failure:
737 -- None.
738 -- Access Status
739 -- Public
740 -- {End of Comments}
741 ------------------------------------------------------------------
742 FUNCTION get_event_count (p_offering_id in number,
743 p_event_type in varchar2 default 'ALL')
744 RETURN varchar2;
745
746 -- ----------------------------------------------------------------
747 -- ------------------<get_question_bank_count >--------------------
748 -- ----------------------------------------------------------------
749 -- {Start of Comments}
750 --
751 -- Description:
752 -- This function will be used to find the number of question banks for particular
753 -- folder
754 -- IN
755 -- p_folder_id
756 --
757 -- OUT
758 -- question bank count
759 -- Post Failure:
760 -- None.
761 -- Access Status
762 -- Public
763 -- {End of Comments}
764 ------------------------------------------------------------------
765 FUNCTION get_question_bank_count (p_folder_id in number)
766 RETURN varchar2;
767
768 -- Author: sbhullar
769 FUNCTION get_enrollment_status(p_delegate_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,
770 p_delegate_contact_id IN NUMBER,
771 p_event_id IN ota_events.event_id%TYPE,
772 p_code number)
773 RETURN VARCHAR2;
774
775 FUNCTION get_user_fullname(p_user_id IN ota_attempts.user_id%TYPE,
776 p_user_type IN ota_attempts.user_type%TYPE)
777
778 RETURN VARCHAR2;
779
780 FUNCTION get_person_fullname(p_user_id IN ota_attempts.user_id%TYPE
781 )RETURN VARCHAR2;
782
783 FUNCTION get_learner_name(p_person_id IN per_all_people_f.person_id%TYPE,
784 p_customer_id IN ota_delegate_bookings.customer_id%TYPE,
785 p_contact_id IN ota_delegate_bookings.delegate_contact_id%TYPE)
786 RETURN VARCHAR2;
787
788 FUNCTION get_customer_id(p_contact_id IN ota_lp_enrollments.contact_id%TYPE)
789 RETURN number;
790
791 FUNCTION get_cust_org_name(p_organization_id IN ota_delegate_bookings.organization_id%TYPE,
792 p_customer_id IN ota_delegate_bookings.customer_id%TYPE,
793 p_contact_id IN ota_lp_enrollments.contact_id%TYPE default null)
794 RETURN VARCHAR2;
795
796 -- ----------------------------------------------------------------
797 -- ------------------<get_catalog_object_path >--------------------
798 -- ----------------------------------------------------------------
799 -- {Start of Comments}
800 --
801 -- Description:
802 -- This function will be used to find the path for particular
803 -- category
804 -- IN
805 -- p_cat_id
806 --
807 -- OUT
808 -- p_path
809 -- Post Failure:
810 -- None.
811 -- Access Status
812 -- Public
813 -- {End of Comments}
814 ------------------------------------------------------------------
815 Procedure get_catalog_object_path(p_cat_id varchar2,
816 p_path OUT NOCOPY varchar2 );
817
818 -- ----------------------------------------------------------------
819 -- ------------------<get_content_object_path >--------------------
820 -- ----------------------------------------------------------------
821 -- {Start of Comments}
822 --
823 -- Description:
824 -- This function will be used to find the path for particular
825 -- content object
826 -- IN
827 -- p_obj_id
828 -- p_obj_type
829 --
830 -- OUT
831 -- p_path
832 -- Post Failure:
833 -- None.
834 -- Access Status
835 -- Public
836 -- {End of Comments}
837 ------------------------------------------------------------------
838 Procedure get_content_object_path(p_obj_id varchar2, p_obj_type varchar2,
842 -- ------------------<check_function_access >--------------------
839 p_path OUT NOCOPY varchar2 );
840
841 -- ----------------------------------------------------------------
843 -- ----------------------------------------------------------------
844 -- {Start of Comments}
845 --
846 -- Description:
847 -- This function will be used to find if the user logged in has
848 -- access to the function or not.
849 -- IN
850 -- p_function_name
851 --
852 -- OUT
853 -- returns T for True or F for False
854 -- Post Failure:
855 -- None.
856 -- Access Status
857 -- Public
858 -- {End of Comments}
859 ------------------------------------------------------------------
860 FUNCTION check_function_access(p_function_name in VARCHAR2)
861 RETURN varchar2;
862
863 -- ----------------------------------------------------------------
864 -- ------------------< get_event_status_code >---------------------
865 -- ----------------------------------------------------------------
866 -- {Start of Comments}
867 --
868 -- Description:
869 -- This function will be used to find the event status code for
870 -- an event
871 -- IN
872 -- p_event_id
873 --
874 -- OUT
875 -- returns event status code
876 -- Post Failure:
877 -- None.
878 -- Access Status
879 -- Public
880 -- {End of Comments}
881 ------------------------------------------------------------------
882 Function get_event_status_code (p_event_id in ota_events.event_id%TYPE)
883 return varchar2;
884
885 -- ----------------------------------------------------------------
886 -- ----------------------< is_applicant >--------------------------
887 -- ----------------------------------------------------------------
888 -- {Start of Comments}
889 --
890 -- Description:
891 -- This function will be used to find whether person is
892 -- applicant or not
893 -- IN
894 -- p_person_id
895 --
896 -- OUT
897 -- returns Y or N
898 -- Post Failure:
899 -- None.
900 -- Access Status
901 -- Public
902 -- {End of Comments}
903 ------------------------------------------------------------------
904 Function is_applicant (p_person_id IN per_all_people_f.person_id%TYPE)
905 return varchar2;
906
907 -- ----------------------------------------------------------------
908 -- -------------------< get_ext_lrnr_party_id >--------------------
909 -- ----------------------------------------------------------------
910 -- {Start of Comments}
911 --
912 -- Description:
913 -- This function will be used to fetch the party id for external learner
914 -- IN
915 -- p_delegate_contact_id
916 --
917 -- OUT
918 -- returns party id
919 -- Post Failure:
920 -- None.
921 -- Access Status
922 -- Public
923 -- {End of Comments}
924 ------------------------------------------------------------------
925 FUNCTION get_ext_lrnr_party_id
926 (p_delegate_contact_id IN ota_delegate_bookings.delegate_contact_id%TYPE)
927 RETURN number;
928
929 FUNCTION is_enrollable
930 ( p_object_type in varchar2
931 ,p_object_id in number
932 )
933 RETURN varchar2;
934
935 PROCEDURE Get_Default_Value_Dff(
936 appl_short_name IN VARCHAR2,
937 flex_field_name IN VARCHAR2,
938 p_attribute_category IN OUT NOCOPY VARCHAR2,
939 p_attribute1 IN OUT NOCOPY VARCHAR2,
940 p_attribute2 IN OUT NOCOPY VARCHAR2,
941 p_attribute3 IN OUT NOCOPY VARCHAR2,
942 p_attribute4 IN OUT NOCOPY VARCHAR2,
943 p_attribute5 IN OUT NOCOPY VARCHAR2,
944 p_attribute6 IN OUT NOCOPY VARCHAR2,
945 p_attribute7 IN OUT NOCOPY VARCHAR2,
946 p_attribute8 IN OUT NOCOPY VARCHAR2,
947 p_attribute9 IN OUT NOCOPY VARCHAR2,
948 p_attribute10 IN OUT NOCOPY VARCHAR2,
949 p_attribute11 IN OUT NOCOPY VARCHAR2,
950 p_attribute12 IN OUT NOCOPY VARCHAR2,
951 p_attribute13 IN OUT NOCOPY VARCHAR2,
952 p_attribute14 IN OUT NOCOPY VARCHAR2,
953 p_attribute15 IN OUT NOCOPY VARCHAR2,
954 p_attribute16 IN OUT NOCOPY VARCHAR2,
955 p_attribute17 IN OUT NOCOPY VARCHAR2,
956 p_attribute18 IN OUT NOCOPY VARCHAR2,
957 p_attribute19 IN OUT NOCOPY VARCHAR2,
958 p_attribute20 IN OUT NOCOPY VARCHAR2);
959
960 PROCEDURE Get_Default_Value_Dff(
961 appl_short_name IN VARCHAR2,
962 flex_field_name IN VARCHAR2,
963 p_attribute_category IN OUT NOCOPY VARCHAR2,
964 p_attribute1 IN OUT NOCOPY VARCHAR2,
965 p_attribute2 IN OUT NOCOPY VARCHAR2,
966 p_attribute3 IN OUT NOCOPY VARCHAR2,
967 p_attribute4 IN OUT NOCOPY VARCHAR2,
968 p_attribute5 IN OUT NOCOPY VARCHAR2,
969 p_attribute6 IN OUT NOCOPY VARCHAR2,
970 p_attribute7 IN OUT NOCOPY VARCHAR2,
971 p_attribute8 IN OUT NOCOPY VARCHAR2,
972 p_attribute9 IN OUT NOCOPY VARCHAR2,
973 p_attribute10 IN OUT NOCOPY VARCHAR2,
974 p_attribute11 IN OUT NOCOPY VARCHAR2,
975 p_attribute12 IN OUT NOCOPY VARCHAR2,
976 p_attribute13 IN OUT NOCOPY VARCHAR2,
977 p_attribute14 IN OUT NOCOPY VARCHAR2,
981 p_attribute18 IN OUT NOCOPY VARCHAR2,
978 p_attribute15 IN OUT NOCOPY VARCHAR2,
979 p_attribute16 IN OUT NOCOPY VARCHAR2,
980 p_attribute17 IN OUT NOCOPY VARCHAR2,
982 p_attribute19 IN OUT NOCOPY VARCHAR2,
983 p_attribute20 IN OUT NOCOPY VARCHAR2,
984 p_attribute21 IN OUT NOCOPY VARCHAR2,
985 p_attribute22 IN OUT NOCOPY VARCHAR2,
986 p_attribute23 IN OUT NOCOPY VARCHAR2,
987 p_attribute24 IN OUT NOCOPY VARCHAR2,
988 p_attribute25 IN OUT NOCOPY VARCHAR2,
989 p_attribute26 IN OUT NOCOPY VARCHAR2,
990 p_attribute27 IN OUT NOCOPY VARCHAR2,
991 p_attribute28 IN OUT NOCOPY VARCHAR2,
992 p_attribute29 IN OUT NOCOPY VARCHAR2,
993 p_attribute30 IN OUT NOCOPY VARCHAR2);
994
995
996 -- Added for bug#4606760
997 function is_customer_associated(p_event_id in NUMBER) return varchar2;
998
999 FUNCTION check_organization_match(
1000 p_person_id IN NUMBER
1001 ,p_sponsor_org_id IN NUMBER) return VARCHAR2;
1002
1003 FUNCTION getEnrollmentChangeReason(
1004 p_booking_id IN NUMBER) return VARCHAR2;
1005
1006 function get_lang_name (
1007 p_language_code in varchar2
1008 ) return varchar2;
1009
1010 function get_class_available_seats(p_event_id ota_events.event_id%type) return varchar2;
1011
1012 function get_cls_enroll_image(p_manager_flag in varchar2,
1013 p_person_id in number,
1014 p_contact_id in number,
1015 p_event_id in ota_events.event_id%TYPE,
1016 p_mandatory_flag in ota_delegate_bookings.is_mandatory_enrollment%TYPE,
1017 p_booking_status_type in ota_booking_status_types.type%TYPE) return varchar2;
1018
1019 FUNCTION is_class_enrollable(
1020 p_enr_type varchar2,
1021 p_class_id ota_events.event_id%TYPE)
1022 RETURN VARCHAR2;
1023
1024 function get_learners_email_addresses(p_event_id ota_events.event_id%type) return clob;
1025
1026
1027 end ota_utility;
1028
1029
[Home] [Help]