eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_INITIALIZATION_WF dependencies on OTA_EVENTS

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 61: l_owner_id ota_events.owner_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:
65:

Line 81: FROM OTA_EVENTS_VL --MLS change _VL added

77: CURSOR c_event
78: IS
79: SELECT TITLE,
80: owner_id
81: FROM OTA_EVENTS_VL --MLS change _VL added
82: WHERE event_id = p_event_id;
83:
84:
85: CURSOR C_person

Line 563: p_eventid in ota_events.event_id%type,

559: END;
560:
561: Procedure set_addnl_attributes(p_item_type in wf_items.item_type%type,
562: p_item_key in wf_items.item_key%type,
563: p_eventid in ota_events.event_id%type,
564: p_from in varchar2 default null
565: )
566:
567: is

Line 571: l_actual_cost ota_events.actual_cost%type;

567: is
568:
569: l_proc varchar2(72) := g_package||'set_addnl_attributes';
570:
571: l_actual_cost ota_events.actual_cost%type;
572: l_budget_currency_code ota_events.budget_currency_code%type;
573: l_act_ver_id ota_events.activity_version_id%type;
574: l_off_id ota_events.parent_offering_id%type;
575: l_event_id ota_events.event_id%type;

Line 572: l_budget_currency_code ota_events.budget_currency_code%type;

568:
569: l_proc varchar2(72) := g_package||'set_addnl_attributes';
570:
571: l_actual_cost ota_events.actual_cost%type;
572: l_budget_currency_code ota_events.budget_currency_code%type;
573: l_act_ver_id ota_events.activity_version_id%type;
574: l_off_id ota_events.parent_offering_id%type;
575: l_event_id ota_events.event_id%type;
576: l_event_type ota_events.event_type%type;

Line 573: l_act_ver_id ota_events.activity_version_id%type;

569: l_proc varchar2(72) := g_package||'set_addnl_attributes';
570:
571: l_actual_cost ota_events.actual_cost%type;
572: l_budget_currency_code ota_events.budget_currency_code%type;
573: l_act_ver_id ota_events.activity_version_id%type;
574: l_off_id ota_events.parent_offering_id%type;
575: l_event_id ota_events.event_id%type;
576: l_event_type ota_events.event_type%type;
577: l_object_type varchar2(240);

Line 574: l_off_id ota_events.parent_offering_id%type;

570:
571: l_actual_cost ota_events.actual_cost%type;
572: l_budget_currency_code ota_events.budget_currency_code%type;
573: l_act_ver_id ota_events.activity_version_id%type;
574: l_off_id ota_events.parent_offering_id%type;
575: l_event_id ota_events.event_id%type;
576: l_event_type ota_events.event_type%type;
577: l_object_type varchar2(240);
578:

Line 575: l_event_id ota_events.event_id%type;

571: l_actual_cost ota_events.actual_cost%type;
572: l_budget_currency_code ota_events.budget_currency_code%type;
573: l_act_ver_id ota_events.activity_version_id%type;
574: l_off_id ota_events.parent_offering_id%type;
575: l_event_id ota_events.event_id%type;
576: l_event_type ota_events.event_type%type;
577: l_object_type varchar2(240);
578:
579: cursor get_event_type is

Line 576: l_event_type ota_events.event_type%type;

572: l_budget_currency_code ota_events.budget_currency_code%type;
573: l_act_ver_id ota_events.activity_version_id%type;
574: l_off_id ota_events.parent_offering_id%type;
575: l_event_id ota_events.event_id%type;
576: l_event_type ota_events.event_type%type;
577: l_object_type varchar2(240);
578:
579: cursor get_event_type is
580: select parent_event_id,event_type from

Line 581: ota_events where event_id =p_eventid;

577: l_object_type varchar2(240);
578:
579: cursor get_event_type is
580: select parent_event_id,event_type from
581: ota_events where event_id =p_eventid;
582:
583:
584: cursor get_addnl_event_info
585: is

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 669: p_eventid in ota_events.event_id%type,

665: end set_addnl_attributes;
666:
667: Procedure Initialize_instructor_wf(
668: p_item_type in wf_items.item_type%type,
669: p_eventid in ota_events.event_id%type,
670: p_sup_res_id in ota_resource_bookings.supplied_resource_id%type,
671: p_start_date in varchar2,
672: p_end_date in varchar2,
673: p_start_time in ota_events.course_start_time%type,

Line 673: p_start_time in ota_events.course_start_time%type,

669: p_eventid in ota_events.event_id%type,
670: p_sup_res_id in ota_resource_bookings.supplied_resource_id%type,
671: p_start_date in varchar2,
672: p_end_date in varchar2,
673: p_start_time in ota_events.course_start_time%type,
674: p_end_time in ota_events.course_start_time%type,
675: p_status in varchar2,
676: p_res_book_id in ota_resource_bookings.resource_booking_id%type,
677: p_person_id in number,

Line 674: p_end_time in ota_events.course_start_time%type,

670: p_sup_res_id in ota_resource_bookings.supplied_resource_id%type,
671: p_start_date in varchar2,
672: p_end_date in varchar2,
673: p_start_time in ota_events.course_start_time%type,
674: p_end_time in ota_events.course_start_time%type,
675: p_status in varchar2,
676: p_res_book_id in ota_resource_bookings.resource_booking_id%type,
677: p_person_id in number,
678: p_event_fired in varchar2)

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 varchar2(100);
688: l_end_date varchar2(100);
689: l_start_time ota_events.course_start_time%type;
690: l_end_time ota_events.course_start_time%type;

