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