2404: IF l_debug_level > 0 THEN
2405: OE_DEBUG_PUB.Add('Inside the Reserve Order Concurrent Program',1);
2406: END IF;
2407:
2408: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
2409: FND_DATE.Canonical_To_Date(p_request_date_high),
2410: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
2411: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
2412: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
2405: OE_DEBUG_PUB.Add('Inside the Reserve Order Concurrent Program',1);
2406: END IF;
2407:
2408: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
2409: FND_DATE.Canonical_To_Date(p_request_date_high),
2410: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
2411: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
2412: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
2413: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
2406: END IF;
2407:
2408: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
2409: FND_DATE.Canonical_To_Date(p_request_date_high),
2410: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
2411: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
2412: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
2413: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
2414: FND_DATE.Canonical_To_Date(p_ordered_date_low),
2407:
2408: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
2409: FND_DATE.Canonical_To_Date(p_request_date_high),
2410: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
2411: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
2412: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
2413: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
2414: FND_DATE.Canonical_To_Date(p_ordered_date_low),
2415: FND_DATE.Canonical_To_Date(p_ordered_date_high)
2408: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
2409: FND_DATE.Canonical_To_Date(p_request_date_high),
2410: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
2411: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
2412: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
2413: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
2414: FND_DATE.Canonical_To_Date(p_ordered_date_low),
2415: FND_DATE.Canonical_To_Date(p_ordered_date_high)
2416: INTO l_request_date_low,
2409: FND_DATE.Canonical_To_Date(p_request_date_high),
2410: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
2411: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
2412: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
2413: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
2414: FND_DATE.Canonical_To_Date(p_ordered_date_low),
2415: FND_DATE.Canonical_To_Date(p_ordered_date_high)
2416: INTO l_request_date_low,
2417: l_request_date_high,
2410: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
2411: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
2412: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
2413: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
2414: FND_DATE.Canonical_To_Date(p_ordered_date_low),
2415: FND_DATE.Canonical_To_Date(p_ordered_date_high)
2416: INTO l_request_date_low,
2417: l_request_date_high,
2418: l_schedule_ship_date_low,
2411: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
2412: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
2413: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
2414: FND_DATE.Canonical_To_Date(p_ordered_date_low),
2415: FND_DATE.Canonical_To_Date(p_ordered_date_high)
2416: INTO l_request_date_low,
2417: l_request_date_high,
2418: l_schedule_ship_date_low,
2419: l_schedule_ship_date_high,