oracle8.1.6 select order_id, ec_order_cost(order_id) as total_order_price from ec_orders where order_state = 'confirmed' and (sysdate - confirmed_date) > 1/96 insert into ec_problems_log (problem_id, problem_date, problem_details, order_id) values (ec_problem_id_sequence.nextval, sysdate, :problem_details, :order_id) select g.gift_certificate_id, t.transaction_id from ec_gift_certificates g, ec_financial_transactions t where g.gift_certificate_id=t.gift_certificate_id and g.gift_certificate_state = 'confirmed' and (sysdate - g.issue_date) > 1/96 update ec_financial_transactions set authorized_date=sysdate, to_be_captured_p='t' where transaction_id = :transaction_id update ec_gift_certificates set authorized_date = sysdate, gift_certificate_state = :cc_result where gift_certificate_id = :gift_certificate_id update ec_orders set order_state='expired', expired_date=sysdate where order_state='in_basket' and sysdate-in_basket_date > [util_memoize {ad_parameter -package_id [ec_id] CartDuration ecommerce} [ec_cache_refresh]] update ec_items set item_state='expired', expired_date=sysdate where item_state='in_basket' and order_id in (select order_id from ec_orders where order_state='expired') select transaction_id, order_id from ec_financial_transactions where to_be_captured_p='t' and sysdate-to_be_captured_date > 1/48 and authorized_date is null and failed_p='f' insert into ec_problems_log (problem_id, problem_date, problem_details, order_id) values (ec_problem_id_sequence.nextval, sysdate, :problem_details, :order_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 authorized_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=: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 settled_date=sysdate where transaction_id=:transaction_id select case when sign(1 - ((sysdate-marked_date)/2)) = -1 then 1 else 0 end from ec_financial_transactions 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) select transaction_id, order_id from ec_financial_transactions where transaction_type='refund' and sysdate - inserted_date > 1/48 and refunded_date is null and failed_p='f' update ec_financial_transactions set refunded_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 refunded_date=sysdate where transaction_id=:transaction_id update ec_financial_transactions set refund_settled_date=sysdate where transaction_id=:transaction_id select case when sign(1 - ((sysdate-refunded_date)/2)) = -1 then 1 else 0 end from ec_financial_transactions 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)