DBA Data[Home] [Help]

APPS.OE_SCH_CONC_REQUESTS dependencies on FND_DATE

Line 330: SELECT fnd_date.canonical_to_date(p_request_date_low),

326: RETURN;
327: END IF;
328:
329: -- Convert dates passed as varchar2 parameters to date variables.
330: SELECT fnd_date.canonical_to_date(p_request_date_low),
331: fnd_date.canonical_to_date(p_request_date_high),
332: fnd_date.canonical_to_date(p_ordered_date_low),
333: fnd_date.canonical_to_date(p_ordered_date_high),
334: fnd_date.canonical_to_date(p_line_request_date_low),

Line 331: fnd_date.canonical_to_date(p_request_date_high),

327: END IF;
328:
329: -- Convert dates passed as varchar2 parameters to date variables.
330: SELECT fnd_date.canonical_to_date(p_request_date_low),
331: fnd_date.canonical_to_date(p_request_date_high),
332: fnd_date.canonical_to_date(p_ordered_date_low),
333: fnd_date.canonical_to_date(p_ordered_date_high),
334: fnd_date.canonical_to_date(p_line_request_date_low),
335: fnd_date.canonical_to_date(p_line_request_date_high),

Line 332: fnd_date.canonical_to_date(p_ordered_date_low),

328:
329: -- Convert dates passed as varchar2 parameters to date variables.
330: SELECT fnd_date.canonical_to_date(p_request_date_low),
331: fnd_date.canonical_to_date(p_request_date_high),
332: fnd_date.canonical_to_date(p_ordered_date_low),
333: fnd_date.canonical_to_date(p_ordered_date_high),
334: fnd_date.canonical_to_date(p_line_request_date_low),
335: fnd_date.canonical_to_date(p_line_request_date_high),
336: fnd_date.canonical_to_date(p_sch_ship_date_low),

Line 333: fnd_date.canonical_to_date(p_ordered_date_high),

329: -- Convert dates passed as varchar2 parameters to date variables.
330: SELECT fnd_date.canonical_to_date(p_request_date_low),
331: fnd_date.canonical_to_date(p_request_date_high),
332: fnd_date.canonical_to_date(p_ordered_date_low),
333: fnd_date.canonical_to_date(p_ordered_date_high),
334: fnd_date.canonical_to_date(p_line_request_date_low),
335: fnd_date.canonical_to_date(p_line_request_date_high),
336: fnd_date.canonical_to_date(p_sch_ship_date_low),
337: fnd_date.canonical_to_date(p_sch_ship_date_high),

Line 334: fnd_date.canonical_to_date(p_line_request_date_low),

330: SELECT fnd_date.canonical_to_date(p_request_date_low),
331: fnd_date.canonical_to_date(p_request_date_high),
332: fnd_date.canonical_to_date(p_ordered_date_low),
333: fnd_date.canonical_to_date(p_ordered_date_high),
334: fnd_date.canonical_to_date(p_line_request_date_low),
335: fnd_date.canonical_to_date(p_line_request_date_high),
336: fnd_date.canonical_to_date(p_sch_ship_date_low),
337: fnd_date.canonical_to_date(p_sch_ship_date_high),
338: fnd_date.canonical_to_date(p_sch_arrival_date_low),

Line 335: fnd_date.canonical_to_date(p_line_request_date_high),

331: fnd_date.canonical_to_date(p_request_date_high),
332: fnd_date.canonical_to_date(p_ordered_date_low),
333: fnd_date.canonical_to_date(p_ordered_date_high),
334: fnd_date.canonical_to_date(p_line_request_date_low),
335: fnd_date.canonical_to_date(p_line_request_date_high),
336: fnd_date.canonical_to_date(p_sch_ship_date_low),
337: fnd_date.canonical_to_date(p_sch_ship_date_high),
338: fnd_date.canonical_to_date(p_sch_arrival_date_low),
339: fnd_date.canonical_to_date(p_sch_arrival_date_high)

Line 336: fnd_date.canonical_to_date(p_sch_ship_date_low),

332: fnd_date.canonical_to_date(p_ordered_date_low),
333: fnd_date.canonical_to_date(p_ordered_date_high),
334: fnd_date.canonical_to_date(p_line_request_date_low),
335: fnd_date.canonical_to_date(p_line_request_date_high),
336: fnd_date.canonical_to_date(p_sch_ship_date_low),
337: fnd_date.canonical_to_date(p_sch_ship_date_high),
338: fnd_date.canonical_to_date(p_sch_arrival_date_low),
339: fnd_date.canonical_to_date(p_sch_arrival_date_high)
340: -- fnd_date.canonical_to_date(p_apply_sch_date)

Line 337: fnd_date.canonical_to_date(p_sch_ship_date_high),

333: fnd_date.canonical_to_date(p_ordered_date_high),
334: fnd_date.canonical_to_date(p_line_request_date_low),
335: fnd_date.canonical_to_date(p_line_request_date_high),
336: fnd_date.canonical_to_date(p_sch_ship_date_low),
337: fnd_date.canonical_to_date(p_sch_ship_date_high),
338: fnd_date.canonical_to_date(p_sch_arrival_date_low),
339: fnd_date.canonical_to_date(p_sch_arrival_date_high)
340: -- fnd_date.canonical_to_date(p_apply_sch_date)
341: INTO l_request_date_low,

Line 338: fnd_date.canonical_to_date(p_sch_arrival_date_low),

334: fnd_date.canonical_to_date(p_line_request_date_low),
335: fnd_date.canonical_to_date(p_line_request_date_high),
336: fnd_date.canonical_to_date(p_sch_ship_date_low),
337: fnd_date.canonical_to_date(p_sch_ship_date_high),
338: fnd_date.canonical_to_date(p_sch_arrival_date_low),
339: fnd_date.canonical_to_date(p_sch_arrival_date_high)
340: -- fnd_date.canonical_to_date(p_apply_sch_date)
341: INTO l_request_date_low,
342: l_request_date_high,

Line 339: fnd_date.canonical_to_date(p_sch_arrival_date_high)

335: fnd_date.canonical_to_date(p_line_request_date_high),
336: fnd_date.canonical_to_date(p_sch_ship_date_low),
337: fnd_date.canonical_to_date(p_sch_ship_date_high),
338: fnd_date.canonical_to_date(p_sch_arrival_date_low),
339: fnd_date.canonical_to_date(p_sch_arrival_date_high)
340: -- fnd_date.canonical_to_date(p_apply_sch_date)
341: INTO l_request_date_low,
342: l_request_date_high,
343: l_ordered_date_low,

Line 340: -- fnd_date.canonical_to_date(p_apply_sch_date)

336: fnd_date.canonical_to_date(p_sch_ship_date_low),
337: fnd_date.canonical_to_date(p_sch_ship_date_high),
338: fnd_date.canonical_to_date(p_sch_arrival_date_low),
339: fnd_date.canonical_to_date(p_sch_arrival_date_high)
340: -- fnd_date.canonical_to_date(p_apply_sch_date)
341: INTO l_request_date_low,
342: l_request_date_high,
343: l_ordered_date_low,
344: l_ordered_date_high,

Line 354: SELECT fnd_date.chardt_to_date(p_apply_sch_date)

350: l_sch_arrival_date_high
351: -- l_apply_sch_date
352: FROM DUAL;
353:
354: SELECT fnd_date.chardt_to_date(p_apply_sch_date)
355: INTO l_apply_sch_date
356: FROM dual;
357:
358: IF l_debug_level > 0 THEN