<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:query-fields><![CDATA[
    ]]></bm:query-fields>
    <bm:operations>
        <bm:operation name="insert">
            <bm:parameters>
                <bm:parameter name="record_id" dataType="java.lang.Long" inputPath="@record_id" output="true" outputPath="@record_id"/>
                <bm:parameter name="workflow_id" dataType="java.lang.Long" required="true"/>
                <bm:parameter name="deliver_reason" dataType="java.lang.String"/>
                <bm:parameter name="date_from" dataType="java.sql.Date" forInsert="true" forUpdate="true" required="true"/>
                <bm:parameter name="date_to" dataType="java.sql.Date" forInsert="true" forUpdate="true"/>
            </bm:parameters>
            <bm:update-sql><![CDATA[
                begin
				    zj_wfl_workflow_pkg.insert_workflow_deliver(
				                                        ${@record_id},
				                                        ${/session/@user_id}, 
				                                        ${@workflow_id},
				                                        ${@date_from}, 
				                                        ${@date_to},
				                                        ${@deliver_to_id}, 
				                                        ${@deliver_reason}, 
				                                        ${/session/@user_id}); 

                end;
            ]]></bm:update-sql>
        </bm:operation>
        <bm:operation name="update">
            <bm:parameters>
                <bm:parameter name="record_id" dataType="java.lang.Long" required="true"/>
                <bm:parameter name="workflow_id" dataType="java.lang.Long" required="true"/>
                <bm:parameter name="deliver_reason" dataType="java.lang.String"/>
                <bm:parameter name="date_from" dataType="java.sql.Date" forInsert="true" forUpdate="true" required="true"/>
                <bm:parameter name="date_to" dataType="java.sql.Date" forInsert="true" forUpdate="true"/>
            </bm:parameters>
            <bm:update-sql><![CDATA[
		        begin
		            zj_wfl_workflow_pkg.update_workflow_deliver(
                                                        ${@record_id},
                                                        ${/session/@user_id}, 
                                                        ${@workflow_id},
                                                        ${@date_from}, 
                                                        ${@date_to},
                                                        ${@deliver_to_id}, 
                                                        ${@deliver_reason},
                                                        ${/session/@user_id}); 
		
		        end;
            ]]></bm:update-sql>
        </bm:operation>
        <bm:operation name="delete">
            <bm:parameters>
                <bm:parameter name="record_id" dataType="java.lang.Long" required="true"/>
            </bm:parameters>
            <bm:update-sql><![CDATA[
                begin
		            zj_wfl_workflow_pkg.delete_workflow_deliver(
		                                          ${@record_id},
		                                          ${/session/@user_id}); 

                end;
            ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
    <bm:features/>
</bm:model>
