APPS.OTA_INITIALIZATION_WF dependencies on OTA_EVENTS_TL

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

56: l_header_id oe_order_headers.header_id%type;
57: l_process wf_activities.name%type := upper(p_process);
58: l_itemkey wf_items.item_key%type := to_char(p_line_id);
59: l_owner_name per_people_f.full_name%type;
60: l_event_title ota_events_tl.title%type; --MLS change _tl added
61: l_owner_id ota_events.owner_id%type;
62: l_email_address per_people_f.email_address%type;
63: l_full_name per_people_f.full_name%type;
64:

Line 590: from ota_events_tl evt, ota_events oev

586: select
587: --added after show n tell
588: oev.activity_version_id,oev.actual_cost, oev.budget_currency_code,
589: oev.parent_offering_id,ota_timezone_util.get_timezone_name(oev.timezone) timezone
590: from ota_events_tl evt, ota_events oev
591: where evt.event_id =oev.event_id
592: and oev.event_id = l_event_id
593: and evt.language=USERENV('LANG');
594:

Line 686: l_title ota_events_tl.title%type;

682:
683: l_process wf_activities.name%type := 'OTA_INSTRUCTOR_NTF_JSP_PRC';
684: l_item_key wf_items.item_key%type;
685:
686: l_title ota_events_tl.title%type;
687: l_start_date date;
688: l_end_date date;
689: l_start_time ota_events.course_start_time%type;
690: l_end_time ota_events.course_start_time%type;

Line 719: from ota_events_tl evt, ota_events oev

715: is
716: select evt.title,
717: oev.course_start_date,oev.course_end_date,oev.course_start_time, oev.course_end_time,
718: oev.location_id,oev.event_type,ota_timezone_util.get_timezone_name(oev.timezone)
719: from ota_events_tl evt, ota_events oev
720: where evt.event_id =oev.event_id
721: and oev.event_id = p_eventid
722: and evt.language= USERENV('LANG');
723:

Line 951: l_title ota_events_tl.title%type;

947:
948: l_process wf_activities.name%type := upper(p_process);
949: l_item_key wf_items.item_key%type;
950:
951: l_title ota_events_tl.title%type;
952: l_start_date date;
953: l_end_date date;
954: l_start_time ota_events.course_start_time%type;
955: l_end_time ota_events.course_start_time%type;

Line 971: from ota_events_tl evt, ota_events oev

967: is
968: select evt.title,oev.course_start_date,oev.course_end_date,
969: oev.course_start_time, oev.course_end_time,
970: oev.location_id
971: from ota_events_tl evt, ota_events oev
972: where evt.event_id =oev.event_id
973: and oev.event_id = p_eventid
974: and evt.language=USERENV('LANG');
975:

Line 2031: SELECT title FROM ota_events_tl

2027: display_type in varchar2,
2028: document in out nocopy varchar2,
2029: document_type in out nocopy varchar2) is
2030: CURSOR csr_get_class_name IS
2031: SELECT title FROM ota_events_tl
2032: WHERE to_char(event_id) = document_id AND language = USERENV('LANG');
2033:
2034: l_class_name varchar2(80);
2035: begin

Line 2054: l_title ota_events_tl.title%type;

2050: l_proc varchar2(72) := g_package||'RAISE_BUSINESS_EVENT';
2051:
2052: l_item_key wf_items.item_key%type;
2053:
2054: l_title ota_events_tl.title%type;
2055: l_start_date varchar2(100);
2056: l_end_date varchar2(100);
2057: l_start_time ota_events.course_start_time%type;
2058: l_end_time ota_events.course_start_time%type;

Line 2079: from ota_events_tl evt, ota_events oev

2075: is
2076: select oev.title,oev.course_start_date,oev.course_end_date,
2077: oev.course_start_time, oev.course_end_time,
2078: oev.location_id,oev.training_center_id
2079: from ota_events_tl evt, ota_events oev
2080: where evt.event_id =oev.event_id
2081: and oev.event_id = p_eventid
2082: and evt.language=USERENV('LANG');
2083: