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_LEARNER_ENROLL_REVIEW_SS dependencies on OTA_EVENTS

Line 484: l_eventid ota_events.event_id%TYPE;

480: ,p_add_enroll_detail_data out nocopy varchar2
481: )
482: is
483:
484: l_eventid ota_events.event_id%TYPE;
485: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
486: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
487: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
488: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;

Line 485: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;

481: )
482: is
483:
484: l_eventid ota_events.event_id%TYPE;
485: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
486: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
487: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
488: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
489: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;

Line 750: l_eventid ota_events.event_id%TYPE;

746: ,p_review_data out nocopy varchar2
747: )
748: is
749:
750: l_eventid ota_events.event_id%TYPE;
751: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
752: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
753: l_ccselectiontext varchar2(2000);
754: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;

Line 968: l_eventid ota_events.event_id%TYPE;

964:
965: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
966: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
967: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
968: l_eventid ota_events.event_id%TYPE;
969: l_object_version_number number;
970: l_person_details OTA_LEARNER_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;
971: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
972: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;

Line 981: l_price_basis OTA_EVENTS.price_basis%TYPE;

977: l_transaction_table hr_transaction_ss.transaction_table;
978: l_from varchar2(15);
979: l_cancel_boolean BOOLEAN;
980: l_auto_create_finance VARCHAR2(40);
981: l_price_basis OTA_EVENTS.price_basis%TYPE;
982: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
983: l_business_group_id_to hr_all_organization_units.organization_id%type;
984: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
985: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;

Line 993: l_event_currency_code ota_events.currency_code%type;

989: fapi_result VARCHAR2(40);
990: fapi_from VARCHAR2(5);
991: fapi_to VARCHAR2(5);
992: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
993: l_event_currency_code ota_events.currency_code%type;
994: l_event_status ota_events.event_status%type;
995: l_cost_allocation_keyflex_id VARCHAR2(1000);
996: l_maximum_internal_attendees NUMBER;
997: l_existing_internal NUMBER;

Line 994: l_event_status ota_events.event_status%type;

990: fapi_from VARCHAR2(5);
991: fapi_to VARCHAR2(5);
992: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
993: l_event_currency_code ota_events.currency_code%type;
994: l_event_status ota_events.event_status%type;
995: l_cost_allocation_keyflex_id VARCHAR2(1000);
996: l_maximum_internal_attendees NUMBER;
997: l_existing_internal NUMBER;
998: l_maximum_internal_allowed NUMBER;

Line 1003: l_offering_id ota_events.offering_id%type;

999: l_automatic_transfer_gl VARCHAR2(40);
1000: result_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
1001: result_create_finance_line VARCHAR2(5) := 'Y';
1002: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
1003: l_offering_id ota_events.offering_id%type;
1004: l_date_booking_placed date;
1005: l_current_date date;
1006: l_restricted_assignment_id PER_ASSIGNMENTS_F.assignment_id%type;
1007: l_version_name ota_activity_versions.version_name%type;

Line 1009: l_owner_id ota_events.owner_id%type;

1005: l_current_date date;
1006: l_restricted_assignment_id PER_ASSIGNMENTS_F.assignment_id%type;
1007: l_version_name ota_activity_versions.version_name%type;
1008: l_owner_username fnd_user.user_name%type;
1009: l_owner_id ota_events.owner_id%type;
1010: l_activity_version_id ota_activity_versions.activity_version_id%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;

Line 1011: l_event_title ota_events.title%type;

1007: l_version_name ota_activity_versions.version_name%type;
1008: l_owner_username fnd_user.user_name%type;
1009: l_owner_id ota_events.owner_id%type;
1010: l_activity_version_id ota_activity_versions.activity_version_id%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;

Line 1012: l_course_start_date ota_events.course_start_date%type;

1008: l_owner_username fnd_user.user_name%type;
1009: l_owner_id ota_events.owner_id%type;
1010: l_activity_version_id ota_activity_versions.activity_version_id%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;

Line 1013: l_course_start_time ota_events.course_start_time%type;

1009: l_owner_id ota_events.owner_id%type;
1010: l_activity_version_id ota_activity_versions.activity_version_id%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:

Line 1014: l_course_end_date ota_events.course_end_date%type;

1010: l_activity_version_id ota_activity_versions.activity_version_id%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);

Line 1021: l_business_group_id ota_events.business_group_id%type;

1017:
1018: l_notification_text VARCHAR2(1000);
1019: l_business_group_name PER_BUSINESS_GROUPS.name%TYPE := null;
1020:
1021: l_business_group_id ota_events.business_group_id%type;
1022: l_standard_price ota_events.standard_price%type;
1023:
1024: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1025: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

