<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="insert">
            <bm:parameters>
                <bm:parameter name="mail_list_id" dataType="java.lang.Long" input="false" output="true"/>
            </bm:parameters>
            <bm:update-sql><![CDATA[
                BEGIN
                  wx_ele_contract_pkg.send_email(p_user_id     => nvl(${/session/@user_id},1),
                                                 p_mail_to     => ${@mail_to},
                                                 p_id_no       => ${@id_no},
                                                 p_contract_id => ${@contract_id},
                                                 v_mail_list_id =>${@mail_list_id});
                END;
            ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
