<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: Calvin 
    $Date: 2017年12月29日10:58:38 
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
                SELECT
                    h.bp_id,
                    h.bp_id becr_id,
                    TO_CHAR(sysdate, 'YYYY-MM-DD') loan_date, --申请借款日期
                    h.CORPORATE_CODE name,                    --姓名
                    h.ID_NUMBER id_number,                   --身份证号
                    h.PHONE mobile,                           --手机号
                    h.card_number card_number,                --银行卡号
                    h.EMAIL
                FROM
                    hls_bp_master h
                WHERE
                    h.bp_id = ${@bp_id}
            ]]></bm:query-sql>
        </bm:operation>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
                BEGIN
                tongdun_interface_pkg.insert_vfs_itfc(p_batch_id => ${@batch_id},
                                        p_bp_id => ${@bp_id},
                                        p_json_list => ${@json_list},
                                        p_user_id => ${/session/@user_id});
                END;
            ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
