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_EVT_BUS dependencies on OTA_TIMEZONE_UTIL

Line 1312: and ota_timezone_util.convert_date(trunc(date_booking_placed)

1308: select 'X'
1309: from ota_delegate_bookings
1310: where event_id = p_event_id
1311: -- Modified for bug#5107347
1312: and ota_timezone_util.convert_date(trunc(date_booking_placed)
1313: , to_char(date_booking_placed, 'HH24:MI')
1314: , ota_timezone_util.get_server_timezone_code
1315: , p_timezone)
1316: not between nvl(p_enrolment_start_date,hr_api.g_sot) and nvl(p_enrolment_end_date +1,hr_api.g_eot);

Line 1314: , ota_timezone_util.get_server_timezone_code

1310: where event_id = p_event_id
1311: -- Modified for bug#5107347
1312: and ota_timezone_util.convert_date(trunc(date_booking_placed)
1313: , to_char(date_booking_placed, 'HH24:MI')
1314: , ota_timezone_util.get_server_timezone_code
1315: , p_timezone)
1316: not between nvl(p_enrolment_start_date,hr_api.g_sot) and nvl(p_enrolment_end_date +1,hr_api.g_eot);
1317: begin
1318: --

Line 2385: l_timezone_id NUMBER := ota_timezone_util.get_timezone_id(p_timezone);

2381: --
2382: --
2383: PROCEDURE check_timezone(p_timezone IN VARCHAR2)
2384: IS
2385: l_timezone_id NUMBER := ota_timezone_util.get_timezone_id(p_timezone);
2386: BEGIN
2387: IF l_timezone_id IS NULL THEN
2388: fnd_message.set_name('OTA','OTA_443982_TIMEZONE_ERROR');
2389: fnd_message.set_token('OBJECT_TYPE',ota_utility.get_lookup_meaning('OTA_OBJECT_TYPE','CL',810));