APPS.ONT_OEXOEOSR_XMLP_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 349: OE_TRANSACTION_TYPES_TL OEOT

345: SELECT
346: OEOT.NAME
347: INTO L_ORDER_TYPE_LOW
348: FROM
349: OE_TRANSACTION_TYPES_TL OEOT
350: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LOW
351: AND OEOT.LANGUAGE = USERENV('LANG');
352: ELSE
353: LP_ORDER_TYPE := 'and ( ot.transaction_type_id between :p_order_type_low and :p_order_type_high ) ';

Line 358: OE_TRANSACTION_TYPES_TL OEOT

354: SELECT
355: OEOT.NAME
356: INTO L_ORDER_TYPE_LOW
357: FROM
358: OE_TRANSACTION_TYPES_TL OEOT
359: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LOW
360: AND OEOT.LANGUAGE = USERENV('LANG');
361: SELECT
362: OEOT.NAME

Line 365: OE_TRANSACTION_TYPES_TL OEOT

361: SELECT
362: OEOT.NAME
363: INTO L_ORDER_TYPE_HIGH
364: FROM
365: OE_TRANSACTION_TYPES_TL OEOT
366: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HIGH
367: AND OEOT.LANGUAGE = USERENV('LANG');
368: END IF;
369: ELSIF (P_ORDER_TYPE_LOW IS NOT NULL) THEN

Line 375: OE_TRANSACTION_TYPES_TL OEOT

371: SELECT
372: OEOT.NAME
373: INTO L_ORDER_TYPE_LOW
374: FROM
375: OE_TRANSACTION_TYPES_TL OEOT
376: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LOW
377: AND OEOT.LANGUAGE = USERENV('LANG');
378: ELSIF (P_ORDER_TYPE_HIGH IS NOT NULL) THEN
379: LP_ORDER_TYPE := 'and ot.transaction_type_id <= :p_order_type_high ';

Line 384: OE_TRANSACTION_TYPES_TL OEOT

380: SELECT
381: OEOT.NAME
382: INTO L_ORDER_TYPE_HIGH
383: FROM
384: OE_TRANSACTION_TYPES_TL OEOT
385: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HIGH
386: AND OEOT.LANGUAGE = USERENV('LANG');
387: END IF;
388: IF (P_CUSTOMER_NAME_LOW IS NOT NULL) AND (P_CUSTOMER_NAME_HIGH IS NOT NULL) THEN