Line 689: l_start_time ota_events.course_start_time%type;

685:
686: l_title ota_events_tl.title%type;
687: l_start_date varchar2(100);
688: l_end_date varchar2(100);
689: l_start_time ota_events.course_start_time%type;
690: l_end_time ota_events.course_start_time%type;
691:
692: l_location_id ota_events.location_id %type;
693: l_event_type ota_events.event_type%type;

Line 690: l_end_time ota_events.course_start_time%type;

686: l_title ota_events_tl.title%type;
687: l_start_date varchar2(100);
688: l_end_date varchar2(100);
689: l_start_time ota_events.course_start_time%type;
690: l_end_time ota_events.course_start_time%type;
691:
692: l_location_id ota_events.location_id %type;
693: l_event_type ota_events.event_type%type;
694:

Line 692: l_location_id ota_events.location_id %type;

688: l_end_date varchar2(100);
689: l_start_time ota_events.course_start_time%type;
690: l_end_time ota_events.course_start_time%type;
691:
692: l_location_id ota_events.location_id %type;
693: l_event_type ota_events.event_type%type;
694:
695: l_person_id per_people_f.person_id%type;
696:

Line 693: l_event_type ota_events.event_type%type;

689: l_start_time ota_events.course_start_time%type;
690: l_end_time ota_events.course_start_time%type;
691:
692: l_location_id ota_events.location_id %type;
693: l_event_type ota_events.event_type%type;
694:
695: l_person_id per_people_f.person_id%type;
696:
697: l_object_type varchar2(240);

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 942: p_eventid in ota_Events.event_id%type,

938:
939: Procedure Initialize_wf(p_process in wf_process_activities.process_name%type,
940: p_item_type in wf_items.item_type%type,
941: p_person_id in number ,
942: p_eventid in ota_Events.event_id%type,
943: p_event_fired in varchar2)
944:
945: is
946: l_proc varchar2(72) := g_package||'Initialize_wf';

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 varchar2(100);
953: l_end_date varchar2(100);
954: l_start_time ota_events.course_start_time%type;
955: l_end_time ota_events.course_start_time%type;

Line 954: l_start_time ota_events.course_start_time%type;

950:
951: l_title ota_events_tl.title%type;
952: l_start_date varchar2(100);
953: l_end_date varchar2(100);
954: l_start_time ota_events.course_start_time%type;
955: l_end_time ota_events.course_start_time%type;
956: l_location_id ota_events.location_id %type;
957: l_event_type ota_events.event_type%type;
958:

Line 955: l_end_time ota_events.course_start_time%type;

951: l_title ota_events_tl.title%type;
952: l_start_date varchar2(100);
953: l_end_date varchar2(100);
954: l_start_time ota_events.course_start_time%type;
955: l_end_time ota_events.course_start_time%type;
956: l_location_id ota_events.location_id %type;
957: l_event_type ota_events.event_type%type;
958:
959: --l_object_type varchar2(240);

Line 956: l_location_id ota_events.location_id %type;

952: l_start_date varchar2(100);
953: l_end_date varchar2(100);
954: l_start_time ota_events.course_start_time%type;
955: l_end_time ota_events.course_start_time%type;
956: l_location_id ota_events.location_id %type;
957: l_event_type ota_events.event_type%type;
958:
959: --l_object_type varchar2(240);
960: l_location_name hr_locations_all_tl.location_code%type;

Line 957: l_event_type ota_events.event_type%type;

953: l_end_date varchar2(100);
954: l_start_time ota_events.course_start_time%type;
955: l_end_time ota_events.course_start_time%type;
956: l_location_id ota_events.location_id %type;
957: l_event_type ota_events.event_type%type;
958:
959: --l_object_type varchar2(240);
960: l_location_name hr_locations_all_tl.location_code%type;
961: l_enrollment_status_name ota_booking_status_types_tl.name%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 1105: p_event_id in ota_events.event_id%type default null)

1101:
1102: Procedure Initialize_auto_wf(p_process in wf_process_activities.process_name%type,
1103: p_item_type in wf_items.item_type%type,
1104: p_event_fired in varchar2,
1105: p_event_id in ota_events.event_id%type default null)
1106: is
1107: l_proc varchar2(72) := g_package||'Initialize_auto_wf';
1108:
1109: l_notify_days_before number(9) := fnd_profile.value('OTA_INST_REMIND_NTF_DAYS');

Line 1116: from ota_events

1112:
1113: cursor get_all_class_info
1114: is
1115: select event_id
1116: from ota_events
1117: where (course_start_date = trunc(sysdate) )
1118: and event_type in ('SCHEDULED' , 'SELFPACED')
1119: and event_status <> 'A';
1120:

