APPS.OTA_TDB_BUS dependencies on OTA_TIMEZONE_UTIL

Line 1666: ota_timezone_util.convert_date(trunc(sysdate), to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, e.timezone)

1662: SELECT 1
1663: FROM ota_events e
1664: WHERE
1665: -- Added for bug#5169098
1666: ota_timezone_util.convert_date(trunc(sysdate), to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, e.timezone)
1667: >= ota_timezone_util.convert_date(nvl(e.course_start_date,to_date('0001/01/01','YYYY/MM/DD')), course_start_time, e.timezone, e.timezone)
1668: --(sysdate >= nvl( e.course_start_date, sysdate))
1669: AND e.event_id = p_event_id;
1670:

Line 1667: >= ota_timezone_util.convert_date(nvl(e.course_start_date,to_date('0001/01/01','YYYY/MM/DD')), course_start_time, e.timezone, e.timezone)

1663: FROM ota_events e
1664: WHERE
1665: -- Added for bug#5169098
1666: ota_timezone_util.convert_date(trunc(sysdate), to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, e.timezone)
1667: >= ota_timezone_util.convert_date(nvl(e.course_start_date,to_date('0001/01/01','YYYY/MM/DD')), course_start_time, e.timezone, e.timezone)
1668: --(sysdate >= nvl( e.course_start_date, sysdate))
1669: AND e.event_id = p_event_id;
1670:
1671: --

Line 2477: l_conv_booking_date := ota_timezone_util.convert_date(trunc(p_date)

2473: || ' ' || '00:00', 'YYYY/MM/DD HH24:MI');
2474: l_enrollment_ed := to_date( nvl(to_char(l_enrollment_ed,'YYYY/MM/DD'),'4712/12/31')
2475: || ' ' || '23:59', 'YYYY/MM/DD HH24:MI');
2476:
2477: l_conv_booking_date := ota_timezone_util.convert_date(trunc(p_date)
2478: , to_char(p_date,'HH24:MI')
2479: , ota_timezone_util.get_server_timezone_code
2480: , l_timezone);
2481: END IF;

Line 2479: , ota_timezone_util.get_server_timezone_code

2475: || ' ' || '23:59', 'YYYY/MM/DD HH24:MI');
2476:
2477: l_conv_booking_date := ota_timezone_util.convert_date(trunc(p_date)
2478: , to_char(p_date,'HH24:MI')
2479: , ota_timezone_util.get_server_timezone_code
2480: , l_timezone);
2481: END IF;
2482:
2483: Return (l_conv_booking_date between l_enrollment_sd

Line 2536: l_conv_booking_date := ota_timezone_util.convert_date(trunc(p_date)

2532: || ' ' || '00:00', 'YYYY/MM/DD HH24:MI');
2533: l_enrollment_ed := to_date( nvl(to_char(l_enrollment_ed,'YYYY/MM/DD'),'4712/12/31')
2534: || ' ' || '23:59', 'YYYY/MM/DD HH24:MI');
2535:
2536: l_conv_booking_date := ota_timezone_util.convert_date(trunc(p_date)
2537: , to_char(p_date,'HH24:MI')
2538: , ota_timezone_util.get_server_timezone_code
2539: , l_timezone);
2540: ELSE

Line 2538: , ota_timezone_util.get_server_timezone_code

2534: || ' ' || '23:59', 'YYYY/MM/DD HH24:MI');
2535:
2536: l_conv_booking_date := ota_timezone_util.convert_date(trunc(p_date)
2537: , to_char(p_date,'HH24:MI')
2538: , ota_timezone_util.get_server_timezone_code
2539: , l_timezone);
2540: ELSE
2541: RETURN 'N';
2542: END IF;