214: l_meaning VARCHAR2 (80);
215: BEGIN
216: SELECT MEANING
217: INTO l_meaning
218: FROM OE_LOOKUPS
219: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY_CODE'
220: AND LOOKUP_CODE = substr(upper(p_print_description),1,1)
221: ;
222:
229: l_meaning VARCHAR2 (80);
230: BEGIN
231: SELECT MEANING
232: INTO l_meaning
233: FROM OE_LOOKUPS
234: WHERE LOOKUP_TYPE = 'YES_NO'
235: AND LOOKUP_CODE = substr(upper(p_open_returns_only),1,1)
236: ;
237:
244: l_fc_display VARCHAR2(80);
245: BEGIN
246: select meaning
247: into l_fc_display
248: from oe_lookups
249: where lookup_type='YES_NO'
250: and lookup_code = p_use_functional_currency
251: ;
252:
429: SELECT
430: MEANING
431: INTO L_SORT_BY
432: FROM
433: OE_LOOKUPS
434: WHERE LOOKUP_CODE = P_ORDER_BY
435: AND LOOKUP_TYPE = 'OEXOEORS SORT BY';
436: RETURN (L_SORT_BY);
437: EXCEPTION