Line 1510: l_time ota_events.course_start_time%type;

1506:
1507: l_title ota_learning_objects.name%type;
1508: l_score varchar2(100);
1509:
1510: l_time ota_events.course_start_time%type;
1511: l_format_time varchar2(50);
1512:
1513:
1514:

Line 1929: l_event_id ota_events.event_id%type;

1925: l_process wf_activities.name%type := 'OTA_COURSE_EVAL_PRC';
1926:
1927: l_person_id ota_forum_messages.person_id%type;
1928: l_contact_id ota_forum_messages.contact_id%type;
1929: l_event_id ota_events.event_id%type;
1930: l_status_type ota_booking_status_types.type%type;
1931:
1932: cursor csr_booking_status is
1933: SELECT bst.Type, tdb.delegate_person_id, tdb.contact_id, tdb.event_id

Line 1994: From ota_events OEV,

1990: l_online_flag ota_category_usages.online_flag%type;
1991:
1992: CURSOR delivery_mode(p_event_id varchar2) IS
1993: Select OCU.synchronous_flag, OCU.online_flag
1994: From ota_events OEV,
1995: ota_offerings OFR,
1996: ota_category_usages OCU
1997: Where OFR.offering_id = OEV.parent_offering_id
1998: And OCU.category_usage_id = OFR.delivery_mode_id

Line 2027: SELECT title FROM ota_events_tl

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

Line 2041: p_eventid in ota_Events.event_id%type,

2037:
2038: end get_class_name;
2039:
2040: procedure RAISE_BUSINESS_EVENT(
2041: p_eventid in ota_Events.event_id%type,
2042: p_event_fired in varchar2
2043: )
2044: is
2045: l_proc varchar2(72) := g_package||'RAISE_BUSINESS_EVENT';

Line 2049: l_title ota_events_tl.title%type;

2045: l_proc varchar2(72) := g_package||'RAISE_BUSINESS_EVENT';
2046:
2047: l_item_key wf_items.item_key%type;
2048:
2049: l_title ota_events_tl.title%type;
2050: l_start_date varchar2(100);
2051: l_end_date varchar2(100);
2052: l_start_time ota_events.course_start_time%type;
2053: l_end_time ota_events.course_start_time%type;

Line 2052: l_start_time ota_events.course_start_time%type;

2048:
2049: l_title ota_events_tl.title%type;
2050: l_start_date varchar2(100);
2051: l_end_date varchar2(100);
2052: l_start_time ota_events.course_start_time%type;
2053: l_end_time ota_events.course_start_time%type;
2054: l_location_id ota_events.location_id %type;
2055: l_training_center_id ota_events.training_center_id %type;
2056: l_event_type ota_events.event_type%type;

Line 2053: l_end_time ota_events.course_start_time%type;

2049: l_title ota_events_tl.title%type;
2050: l_start_date varchar2(100);
2051: l_end_date varchar2(100);
2052: l_start_time ota_events.course_start_time%type;
2053: l_end_time ota_events.course_start_time%type;
2054: l_location_id ota_events.location_id %type;
2055: l_training_center_id ota_events.training_center_id %type;
2056: l_event_type ota_events.event_type%type;
2057:

Line 2054: l_location_id ota_events.location_id %type;

2050: l_start_date varchar2(100);
2051: l_end_date varchar2(100);
2052: l_start_time ota_events.course_start_time%type;
2053: l_end_time ota_events.course_start_time%type;
2054: l_location_id ota_events.location_id %type;
2055: l_training_center_id ota_events.training_center_id %type;
2056: l_event_type ota_events.event_type%type;
2057:
2058: l_location_name hr_locations_all_tl.location_code%type;

Line 2055: l_training_center_id ota_events.training_center_id %type;

2051: l_end_date varchar2(100);
2052: l_start_time ota_events.course_start_time%type;
2053: l_end_time ota_events.course_start_time%type;
2054: l_location_id ota_events.location_id %type;
2055: l_training_center_id ota_events.training_center_id %type;
2056: l_event_type ota_events.event_type%type;
2057:
2058: l_location_name hr_locations_all_tl.location_code%type;
2059: l_training_center hr_all_organization_units.name%TYPE;

Line 2056: l_event_type ota_events.event_type%type;

2052: l_start_time ota_events.course_start_time%type;
2053: l_end_time ota_events.course_start_time%type;
2054: l_location_id ota_events.location_id %type;
2055: l_training_center_id ota_events.training_center_id %type;
2056: l_event_type ota_events.event_type%type;
2057:
2058: l_location_name hr_locations_all_tl.location_code%type;
2059: l_training_center hr_all_organization_units.name%TYPE;
2060: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;

Line 2074: from ota_events_tl evt, ota_events oev

2070: is
2071: select evt.title,oev.course_start_date,oev.course_end_date,
2072: oev.course_start_time, oev.course_end_time,
2073: oev.location_id,oev.training_center_id
2074: from ota_events_tl evt, ota_events oev
2075: where evt.event_id =oev.event_id
2076: and oev.event_id = p_eventid
2077: and evt.language=USERENV('LANG');
2078: