APPS.ONT_OEXIODIS_XMLP_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 28: OE_TRANSACTION_TYPES_TL OEOT

24: SELECT
25: OEOT.NAME
26: INTO L_ORDER_TYPE_LOW
27: FROM
28: OE_TRANSACTION_TYPES_TL OEOT
29: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LOW
30: AND OEOT.LANGUAGE = USERENV('LANG');
31: ELSE
32: LP_ORDER_DATE_LOW := ' ';

Line 44: OE_TRANSACTION_TYPES_TL OEOT

40: SELECT
41: OEOT.NAME
42: INTO L_ORDER_TYPE_HIGH
43: FROM
44: OE_TRANSACTION_TYPES_TL OEOT
45: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HIGH
46: AND OEOT.LANGUAGE = USERENV('LANG');
47: ELSE
48: LP_ORDER_DATE_HIGH := ' ';

Line 60: OE_TRANSACTION_TYPES_TL OEOT

56: SELECT
57: OEOT.NAME
58: INTO L_ORDER_TYPE_LOW
59: FROM
60: OE_TRANSACTION_TYPES_TL OEOT
61: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LOW
62: AND OEOT.LANGUAGE = USERENV('LANG');
63: ELSE
64: LP_ORDER_TYPE_LOW := ' ';

Line 76: OE_TRANSACTION_TYPES_TL OEOT

72: SELECT
73: OEOT.NAME
74: INTO L_ORDER_TYPE_HIGH
75: FROM
76: OE_TRANSACTION_TYPES_TL OEOT
77: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HIGH
78: AND OEOT.LANGUAGE = USERENV('LANG');
79: ELSE
80: LP_ORDER_TYPE_HIGH := ' ';