455: gme_debug.put_line('setting dates ');
456: END IF;
457:
458:
459: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
460: FND_DATE.Canonical_To_Date(p_request_date_high),
461: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
462: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
463: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
456: END IF;
457:
458:
459: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
460: FND_DATE.Canonical_To_Date(p_request_date_high),
461: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
462: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
463: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
464: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
457:
458:
459: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
460: FND_DATE.Canonical_To_Date(p_request_date_high),
461: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
462: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
463: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
464: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
465: FND_DATE.Canonical_To_Date(p_ordered_date_low),
458:
459: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
460: FND_DATE.Canonical_To_Date(p_request_date_high),
461: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
462: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
463: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
464: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
465: FND_DATE.Canonical_To_Date(p_ordered_date_low),
466: FND_DATE.Canonical_To_Date(p_ordered_date_high)
459: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
460: FND_DATE.Canonical_To_Date(p_request_date_high),
461: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
462: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
463: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
464: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
465: FND_DATE.Canonical_To_Date(p_ordered_date_low),
466: FND_DATE.Canonical_To_Date(p_ordered_date_high)
467: INTO l_request_date_low,
460: FND_DATE.Canonical_To_Date(p_request_date_high),
461: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
462: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
463: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
464: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
465: FND_DATE.Canonical_To_Date(p_ordered_date_low),
466: FND_DATE.Canonical_To_Date(p_ordered_date_high)
467: INTO l_request_date_low,
468: l_request_date_high,
461: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
462: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
463: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
464: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
465: FND_DATE.Canonical_To_Date(p_ordered_date_low),
466: FND_DATE.Canonical_To_Date(p_ordered_date_high)
467: INTO l_request_date_low,
468: l_request_date_high,
469: l_schedule_ship_date_low,
462: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
463: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
464: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
465: FND_DATE.Canonical_To_Date(p_ordered_date_low),
466: FND_DATE.Canonical_To_Date(p_ordered_date_high)
467: INTO l_request_date_low,
468: l_request_date_high,
469: l_schedule_ship_date_low,
470: l_schedule_ship_date_high,