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 2190: from ota_offerings ofe, ota_category_usages_tl ocu

2186:
2187:
2188: cursor get_lang_det is
2189: select ofe.language_id, ocu.category
2190: from ota_offerings ofe, ota_category_usages_tl ocu
2191: where ofe.delivery_mode_id = ocu.category_usage_id
2192: and ocu.language=USERENV('LANG')
2193: and ofe.offering_id = l_off_id;
2194:

Line 2199: l_delivery_method ota_category_usages.category%type;

2195:
2196: l_lang_description fnd_languages_vl.description%TYPE;
2197: l_curr_name fnd_currencies_vl.name%TYPE;
2198: l_lang_id ota_offerings.language_id%type;
2199: l_delivery_method ota_category_usages.category%type;
2200:
2201: begin
2202:
2203:

Line 2258: ota_category_usages OCU

2254: CURSOR delivery_mode(p_event_id OTA_EVENTS.event_id%TYPE) IS
2255: Select OCU.synchronous_flag, OCU.online_flag
2256: From ota_events OEV,
2257: ota_offerings OFR,
2258: ota_category_usages OCU
2259: Where OFR.offering_id = OEV.parent_offering_id
2260: And OCU.category_usage_id = OFR.delivery_mode_id
2261: And OEV.event_id = p_event_id;
2262:

Line 2269: l_synchronous_flag ota_category_usages.synchronous_flag%type;

2265: l_booking_id ota_delegate_bookings.booking_id%type;
2266: l_notification_text varchar2(2000);
2267: l_status_type ota_booking_status_types.type%type;
2268:
2269: l_synchronous_flag ota_category_usages.synchronous_flag%type;
2270: l_online_flag ota_category_usages.online_flag%type;
2271: l_dm_status varchar2(20);
2272: l_approval_req_flag varchar2(100);
2273: l_forward_to_person_id per_people_f.person_id%type;

Line 2270: l_online_flag ota_category_usages.online_flag%type;

2266: l_notification_text varchar2(2000);
2267: l_status_type ota_booking_status_types.type%type;
2268:
2269: l_synchronous_flag ota_category_usages.synchronous_flag%type;
2270: l_online_flag ota_category_usages.online_flag%type;
2271: l_dm_status varchar2(20);
2272: l_approval_req_flag varchar2(100);
2273: l_forward_to_person_id per_people_f.person_id%type;
2274: