<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: xiang.zhang 
    $Date: 2016-05-24 上午11:15:04  
    $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
                    crm_deposit_receipt_pkg.save_bank_data
                    (
                        p_deposit_receipt_id=>${@deposit_receipt_id},
                        p_wait_write_off_flag => ${@wait_write_off_flag},
                        p_trx_type => ${@trx_type},
                        p_po_id=> ${@po_id},
                        p_user_id=>${/session/@user_id}
                    );
                end;]]></bm:update-sql>
        </bm:operation>
        <bm:operation name="insert">
            <bm:update-sql><![CDATA[
                BEGIN
                     tre_loan_con_export_pkg.upload_data(p_interface_header_id =>  ${@header_id},
                                      p_err_count => ${@err_count},
                                      p_loan_contract_id => ${@loan_contract_id},
                                      p_widthdrawal_plan_id => ${@widthdrawal_plan_id},
                                      p_user_id => ${/session/@user_id});  
                     
                END;
            ]]></bm:update-sql>
            <bm:parameters>
                <bm:parameter name="header_id"/>
                <bm:parameter name="err_count" dataType="java.lang.Long" output="true" outputPath="@err_count"/>
                <bm:parameter inputPath="/session/@user_id"/>
                <bm:parameter name="widthdrawal_plan_id"/>
            </bm:parameters>
        </bm:operation>
        <bm:operation name="delete">
            <bm:update-sql><![CDATA[
                BEGIN
                    delete from tre_loan_con_repayment_plan t where t.repayment_plan_id =  ${@repayment_plan_id};
                END;
            ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
