delete_payment_req.lwm 720 Bytes
Newer Older
Spencer Chang's avatar
Spencer Chang committed
1 2 3 4 5 6 7 8 9 10 11 12
<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: hp  
    $Date: 2014-12-15 下午2:34:31  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false">
    <bm:operations>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
            begin
niminmin's avatar
niminmin committed
13 14 15 16 17 18
           update csh_payment_req_hd t
            set t.approval_status='CANCEL',
                t.closed_flag='Y',
                t.last_updated_by=${/session/@user_id},
                t.last_update_date=sysdate
            where t.payment_req_id = ${@payment_req_id};
Spencer Chang's avatar
Spencer Chang committed
19 20 21 22 23
            end;
            ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>