APPS.ONT_OEXIODIS_XMLP_PKG dependencies on OE_LOOKUPS

Line 213: OE_LOOKUPS

209: SELECT
210: MEANING
211: INTO ITEM_DISPLAY_MEANING
212: FROM
213: OE_LOOKUPS
214: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY_CODE'
215: AND LOOKUP_CODE = P_PRINT_DESCRIPTION;
216: RP_ITEM_DISPLAY_METHOD := ITEM_DISPLAY_MEANING;
217: EXCEPTION

Line 228: OE_LOOKUPS

224: SELECT
225: MEANING
226: INTO OPEN_ORDER_ONLY
227: FROM
228: OE_LOOKUPS
229: WHERE LOOKUP_TYPE = 'YES_NO'
230: AND LOOKUP_CODE = P_OPEN_ORDER_ONLY;
231: RP_OPEN_ORDER_ONLY := OPEN_ORDER_ONLY;
232: EXCEPTION

Line 243: OE_LOOKUPS

239: SELECT
240: MEANING
241: INTO ORDER_BY
242: FROM
243: OE_LOOKUPS
244: WHERE LOOKUP_TYPE = 'OEXIODIS ORDER BY'
245: AND LOOKUP_CODE = P_ORDER_BY;
246: RP_ORDER_BY := ORDER_BY;
247: EXCEPTION

Line 279: OE_LOOKUPS

275: SELECT
276: MEANING
277: INTO L_MEANING
278: FROM
279: OE_LOOKUPS
280: WHERE LOOKUP_TYPE = 'YES_NO'
281: AND LOOKUP_CODE = 'N';
282: ELSE
283: SELECT

Line 287: OE_LOOKUPS

283: SELECT
284: MEANING
285: INTO L_MEANING
286: FROM
287: OE_LOOKUPS
288: WHERE LOOKUP_TYPE = 'YES_NO'
289: AND LOOKUP_CODE = 'Y';
290: END IF;
291: RETURN (L_MEANING);