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_ORDER_PURGE_PVT dependencies on FND_DATE

Line 215: SELECT fnd_date.canonical_to_date(p_ordered_date_low),

211: THEN
212: OE_DEBUG_PUB.Add('Inside select_where_cond_quote');
213: END IF;
214:
215: SELECT fnd_date.canonical_to_date(p_ordered_date_low),
216: fnd_date.canonical_to_date(p_ordered_date_high),
217: fnd_date.canonical_to_date(p_creation_date_low),
218: fnd_date.canonical_to_date(p_creation_date_high)
219: INTO l_ordered_date_low,

Line 216: fnd_date.canonical_to_date(p_ordered_date_high),

212: OE_DEBUG_PUB.Add('Inside select_where_cond_quote');
213: END IF;
214:
215: SELECT fnd_date.canonical_to_date(p_ordered_date_low),
216: fnd_date.canonical_to_date(p_ordered_date_high),
217: fnd_date.canonical_to_date(p_creation_date_low),
218: fnd_date.canonical_to_date(p_creation_date_high)
219: INTO l_ordered_date_low,
220: l_ordered_date_high,

Line 217: fnd_date.canonical_to_date(p_creation_date_low),

213: END IF;
214:
215: SELECT fnd_date.canonical_to_date(p_ordered_date_low),
216: fnd_date.canonical_to_date(p_ordered_date_high),
217: fnd_date.canonical_to_date(p_creation_date_low),
218: fnd_date.canonical_to_date(p_creation_date_high)
219: INTO l_ordered_date_low,
220: l_ordered_date_high,
221: l_creation_date_low,

Line 218: fnd_date.canonical_to_date(p_creation_date_high)

214:
215: SELECT fnd_date.canonical_to_date(p_ordered_date_low),
216: fnd_date.canonical_to_date(p_ordered_date_high),
217: fnd_date.canonical_to_date(p_creation_date_low),
218: fnd_date.canonical_to_date(p_creation_date_high)
219: INTO l_ordered_date_low,
220: l_ordered_date_high,
221: l_creation_date_low,
222: l_creation_date_high

Line 709: SELECT fnd_date.canonical_to_date(p_offer_exp_date_low),

705: OE_DEBUG_PUB.Add('Inside select_where_cond_quote');
706: END IF;
707:
708:
709: SELECT fnd_date.canonical_to_date(p_offer_exp_date_low),
710: fnd_date.canonical_to_date(p_offer_exp_date_high),
711: fnd_date.canonical_to_date(p_creation_date_low),
712: fnd_date.canonical_to_date(p_creation_date_high),
713: fnd_date.canonical_to_date(p_quote_date_low),

Line 710: fnd_date.canonical_to_date(p_offer_exp_date_high),

706: END IF;
707:
708:
709: SELECT fnd_date.canonical_to_date(p_offer_exp_date_low),
710: fnd_date.canonical_to_date(p_offer_exp_date_high),
711: fnd_date.canonical_to_date(p_creation_date_low),
712: fnd_date.canonical_to_date(p_creation_date_high),
713: fnd_date.canonical_to_date(p_quote_date_low),
714: fnd_date.canonical_to_date(p_quote_date_high)

Line 711: fnd_date.canonical_to_date(p_creation_date_low),

707:
708:
709: SELECT fnd_date.canonical_to_date(p_offer_exp_date_low),
710: fnd_date.canonical_to_date(p_offer_exp_date_high),
711: fnd_date.canonical_to_date(p_creation_date_low),
712: fnd_date.canonical_to_date(p_creation_date_high),
713: fnd_date.canonical_to_date(p_quote_date_low),
714: fnd_date.canonical_to_date(p_quote_date_high)
715: INTO l_offer_exp_date_low,

Line 712: fnd_date.canonical_to_date(p_creation_date_high),

708:
709: SELECT fnd_date.canonical_to_date(p_offer_exp_date_low),
710: fnd_date.canonical_to_date(p_offer_exp_date_high),
711: fnd_date.canonical_to_date(p_creation_date_low),
712: fnd_date.canonical_to_date(p_creation_date_high),
713: fnd_date.canonical_to_date(p_quote_date_low),
714: fnd_date.canonical_to_date(p_quote_date_high)
715: INTO l_offer_exp_date_low,
716: l_offer_exp_date_high,

Line 713: fnd_date.canonical_to_date(p_quote_date_low),

709: SELECT fnd_date.canonical_to_date(p_offer_exp_date_low),
710: fnd_date.canonical_to_date(p_offer_exp_date_high),
711: fnd_date.canonical_to_date(p_creation_date_low),
712: fnd_date.canonical_to_date(p_creation_date_high),
713: fnd_date.canonical_to_date(p_quote_date_low),
714: fnd_date.canonical_to_date(p_quote_date_high)
715: INTO l_offer_exp_date_low,
716: l_offer_exp_date_high,
717: l_creation_date_low,

Line 714: fnd_date.canonical_to_date(p_quote_date_high)

710: fnd_date.canonical_to_date(p_offer_exp_date_high),
711: fnd_date.canonical_to_date(p_creation_date_low),
712: fnd_date.canonical_to_date(p_creation_date_high),
713: fnd_date.canonical_to_date(p_quote_date_low),
714: fnd_date.canonical_to_date(p_quote_date_high)
715: INTO l_offer_exp_date_low,
716: l_offer_exp_date_high,
717: l_creation_date_low,
718: l_creation_date_high,