eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_BATCH_PRICING dependencies on FND_DATE

Line 268: select FND_DATE.Canonical_To_Date(p_order_date_low),

264: oe_debug_pub.add('Before converting Canonical to Date', 5);
265: END IF;
266:
267: /* Convert Strings to Dates */
268: select FND_DATE.Canonical_To_Date(p_order_date_low),
269: FND_DATE.Canonical_To_Date(p_order_date_high),
270: FND_DATE.Canonical_To_Date(p_order_creation_date_low),
271: FND_DATE.Canonical_To_Date(p_order_creation_date_high),
272: FND_DATE.CHARDT_TO_DATE(p_line_creation_date_low),

Line 269: FND_DATE.Canonical_To_Date(p_order_date_high),

265: END IF;
266:
267: /* Convert Strings to Dates */
268: select FND_DATE.Canonical_To_Date(p_order_date_low),
269: FND_DATE.Canonical_To_Date(p_order_date_high),
270: FND_DATE.Canonical_To_Date(p_order_creation_date_low),
271: FND_DATE.Canonical_To_Date(p_order_creation_date_high),
272: FND_DATE.CHARDT_TO_DATE(p_line_creation_date_low),
273: FND_DATE.CHARDT_TO_DATE(p_line_creation_date_high),

Line 270: FND_DATE.Canonical_To_Date(p_order_creation_date_low),

266:
267: /* Convert Strings to Dates */
268: select FND_DATE.Canonical_To_Date(p_order_date_low),
269: FND_DATE.Canonical_To_Date(p_order_date_high),
270: FND_DATE.Canonical_To_Date(p_order_creation_date_low),
271: FND_DATE.Canonical_To_Date(p_order_creation_date_high),
272: FND_DATE.CHARDT_TO_DATE(p_line_creation_date_low),
273: FND_DATE.CHARDT_TO_DATE(p_line_creation_date_high),
274: FND_DATE.Canonical_To_Date(p_booked_date_low),

Line 271: FND_DATE.Canonical_To_Date(p_order_creation_date_high),

267: /* Convert Strings to Dates */
268: select FND_DATE.Canonical_To_Date(p_order_date_low),
269: FND_DATE.Canonical_To_Date(p_order_date_high),
270: FND_DATE.Canonical_To_Date(p_order_creation_date_low),
271: FND_DATE.Canonical_To_Date(p_order_creation_date_high),
272: FND_DATE.CHARDT_TO_DATE(p_line_creation_date_low),
273: FND_DATE.CHARDT_TO_DATE(p_line_creation_date_high),
274: FND_DATE.Canonical_To_Date(p_booked_date_low),
275: FND_DATE.Canonical_To_Date(p_booked_date_high),

Line 272: FND_DATE.CHARDT_TO_DATE(p_line_creation_date_low),

268: select FND_DATE.Canonical_To_Date(p_order_date_low),
269: FND_DATE.Canonical_To_Date(p_order_date_high),
270: FND_DATE.Canonical_To_Date(p_order_creation_date_low),
271: FND_DATE.Canonical_To_Date(p_order_creation_date_high),
272: FND_DATE.CHARDT_TO_DATE(p_line_creation_date_low),
273: FND_DATE.CHARDT_TO_DATE(p_line_creation_date_high),
274: FND_DATE.Canonical_To_Date(p_booked_date_low),
275: FND_DATE.Canonical_To_Date(p_booked_date_high),
276: FND_DATE.CHARDT_TO_DATE(p_pricing_date_low),

Line 273: FND_DATE.CHARDT_TO_DATE(p_line_creation_date_high),

269: FND_DATE.Canonical_To_Date(p_order_date_high),
270: FND_DATE.Canonical_To_Date(p_order_creation_date_low),
271: FND_DATE.Canonical_To_Date(p_order_creation_date_high),
272: FND_DATE.CHARDT_TO_DATE(p_line_creation_date_low),
273: FND_DATE.CHARDT_TO_DATE(p_line_creation_date_high),
274: FND_DATE.Canonical_To_Date(p_booked_date_low),
275: FND_DATE.Canonical_To_Date(p_booked_date_high),
276: FND_DATE.CHARDT_TO_DATE(p_pricing_date_low),
277: FND_DATE.CHARDT_TO_DATE(p_pricing_date_high),

Line 274: FND_DATE.Canonical_To_Date(p_booked_date_low),

