DBA Data[Home] [Help]

APPS.OE_RESERVE_CONC dependencies on FND_DATE

Line 2408: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),

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

Line 2409: FND_DATE.Canonical_To_Date(p_request_date_high),

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

Line 2410: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),

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

Line 2411: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),

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)

Line 2412: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),

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,

Line 2413: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),

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,

Line 2414: FND_DATE.Canonical_To_Date(p_ordered_date_low),

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,

Line 2415: FND_DATE.Canonical_To_Date(p_ordered_date_high)

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,