Line 1022: l_standard_price ota_events.standard_price%type;

1018: l_notification_text VARCHAR2(1000);
1019: l_business_group_name PER_BUSINESS_GROUPS.name%TYPE := null;
1020:
1021: l_business_group_id ota_events.business_group_id%type;
1022: l_standard_price ota_events.standard_price%type;
1023:
1024: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1025: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1026: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

Line 1050: l_course_end_time ota_events.course_start_time%type;

1046: l_booking_justification_id ota_bkng_justifications_b.booking_justification_id%TYPE;
1047: l_priority_level ota_delegate_bookings.booking_priority%TYPE;
1048:
1049: l_timezone fnd_timezones_tl.name%TYPE;
1050: l_course_end_time ota_events.course_start_time%type;
1051: status_not_seeded exception;
1052:
1053:
1054: CURSOR bg_to (l_event_id ota_events.event_id%TYPE) IS

Line 1054: CURSOR bg_to (l_event_id ota_events.event_id%TYPE) IS

1050: l_course_end_time ota_events.course_start_time%type;
1051: status_not_seeded exception;
1052:
1053:
1054: CURSOR bg_to (l_event_id ota_events.event_id%TYPE) IS
1055: SELECT hao.business_group_id,
1056: evt.organization_id,
1057: evt.currency_code,
1058: evt.offering_id,

Line 1073: FROM OTA_EVENTS_VL evt,

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
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

Line 1087: from OTA_EVENTS

1083:
1084: --Bug#2221320 hdshah standard price included.
1085: Cursor Get_Event_status is
1086: Select event_status, maximum_internal_attendees,nvl(price_basis,NULL),standard_price
1087: from OTA_EVENTS
1088: WHERE EVENT_ID = l_eventid;
1089:
1090: CURSOR get_existing_internal IS
1091: SELECT count(*)

Line 1919: l_eventid ota_events.event_id%TYPE;

1915: funmode in varchar2,
1916: result out nocopy varchar2 ) is
1917:
1918: l_transaction_step_id number;
1919: l_eventid ota_events.event_id%TYPE;
1920: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
1921: l_business_group_id OTA_DELEGATE_BOOKINGS.business_group_id%type;
1922: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1923: l_delegate_id PER_PEOPLE_F.person_id%TYPE;

Line 2092: CURSOR user_name(p_event_id OTA_EVENTS.event_id%TYPE) IS

2088: funcmode IN VARCHAR2,
2089: resultout OUT nocopy VARCHAR2 )
2090: IS
2091:
2092: CURSOR user_name(p_event_id OTA_EVENTS.event_id%TYPE) IS
2093: SELECT usr.user_name
2094: FROM OTA_EVENTS evt,
2095: FND_USER USR
2096: WHERE evt.event_id = p_event_id and

Line 2094: FROM OTA_EVENTS evt,

2090: IS
2091:
2092: CURSOR user_name(p_event_id OTA_EVENTS.event_id%TYPE) IS
2093: SELECT usr.user_name
2094: FROM OTA_EVENTS evt,
2095: FND_USER USR
2096: WHERE evt.event_id = p_event_id and
2097: usr.employee_id = evt.owner_id
2098: and trunc(sysdate) between usr.start_date and nvl(usr.end_date,to_date('4712/12/31', 'YYYY/MM/DD')) ; --Bug 5676892

Line 2159: p_eventid in ota_events.event_id %type

2155: END Cross_Charges_Notifications;
2156:
2157: Procedure set_addnl_attributes(p_item_type in wf_items.item_type%type,
2158: p_item_key in wf_items.item_key%type,
2159: p_eventid in ota_events.event_id %type
2160: )
2161:
2162: is
2163:

Line 2166: l_actual_cost ota_events.actual_cost%type;

2162: is
2163:
2164: l_proc varchar2(72) := g_package||'set_addnl_attributes';
2165:
2166: l_actual_cost ota_events.actual_cost%type;
2167: l_budget_currency_code ota_events.budget_currency_code%type;
2168: l_act_ver_id ota_events.activity_version_id%type;
2169: l_off_id ota_events.parent_offering_id%type;
2170: l_event_id ota_events.event_id%type;

Line 2167: l_budget_currency_code ota_events.budget_currency_code%type;

