APPS.ONT_OEXOEUBD_XMLP_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 79: OE_TRANSACTION_TYPES_TL OEOT

75: SELECT
76: OEOT.NAME
77: INTO L_ORDER_TYPE_LOW
78: FROM
79: OE_TRANSACTION_TYPES_TL OEOT
80: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LOW
81: AND OEOT.LANGUAGE = USERENV('LANG');
82: SELECT
83: OEOT.NAME

Line 86: OE_TRANSACTION_TYPES_TL OEOT

82: SELECT
83: OEOT.NAME
84: INTO L_ORDER_TYPE_HIGH
85: FROM
86: OE_TRANSACTION_TYPES_TL OEOT
87: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HIGH
88: AND OEOT.LANGUAGE = USERENV('LANG');
89: ELSIF (P_ORDER_TYPE_LOW IS NOT NULL) THEN
90: LP_ORDER_TYPE := 'and ot.transaction_type_id >= :p_order_type_low ';

Line 95: OE_TRANSACTION_TYPES_TL OEOT

91: SELECT
92: OEOT.NAME
93: INTO L_ORDER_TYPE_LOW
94: FROM
95: OE_TRANSACTION_TYPES_TL OEOT
96: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LOW
97: AND OEOT.LANGUAGE = USERENV('LANG');
98: ELSIF (P_ORDER_TYPE_HIGH IS NOT NULL) THEN
99: LP_ORDER_TYPE := 'and ot.transaction_type_id <= :p_order_type_high ';

Line 104: OE_TRANSACTION_TYPES_TL OEOT

100: SELECT
101: OEOT.NAME
102: INTO L_ORDER_TYPE_HIGH
103: FROM
104: OE_TRANSACTION_TYPES_TL OEOT
105: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HIGH
106: AND OEOT.LANGUAGE = USERENV('LANG');
107: END IF;
108: END;