270: FND_DATE.Canonical_To_Date(p_order_creation_date_low),
271: FND_DATE.Canonical_To_Date(p_order_creation_date_high),
272: FND_DATE.CHARDT_TO_DATE(p_line_creation_date_low),
273: FND_DATE.CHARDT_TO_DATE(p_line_creation_date_high),
274: FND_DATE.Canonical_To_Date(p_booked_date_low),
275: FND_DATE.Canonical_To_Date(p_booked_date_high),
276: FND_DATE.CHARDT_TO_DATE(p_pricing_date_low),
277: FND_DATE.CHARDT_TO_DATE(p_pricing_date_high),
278: FND_DATE.CHARDT_TO_DATE(p_schedule_ship_date_low),

Line 275: FND_DATE.Canonical_To_Date(p_booked_date_high),

271: FND_DATE.Canonical_To_Date(p_order_creation_date_high),
272: FND_DATE.CHARDT_TO_DATE(p_line_creation_date_low),
273: FND_DATE.CHARDT_TO_DATE(p_line_creation_date_high),
274: FND_DATE.Canonical_To_Date(p_booked_date_low),
275: FND_DATE.Canonical_To_Date(p_booked_date_high),
276: FND_DATE.CHARDT_TO_DATE(p_pricing_date_low),
277: FND_DATE.CHARDT_TO_DATE(p_pricing_date_high),
278: FND_DATE.CHARDT_TO_DATE(p_schedule_ship_date_low),
279: FND_DATE.CHARDT_TO_DATE(p_schedule_ship_date_high)

Line 276: FND_DATE.CHARDT_TO_DATE(p_pricing_date_low),

272: FND_DATE.CHARDT_TO_DATE(p_line_creation_date_low),
273: FND_DATE.CHARDT_TO_DATE(p_line_creation_date_high),
274: FND_DATE.Canonical_To_Date(p_booked_date_low),
275: FND_DATE.Canonical_To_Date(p_booked_date_high),
276: FND_DATE.CHARDT_TO_DATE(p_pricing_date_low),
277: FND_DATE.CHARDT_TO_DATE(p_pricing_date_high),
278: FND_DATE.CHARDT_TO_DATE(p_schedule_ship_date_low),
279: FND_DATE.CHARDT_TO_DATE(p_schedule_ship_date_high)
280: into l_order_date_low,

Line 277: FND_DATE.CHARDT_TO_DATE(p_pricing_date_high),

273: FND_DATE.CHARDT_TO_DATE(p_line_creation_date_high),
274: FND_DATE.Canonical_To_Date(p_booked_date_low),
275: FND_DATE.Canonical_To_Date(p_booked_date_high),
276: FND_DATE.CHARDT_TO_DATE(p_pricing_date_low),
277: FND_DATE.CHARDT_TO_DATE(p_pricing_date_high),
278: FND_DATE.CHARDT_TO_DATE(p_schedule_ship_date_low),
279: FND_DATE.CHARDT_TO_DATE(p_schedule_ship_date_high)
280: into l_order_date_low,
281: l_order_date_high,

Line 278: FND_DATE.CHARDT_TO_DATE(p_schedule_ship_date_low),

274: FND_DATE.Canonical_To_Date(p_booked_date_low),
275: FND_DATE.Canonical_To_Date(p_booked_date_high),
276: FND_DATE.CHARDT_TO_DATE(p_pricing_date_low),
277: FND_DATE.CHARDT_TO_DATE(p_pricing_date_high),
278: FND_DATE.CHARDT_TO_DATE(p_schedule_ship_date_low),
279: FND_DATE.CHARDT_TO_DATE(p_schedule_ship_date_high)
280: into l_order_date_low,
281: l_order_date_high,
282: l_order_creation_date_low,

Line 279: FND_DATE.CHARDT_TO_DATE(p_schedule_ship_date_high)

275: FND_DATE.Canonical_To_Date(p_booked_date_high),
276: FND_DATE.CHARDT_TO_DATE(p_pricing_date_low),
277: FND_DATE.CHARDT_TO_DATE(p_pricing_date_high),
278: FND_DATE.CHARDT_TO_DATE(p_schedule_ship_date_low),
279: FND_DATE.CHARDT_TO_DATE(p_schedule_ship_date_high)
280: into l_order_date_low,
281: l_order_date_high,
282: l_order_creation_date_low,
283: l_order_creation_date_high,