DBA Data[Home] [Help]

APPS.MRP_LINE_SCHEDULE_ALGORITHM dependencies on FLM_TIMEZONE

Line 268: v_current_date_in_client00 := flm_timezone.client00_in_server(v_date+(v_line_start_time/86400));

264: p_cap_tab(v_current_date).capacity := v_line_rate;
265:
266: --fix bug#3783650
267: v_date := to_date(v_current_date,'J');
268: v_current_date_in_client00 := flm_timezone.client00_in_server(v_date+(v_line_start_time/86400));
269: --end of fix bug#3783650
270:
271: SELECT NVL(SUM(NVL(start_quantity,0)
272: - NVL(quantity_completed,0)

Line 334: flm_timezone.client00_in_server(first_unit_completion_date)

330: --AND v_current_date BETWEEN
331: -- to_number(to_char(first_unit_completion_date,'J'))
332: --AND to_number(to_char(last_unit_completion_date,'J'));
333: AND v_current_date_in_client00 BETWEEN
334: flm_timezone.client00_in_server(first_unit_completion_date)
335: AND flm_timezone.client00_in_server(last_unit_completion_date+1)-1/86400;
336: --end of fix bug#3783650
337:
338: V_ERROR_LINE := 6;

Line 335: AND flm_timezone.client00_in_server(last_unit_completion_date+1)-1/86400;

331: -- to_number(to_char(first_unit_completion_date,'J'))
332: --AND to_number(to_char(last_unit_completion_date,'J'));
333: AND v_current_date_in_client00 BETWEEN
334: flm_timezone.client00_in_server(first_unit_completion_date)
335: AND flm_timezone.client00_in_server(last_unit_completion_date+1)-1/86400;
336: --end of fix bug#3783650
337:
338: V_ERROR_LINE := 6;
339: