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_CANCEL_TRAINING_SS dependencies on OTA_DELEGATE_BOOKINGS

Line 336: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;

332: -- ------------------------
333: -- booking_csr variables
334: -- ------------------------
335: --
336: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
337: l_content_player_status ota_delegate_bookings.content_player_status%TYPE;
338: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;
339: --
340: -- ------------------------

Line 337: l_content_player_status ota_delegate_bookings.content_player_status%TYPE;

333: -- booking_csr variables
334: -- ------------------------
335: --
336: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
337: l_content_player_status ota_delegate_bookings.content_player_status%TYPE;
338: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;
339: --
340: -- ------------------------
341: -- Finance_csr Variables

Line 338: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;

334: -- ------------------------
335: --
336: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
337: l_content_player_status ota_delegate_bookings.content_player_status%TYPE;
338: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;
339: --
340: -- ------------------------
341: -- Finance_csr Variables
342: -- ------------------------

Line 373: l_daemon_flag ota_delegate_bookings.daemon_flag%TYPE;

369: l_auto_waitlist_days NUMBER;
370: l_sysdate DATE := SYSDATE;
371: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
372: l_msg_data VARCHAR2(1000);
373: l_daemon_flag ota_delegate_bookings.daemon_flag%TYPE;
374: l_daemon_type ota_delegate_bookings.daemon_type%TYPE;
375: lb_object_version_number ota_delegate_bookings.object_version_number%TYPE;
376: l_wf_exception EXCEPTION;
377: ltt_item_attribute hr_workflow_service.g_varchar2_tab_type;

Line 374: l_daemon_type ota_delegate_bookings.daemon_type%TYPE;

370: l_sysdate DATE := SYSDATE;
371: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
372: l_msg_data VARCHAR2(1000);
373: l_daemon_flag ota_delegate_bookings.daemon_flag%TYPE;
374: l_daemon_type ota_delegate_bookings.daemon_type%TYPE;
375: lb_object_version_number ota_delegate_bookings.object_version_number%TYPE;
376: l_wf_exception EXCEPTION;
377: ltt_item_attribute hr_workflow_service.g_varchar2_tab_type;
378: ltt_item_attribute_value hr_workflow_service.g_varchar2_tab_type;

Line 375: lb_object_version_number ota_delegate_bookings.object_version_number%TYPE;

371: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
372: l_msg_data VARCHAR2(1000);
373: l_daemon_flag ota_delegate_bookings.daemon_flag%TYPE;
374: l_daemon_type ota_delegate_bookings.daemon_type%TYPE;
375: lb_object_version_number ota_delegate_bookings.object_version_number%TYPE;
376: l_wf_exception EXCEPTION;
377: ltt_item_attribute hr_workflow_service.g_varchar2_tab_type;
378: ltt_item_attribute_value hr_workflow_service.g_varchar2_tab_type;
379: l_proc VARCHAR2(72) := 'ota_cancel_enrollment_ss.cancel_enrollment';

Line 398: CURSOR booking_csr (p_booking_id ota_delegate_bookings.booking_id%TYPE)

394: AND e.event_id = p_event_id
395: AND language=userenv('LANG');
396: --
397:
398: CURSOR booking_csr (p_booking_id ota_delegate_bookings.booking_id%TYPE)
399: IS
400: SELECT b.date_booking_placed, b.content_player_status, b.object_version_number
401: FROM ota_delegate_bookings b
402: WHERE b.booking_id = p_booking_id;

Line 401: FROM ota_delegate_bookings b

397:
398: CURSOR booking_csr (p_booking_id ota_delegate_bookings.booking_id%TYPE)
399: IS
400: SELECT b.date_booking_placed, b.content_player_status, b.object_version_number
401: FROM ota_delegate_bookings b
402: WHERE b.booking_id = p_booking_id;
403: --
404: CURSOR finance_csr (p_booking_id ota_finance_lines.booking_id%TYPE)
405: IS