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

Line 880: l_eventid ota_events.event_id%TYPE;

876: ,p_add_enroll_detail_data out nocopy varchar2
877: )
878: is
879:
880: l_eventid ota_events.event_id%TYPE;
881: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
882: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
883: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
884: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;

Line 881: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;

877: )
878: is
879:
880: l_eventid ota_events.event_id%TYPE;
881: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
882: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
883: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
884: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
885: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;

Line 1144: l_eventid ota_events.event_id%TYPE;

1140: ,p_review_data out nocopy varchar2
1141: )
1142: is
1143:
1144: l_eventid ota_events.event_id%TYPE;
1145: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
1146: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
1147: l_ccselectiontext varchar2(200);
1148: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;

Line 1340: l_eventid ota_events.event_id%TYPE;

1336:
1337: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
1338: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1339: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
1340: l_eventid ota_events.event_id%TYPE;
1341: l_object_version_number number;
1342: l_person_details OTA_ENROLL_IN_TRAINING_SS.csr_person_to_enroll_details%ROWTYPE;
1343: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
1344: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;

Line 1353: l_price_basis OTA_EVENTS.price_basis%TYPE;

1349: l_transaction_table hr_transaction_ss.transaction_table;
1350: l_from varchar2(15);
1351: l_cancel_boolean BOOLEAN;
1352: l_auto_create_finance VARCHAR2(40);
1353: l_price_basis OTA_EVENTS.price_basis%TYPE;
1354: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
1355: l_business_group_id_to hr_all_organization_units.organization_id%type;
1356: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
1357: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;

Line 1365: l_event_currency_code ota_events.currency_code%type;

1361: fapi_result VARCHAR2(40);
1362: fapi_from VARCHAR2(5);
1363: fapi_to VARCHAR2(5);
1364: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
1365: l_event_currency_code ota_events.currency_code%type;
1366: l_event_status ota_events.event_status%type;
1367: l_cost_allocation_keyflex_id VARCHAR2(1000);
1368: l_maximum_internal_attendees NUMBER;
1369: l_existing_internal NUMBER;

Line 1366: l_event_status ota_events.event_status%type;

1362: fapi_from VARCHAR2(5);
1363: fapi_to VARCHAR2(5);
1364: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
1365: l_event_currency_code ota_events.currency_code%type;
1366: l_event_status ota_events.event_status%type;
1367: l_cost_allocation_keyflex_id VARCHAR2(1000);
1368: l_maximum_internal_attendees NUMBER;
1369: l_existing_internal NUMBER;
1370: l_maximum_internal_allowed NUMBER;

Line 1375: l_offering_id ota_events.offering_id%type;

1371: l_automatic_transfer_gl VARCHAR2(40);
1372: result_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
1373: result_create_finance_line VARCHAR2(5) := 'Y';
1374: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
1375: l_offering_id ota_events.offering_id%type;
1376: l_date_booking_placed date;
1377: l_current_date date;
1378: l_restricted_assignment_id PER_ASSIGNMENTS_F.assignment_id%type;
1379: l_version_name ota_activity_versions.version_name%type;

Line 1381: l_owner_id ota_events.owner_id%type;

1377: l_current_date date;
1378: l_restricted_assignment_id PER_ASSIGNMENTS_F.assignment_id%type;
1379: l_version_name ota_activity_versions.version_name%type;
1380: l_owner_username fnd_user.user_name%type;
1381: l_owner_id ota_events.owner_id%type;
1382: l_activity_version_id ota_activity_versions.activity_version_id%type;
1383: l_event_title ota_events.title%type;
1384: l_course_start_date ota_events.course_start_date%type;
1385: l_course_end_date ota_events.course_end_date%type;

Line 1383: l_event_title ota_events.title%type;

1379: l_version_name ota_activity_versions.version_name%type;
1380: l_owner_username fnd_user.user_name%type;
1381: l_owner_id ota_events.owner_id%type;
1382: l_activity_version_id ota_activity_versions.activity_version_id%type;
1383: l_event_title ota_events.title%type;
1384: l_course_start_date ota_events.course_start_date%type;
1385: l_course_end_date ota_events.course_end_date%type;
1386: l_notification_text VARCHAR2(1000);
1387: l_business_group_name PER_BUSINESS_GROUPS.name%TYPE := null;

Line 1384: l_course_start_date ota_events.course_start_date%type;

1380: l_owner_username fnd_user.user_name%type;
1381: l_owner_id ota_events.owner_id%type;
1382: l_activity_version_id ota_activity_versions.activity_version_id%type;
1383: l_event_title ota_events.title%type;
1384: l_course_start_date ota_events.course_start_date%type;
1385: l_course_end_date ota_events.course_end_date%type;
1386: l_notification_text VARCHAR2(1000);
1387: l_business_group_name PER_BUSINESS_GROUPS.name%TYPE := null;
1388:

Line 1385: l_course_end_date ota_events.course_end_date%type;

