70: SELECT
71: OEOT.NAME
72: INTO L_ORDER_TYPE_LOW
73: FROM
74: OE_TRANSACTION_TYPES_TL OEOT
75: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LO
76: AND OEOT.LANGUAGE = USERENV('LANG');
77: SELECT
78: OEOT.NAME
77: SELECT
78: OEOT.NAME
79: INTO L_ORDER_TYPE_HIGH
80: FROM
81: OE_TRANSACTION_TYPES_TL OEOT
82: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HI
83: AND OEOT.LANGUAGE = USERENV('LANG');
84: ELSIF P_ORDER_TYPE_LO IS NULL AND P_ORDER_TYPE_HI IS NOT NULL THEN
85: LP_WHERE_CLAUSE := 'ot.transaction_type_id = ''' || P_ORDER_TYPE_HI || ''' and';
86: SELECT
87: OEOT.NAME
88: INTO L_ORDER_TYPE_LOW
89: FROM
90: OE_TRANSACTION_TYPES_TL OEOT
91: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LO
92: AND OEOT.LANGUAGE = USERENV('LANG');
93: ELSIF P_ORDER_TYPE_LO IS NOT NULL AND P_ORDER_TYPE_HI IS NULL THEN
94: LP_WHERE_CLAUSE := 'ot.transaction_type_id = ''' || P_ORDER_TYPE_LO || ''' and';
95: SELECT
96: OEOT.NAME
97: INTO L_ORDER_TYPE_HIGH
98: FROM
99: OE_TRANSACTION_TYPES_TL OEOT
100: WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HI
101: AND OEOT.LANGUAGE = USERENV('LANG');
102: ELSE
103: LP_WHERE_CLAUSE := ' ';