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 1910: l_eventid ota_events.event_id%TYPE;

1906: funmode in varchar2,
1907: result out nocopy varchar2 ) is
1908:
1909: l_transaction_step_id number;
1910: l_eventid ota_events.event_id%TYPE;
1911: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
1912: l_business_group_id OTA_DELEGATE_BOOKINGS.business_group_id%type;
1913: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1914: l_delegate_id PER_PEOPLE_F.person_id%TYPE;

Line 2103: l_offering_id ota_events.offering_id%type;

2099: l_transfer_status ota_finance_headers.transfer_status%type;
2100: l_administrator ota_finance_headers.administrator%type;
2101: l_date_format varchar2(200);
2102:
2103: l_offering_id ota_events.offering_id%type;
2104:
2105: CURSOR THG_FROM(p_business_group_id in number)
2106: IS
2107: Select

Line 2170: OTA_EVENTS EVT

2166:
2167: CURSOR SPO IS
2168: SELECT hr.COST_ALLOCATION_KEYFLEX_ID
2169: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2170: OTA_EVENTS EVT
2171: WHERE hr.organization_id = evt.organization_id and
2172: evt.event_id = p_event_id;
2173:
2174: /* For Ilearning */

Line 2178: FROM ota_events

2174: /* For Ilearning */
2175: CURSOR csr_event
2176: IS
2177: SELECT offering_id
2178: FROM ota_events
2179: where event_id= p_event_id;
2180:
2181: Begin
2182: p_result := 'S';

Line 2337: OTA_EVENTS EVT

2333: CLOSE SPO;
2334:
2335: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2336: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2337: OTA_EVENTS EVT
2338: WHERE hr.organization_id = evt.organization_id and
2339: evt.event_id = p_event_id; */
2340: l_dynamicSqlString := 'SELECT ' ||from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2341: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;

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

2764: funcmode IN VARCHAR2,
2765: resultout OUT nocopy VARCHAR2 )
2766: IS
2767:
2768: CURSOR user_name(p_event_id OTA_EVENTS.event_id%TYPE) IS
2769: SELECT usr.user_name
2770: FROM OTA_EVENTS evt,
2771: FND_USER USR
2772: WHERE evt.event_id = p_event_id and

Line 2770: FROM OTA_EVENTS evt,

2766: IS
2767:
2768: CURSOR user_name(p_event_id OTA_EVENTS.event_id%TYPE) IS
2769: SELECT usr.user_name
2770: FROM OTA_EVENTS evt,
2771: FND_USER USR
2772: WHERE evt.event_id = p_event_id and
2773: usr.employee_id = evt.owner_id
2774: and trunc(sysdate) between usr.start_date and nvl(usr.end_date,to_date('4712/12/31', 'YYYY/MM/DD')) ; --Bug 5676892

Line 2835: p_eventid in ota_events.event_id %type

2831: END Cross_Charges_Notifications;
2832:
2833: Procedure set_addnl_attributes(p_item_type in wf_items.item_type%type,
2834: p_item_key in wf_items.item_key%type,
2835: p_eventid in ota_events.event_id %type
2836: )
2837:
2838: is
2839:

Line 2842: l_actual_cost ota_events.actual_cost%type;

2838: is
2839:
2840: l_proc varchar2(72) := g_package||'set_addnl_attributes';
2841:
2842: l_actual_cost ota_events.actual_cost%type;
2843: l_budget_currency_code ota_events.budget_currency_code%type;
2844: l_act_ver_id ota_events.activity_version_id%type;
2845: l_off_id ota_events.parent_offering_id%type;
2846: l_event_id ota_events.event_id%type;

Line 2843: l_budget_currency_code ota_events.budget_currency_code%type;

2839:
2840: l_proc varchar2(72) := g_package||'set_addnl_attributes';
2841:
2842: l_actual_cost ota_events.actual_cost%type;
2843: l_budget_currency_code ota_events.budget_currency_code%type;
2844: l_act_ver_id ota_events.activity_version_id%type;
2845: l_off_id ota_events.parent_offering_id%type;
2846: l_event_id ota_events.event_id%type;
2847: l_event_type ota_events.event_type%type;

Line 2844: l_act_ver_id ota_events.activity_version_id%type;

