DBA Data[Home] [Help]

APPS.FLM_SEQ_READER_WRITER dependencies on WIP_DATETIMES

Line 25: l_start_date := wip_datetimes.float_to_dt(p_start_date);

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

Line 26: l_end_date := wip_datetimes.float_to_dt(p_end_date);

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;

Line 48: g_days(l_index) := wip_datetimes.dt_to_float(l_date);

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;

Line 155: l_start_date := wip_datetimes.float_to_dt(p_start_date);

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;

Line 177: l_end_date := wip_datetimes.float_to_dt(p_end_date);

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;