<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: Harry
    $Date: 2018-8-1 下午4:45:08
    $Revision: 1.0
    $Purpose:
-->
<bm:model xmlns:o="leaf.database.local.oracle" xmlns:f="leaf.database.features"
          xmlns:bm="http://www.leaf-framework.org/schema/bm" alias="t1" baseTable="CSH_RECEIPT_BANK_ACCOUNT">

    <bm:operations>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
                BEGIN
                      csh_bank_account_pkg.update_status_cancel(p_receipt_account_id => ${@receipt_account_id}, p_user_id => ${/session/@user_id});

                END;
            ]]></bm:update-sql>
        </bm:operation>


        <bm:operation name="execute">
            <bm:update-sql><![CDATA[
                BEGIN
                      csh_bank_account_pkg.save_bank_account(p_bank_account_number => ${@bank_account_number},
                                                             p_bank_account_name => ${@bank_account_name},
                                                             p_bank_name => ${@bank_name},
                                                             p_vender_bp_id        => ${@vender_bp_id},
                                                             p_status => ${@status},
                                                             p_user_id => ${/session/@user_id});

                END;
            ]]></bm:update-sql>
        </bm:operation>


    </bm:operations>

</bm:model>
