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