APPS.OTA_LEARNER_ENROLL_REVIEW_SS dependencies on OTA_CATEGORY_USAGES

Line 1015: l_delivery_mode ota_category_usages_tl.category%type;

1011: l_event_title ota_events.title%type;
1012: l_course_start_date ota_events.course_start_date%type;
1013: l_course_start_time ota_events.course_start_time%type;
1014: l_course_end_date ota_events.course_end_date%type;
1015: l_delivery_mode ota_category_usages_tl.category%type;
1016: l_event_location hr_locations_all.location_code%TYPE;
1017:
1018: l_notification_text VARCHAR2(1000);
1019: l_business_group_name PER_BUSINESS_GROUPS.name%TYPE := null;

Line 1068: -- (Select Category from ota_category_usages_tl where Category_Usage_Id = ofr.Delivery_Mode_Id

1064: evt.business_group_id bg_id,
1065: evt.course_start_time,
1066: Ctl.Category,
1067: -- Modified for bug 3389890 as usage of inline query in CURSOR is not supported in 8.1.7
1068: -- (Select Category from ota_category_usages_tl where Category_Usage_Id = ofr.Delivery_Mode_Id
1069: -- and Language = userenv('LANG')) Delivery_Mode,
1070: ota_general.get_location_code(ota_utility.get_event_location(evt.event_id)) Location_Name,
1071: ota_timezone_util.get_timezone_name(evt.timezone) timezone,
1072: evt.course_end_time

Line 1075: OTA_CATEGORY_USAGES_TL ctl,

1071: ota_timezone_util.get_timezone_name(evt.timezone) timezone,
1072: evt.course_end_time
1073: FROM OTA_EVENTS_VL evt,
1074: OTA_OFFERINGS ofr,
1075: OTA_CATEGORY_USAGES_TL ctl,
1076: HR_ALL_ORGANIZATION_UNITS hao
1077: WHERE evt.event_id = l_eventid
1078: AND evt.parent_offering_id = ofr.offering_id
1079: AND evt.organization_id = hao.organization_id (+)

Line 2866: from ota_offerings ofe, ota_category_usages_tl ocu

2862:
2863:
2864: cursor get_lang_det is
2865: select ofe.language_id, ocu.category
2866: from ota_offerings ofe, ota_category_usages_tl ocu
2867: where ofe.delivery_mode_id = ocu.category_usage_id
2868: and ocu.language=USERENV('LANG')
2869: and ofe.offering_id = l_off_id;
2870:

Line 2875: l_delivery_method ota_category_usages.category%type;

2871:
2872: l_lang_description fnd_languages_vl.description%TYPE;
2873: l_curr_name fnd_currencies_vl.name%TYPE;
2874: l_lang_id ota_offerings.language_id%type;
2875: l_delivery_method ota_category_usages.category%type;
2876:
2877: begin
2878:
2879:

Line 2934: ota_category_usages OCU

2930: CURSOR delivery_mode(p_event_id OTA_EVENTS.event_id%TYPE) IS
2931: Select OCU.synchronous_flag, OCU.online_flag
2932: From ota_events OEV,
2933: ota_offerings OFR,
2934: ota_category_usages OCU
2935: Where OFR.offering_id = OEV.parent_offering_id
2936: And OCU.category_usage_id = OFR.delivery_mode_id
2937: And OEV.event_id = p_event_id;
2938:

Line 2945: l_synchronous_flag ota_category_usages.synchronous_flag%type;

2941: l_booking_id ota_delegate_bookings.booking_id%type;
2942: l_notification_text varchar2(2000);
2943: l_status_type ota_booking_status_types.type%type;
2944:
2945: l_synchronous_flag ota_category_usages.synchronous_flag%type;
2946: l_online_flag ota_category_usages.online_flag%type;
2947: l_dm_status varchar2(20);
2948: l_approval_req_flag varchar2(100);
2949: l_forward_to_person_id per_people_f.person_id%type;

Line 2946: l_online_flag ota_category_usages.online_flag%type;

2942: l_notification_text varchar2(2000);
2943: l_status_type ota_booking_status_types.type%type;
2944:
2945: l_synchronous_flag ota_category_usages.synchronous_flag%type;
2946: l_online_flag ota_category_usages.online_flag%type;
2947: l_dm_status varchar2(20);
2948: l_approval_req_flag varchar2(100);
2949: l_forward_to_person_id per_people_f.person_id%type;
2950: