DBA Data[Home] [Help]

APPS.GME_RESERVE_CONC dependencies on FND_DATE

Line 461: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),

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

Line 462: FND_DATE.Canonical_To_Date(p_request_date_high),

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

Line 463: FND_DATE.Canonical_To_Date(p_schedule_ship_date_low),

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

Line 464: FND_DATE.Canonical_To_Date(p_schedule_ship_date_high),

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

Line 465: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_low),

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

Line 466: FND_DATE.Canonical_To_Date(p_schedule_arrival_date_high),

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

Line 467: FND_DATE.Canonical_To_Date(p_ordered_date_low),

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

Line 468: FND_DATE.Canonical_To_Date(p_ordered_date_high)

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