csh_transaction_update.lwm

<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: sf
    $Date: 2019-9-12 下午07:57:46
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
            begin
                update csh_transaction
                set LAST_UPDATE_DATE = sysdate,
                    last_updated_by  = ${/session/@user_id},
                    confirmed_flag   = 'ACCAUDITING'
                where transaction_id = ${@transaction_id}
                  and confirmed_flag in ('NEW','CT_REJECTED');
            end;
            ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>