APPS.OTA_CANCEL_API dependencies on OTA_EVENTS_TL

Line 69: l_title ota_events_tl.title%type; -- MLS change _tl added

65:
66: l_event_id ota_events.event_id%type;
67: l_event_business_group_id ota_events.business_group_id%type;
68: l_event_status varchar2(100);
69: l_title ota_events_tl.title%type; -- MLS change _tl added
70: l_owner_id ota_events.owner_id%type := null;
71: l_owner_email varchar2(100);
72: l_type varchar2(4);
73: l_event_ovn ota_events.object_version_number%type;

Line 139: OTA_EVENTS_tl evt -- MLS change _tl added

135: tdb.event_id,
136: evt.title
137: FROM
138: OTA_DELEGATE_BOOKINGS tdb,
139: OTA_EVENTS_tl evt -- MLS change _tl added
140: WHERE
141: tdb.Line_id = p_line_id and
142: evt.event_id = tdb.event_id;
143:

Line 424: l_event_title ota_events_tl.title%type; -- MLS change _tl added

420: l_booking_status_type ota_booking_status_types.type%type;
421: l_daemon_flag ota_delegate_bookings.daemon_flag%type;
422: l_daemon_type ota_delegate_bookings.daemon_type%type;
423: l_line_id ota_delegate_bookings.line_id%type;
424: l_event_title ota_events_tl.title%type; -- MLS change _tl added
425: l_business_group_id ota_delegate_bookings.business_group_id%type;
426: l_single_business_group_id ota_delegate_bookings.business_group_id%type:=
427: fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
428: -- Define local variable for status