DBA Data[Home] [Help]

APPS.CSR_SCHEDULER_PVT dependencies on HZ_TIMEZONE_PUB

Line 237: l_server_date := hz_timezone_pub.convert_datetime(

233: RETURN NUMBER IS
234: l_offset_days NUMBER;
235: l_server_date DATE;
236: BEGIN
237: l_server_date := hz_timezone_pub.convert_datetime(
238: p_source_tz_id => p_timezone_id
239: , p_dest_tz_id => get_server_timezone
240: , p_source_day_time => SYSDATE
241: );

Line 303: hz_timezone_pub.get_time(p_api_version => 1

299: l_src_datetime := TO_DATE(TO_CHAR( TRUNC(SYSDATE), 'DD-MM-YYYY') || TO_CHAR(p_time, 'HH24:MI')
300: , 'DD-MM-YYYY HH24:MI'
301: );
302:
303: hz_timezone_pub.get_time(p_api_version => 1
304: , p_init_msg_list => fnd_api.g_false
305: , x_return_status => l_return_status
306: , x_msg_count => l_msg_count
307: , x_msg_data => l_msg_data