DBA Data[Home] [Help]

APPS.GME_RESERVE_CONC dependencies on FND_DATE

Line 459: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),

455: gme_debug.put_line('setting dates ');
456: END IF;
457:
458:
459: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
460: FND_DATE.Canonical_To_Date(p_request_date_high),
461: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
462: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
463: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),

Line 460: FND_DATE.Canonical_To_Date(p_request_date_high),

456: END IF;
457:
458:
459: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
460: FND_DATE.Canonical_To_Date(p_request_date_high),
461: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
462: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
463: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
464: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),

Line 461: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),

457:
458:
459: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
460: FND_DATE.Canonical_To_Date(p_request_date_high),
461: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
462: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
463: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
464: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
465: FND_DATE.Canonical_To_Date(p_ordered_date_low),

Line 462: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),

458:
459: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
460: FND_DATE.Canonical_To_Date(p_request_date_high),
461: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
462: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
463: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
464: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
465: FND_DATE.Canonical_To_Date(p_ordered_date_low),
466: FND_DATE.Canonical_To_Date(p_ordered_date_high)

Line 463: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),

459: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
460: FND_DATE.Canonical_To_Date(p_request_date_high),
461: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
462: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
463: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
464: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
465: FND_DATE.Canonical_To_Date(p_ordered_date_low),
466: FND_DATE.Canonical_To_Date(p_ordered_date_high)
467: INTO l_request_date_low,

Line 464: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),

460: FND_DATE.Canonical_To_Date(p_request_date_high),
461: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
462: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
463: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
464: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
465: FND_DATE.Canonical_To_Date(p_ordered_date_low),
466: FND_DATE.Canonical_To_Date(p_ordered_date_high)
467: INTO l_request_date_low,
468: l_request_date_high,

Line 465: FND_DATE.Canonical_To_Date(p_ordered_date_low),

461: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),
462: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
463: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
464: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
465: FND_DATE.Canonical_To_Date(p_ordered_date_low),
466: FND_DATE.Canonical_To_Date(p_ordered_date_high)
467: INTO l_request_date_low,
468: l_request_date_high,
469: l_schedule_ship_date_low,

Line 466: FND_DATE.Canonical_To_Date(p_ordered_date_high)

462: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),
463: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),
464: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),
465: FND_DATE.Canonical_To_Date(p_ordered_date_low),
466: FND_DATE.Canonical_To_Date(p_ordered_date_high)
467: INTO l_request_date_low,
468: l_request_date_high,
469: l_schedule_ship_date_low,
470: l_schedule_ship_date_high,