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),
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),
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),
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),
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),
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),
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),
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)
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,
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,
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,
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,