105:
106:
107: CURSOR Get_Order_Type_id(p_type_id IN NUMBER ,p_type_name IN VARCHAR2) IS
108: SELECT transaction_type_id
109: FROM oe_transaction_types_tl
110: WHERE p_type_id IS NOT NULL
111: AND transaction_type_id = p_type_id
112: UNION All
113: SELECT transaction_type_id
110: WHERE p_type_id IS NOT NULL
111: AND transaction_type_id = p_type_id
112: UNION All
113: SELECT transaction_type_id
114: FROM oe_transaction_types_tl
115: WHERE p_type_id IS NULL
116: AND name = p_type_name;
117:
118: