24:
25: l_start_date := wip_datetimes.float_to_dt(p_start_date);
26: l_end_date := wip_datetimes.float_to_dt(p_end_date);
27:
28: if (not flm_timezone.is_init) then
29: flm_timezone.init_timezone(p_organization_id);
30: end if;
31:
32: l_start_date := flm_timezone.server_to_calendar(l_start_date);
25: l_start_date := wip_datetimes.float_to_dt(p_start_date);
26: l_end_date := wip_datetimes.float_to_dt(p_end_date);
27:
28: if (not flm_timezone.is_init) then
29: flm_timezone.init_timezone(p_organization_id);
30: end if;
31:
32: l_start_date := flm_timezone.server_to_calendar(l_start_date);
33: l_end_date := flm_timezone.server_to_calendar(l_end_date);
28: if (not flm_timezone.is_init) then
29: flm_timezone.init_timezone(p_organization_id);
30: end if;
31:
32: l_start_date := flm_timezone.server_to_calendar(l_start_date);
33: l_end_date := flm_timezone.server_to_calendar(l_end_date);
34:
35: l_start_date := MRP_CALENDAR.NEXT_WORK_DAY(p_organization_id, 1, l_start_date);
36:
29: flm_timezone.init_timezone(p_organization_id);
30: end if;
31:
32: l_start_date := flm_timezone.server_to_calendar(l_start_date);
33: l_end_date := flm_timezone.server_to_calendar(l_end_date);
34:
35: l_start_date := MRP_CALENDAR.NEXT_WORK_DAY(p_organization_id, 1, l_start_date);
36:
37: l_cnt := MRP_CALENDAR.DAYS_BETWEEN(p_organization_id,