<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: Darming  
    $Date: 2017-12-28 下午5:45:36  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
           begin
  -- Call the procedure
  wx_financing_calculate_pkg.wx_calc_try(p_product_id => ${@product_id},
                                         p_promise_to_pay => ${@promise_to_pay},
                                         p_other_payment3 => ${@other_payment3},
                                         p_btb_total_fee => ${@btb_total_fee},
                                         p_btb_total_fee_pv  => ${@btb_total_fee_pv},
                                         p_btb_net_finance_amount => ${@btb_net_finance_amount},
                                         p_btb_finance_amount => ${@btb_finance_amount},
                             
                                         p_notarial_fee_payable => ${@notarial_fee_payable},
                                         p_margin_ratio => ${@margin_ratio},
                                         p_btb_int_rate_implicit => ${@btb_int_rate_implicit},
                                         p_commission_receivable  => ${@commission_receivable},
                                         p_hd_user_col_v01 => ${@hd_user_col_v01},
                                         p_down_payment_ratio => ${@down_payment_ratio},
                                       
                                         p_other_fee => ${@other_fee},
                                         p_other_fee3 => ${@other_fee3},
                                         p_lease_charge_ratio => ${@lease_charge_ratio},
                                        
                                         p_int_rate_display => ${@int_rate_display},
                                         
                                         p_deposit_ratio => ${@deposit_ratio},
                                        
                                         p_lease_times => ${@lease_times},
                                         p_annual_pay_times => ${@annual_pay_times},
                                         p_insurance_fee => ${@insurance_fee},
                                         p_hd_user_col_n05 => ${@hd_user_col_n05},
                                         p_btb_interest_margin => ${@btb_interest_margin},
                                         p_lease_item_price_agent => ${@lease_item_price_agent},
                                         
                                         p_price_list => ${@price_list},
                                         p_btb_fee_after_tax => ${@btb_fee_after_tax},
                                         p_lease_start_date => ${@lease_start_date},
                                         p_irr => ${@irr},
                                         p_h155hd_user_col_n13 => ${@h155hd_user_col_n13},
                                         p_hd_user_col_n14 => ${@hd_user_col_n14},
                                         p_third_party_deposit => ${@third_party_deposit},
                                        
                                         p_deposit_deduction => ${@deposit_deduction},
                                         p_base_rate_type => ${@base_rate_type},
                                         p_business_type => ${@business_type},
                                         p_document_category => ${@document_category},
                                         p_hd_user_col_v03 => ${@hd_user_col_v03},
                                         p_user_id => ${@user_id},
                                         p_calc_session_id => ${@calc_session_id},
                                         p_calc_successful => ${@calc_successful},
                                         p_warning_message => ${@warning_message});
end;

]]></bm:update-sql>
            <bm:parameters>
                <bm:parameter name="calc_session_id" dataType="java.lang.Long" input="true" output="true" outputPath="@calc_session_id"/>
            </bm:parameters>
        </bm:operation>
    </bm:operations>
</bm:model>
