<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false">
    <bm:operations>
        <bm:operation name="execute">
            <bm:parameters>
                <bm:parameter name="contract_id" dataType="java.lang.Long" input="true" output="false"/>
                <bm:parameter name="insurance_rate" dataType="java.lang.Double" input="false" output="true"/>
                <bm:parameter name="insurance_fee" dataType="java.lang.Double" input="false" output="true"/>
            </bm:parameters>
            <bm:update-sql><![CDATA[
                begin
                ins_insurance_pkg.calc_ccr_insurance(p_contract_id    =>${@contract_id},
                               p_ccr_outstanding_times =>${@ccr_outstanding_times},
                               p_ccr_start_times	  =>${@ccr_start_times},
                               p_user_id              =>${/session/@user_id},
                               p_rate                 =>${@insurance_rate},
                               p_insurance_fee        =>${@insurance_fee});
                   
                end;]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
