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.

[Home] [Help]

APPS.CSF_TDS_PUB dependencies on CSF_TIMEZONES_PVT

Line 428: TRUNC (csf_timezones_pvt.date_to_client_tz_date (SYSDATE - 14));

424: --
425: IF p_start_date IS NULL
426: THEN
427: l_start_date :=
428: TRUNC (csf_timezones_pvt.date_to_client_tz_date (SYSDATE - 14));
429: -- convert to server timezone
430: l_start_date :=
431: csf_timezones_pvt.date_to_server_tz_date (l_start_date);
432: ELSE

Line 431: csf_timezones_pvt.date_to_server_tz_date (l_start_date);

427: l_start_date :=
428: TRUNC (csf_timezones_pvt.date_to_client_tz_date (SYSDATE - 14));
429: -- convert to server timezone
430: l_start_date :=
431: csf_timezones_pvt.date_to_server_tz_date (l_start_date);
432: ELSE
433: -- all fnd_date converts to server timezone so need for conversion
434: l_start_date := fnd_date.canonical_to_date (p_start_date);
435: END IF;

Line 449: l_end_date := csf_timezones_pvt.date_to_server_tz_date (l_end_date);

445: ELSE
446: l_end_date := l_start_date + 1;
447: END IF;
448: -- all fnd_date converts to server timezone so need for conversion
449: l_end_date := csf_timezones_pvt.date_to_server_tz_date (l_end_date);
450:
451: ELSE
452: l_end_date := fnd_date.canonical_to_date (p_end_date);
453: END IF;

Line 473: l_start_date := csf_timezones_pvt.date_to_server_tz_date (l_start_date);

469: put_stream (g_output, fnd_message.get);
470: --
471: -- finally convert the date range to server timezone before processing
472: --
473: l_start_date := csf_timezones_pvt.date_to_server_tz_date (l_start_date);
474: l_end_date := csf_timezones_pvt.date_to_server_tz_date (l_end_date);
475:
476: l_del_qry := 'DELETE FROM CSF_TDS_ROUTE_CACHE'||multiDataSetProfileValue
477: ||' WHERE HITCOUNT = 0

Line 474: l_end_date := csf_timezones_pvt.date_to_server_tz_date (l_end_date);

470: --
471: -- finally convert the date range to server timezone before processing
472: --
473: l_start_date := csf_timezones_pvt.date_to_server_tz_date (l_start_date);
474: l_end_date := csf_timezones_pvt.date_to_server_tz_date (l_end_date);
475:
476: l_del_qry := 'DELETE FROM CSF_TDS_ROUTE_CACHE'||multiDataSetProfileValue
477: ||' WHERE HITCOUNT = 0
478: AND CREATION_DATE >= :1