2840: l_proc varchar2(72) := g_package||'set_addnl_attributes';
2841:
2842: l_actual_cost ota_events.actual_cost%type;
2843: l_budget_currency_code ota_events.budget_currency_code%type;
2844: l_act_ver_id ota_events.activity_version_id%type;
2845: l_off_id ota_events.parent_offering_id%type;
2846: l_event_id ota_events.event_id%type;
2847: l_event_type ota_events.event_type%type;
2848: l_object_type varchar2(240);

Line 2845: l_off_id ota_events.parent_offering_id%type;

2841:
2842: l_actual_cost ota_events.actual_cost%type;
2843: l_budget_currency_code ota_events.budget_currency_code%type;
2844: l_act_ver_id ota_events.activity_version_id%type;
2845: l_off_id ota_events.parent_offering_id%type;
2846: l_event_id ota_events.event_id%type;
2847: l_event_type ota_events.event_type%type;
2848: l_object_type varchar2(240);
2849: l_timezone ota_events.timezone%type;

Line 2846: l_event_id ota_events.event_id%type;

2842: l_actual_cost ota_events.actual_cost%type;
2843: l_budget_currency_code ota_events.budget_currency_code%type;
2844: l_act_ver_id ota_events.activity_version_id%type;
2845: l_off_id ota_events.parent_offering_id%type;
2846: l_event_id ota_events.event_id%type;
2847: l_event_type ota_events.event_type%type;
2848: l_object_type varchar2(240);
2849: l_timezone ota_events.timezone%type;
2850:

Line 2847: l_event_type ota_events.event_type%type;

2843: l_budget_currency_code ota_events.budget_currency_code%type;
2844: l_act_ver_id ota_events.activity_version_id%type;
2845: l_off_id ota_events.parent_offering_id%type;
2846: l_event_id ota_events.event_id%type;
2847: l_event_type ota_events.event_type%type;
2848: l_object_type varchar2(240);
2849: l_timezone ota_events.timezone%type;
2850:
2851:

Line 2849: l_timezone ota_events.timezone%type;

2845: l_off_id ota_events.parent_offering_id%type;
2846: l_event_id ota_events.event_id%type;
2847: l_event_type ota_events.event_type%type;
2848: l_object_type varchar2(240);
2849: l_timezone ota_events.timezone%type;
2850:
2851:
2852:
2853: cursor get_addnl_event_info

Line 2859: from ota_events oev

2855: select
2856: --added after show n tell
2857: oev.actual_cost, oev.budget_currency_code,
2858: oev.parent_offering_id,oev.timezone
2859: from ota_events oev
2860: where
2861: oev.event_id = l_event_id;
2862:
2863:

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

2910: funcmode IN VARCHAR2,
2911: resultout OUT nocopy VARCHAR2 )
2912: IS
2913:
2914: CURSOR user_name(p_event_id OTA_EVENTS.event_id%TYPE) IS
2915: SELECT usr.user_name
2916: FROM OTA_EVENTS evt,
2917: FND_USER USR
2918: WHERE evt.event_id = p_event_id and

Line 2916: FROM OTA_EVENTS evt,

2912: IS
2913:
2914: CURSOR user_name(p_event_id OTA_EVENTS.event_id%TYPE) IS
2915: SELECT usr.user_name
2916: FROM OTA_EVENTS evt,
2917: FND_USER USR
2918: WHERE evt.event_id = p_event_id and
2919: usr.employee_id = evt.owner_id
2920: and trunc(sysdate) between usr.start_date and nvl(usr.end_date,to_date('4712/12/31', 'YYYY/MM/DD')); --Bug 5676892

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

2926: OTA_BOOKING_STATUS_TYPES bst
2927: WHERE tdb.booking_id = p_booking_id
2928: AND bst.booking_status_type_id = tdb.booking_status_type_id;
2929:
2930: CURSOR delivery_mode(p_event_id OTA_EVENTS.event_id%TYPE) IS
2931: Select OCU.synchronous_flag, OCU.online_flag
2932: From ota_events OEV,
2933: ota_offerings OFR,
2934: ota_category_usages OCU

Line 2932: From ota_events OEV,

2928: AND bst.booking_status_type_id = tdb.booking_status_type_id;
2929:
2930: CURSOR delivery_mode(p_event_id OTA_EVENTS.event_id%TYPE) IS
2931: Select OCU.synchronous_flag, OCU.online_flag
2932: From ota_events OEV,
2933: ota_offerings OFR,
2934: ota_category_usages OCU
2935: Where OFR.offering_id = OEV.parent_offering_id
2936: And OCU.category_usage_id = OFR.delivery_mode_id