<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: Administrator  
    $Date: 2017-8-21 下午4:50:13  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="update">
            <bm:parameters>
                <bm:parameter name="header_id" output="true" outputPath="@header_id"/>
                <bm:parameter name="error_code" output="true" outputPath="@error_code"/>
                <bm:parameter name="head_id" output="true" outputPath="@head_id"/>
            </bm:parameters>
            <bm:update-sql><![CDATA[
            begin
              hls_ebank_abc_pub_pkg.insert_fnd_interface_head(p_header_id =>${@header_id} ,
                                                p_file_name =>${@file_name} ,
                                                p_col_1     =>${@col_1} ,
                                                p_col_2     =>${@col_2}  ,
                                                p_col_3     => ${@col_3} ,
                                                p_col_4     =>${@col_4} ,
                                                p_col_5     =>${@col_5}  ,
                                                p_col_6     =>${@col_6}  ,
                                                p_col_7     =>${@col_7}  ,
                                                p_col_8     =>${@col_8}  ,
                                                p_col_9     =>${@col_9}  ,
                                                p_error_code  =>${@error_code},
                                                p_head_id  =>${@head_id},
                                                p_user_id   =>${/session/@user_id}  );
            end;
]]></bm:update-sql>
        </bm:operation>
        <bm:operation name="insert">
            <bm:update-sql><![CDATA[
               begin
                 hls_ebank_abc_pub_pkg.insert_fnd_interface_ln(p_header_id        =>${@header_id} ,
                                              p_line_number      =>${@line_number} ,
                                              p_contract_number  =>${@contract_number} ,
                                              p_bank_account_num =>${@bank_account_num} ,
                                              p_due_amount       =>${@due_amount} ,
                                              p_write_off_amount =>${@write_off_amount} ,
                                              p_currency_code    =>${@currency_code} ,
                                              p_write_off_date   =>${@write_off_date} ,
                                              p_withhold_id      =>${@withhold_id} ,
                                              p_withhold_note    =>${@withhold_note} ,
                                              p_head_id          =>${@head_id},
                                              p_user_id          =>${/session/@user_id} );
               end;
            ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
