21: Begin
22:
23: x_err_code := 0;
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);
22:
23: x_err_code := 0;
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;
44: l_date := l_start_date-1;
45:
46: FOR l_index IN 1..l_cnt LOOP
47: l_date := MRP_CALENDAR.NEXT_WORK_DAY(p_organization_id, 1, l_date+1);
48: g_days(l_index) := wip_datetimes.dt_to_float(l_date);
49: END LOOP;
50:
51: g_days_index := 1;
52: x_err_code := l_cnt;
151: x_err_code := 0;
152: x_start_seq := -1;
153: x_end_seq := -1;
154:
155: l_start_date := wip_datetimes.float_to_dt(p_start_date);
156: l_date1 := l_start_date;
157:
158:
159: l_found := 0;
173: else
174: x_start_seq := -1;
175: end if;
176:
177: l_end_date := wip_datetimes.float_to_dt(p_end_date);
178: l_date2 := l_end_date;
179:
180:
181: l_found := 0;