<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: ldd  
    $Date: 2012-2-13 下午02:13:08  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="insert">
            <bm:parameters>
                <bm:parameter name="expense_report_type_id" dataType="java.lang.Long" input="true" output="false"/>
                <bm:parameter name="expense_object_type_id" dataType="java.lang.Long" input="true" output="false"/>
                <bm:parameter name="layout_position" dataType="java.lang.String" input="true" output="false"/>
                <bm:parameter name="layout_priority" dataType="java.lang.Long" input="true" output="false"/>
                <bm:parameter name="default_object_id" dataType="java.lang.Long" input="true" output="false"/>
                <bm:parameter name="created_by" dataType="java.lang.Long" input="true" output="false"/>
                <bm:parameter name="required_flag" dataType="java.lang.String" input="true" output="false"/>
                <bm:parameter name="exp_rep_ref_object_types_id" dataType="java.lang.Long" input="false" output="true"/>
            </bm:parameters>
            <bm:update-sql><![CDATA[
                begin
                    EXP_SOB_REPORT_TYPES_PKG.INSERT_EXP_SOB_REP_REF_OBJECT
                    (
                        p_expense_report_type_id=>${@expense_report_type_id},
                        p_expense_object_type_id=>${@expense_object_type_id},
                        p_layout_position=>${@layout_position},
                        p_layout_priority=>${@layout_priority},
                        p_default_object_id=>${@default_object_id},
                        p_created_by=>${/session/@user_id},
                        p_required_flag=>${@required_flag},
                        p_exp_rep_ref_object_types_id=>${@exp_rep_ref_object_types_id}
                    );
                end;]]></bm:update-sql>
        </bm:operation>
        <bm:operation name="update">
            <bm:parameters>
                <bm:parameter name="exp_rep_ref_object_types_id" dataType="java.lang.Long" input="true" output="false"/>
                <bm:parameter name="expense_report_type_id" dataType="java.lang.Long" input="true" output="false"/>
                <bm:parameter name="expense_object_type_id" dataType="java.lang.Long" input="true" output="false"/>
                <bm:parameter name="layout_position" dataType="java.lang.String" input="true" output="false"/>
                <bm:parameter name="layout_priority" dataType="java.lang.Long" input="true" output="false"/>
                <bm:parameter name="default_object_id" dataType="java.lang.Long" input="true" output="false"/>
                <bm:parameter name="last_updated_by" dataType="java.lang.Long" input="true" output="false"/>
                <bm:parameter name="required_flag" dataType="java.lang.String" input="true" output="false"/>
            </bm:parameters>
            <bm:update-sql><![CDATA[
                begin
                    EXP_SOB_REPORT_TYPES_PKG.UPDATE_EXP_SOB_REP_REF_OBJECT
                    (
                        p_exp_rep_ref_object_types_id=>${@exp_rep_ref_object_types_id},
                        p_expense_report_type_id=>${@expense_report_type_id},
                        p_expense_object_type_id=>${@expense_object_type_id},
                        p_layout_position=>${@layout_position},
                        p_layout_priority=>${@layout_priority},
                        p_default_object_id=>${@default_object_id},
                        p_last_updated_by=>${/session/@user_id},
                        p_required_flag=>${@required_flag}
                    );
                end;]]></bm:update-sql>
        </bm:operation>
        <bm:operation name="delete">
            <bm:parameters>
                <bm:parameter name="exp_rep_ref_object_types_id" dataType="java.lang.Long" input="true" output="false"/>
            </bm:parameters>
            <bm:update-sql><![CDATA[
                begin
                    EXP_SOB_REPORT_TYPES_PKG.DELETE_EXP_SOB_REP_REF_OBJECT
                    (
                        p_exp_rep_ref_object_types_id=>${@exp_rep_ref_object_types_id}
                    );
                end;]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
