399: RETURN;
400: END IF;
401:
402: -- Convert dates passed as varchar2 parameters to date variables.
403: SELECT fnd_date.canonical_to_date(p_request_date_low),
404: fnd_date.canonical_to_date(p_request_date_high),
405: fnd_date.canonical_to_date(p_ordered_date_low),
406: fnd_date.canonical_to_date(p_ordered_date_high),
407: fnd_date.canonical_to_date(p_line_request_date_low),
400: END IF;
401:
402: -- Convert dates passed as varchar2 parameters to date variables.
403: SELECT fnd_date.canonical_to_date(p_request_date_low),
404: fnd_date.canonical_to_date(p_request_date_high),
405: fnd_date.canonical_to_date(p_ordered_date_low),
406: fnd_date.canonical_to_date(p_ordered_date_high),
407: fnd_date.canonical_to_date(p_line_request_date_low),
408: fnd_date.canonical_to_date(p_line_request_date_high),
401:
402: -- Convert dates passed as varchar2 parameters to date variables.
403: SELECT fnd_date.canonical_to_date(p_request_date_low),
404: fnd_date.canonical_to_date(p_request_date_high),
405: fnd_date.canonical_to_date(p_ordered_date_low),
406: fnd_date.canonical_to_date(p_ordered_date_high),
407: fnd_date.canonical_to_date(p_line_request_date_low),
408: fnd_date.canonical_to_date(p_line_request_date_high),
409: fnd_date.canonical_to_date(p_sch_ship_date_low),
402: -- Convert dates passed as varchar2 parameters to date variables.
403: SELECT fnd_date.canonical_to_date(p_request_date_low),
404: fnd_date.canonical_to_date(p_request_date_high),
405: fnd_date.canonical_to_date(p_ordered_date_low),
406: fnd_date.canonical_to_date(p_ordered_date_high),
407: fnd_date.canonical_to_date(p_line_request_date_low),
408: fnd_date.canonical_to_date(p_line_request_date_high),
409: fnd_date.canonical_to_date(p_sch_ship_date_low),
410: fnd_date.canonical_to_date(p_sch_ship_date_high),
403: SELECT fnd_date.canonical_to_date(p_request_date_low),
404: fnd_date.canonical_to_date(p_request_date_high),
405: fnd_date.canonical_to_date(p_ordered_date_low),
406: fnd_date.canonical_to_date(p_ordered_date_high),
407: fnd_date.canonical_to_date(p_line_request_date_low),
408: fnd_date.canonical_to_date(p_line_request_date_high),
409: fnd_date.canonical_to_date(p_sch_ship_date_low),
410: fnd_date.canonical_to_date(p_sch_ship_date_high),
411: fnd_date.canonical_to_date(p_sch_arrival_date_low),
404: fnd_date.canonical_to_date(p_request_date_high),
405: fnd_date.canonical_to_date(p_ordered_date_low),
406: fnd_date.canonical_to_date(p_ordered_date_high),
407: fnd_date.canonical_to_date(p_line_request_date_low),
408: fnd_date.canonical_to_date(p_line_request_date_high),
409: fnd_date.canonical_to_date(p_sch_ship_date_low),
410: fnd_date.canonical_to_date(p_sch_ship_date_high),
411: fnd_date.canonical_to_date(p_sch_arrival_date_low),
412: fnd_date.canonical_to_date(p_sch_arrival_date_high)
405: fnd_date.canonical_to_date(p_ordered_date_low),
406: fnd_date.canonical_to_date(p_ordered_date_high),
407: fnd_date.canonical_to_date(p_line_request_date_low),
408: fnd_date.canonical_to_date(p_line_request_date_high),
409: fnd_date.canonical_to_date(p_sch_ship_date_low),
410: fnd_date.canonical_to_date(p_sch_ship_date_high),
411: fnd_date.canonical_to_date(p_sch_arrival_date_low),
412: fnd_date.canonical_to_date(p_sch_arrival_date_high)
413: -- fnd_date.canonical_to_date(p_apply_sch_date)
406: fnd_date.canonical_to_date(p_ordered_date_high),
407: fnd_date.canonical_to_date(p_line_request_date_low),
408: fnd_date.canonical_to_date(p_line_request_date_high),
409: fnd_date.canonical_to_date(p_sch_ship_date_low),
410: fnd_date.canonical_to_date(p_sch_ship_date_high),
411: fnd_date.canonical_to_date(p_sch_arrival_date_low),
412: fnd_date.canonical_to_date(p_sch_arrival_date_high)
413: -- fnd_date.canonical_to_date(p_apply_sch_date)
414: INTO l_request_date_low,
407: fnd_date.canonical_to_date(p_line_request_date_low),
408: fnd_date.canonical_to_date(p_line_request_date_high),
409: fnd_date.canonical_to_date(p_sch_ship_date_low),
410: fnd_date.canonical_to_date(p_sch_ship_date_high),
411: fnd_date.canonical_to_date(p_sch_arrival_date_low),
412: fnd_date.canonical_to_date(p_sch_arrival_date_high)
413: -- fnd_date.canonical_to_date(p_apply_sch_date)
414: INTO l_request_date_low,
415: l_request_date_high,
408: fnd_date.canonical_to_date(p_line_request_date_high),
409: fnd_date.canonical_to_date(p_sch_ship_date_low),
410: fnd_date.canonical_to_date(p_sch_ship_date_high),
411: fnd_date.canonical_to_date(p_sch_arrival_date_low),
412: fnd_date.canonical_to_date(p_sch_arrival_date_high)
413: -- fnd_date.canonical_to_date(p_apply_sch_date)
414: INTO l_request_date_low,
415: l_request_date_high,
416: l_ordered_date_low,
409: fnd_date.canonical_to_date(p_sch_ship_date_low),
410: fnd_date.canonical_to_date(p_sch_ship_date_high),
411: fnd_date.canonical_to_date(p_sch_arrival_date_low),
412: fnd_date.canonical_to_date(p_sch_arrival_date_high)
413: -- fnd_date.canonical_to_date(p_apply_sch_date)
414: INTO l_request_date_low,
415: l_request_date_high,
416: l_ordered_date_low,
417: l_ordered_date_high,
423: l_sch_arrival_date_high
424: -- l_apply_sch_date
425: FROM DUAL;
426:
427: SELECT fnd_date.chardt_to_date(p_apply_sch_date)
428: INTO l_apply_sch_date
429: FROM dual;
430:
431: IF l_debug_level > 0 THEN