326: RETURN;
327: END IF;
328:
329: -- Convert dates passed as varchar2 parameters to date variables.
330: SELECT fnd_date.canonical_to_date(p_request_date_low),
331: fnd_date.canonical_to_date(p_request_date_high),
332: fnd_date.canonical_to_date(p_ordered_date_low),
333: fnd_date.canonical_to_date(p_ordered_date_high),
334: fnd_date.canonical_to_date(p_line_request_date_low),
327: END IF;
328:
329: -- Convert dates passed as varchar2 parameters to date variables.
330: SELECT fnd_date.canonical_to_date(p_request_date_low),
331: fnd_date.canonical_to_date(p_request_date_high),
332: fnd_date.canonical_to_date(p_ordered_date_low),
333: fnd_date.canonical_to_date(p_ordered_date_high),
334: fnd_date.canonical_to_date(p_line_request_date_low),
335: fnd_date.canonical_to_date(p_line_request_date_high),
328:
329: -- Convert dates passed as varchar2 parameters to date variables.
330: SELECT fnd_date.canonical_to_date(p_request_date_low),
331: fnd_date.canonical_to_date(p_request_date_high),
332: fnd_date.canonical_to_date(p_ordered_date_low),
333: fnd_date.canonical_to_date(p_ordered_date_high),
334: fnd_date.canonical_to_date(p_line_request_date_low),
335: fnd_date.canonical_to_date(p_line_request_date_high),
336: fnd_date.canonical_to_date(p_sch_ship_date_low),
329: -- Convert dates passed as varchar2 parameters to date variables.
330: SELECT fnd_date.canonical_to_date(p_request_date_low),
331: fnd_date.canonical_to_date(p_request_date_high),
332: fnd_date.canonical_to_date(p_ordered_date_low),
333: fnd_date.canonical_to_date(p_ordered_date_high),
334: fnd_date.canonical_to_date(p_line_request_date_low),
335: fnd_date.canonical_to_date(p_line_request_date_high),
336: fnd_date.canonical_to_date(p_sch_ship_date_low),
337: fnd_date.canonical_to_date(p_sch_ship_date_high),
330: SELECT fnd_date.canonical_to_date(p_request_date_low),
331: fnd_date.canonical_to_date(p_request_date_high),
332: fnd_date.canonical_to_date(p_ordered_date_low),
333: fnd_date.canonical_to_date(p_ordered_date_high),
334: fnd_date.canonical_to_date(p_line_request_date_low),
335: fnd_date.canonical_to_date(p_line_request_date_high),
336: fnd_date.canonical_to_date(p_sch_ship_date_low),
337: fnd_date.canonical_to_date(p_sch_ship_date_high),
338: fnd_date.canonical_to_date(p_sch_arrival_date_low),
331: fnd_date.canonical_to_date(p_request_date_high),
332: fnd_date.canonical_to_date(p_ordered_date_low),
333: fnd_date.canonical_to_date(p_ordered_date_high),
334: fnd_date.canonical_to_date(p_line_request_date_low),
335: fnd_date.canonical_to_date(p_line_request_date_high),
336: fnd_date.canonical_to_date(p_sch_ship_date_low),
337: fnd_date.canonical_to_date(p_sch_ship_date_high),
338: fnd_date.canonical_to_date(p_sch_arrival_date_low),
339: fnd_date.canonical_to_date(p_sch_arrival_date_high)
332: fnd_date.canonical_to_date(p_ordered_date_low),
333: fnd_date.canonical_to_date(p_ordered_date_high),
334: fnd_date.canonical_to_date(p_line_request_date_low),
335: fnd_date.canonical_to_date(p_line_request_date_high),
336: fnd_date.canonical_to_date(p_sch_ship_date_low),
337: fnd_date.canonical_to_date(p_sch_ship_date_high),
338: fnd_date.canonical_to_date(p_sch_arrival_date_low),
339: fnd_date.canonical_to_date(p_sch_arrival_date_high)
340: -- fnd_date.canonical_to_date(p_apply_sch_date)
333: fnd_date.canonical_to_date(p_ordered_date_high),
334: fnd_date.canonical_to_date(p_line_request_date_low),
335: fnd_date.canonical_to_date(p_line_request_date_high),
336: fnd_date.canonical_to_date(p_sch_ship_date_low),
337: fnd_date.canonical_to_date(p_sch_ship_date_high),
338: fnd_date.canonical_to_date(p_sch_arrival_date_low),
339: fnd_date.canonical_to_date(p_sch_arrival_date_high)
340: -- fnd_date.canonical_to_date(p_apply_sch_date)
341: INTO l_request_date_low,
334: fnd_date.canonical_to_date(p_line_request_date_low),
335: fnd_date.canonical_to_date(p_line_request_date_high),
336: fnd_date.canonical_to_date(p_sch_ship_date_low),
337: fnd_date.canonical_to_date(p_sch_ship_date_high),
338: fnd_date.canonical_to_date(p_sch_arrival_date_low),
339: fnd_date.canonical_to_date(p_sch_arrival_date_high)
340: -- fnd_date.canonical_to_date(p_apply_sch_date)
341: INTO l_request_date_low,
342: l_request_date_high,
335: fnd_date.canonical_to_date(p_line_request_date_high),
336: fnd_date.canonical_to_date(p_sch_ship_date_low),
337: fnd_date.canonical_to_date(p_sch_ship_date_high),
338: fnd_date.canonical_to_date(p_sch_arrival_date_low),
339: fnd_date.canonical_to_date(p_sch_arrival_date_high)
340: -- fnd_date.canonical_to_date(p_apply_sch_date)
341: INTO l_request_date_low,
342: l_request_date_high,
343: l_ordered_date_low,
336: fnd_date.canonical_to_date(p_sch_ship_date_low),
337: fnd_date.canonical_to_date(p_sch_ship_date_high),
338: fnd_date.canonical_to_date(p_sch_arrival_date_low),
339: fnd_date.canonical_to_date(p_sch_arrival_date_high)
340: -- fnd_date.canonical_to_date(p_apply_sch_date)
341: INTO l_request_date_low,
342: l_request_date_high,
343: l_ordered_date_low,
344: l_ordered_date_high,
350: l_sch_arrival_date_high
351: -- l_apply_sch_date
352: FROM DUAL;
353:
354: SELECT fnd_date.chardt_to_date(p_apply_sch_date)
355: INTO l_apply_sch_date
356: FROM dual;
357:
358: IF l_debug_level > 0 THEN