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

Line 442: l_eventid ota_events.event_id%TYPE;

438: ,p_add_enroll_detail_data out nocopy varchar2
439: )
440: is
441:
442: l_eventid ota_events.event_id%TYPE;
443: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
444: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
445: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
446: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;

Line 443: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;

439: )
440: is
441:
442: l_eventid ota_events.event_id%TYPE;
443: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
444: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
445: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
446: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
447: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;

Line 694: l_eventid ota_events.event_id%TYPE;

690: ,p_review_data out nocopy varchar2
691: )
692: is
693:
694: l_eventid ota_events.event_id%TYPE;
695: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
696: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
697: l_ccselectiontext varchar2(200);
698: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;

Line 890: l_eventid ota_events.event_id%TYPE;

886:
887: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
888: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
889: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
890: l_eventid ota_events.event_id%TYPE;
891: l_object_version_number number;
892: l_person_details OTA_trng_enroll_SS.csr_person_to_enroll_details%ROWTYPE;
893: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
894: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;

Line 903: l_price_basis OTA_EVENTS.price_basis%TYPE;

899: l_transaction_table hr_transaction_ss.transaction_table;
900: l_from varchar2(15);
901: l_cancel_boolean BOOLEAN;
902: l_auto_create_finance VARCHAR2(40);
903: l_price_basis OTA_EVENTS.price_basis%TYPE;
904: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
905: l_business_group_id_to hr_all_organization_units.organization_id%type;
906: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
907: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;

Line 915: l_event_currency_code ota_events.currency_code%type;

911: fapi_result VARCHAR2(40);
912: fapi_from VARCHAR2(5);
913: fapi_to VARCHAR2(5);
914: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
915: l_event_currency_code ota_events.currency_code%type;
916: l_event_status ota_events.event_status%type;
917: l_cost_allocation_keyflex_id VARCHAR2(1000);
918: l_maximum_internal_attendees NUMBER;
919: l_existing_internal NUMBER;

Line 916: l_event_status ota_events.event_status%type;

912: fapi_from VARCHAR2(5);
913: fapi_to VARCHAR2(5);
914: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
915: l_event_currency_code ota_events.currency_code%type;
916: l_event_status ota_events.event_status%type;
917: l_cost_allocation_keyflex_id VARCHAR2(1000);
918: l_maximum_internal_attendees NUMBER;
919: l_existing_internal NUMBER;
920: l_maximum_internal_allowed NUMBER;

Line 925: l_offering_id ota_events.offering_id%type;

921: l_automatic_transfer_gl VARCHAR2(40);
922: result_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
923: result_create_finance_line VARCHAR2(5) := 'Y';
924: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
925: l_offering_id ota_events.offering_id%type;
926: l_date_booking_placed date;
927: l_current_date date;
928: l_restricted_assignment_id PER_ASSIGNMENTS_F.assignment_id%type;
929: l_version_name ota_activity_versions.version_name%type;

Line 931: l_owner_id ota_events.owner_id%type;

927: l_current_date date;
928: l_restricted_assignment_id PER_ASSIGNMENTS_F.assignment_id%type;
929: l_version_name ota_activity_versions.version_name%type;
930: l_owner_username fnd_user.user_name%type;
931: l_owner_id ota_events.owner_id%type;
932: l_activity_version_id ota_activity_versions.activity_version_id%type;
933: l_event_title ota_events.title%type;
934: l_course_start_date ota_events.course_start_date%type;
935: l_course_end_date ota_events.course_end_date%type;

Line 933: l_event_title ota_events.title%type;

929: l_version_name ota_activity_versions.version_name%type;
930: l_owner_username fnd_user.user_name%type;
931: l_owner_id ota_events.owner_id%type;
932: l_activity_version_id ota_activity_versions.activity_version_id%type;
933: l_event_title ota_events.title%type;
934: l_course_start_date ota_events.course_start_date%type;
935: l_course_end_date ota_events.course_end_date%type;
936: l_notification_text VARCHAR2(1000);
937: l_business_group_name PER_BUSINESS_GROUPS.name%TYPE := null;

Line 934: l_course_start_date ota_events.course_start_date%type;

930: l_owner_username fnd_user.user_name%type;
931: l_owner_id ota_events.owner_id%type;
932: l_activity_version_id ota_activity_versions.activity_version_id%type;
933: l_event_title ota_events.title%type;
934: l_course_start_date ota_events.course_start_date%type;
935: l_course_end_date ota_events.course_end_date%type;
936: l_notification_text VARCHAR2(1000);
937: l_business_group_name PER_BUSINESS_GROUPS.name%TYPE := null;
938:

