<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: ZLF  
    $Date: 2014-12-8 上午11:04:41  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="delete">
            <bm:update-sql><![CDATA[
                begin
                    delete from hlcm_comsn_reconcilia_wfl_temp t where t.session_id = ${/session/@session_id};
                end;
            ]]></bm:update-sql>
        </bm:operation>
        <bm:operation name="execute">
            <bm:update-sql><![CDATA[
                BEGIN
                    hlcm_comsn_reconcilia_pkg.create_comsn_wfl_temp(p_session_id => ${/session/@session_id},
                                                                   p_contract_id => ${@contract_id},
                                                                   p_user_id     => ${/session/@user_id});
                END;
            ]]></bm:update-sql>
        </bm:operation>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
                BEGIN
                    hlcm_comsn_reconcilia_pkg.comsn_submit(p_session_id   => ${/session/@session_id},
                                                           p_user_id      => ${/session/@user_id});
                END;
            ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
