DBA Data[Home] [Help]

APPS.CSF_TDS_PUB dependencies on FND_DATE

Line 461: -- all fnd_date converts to server timezone so need for conversion

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;
464:
465: --

Line 462: l_start_date := fnd_date.canonical_to_date (p_start_date);

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;
464:
465: --
466: -- end date defaults to same day as start date (also truncated)

Line 476: -- all fnd_date converts to server timezone so need for conversion

472: l_end_date := l_start_date - 7;
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);

Line 480: l_end_date := fnd_date.canonical_to_date (p_end_date);

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;
482:
483: --
484: -- get date format