APPS.CSF_TDS_PUB dependencies on CSF_TIMEZONES_PVT

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

452: --
453: IF p_start_date IS NULL
454: THEN
455: l_start_date :=
456: TRUNC (csf_timezones_pvt.date_to_client_tz_date (SYSDATE - 14));
457: -- convert to server timezone
458: l_start_date :=
459: csf_timezones_pvt.date_to_server_tz_date (l_start_date);
460: ELSE

Line 459: csf_timezones_pvt.date_to_server_tz_date (l_start_date);

455: l_start_date :=
456: TRUNC (csf_timezones_pvt.date_to_client_tz_date (SYSDATE - 14));
457: -- convert to server timezone
458: l_start_date :=
459: csf_timezones_pvt.date_to_server_tz_date (l_start_date);
460: ELSE
461: -- all fnd_date converts to server timezone so need for conversion
462: l_start_date := fnd_date.canonical_to_date (p_start_date);
463: END IF;

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

473: ELSE
474: l_end_date := l_start_date + 1;
475: END IF;
476: -- all fnd_date converts to server timezone so need for conversion
477: l_end_date := csf_timezones_pvt.date_to_server_tz_date (l_end_date);
478:
479: ELSE
480: l_end_date := fnd_date.canonical_to_date (p_end_date);
481: END IF;

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

497: put_stream (g_output, fnd_message.get);
498: --
499: -- finally convert the date range to server timezone before processing
500: --
501: l_start_date := csf_timezones_pvt.date_to_server_tz_date (l_start_date);
502: l_end_date := csf_timezones_pvt.date_to_server_tz_date (l_end_date);
503:
504: l_del_qry := 'DELETE FROM CSF_TDS_ROUTE_CACHE'||multiDataSetProfileValue
505: ||' WHERE HITCOUNT = 0

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

498: --
499: -- finally convert the date range to server timezone before processing
500: --
501: l_start_date := csf_timezones_pvt.date_to_server_tz_date (l_start_date);
502: l_end_date := csf_timezones_pvt.date_to_server_tz_date (l_end_date);
503:
504: l_del_qry := 'DELETE FROM CSF_TDS_ROUTE_CACHE'||multiDataSetProfileValue
505: ||' WHERE HITCOUNT = 0
506: AND CREATION_DATE >= :1