<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:o="leaf.database.local.oracle" xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="SDIC_FIN_PLAN_RPT_QUARTER_LN" defaultOrderBy="ln_id">
    <bm:fields>
        <bm:field name="ln_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LN_ID" prompt="SDIC_FIN_PLAN_RPT_QUARTER_LN.LN_ID"/>
        <bm:field name="hd_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="HD_ID" prompt="SDIC_FIN_PLAN_RPT_QUARTER_LN.HD_ID"/>
        <bm:field name="item_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ITEM_CODE" prompt="SDIC_FIN_PLAN_RPT_QUARTER_LN.ITEM_CODE"/>
        <bm:field name="item_description" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ITEM_DESCRIPTION" prompt="SDIC_FIN_PLAN_RPT_QUARTER_LN.ITEM_DESCRIPTION"/>
        <bm:field name="first_quarter_data" databaseType="NUMBER" datatype="java.lang.Long" physicalName="FIRST_QUARTER_DATA" prompt="SDIC_FIN_PLAN_RPT_QUARTER_LN.FIRST_QUARTER_DATA"/>
        <bm:field name="second_quarter_data" databaseType="NUMBER" datatype="java.lang.Long" physicalName="SECOND_QUARTER_DATA" prompt="SDIC_FIN_PLAN_RPT_QUARTER_LN.SECOND_QUARTER_DATA"/>
        <bm:field name="third_quarter_data" databaseType="NUMBER" datatype="java.lang.Long" physicalName="THIRD_QUARTER_DATA" prompt="SDIC_FIN_PLAN_RPT_QUARTER_LN.THIRD_QUARTER_DATA"/>
        <bm:field name="forth_quarter_data" databaseType="NUMBER" datatype="java.lang.Long" physicalName="FORTH_QUARTER_DATA" prompt="SDIC_FIN_PLAN_RPT_QUARTER_LN.FORTH_QUARTER_DATA"/>
        <bm:field name="current_year_plan_data" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CURRENT_YEAR_PLAN_DATA" prompt="SDIC_FIN_PLAN_RPT_QUARTER_LN.CURRENT_YEAR_PLAN_DATA"/>
        <bm:field name="order_seq" databaseType="NUMBER" datatype="java.lang.Long" physicalName="ORDER_SEQ" prompt="SDIC_FIN_PLAN_RPT_QUARTER_LN.ORDER_SEQ"/>
    </bm:fields>
    <bm:features>
        <f:standard-who/>
        <o:sequence-pk/>
    </bm:features>
    <bm:primary-key>
        <bm:pk-field name="ln_id"/>
    </bm:primary-key>
    <bm:operations>
        <bm:operation name="execute">
            <bm:update-sql><![CDATA[
                BEGIN
                    sdic_fin_plan_rpt_pkg.sdic_fin_plan_quarter_ln_ins(p_hd_id =>${@hd_id}, 
                                                                     p_user_id =>${/session/@user_id});
                END;
            ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
    <bm:data-filters>
        <bm:data-filter enforceOperations="query" expression="t1.hd_id=${@hd_id}"/>
    </bm:data-filters>
</bm:model>
