APPS.ONT_OEXOEITR_XMLP_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 133: OE_TRANSACTION_TYPES_TL OEOT

129: SELECT
130: OEOT.NAME
131: INTO L_ORDER_TYPE_LOW
132: FROM
133: OE_TRANSACTION_TYPES_TL OEOT
134: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LOW
135: AND OEOT.LANGUAGE = USERENV('LANG');
136: SELECT
137: OEOT.NAME

Line 140: OE_TRANSACTION_TYPES_TL OEOT

136: SELECT
137: OEOT.NAME
138: INTO L_ORDER_TYPE_HIGH
139: FROM
140: OE_TRANSACTION_TYPES_TL OEOT
141: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HIGH
142: AND OEOT.LANGUAGE = USERENV('LANG');
143: ELSE
144: IF P_ORDER_TYPE_LOW IS NULL AND P_ORDER_TYPE_HIGH IS NOT NULL THEN

Line 150: OE_TRANSACTION_TYPES_TL OEOT

146: SELECT
147: OEOT.NAME
148: INTO L_ORDER_TYPE_HIGH
149: FROM
150: OE_TRANSACTION_TYPES_TL OEOT
151: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HIGH
152: AND OEOT.LANGUAGE = USERENV('LANG');
153: ELSE
154: IF P_ORDER_TYPE_LOW IS NOT NULL AND P_ORDER_TYPE_HIGH IS NULL THEN

Line 160: OE_TRANSACTION_TYPES_TL OEOT

156: SELECT
157: OEOT.NAME
158: INTO L_ORDER_TYPE_LOW
159: FROM
160: OE_TRANSACTION_TYPES_TL OEOT
161: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LOW
162: AND OEOT.LANGUAGE = USERENV('LANG');
163: ELSE
164: LP_ORDER_TYPE := ' ';