[Home] [Help]
12:
13: ---------- private function to get item type for current transaction ---------
14: -------------------------------------------------------------------------------
15: function get_item_type
16: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
17: return varchar2 is
18: c_item_type varchar2(50);
19:
20: begin
36: --------- function get_item_key --------------------------------------------
37: ---------- private function to get item key for current transaction ---------
38: -------------------------------------------------------------------------------
39: function get_item_key
40: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
41: return varchar2 is
42: c_item_key varchar2(100);
43:
44: begin
66: -- Get the class standard price
67: --
68:
69: function get_class_standard_price
70: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
71: return number is
72: c_class_standard_price ota_events.standard_price%type;
73: c_event_id ota_events.event_id%type;
74: c_item_type varchar2(50);
116: --
117: -- Get the learning path name
118: --
119: function get_Learning_path_name
120: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
121: return varchar2 is
122:
123: c_lp_name ota_learning_paths_tl.name%type;
124: c_event_id ota_events.event_id%type;
182: --
183: -- Get the course primary category
184: --
185: function get_course_primary_category
186: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
187: return varchar2 is
188:
189: c_course_category ota_category_usages_tl.category%type;
190: c_event_id ota_events.event_id%type;
241: --
242: -- Get the enrollment status
243: --
244: function get_enrollment_status
245: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
246: return varchar2 is
247:
248: c_enrollment_status ota_booking_status_types.name%type;
249: c_booking_id ota_delegate_bookings.booking_id%type;
295: --
296: -- Get the delivery mode for the offering
297: --
298: function get_ofr_delivery_mode
299: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
300: return varchar2 is
301:
302: c_delivery_mode ota_category_usages_tl.category%type;
303: c_event_id ota_events.event_id%type;
358: --
359: -- Get the course name
360: --
361: function get_course_name
362: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
363: return varchar2 is
364:
365: c_course_name ota_activity_versions_tl.version_name%type;
366: c_event_id ota_events.event_id%type;
407: --
408: -- Get the offering name
409: --
410: function get_offering_name
411: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
412: return varchar2 is
413:
414: c_offering_name ota_offerings_tl.name%type;
415: c_event_id ota_events.event_id%type;
456: --
457: -- Get the class name
458: --
459: function get_class_name
460: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
461: return varchar2 is
462:
463: c_class_name ota_events_tl.title%type;
464: c_event_id ota_events.event_id%type;
503: --
504: -- Get the class location
505: --
506: function get_class_location
507: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
508: return varchar2 is
509:
510: c_class_location hr_locations_all.location_code%type;
511: c_event_id ota_events.event_id%type;
550: --
551: -- Get the certification name
552:
553: function get_certification_name
554: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
555: return varchar2 is
556:
557: c_certification_name ota_certifications_tl.name%type;
558: --c_certification_id ota_events.event_id%type;
585: -- ------------------------------------------------------------------------
586: --
587:
588: function get_certification_type
589: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
590: return varchar2 is
591:
592: c_certification_type varchar2(100);
593: c_certification_id ota_certifications_b.certification_id%type;
633: -- ------------------------------------------------------------------------
634:
635: --
636: function get_init_cert_dur
637: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
638: return varchar2 is
639:
640: c_cert_dur varchar2(100);
641: c_certification_id ota_certifications_b.certification_id%type;
681: -- ------------------------------------------------------------------------
682:
683: --
684: function get_renewal_duration
685: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
686: return varchar2 is
687:
688: c_cert_dur varchar2(100);
689: c_certification_id ota_certifications_b.certification_id%type;
728: -- ------------------------------------------------------------------------
729:
730: --
731: function get_validity_duration
732: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
733: return varchar2 is
734:
735: c_cert_dur varchar2(100);
736: c_certification_id ota_certifications_b.certification_id%type;
779: -- ------------------------------------------------------------------------
780:
781: --
782: function get_cert_period_start_date
783: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
784: return varchar2 is
785:
786: c_cert_date Date;
787: l_return_value varchar2(100);
844: -- ------------------------------------------------------------------------
845:
846: --
847: function get_cert_period_end_date
848: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
849: return varchar2 is
850:
851: c_cert_date Date;
852: l_return_value varchar2(100);
909: -- ------------------------------------------------------------------------
910:
911: --
912: function get_init_cert_comp_date
913: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
914: return varchar2 is
915:
916: c_cert_date Date;
917: l_return_value varchar2(100);