<?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
                    DR_HLS_BP_MASTER_PKG.CREATE_BP_MASTER
                    (
                        p_bp_id=>${@bp_id},
                        p_id_number=>${@id_number},
                        p_bp_name=>${@bp_name},
                        p_bp_category=>${@bp_category},
                        p_bp_type=>${@bp_type},
                        p_bp_class=>${@bp_class},
                        p_id_type=>${@id_type},
                        p_id_card_no=>${@id_card_no},
                        p_work_unit=>${@work_unit},
                        p_cell_phone=>${@cell_phone},
                        p_email=>${@email},
                        p_work_unit_phone=>${@work_unit_phone},
                        p_user_id=>${@user_id},
                        p_company_id=>1,
                        p_gender=>${@gender},
                        p_phone=>${@phone},
                        p_date_of_birth=>to_date(${@date_of_birth},'yyyy-mm-dd'),
                        p_marital_status=>${@marital_status},
                        p_academic_background=>${@academic_background},
                        p_industry=>${@industry},
                        p_monthly_income=>${@monthly_income},
                        p_contact_person=>${@contact_person},
                        p_liv_province=>${@liv_province},
                        p_liv_city=>${@liv_city},
                        p_liv_district=>${@liv_district},
						p_liv_street=>${@liv_street},
                        p_organization_code=>${@organization_code},
                        p_legal_form=>${@legal_form},
                        p_business_license_num=>${@business_license_num},
                        p_founded_date=>to_date(${@founded_date},'yyyy-mm-dd'),
                        p_registered_capital=>${@registered_capital},
                        p_corporate_code=>${@corporate_code},
                        p_office_space=>${@office_space},
                        p_taxpayer_type=>${@taxpayer_type},
                        p_tax_registry_num=>${@tax_registry_num},
                        p_invoice_bp_address_phone_num=>${@invoice_bp_address_phone_num},
                        p_invoice_title=>${@invoice_title},
                        p_invoice_bp_bank_account=>${@invoice_bp_bank_account}
                    );
                end;]]></bm:update-sql>
            <bm:parameters>
                <bm:parameter name="bp_id" dataType="java.lang.Long" input="true" output="true" outputPath="@bp_id"/>
            </bm:parameters>
        </bm:operation>
    </bm:operations>
</bm:model>