1381: l_owner_id ota_events.owner_id%type;
1382: l_activity_version_id ota_activity_versions.activity_version_id%type;
1383: l_event_title ota_events.title%type;
1384: l_course_start_date ota_events.course_start_date%type;
1385: l_course_end_date ota_events.course_end_date%type;
1386: l_notification_text VARCHAR2(1000);
1387: l_business_group_name PER_BUSINESS_GROUPS.name%TYPE := null;
1388:
1389: l_business_group_id ota_events.business_group_id%type;

Line 1389: l_business_group_id ota_events.business_group_id%type;

1385: l_course_end_date ota_events.course_end_date%type;
1386: l_notification_text VARCHAR2(1000);
1387: l_business_group_name PER_BUSINESS_GROUPS.name%TYPE := null;
1388:
1389: l_business_group_id ota_events.business_group_id%type;
1390: l_standard_price ota_events.standard_price%type;
1391:
1392: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1393: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;

Line 1390: l_standard_price ota_events.standard_price%type;

1386: l_notification_text VARCHAR2(1000);
1387: l_business_group_name PER_BUSINESS_GROUPS.name%TYPE := null;
1388:
1389: l_business_group_id ota_events.business_group_id%type;
1390: l_standard_price ota_events.standard_price%type;
1391:
1392: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1393: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1394: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

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

1413:
1414: status_not_seeded exception;
1415:
1416:
1417: CURSOR bg_to (l_event_id ota_events.event_id%TYPE) IS
1418: SELECT hao.business_group_id,
1419: evt.organization_id,
1420: evt.currency_code,
1421: evt.offering_id,

Line 1428: FROM OTA_EVENTS_VL evt,

1424: evt.Title,
1425: evt.course_start_date,
1426: evt.course_end_date,
1427: evt.business_group_id bg_id -- Bug#2215026 evt.business_group_id included.
1428: FROM OTA_EVENTS_VL evt,
1429: HR_ALL_ORGANIZATION_UNITS hao
1430: WHERE evt.event_id = l_eventid
1431: AND evt.organization_id = hao.organization_id (+); --Bug#2215026 (+) included.
1432:

Line 1438: from OTA_EVENTS

1434:
1435: --Bug#2221320 hdshah standard price included.
1436: Cursor Get_Event_status is
1437: Select event_status, maximum_internal_attendees,nvl(price_basis,NULL),standard_price
1438: from OTA_EVENTS
1439: WHERE EVENT_ID = l_eventid;
1440:
1441: CURSOR get_existing_internal IS
1442: SELECT count(*)

Line 2255: l_eventid ota_events.event_id%TYPE;

2251: funmode in varchar2,
2252: result out nocopy varchar2 ) is
2253:
2254: l_transaction_step_id number;
2255: l_eventid ota_events.event_id%TYPE;
2256: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
2257: l_business_group_id OTA_DELEGATE_BOOKINGS.business_group_id%type;
2258: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
2259: l_delegate_id PER_PEOPLE_F.person_id%TYPE;

Line 2361: l_eventid ota_events.event_id%type;

2357: p_item_key in varchar2,
2358: p_message out nocopy varchar2) is
2359:
2360: l_transaction_step_id number;
2361: l_eventid ota_events.event_id%type;
2362:
2363: l_approval_mode wf_activity_attr_values.text_value%type;
2364: l_dummy_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
2365: l_dummy_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;

Line 2492: l_offering_id ota_events.offering_id%type;

2488: l_transfer_status ota_finance_headers.transfer_status%type;
2489: l_administrator ota_finance_headers.administrator%type;
2490: l_date_format varchar2(200);
2491:
2492: l_offering_id ota_events.offering_id%type;
2493:
2494: CURSOR THG_FROM(p_business_group_id in number)
2495: IS
2496: Select

Line 2559: OTA_EVENTS EVT

2555:
2556: CURSOR SPO IS
2557: SELECT hr.COST_ALLOCATION_KEYFLEX_ID
2558: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2559: OTA_EVENTS EVT
2560: WHERE hr.organization_id = evt.organization_id and
2561: evt.event_id = p_event_id;
2562:
2563: /* For Ilearning */

Line 2567: FROM ota_events

2563: /* For Ilearning */
2564: CURSOR csr_event
2565: IS
2566: SELECT offering_id
2567: FROM ota_events
2568: where event_id= p_event_id;
2569:
2570: Begin
2571: p_result := 'S';

Line 2726: OTA_EVENTS EVT

2722: CLOSE SPO;
2723:
2724: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2725: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2726: OTA_EVENTS EVT
2727: WHERE hr.organization_id = evt.organization_id and
2728: evt.event_id = p_event_id; */
2729: l_dynamicSqlString := 'SELECT ' ||from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2730: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;

Line 2963: OTA_EVENTS EVT

2959: CLOSE SPO;
2960:
2961: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2962: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2963: OTA_EVENTS EVT
2964: WHERE hr.organization_id = evt.organization_id and
2965: evt.event_id = p_event_id; */
2966: l_dynamicSqlString := 'SELECT ' ||to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2967: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;