APPS.ONT_OEXPRPRS_XMLP_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 356: OE_TRANSACTION_TYPES_TL OEOT

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

Line 363: OE_TRANSACTION_TYPES_TL OEOT

359: SELECT
360: OEOT.NAME
361: INTO L_ORDER_TYPE_HIGH
362: FROM
363: OE_TRANSACTION_TYPES_TL OEOT
364: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HI
365: AND OEOT.LANGUAGE = USERENV('LANG');
366: ELSIF (P_ORDER_TYPE_LO IS NOT NULL) THEN
367: LP_ORDER_TYPE := 'and ot.transaction_type_id >= :p_order_type_lo ';

Line 372: OE_TRANSACTION_TYPES_TL OEOT

368: SELECT
369: OEOT.NAME
370: INTO L_ORDER_TYPE_LOW
371: FROM
372: OE_TRANSACTION_TYPES_TL OEOT
373: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LO
374: AND OEOT.LANGUAGE = USERENV('LANG');
375: ELSIF (P_ORDER_TYPE_HI IS NOT NULL) THEN
376: LP_ORDER_TYPE := 'and ot.transaction_type_id <= :p_order_type_hi ';

Line 381: OE_TRANSACTION_TYPES_TL OEOT

377: SELECT
378: OEOT.NAME
379: INTO L_ORDER_TYPE_HIGH
380: FROM
381: OE_TRANSACTION_TYPES_TL OEOT
382: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HI
383: AND OEOT.LANGUAGE = USERENV('LANG');
384: END IF;
385: IF (P_ORDER_NUM_LOW IS NOT NULL) AND (P_ORDER_NUM_HIGH IS NOT NULL) THEN