oracle 8.1.6 select ec_gift_certificate_balance(:user_id) from dual select ec_order_gift_cert_amount(:order_id) from dual select nvl(sum(i.price_charged),0) - nvl(sum(i.price_refunded),0) as soft_goods_cost from ec_items i, ec_products p where i.order_id = :order_id and i.item_state <> 'void' and i.product_id = p.product_id and p.no_shipping_avail_p = 't' select nvl(sum(i.price_charged),0) - nvl(sum(i.price_refunded),0) as hard_goods_cost from ec_items i, ec_products p where i.order_id = :order_id and i.item_state <> 'void' and i.product_id = p.product_id and p.no_shipping_avail_p = 'f' insert into ec_financial_transactions (transaction_id, order_id, transaction_amount, transaction_type, inserted_date) values (:transaction_id, :order_id, :transaction_amount, 'charge', sysdate) update ec_financial_transactions set authorized_date = sysdate where transaction_id = :transaction_id update ec_financial_transactions set authorized_date = sysdate, to_be_captured_p = 't', to_be_captured_date = sysdate where transaction_id = :transaction_id update ec_financial_transactions set to_be_captured_p = 't', to_be_captured_date = sysdate where transaction_id = :transaction_id insert into ec_problems_log (problem_id, problem_date, problem_details, order_id) values (ec_problem_id_sequence.nextval, sysdate, :problem_details, :order_id) update ec_financial_transactions set marked_date = sysdate where transaction_id = :pgw_transaction_id