<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: wangwei  
    $Date: 2016-5-30 下午4:28:35  
    $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
            ${@quotation_id}:=HN_CON_CONTRACT_PKG.create_con_quotation(
                                p_contract_id =>${@contract_id},
                                p_req_date =>to_date(${@req_date},'yyyy-mm-dd'),
                                p_note =>${@note},
                                p_user_id=>${/session/@user_id}
                                );
            end;
]]></bm:update-sql>
            <bm:parameters>
                <bm:parameter name="quotation_id" output="true" outputPath="@quotation_id"/>
            </bm:parameters>
        </bm:operation>
        <bm:operation name="delete">
            <bm:update-sql><![CDATA[
               begin
                 HN_CON_CONTRACT_PKG.CANCEL_CON_QUOTATION(p_quotation_id =>${@quotation_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_contract_quotation(
           p_quotation_id =>${@quotation_id}, 
           p_user_id =>${/session/@user_id}
           );
           end;
           ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>