APPS.ONT_OEXOEIOS_XMLP_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 183: OE_TRANSACTION_TYPES_TL OEOT

179: SELECT
180: OEOT.NAME
181: INTO L_ORDER_TYPE_LOW
182: FROM
183: OE_TRANSACTION_TYPES_TL OEOT
184: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LOW
185: AND OEOT.LANGUAGE = USERENV('LANG');
186: SELECT
187: OEOT.NAME

Line 190: OE_TRANSACTION_TYPES_TL OEOT

186: SELECT
187: OEOT.NAME
188: INTO L_ORDER_TYPE_HIGH
189: FROM
190: OE_TRANSACTION_TYPES_TL OEOT
191: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HIGH
192: AND OEOT.LANGUAGE = USERENV('LANG');
193: ELSIF (P_ORDER_TYPE_LOW IS NOT NULL) THEN
194: LP_ORDER_TYPE := 'and ot.transaction_type_id >= :p_order_type_low ';

Line 199: OE_TRANSACTION_TYPES_TL OEOT

195: SELECT
196: OEOT.NAME
197: INTO L_ORDER_TYPE_LOW
198: FROM
199: OE_TRANSACTION_TYPES_TL OEOT
200: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LOW
201: AND OEOT.LANGUAGE = USERENV('LANG');
202: ELSIF (P_ORDER_TYPE_HIGH IS NOT NULL) THEN
203: LP_ORDER_TYPE := 'and ot.transaction_type_id <= :p_order_type_high ';

Line 208: OE_TRANSACTION_TYPES_TL OEOT

204: SELECT
205: OEOT.NAME
206: INTO L_ORDER_TYPE_HIGH
207: FROM
208: OE_TRANSACTION_TYPES_TL OEOT
209: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HIGH
210: AND OEOT.LANGUAGE = USERENV('LANG');
211: END IF;
212: