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 2404: l_timezone_id NUMBER := ota_timezone_util.get_timezone_id(p_timezone);

2400: --
2401: --
2402: PROCEDURE check_timezone(p_timezone IN VARCHAR2)
2403: IS
2404: l_timezone_id NUMBER := ota_timezone_util.get_timezone_id(p_timezone);
2405: BEGIN
2406: IF l_timezone_id IS NULL THEN
2407: fnd_message.set_name('OTA','OTA_443982_TIMEZONE_ERROR');
2408: fnd_message.set_token('OBJECT_TYPE',ota_utility.get_lookup_meaning('OTA_OBJECT_TYPE','CL',810));