DBA Data[Home] [Help]

APPS.CSF_TDS_PUB dependencies on FND_DATE

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

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;
436:
437: --

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

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;
436:
437: --
438: -- end date defaults to same day as start date (also truncated)

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

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

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

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;
454:
455: --
456: -- get date format