2351: IF l_debug_level > 0 THEN
2352: OE_DEBUG_PUB.Add('Inside the Reserve Order Concurrent Program',1);
2353: END IF;
2354:
2355: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
2356: FND_DATE.Canonical_To_Date(p_request_date_high),
2357: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
2358: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
2359: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
2352: OE_DEBUG_PUB.Add('Inside the Reserve Order Concurrent Program',1);
2353: END IF;
2354:
2355: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
2356: FND_DATE.Canonical_To_Date(p_request_date_high),
2357: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
2358: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
2359: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
2360: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
2353: END IF;
2354:
2355: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
2356: FND_DATE.Canonical_To_Date(p_request_date_high),
2357: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
2358: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
2359: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
2360: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
2361: FND_DATE.Canonical_To_Date(p_ordered_date_low),
2354:
2355: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
2356: FND_DATE.Canonical_To_Date(p_request_date_high),
2357: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
2358: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
2359: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
2360: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
2361: FND_DATE.Canonical_To_Date(p_ordered_date_low),
2362: FND_DATE.Canonical_To_Date(p_ordered_date_high)
2355: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
2356: FND_DATE.Canonical_To_Date(p_request_date_high),
2357: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
2358: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
2359: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
2360: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
2361: FND_DATE.Canonical_To_Date(p_ordered_date_low),
2362: FND_DATE.Canonical_To_Date(p_ordered_date_high)
2363: INTO l_request_date_low,
2356: FND_DATE.Canonical_To_Date(p_request_date_high),
2357: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
2358: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
2359: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
2360: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
2361: FND_DATE.Canonical_To_Date(p_ordered_date_low),
2362: FND_DATE.Canonical_To_Date(p_ordered_date_high)
2363: INTO l_request_date_low,
2364: l_request_date_high,
2357: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
2358: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
2359: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
2360: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
2361: FND_DATE.Canonical_To_Date(p_ordered_date_low),
2362: FND_DATE.Canonical_To_Date(p_ordered_date_high)
2363: INTO l_request_date_low,
2364: l_request_date_high,
2365: l_schedule_ship_date_low,
2358: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
2359: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
2360: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
2361: FND_DATE.Canonical_To_Date(p_ordered_date_low),
2362: FND_DATE.Canonical_To_Date(p_ordered_date_high)
2363: INTO l_request_date_low,
2364: l_request_date_high,
2365: l_schedule_ship_date_low,
2366: l_schedule_ship_date_high,