DBA Data[Home] [Help]

APPS.OE_RESERVE_CONC dependencies on FND_DATE

Line 2355: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),

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),

Line 2356: FND_DATE.Canonical_To_Date(p_request_date_high),

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),

Line 2357: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),

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),

Line 2358: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),

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)

Line 2359: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),

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,

Line 2360: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),

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,

Line 2361: FND_DATE.Canonical_To_Date(p_ordered_date_low),

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,

Line 2362: FND_DATE.Canonical_To_Date(p_ordered_date_high)

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,