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: --
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)
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);
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