2163:
2164: l_proc varchar2(72) := g_package||'set_addnl_attributes';
2165:
2166: l_actual_cost ota_events.actual_cost%type;
2167: l_budget_currency_code ota_events.budget_currency_code%type;
2168: l_act_ver_id ota_events.activity_version_id%type;
2169: l_off_id ota_events.parent_offering_id%type;
2170: l_event_id ota_events.event_id%type;
2171: l_event_type ota_events.event_type%type;

Line 2168: l_act_ver_id ota_events.activity_version_id%type;

2164: l_proc varchar2(72) := g_package||'set_addnl_attributes';
2165:
2166: l_actual_cost ota_events.actual_cost%type;
2167: l_budget_currency_code ota_events.budget_currency_code%type;
2168: l_act_ver_id ota_events.activity_version_id%type;
2169: l_off_id ota_events.parent_offering_id%type;
2170: l_event_id ota_events.event_id%type;
2171: l_event_type ota_events.event_type%type;
2172: l_object_type varchar2(240);

Line 2169: l_off_id ota_events.parent_offering_id%type;

2165:
2166: l_actual_cost ota_events.actual_cost%type;
2167: l_budget_currency_code ota_events.budget_currency_code%type;
2168: l_act_ver_id ota_events.activity_version_id%type;
2169: l_off_id ota_events.parent_offering_id%type;
2170: l_event_id ota_events.event_id%type;
2171: l_event_type ota_events.event_type%type;
2172: l_object_type varchar2(240);
2173: l_timezone ota_events.timezone%type;

Line 2170: l_event_id ota_events.event_id%type;

2166: l_actual_cost ota_events.actual_cost%type;
2167: l_budget_currency_code ota_events.budget_currency_code%type;
2168: l_act_ver_id ota_events.activity_version_id%type;
2169: l_off_id ota_events.parent_offering_id%type;
2170: l_event_id ota_events.event_id%type;
2171: l_event_type ota_events.event_type%type;
2172: l_object_type varchar2(240);
2173: l_timezone ota_events.timezone%type;
2174:

Line 2171: l_event_type ota_events.event_type%type;

2167: l_budget_currency_code ota_events.budget_currency_code%type;
2168: l_act_ver_id ota_events.activity_version_id%type;
2169: l_off_id ota_events.parent_offering_id%type;
2170: l_event_id ota_events.event_id%type;
2171: l_event_type ota_events.event_type%type;
2172: l_object_type varchar2(240);
2173: l_timezone ota_events.timezone%type;
2174:
2175:

Line 2173: l_timezone ota_events.timezone%type;

2169: l_off_id ota_events.parent_offering_id%type;
2170: l_event_id ota_events.event_id%type;
2171: l_event_type ota_events.event_type%type;
2172: l_object_type varchar2(240);
2173: l_timezone ota_events.timezone%type;
2174:
2175:
2176:
2177: cursor get_addnl_event_info

Line 2183: from ota_events oev

2179: select
2180: --added after show n tell
2181: oev.actual_cost, oev.budget_currency_code,
2182: oev.parent_offering_id,oev.timezone
2183: from ota_events oev
2184: where
2185: oev.event_id = l_event_id;
2186:
2187:

Line 2238: CURSOR user_name(p_event_id OTA_EVENTS.event_id%TYPE) IS

2234: funcmode IN VARCHAR2,
2235: resultout OUT nocopy VARCHAR2 )
2236: IS
2237:
2238: CURSOR user_name(p_event_id OTA_EVENTS.event_id%TYPE) IS
2239: SELECT usr.user_name
2240: FROM OTA_EVENTS evt,
2241: FND_USER USR
2242: WHERE evt.event_id = p_event_id and

Line 2240: FROM OTA_EVENTS evt,

2236: IS
2237:
2238: CURSOR user_name(p_event_id OTA_EVENTS.event_id%TYPE) IS
2239: SELECT usr.user_name
2240: FROM OTA_EVENTS evt,
2241: FND_USER USR
2242: WHERE evt.event_id = p_event_id and
2243: usr.employee_id = evt.owner_id
2244: and trunc(sysdate) between usr.start_date and nvl(usr.end_date,to_date('4712/12/31', 'YYYY/MM/DD')); --Bug 5676892

Line 2254: CURSOR delivery_mode(p_event_id OTA_EVENTS.event_id%TYPE) IS

2250: OTA_BOOKING_STATUS_TYPES bst
2251: WHERE tdb.booking_id = p_booking_id
2252: AND bst.booking_status_type_id = tdb.booking_status_type_id;
2253:
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

Line 2256: From ota_events OEV,

2252: AND bst.booking_status_type_id = tdb.booking_status_type_id;
2253:
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