<?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:update-sql><![CDATA[
                BEGIN
                    ${@change_req_id}:=hn_con_contract_pkg.create_con_account_change_req(p_contract_id =>${@contract_id},
                                         p_req_date =>to_date(${@req_date},'YYYY-MM-DD'),
                                         p_user_id  =>${/session/@user_id});
                END;
            ]]></bm:update-sql>
            <bm:parameters>
                <bm:parameter name="change_req_id" output="true" outputPath="@change_req_id"/>
            </bm:parameters>
        </bm:operation>
        <bm:operation name="delete">
            <bm:update-sql><![CDATA[
                BEGIN
                    hn_con_contract_pkg.cancel_con_account_change_req(p_change_req_id =>${@change_req_id},
                                         p_user_id  =>${/session/@user_id});
                END;
            ]]></bm:update-sql>
        </bm:operation>
        <bm:operation name="execute">
            <bm:update-sql><![CDATA[
                BEGIN
                    hn_con_contract_pkg.submit_con_account_change_req(p_change_req_id =>${@change_req_id},
                    						p_contract_id =>${@contract_id},
                    						p_company_id  =>${/session/@company_id},
                                         p_user_id  =>${/session/@user_id});
                END;
            ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
