<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="execute">
            <bm:update-sql><![CDATA[
                BEGIN
                    tre_loan_withdraw_flt_rate_pkg.bgfl_loan_withdraw_flt_tmp_ins(p_user_id =>${/session/@session_id}, 
                                                                                             p_withdraw_id =>${@withdraw_id},
                                                                                             p_batch_id =>${@batch_id});
                END;
            ]]></bm:update-sql>
            <bm:parameters>
                <bm:parameter name="batch_id" dataType="java.lang.Long" output="true" outputPath="@batch_id"/>
            </bm:parameters>
        </bm:operation>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
            BEGIN
                tre_loan_withdraw_flt_rate_pkg.bgfl_withdraw_flt_rate_update(p_batch_id =>${@batch_id},
                                               p_value_date =>to_date(${@value_date},'yyyy-mm-dd'), 
                                               p_int_rate =>${@int_rate}, 
                                               p_user_id =>${/session/@user_id});
            END;
            ]]></bm:update-sql>
        </bm:operation>
        <bm:operation name="delete">
            <bm:update-sql><![CDATA[
            BEGIN
                tre_loan_withdraw_flt_rate_pkg.bgfl_loan_withdraw_flt_tmp_del(p_user_id =>${/session/@session_id});
            END;
            ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
