<?xml version="1.0" encoding="UTF-8"?>

<bm:model xmlns:f="leaf.database.features" xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>

        <bm:operation name="insert">
            <bm:update-sql><![CDATA[
                BEGIN
                csh_abc_import_pkg.att_import_bank_update_trx(
                p_doc_code => ${@doc_code},
                p_receipt_no => ${@receipt_no},
                p_bank_name => ${@bank_name},
                p_beneficiary_name => ${@beneficiary_name},
                p_bank_num => ${@bank_num},
                p_beneficiary_bank => ${@beneficiary_bank},
                p_payer_name => ${@payer_name},
                p_payer_number => ${@payer_number},
                p_payer_bank => ${@payer_bank},
                p_bank_receipt_date =>to_date(${@bank_receipt_date}, 'YYYY-MM-DD'),
                p_total_amount => ${@total_amount},
                p_purpose => ${@purpose},
                p_remark => ${@remark},
                p_zy => ${@zy},
                p_business_type => ${@business_type},
                p_contract1 => ${@contract1},
                p_gl_code => ${@gl_code},
                p_agencycode => ${@agencycode},
                p_client => ${@client},
                p_preprocess_code => ${@preprocess_code},
                p_agency => ${@agency},
                p_blcode => ${@blcode},
                p_slip_batch_id => ${@slip_batch_id},
                p_user_id => ${/session/@user_id}
                );
                END;
                ]]>
            </bm:update-sql>
        </bm:operation>

    </bm:operations>

</bm:model>
