DBA Data[Home] [Help]

APPS.OE_SCH_CONC_REQUESTS dependencies on FND_DATE

Line 403: SELECT fnd_date.canonical_to_date(p_request_date_low),

399: RETURN;
400: END IF;
401:
402: -- Convert dates passed as varchar2 parameters to date variables.
403: SELECT fnd_date.canonical_to_date(p_request_date_low),
404: fnd_date.canonical_to_date(p_request_date_high),
405: fnd_date.canonical_to_date(p_ordered_date_low),
406: fnd_date.canonical_to_date(p_ordered_date_high),
407: fnd_date.canonical_to_date(p_line_request_date_low),

Line 404: fnd_date.canonical_to_date(p_request_date_high),

400: END IF;
401:
402: -- Convert dates passed as varchar2 parameters to date variables.
403: SELECT fnd_date.canonical_to_date(p_request_date_low),
404: fnd_date.canonical_to_date(p_request_date_high),
405: fnd_date.canonical_to_date(p_ordered_date_low),
406: fnd_date.canonical_to_date(p_ordered_date_high),
407: fnd_date.canonical_to_date(p_line_request_date_low),
408: fnd_date.canonical_to_date(p_line_request_date_high),

Line 405: fnd_date.canonical_to_date(p_ordered_date_low),

401:
402: -- Convert dates passed as varchar2 parameters to date variables.
403: SELECT fnd_date.canonical_to_date(p_request_date_low),
404: fnd_date.canonical_to_date(p_request_date_high),
405: fnd_date.canonical_to_date(p_ordered_date_low),
406: fnd_date.canonical_to_date(p_ordered_date_high),
407: fnd_date.canonical_to_date(p_line_request_date_low),
408: fnd_date.canonical_to_date(p_line_request_date_high),
409: fnd_date.canonical_to_date(p_sch_ship_date_low),

Line 406: fnd_date.canonical_to_date(p_ordered_date_high),

402: -- Convert dates passed as varchar2 parameters to date variables.
403: SELECT fnd_date.canonical_to_date(p_request_date_low),
404: fnd_date.canonical_to_date(p_request_date_high),
405: fnd_date.canonical_to_date(p_ordered_date_low),
406: fnd_date.canonical_to_date(p_ordered_date_high),
407: fnd_date.canonical_to_date(p_line_request_date_low),
408: fnd_date.canonical_to_date(p_line_request_date_high),
409: fnd_date.canonical_to_date(p_sch_ship_date_low),
410: fnd_date.canonical_to_date(p_sch_ship_date_high),

Line 407: fnd_date.canonical_to_date(p_line_request_date_low),

403: SELECT fnd_date.canonical_to_date(p_request_date_low),
404: fnd_date.canonical_to_date(p_request_date_high),
405: fnd_date.canonical_to_date(p_ordered_date_low),
406: fnd_date.canonical_to_date(p_ordered_date_high),
407: fnd_date.canonical_to_date(p_line_request_date_low),
408: fnd_date.canonical_to_date(p_line_request_date_high),
409: fnd_date.canonical_to_date(p_sch_ship_date_low),
410: fnd_date.canonical_to_date(p_sch_ship_date_high),
411: fnd_date.canonical_to_date(p_sch_arrival_date_low),

Line 408: fnd_date.canonical_to_date(p_line_request_date_high),

404: fnd_date.canonical_to_date(p_request_date_high),
405: fnd_date.canonical_to_date(p_ordered_date_low),
406: fnd_date.canonical_to_date(p_ordered_date_high),
407: fnd_date.canonical_to_date(p_line_request_date_low),
408: fnd_date.canonical_to_date(p_line_request_date_high),
409: fnd_date.canonical_to_date(p_sch_ship_date_low),
410: fnd_date.canonical_to_date(p_sch_ship_date_high),
411: fnd_date.canonical_to_date(p_sch_arrival_date_low),
412: fnd_date.canonical_to_date(p_sch_arrival_date_high)

Line 409: fnd_date.canonical_to_date(p_sch_ship_date_low),

405: fnd_date.canonical_to_date(p_ordered_date_low),
406: fnd_date.canonical_to_date(p_ordered_date_high),
407: fnd_date.canonical_to_date(p_line_request_date_low),
408: fnd_date.canonical_to_date(p_line_request_date_high),
409: fnd_date.canonical_to_date(p_sch_ship_date_low),
410: fnd_date.canonical_to_date(p_sch_ship_date_high),
411: fnd_date.canonical_to_date(p_sch_arrival_date_low),
412: fnd_date.canonical_to_date(p_sch_arrival_date_high)
413: -- fnd_date.canonical_to_date(p_apply_sch_date)

Line 410: fnd_date.canonical_to_date(p_sch_ship_date_high),

406: fnd_date.canonical_to_date(p_ordered_date_high),
407: fnd_date.canonical_to_date(p_line_request_date_low),
408: fnd_date.canonical_to_date(p_line_request_date_high),
409: fnd_date.canonical_to_date(p_sch_ship_date_low),
410: fnd_date.canonical_to_date(p_sch_ship_date_high),
411: fnd_date.canonical_to_date(p_sch_arrival_date_low),
412: fnd_date.canonical_to_date(p_sch_arrival_date_high)
413: -- fnd_date.canonical_to_date(p_apply_sch_date)
414: INTO l_request_date_low,

Line 411: fnd_date.canonical_to_date(p_sch_arrival_date_low),

407: fnd_date.canonical_to_date(p_line_request_date_low),
408: fnd_date.canonical_to_date(p_line_request_date_high),
409: fnd_date.canonical_to_date(p_sch_ship_date_low),
410: fnd_date.canonical_to_date(p_sch_ship_date_high),
411: fnd_date.canonical_to_date(p_sch_arrival_date_low),
412: fnd_date.canonical_to_date(p_sch_arrival_date_high)
413: -- fnd_date.canonical_to_date(p_apply_sch_date)
414: INTO l_request_date_low,
415: l_request_date_high,

Line 412: fnd_date.canonical_to_date(p_sch_arrival_date_high)

408: fnd_date.canonical_to_date(p_line_request_date_high),
409: fnd_date.canonical_to_date(p_sch_ship_date_low),
410: fnd_date.canonical_to_date(p_sch_ship_date_high),
411: fnd_date.canonical_to_date(p_sch_arrival_date_low),
412: fnd_date.canonical_to_date(p_sch_arrival_date_high)
413: -- fnd_date.canonical_to_date(p_apply_sch_date)
414: INTO l_request_date_low,
415: l_request_date_high,
416: l_ordered_date_low,

Line 413: -- fnd_date.canonical_to_date(p_apply_sch_date)

409: fnd_date.canonical_to_date(p_sch_ship_date_low),
410: fnd_date.canonical_to_date(p_sch_ship_date_high),
411: fnd_date.canonical_to_date(p_sch_arrival_date_low),
412: fnd_date.canonical_to_date(p_sch_arrival_date_high)
413: -- fnd_date.canonical_to_date(p_apply_sch_date)
414: INTO l_request_date_low,
415: l_request_date_high,
416: l_ordered_date_low,
417: l_ordered_date_high,

Line 427: SELECT fnd_date.chardt_to_date(p_apply_sch_date)

423: l_sch_arrival_date_high
424: -- l_apply_sch_date
425: FROM DUAL;
426:
427: SELECT fnd_date.chardt_to_date(p_apply_sch_date)
428: INTO l_apply_sch_date
429: FROM dual;
430:
431: IF l_debug_level > 0 THEN