<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: gaoyang  
    $Date: 2013-5-23 下午04:23:02  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false">
    <bm:operations>
        <bm:operation name="insert">
            <bm:update-sql><![CDATA[
            	begin
           csh_write_off_pkg.execute_csh_write_off_temp(
            			  p_session_id=>${/session/@session_id},
			              p_write_off_type=>${@write_off_type},
			              p_transaction_category=>${@transaction_category},
			              p_transaction_type=>${@transaction_type},
			              p_write_off_date=>to_date(${@write_off_date},'yyyy-mm-dd hh24:mi:ss'),
			              p_write_off_due_amount=>${@deposit_amount},
			              p_write_off_principal=>${@write_off_principal},
			              p_write_off_interest=>${@write_off_interest},
			              p_write_off_penalty=>${@write_off_penalty},
			              p_write_off_due_amount_cny =>${@write_off_due_amount_cny},
                          p_write_off_principal_cny=>${@write_off_principal_cny},
                          p_write_off_interest_cny=>${@write_off_interest_cny},
                          p_exchange_rate=>${@exchange_rate},
			              p_company_id=>${/session/@company_id},
			              p_document_category=>${@document_category},
			              p_document_id=>${@contract_id},
			              p_document_line_id=>${@document_line_id},
			              p_penalty_cashflow_id=>${@penalty_cashflow_id},
			              p_description=>${@description},
			              p_user_id=>${/session/@user_id},
			              p_transaction_id=>${@transaction_id},
			              p_bp_id	=> ${@bp_id_agent_level1},
			              p_year_flag =>${@year_flag},
			              p_quarter_flag =>${@quarter_flag},
			              p_month_flag =>${@month_flag},
			              p_transfer_type =>${@transfer_type},
			              p_risk_in_dec => ${@risk_in_dec},
			              p_deposit_trans_type=>${@deposit_trans_type}
            		);
            	end;
            ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