Line 935: l_course_end_date ota_events.course_end_date%type;

931: l_owner_id ota_events.owner_id%type;
932: l_activity_version_id ota_activity_versions.activity_version_id%type;
933: l_event_title ota_events.title%type;
934: l_course_start_date ota_events.course_start_date%type;
935: l_course_end_date ota_events.course_end_date%type;
936: l_notification_text VARCHAR2(1000);
937: l_business_group_name PER_BUSINESS_GROUPS.name%TYPE := null;
938:
939: l_business_group_id ota_events.business_group_id%type;

Line 939: l_business_group_id ota_events.business_group_id%type;

935: l_course_end_date ota_events.course_end_date%type;
936: l_notification_text VARCHAR2(1000);
937: l_business_group_name PER_BUSINESS_GROUPS.name%TYPE := null;
938:
939: l_business_group_id ota_events.business_group_id%type;
940: l_standard_price ota_events.standard_price%type;
941:
942: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
943: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

Line 940: l_standard_price ota_events.standard_price%type;

936: l_notification_text VARCHAR2(1000);
937: l_business_group_name PER_BUSINESS_GROUPS.name%TYPE := null;
938:
939: l_business_group_id ota_events.business_group_id%type;
940: l_standard_price ota_events.standard_price%type;
941:
942: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
943: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
944: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

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

963:
964: status_not_seeded exception;
965:
966:
967: CURSOR bg_to (l_event_id ota_events.event_id%TYPE) IS
968: SELECT hao.business_group_id,
969: evt.organization_id,
970: evt.currency_code,
971: evt.offering_id,

Line 978: FROM OTA_EVENTS_VL evt,

974: evt.Title,
975: evt.course_start_date,
976: evt.course_end_date,
977: evt.business_group_id bg_id -- Bug#2215026 evt.business_group_id included.
978: FROM OTA_EVENTS_VL evt,
979: HR_ALL_ORGANIZATION_UNITS hao
980: WHERE evt.event_id = l_eventid
981: AND evt.organization_id = hao.organization_id (+); --Bug#2215026 (+) included.
982:

Line 988: from OTA_EVENTS

984:
985: --Bug#2221320 hdshah standard price included.
986: Cursor Get_Event_status is
987: Select event_status, maximum_internal_attendees,nvl(price_basis,NULL),standard_price
988: from OTA_EVENTS
989: WHERE EVENT_ID = l_eventid;
990:
991: CURSOR get_existing_internal IS
992: SELECT count(*)

Line 1781: l_eventid ota_events.event_id%TYPE;

1777: funmode in varchar2,
1778: result out nocopy varchar2 ) is
1779:
1780: l_transaction_step_id number;
1781: l_eventid ota_events.event_id%TYPE;
1782: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
1783: l_business_group_id OTA_DELEGATE_BOOKINGS.business_group_id%type;
1784: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1785: l_delegate_id PER_PEOPLE_F.person_id%TYPE;

Line 1882: l_eventid ota_events.event_id%type;

1878: p_item_key in varchar2,
1879: p_message out nocopy varchar2) is
1880:
1881: l_transaction_step_id number;
1882: l_eventid ota_events.event_id%type;
1883:
1884: l_approval_mode wf_activity_attr_values.text_value%type;
1885: l_dummy_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1886: l_dummy_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;

Line 2013: l_offering_id ota_events.offering_id%type;

2009: l_transfer_status ota_finance_headers.transfer_status%type;
2010: l_administrator ota_finance_headers.administrator%type;
2011: l_date_format varchar2(200);
2012:
2013: l_offering_id ota_events.offering_id%type;
2014:
2015: CURSOR THG_FROM(p_business_group_id in number)
2016: IS
2017: Select

Line 2080: OTA_EVENTS EVT

2076:
2077: CURSOR SPO IS
2078: SELECT hr.COST_ALLOCATION_KEYFLEX_ID
2079: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2080: OTA_EVENTS EVT
2081: WHERE hr.organization_id = evt.organization_id and
2082: evt.event_id = p_event_id;
2083:
2084: /* For Ilearning */

Line 2088: FROM ota_events

2084: /* For Ilearning */
2085: CURSOR csr_event
2086: IS
2087: SELECT offering_id
2088: FROM ota_events
2089: where event_id= p_event_id;
2090:
2091: Begin
2092: p_result := 'S';

Line 2247: OTA_EVENTS EVT

2243: CLOSE SPO;
2244:
2245: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2246: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2247: OTA_EVENTS EVT
2248: WHERE hr.organization_id = evt.organization_id and
2249: evt.event_id = p_event_id; */
2250: l_dynamicSqlString := 'SELECT ' ||from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2251: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;