<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: SC
    $Date: 2022年11月23日20:40:09
    $Revision: 1.0
    $Purpose:
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false">
    <bm:operations>
        <bm:operation name="insert">
            <bm:update-sql><![CDATA[
                begin
                prj_project_lease_import_pkg.insert_lease_temp(p_header_id =>${@header_id},
                p_session_id=>${/session/@session_id},
                p_set_number=>${@set_number},
                p_lease_item_id=>${@lease_item_id},
                p_user_id=>${/session/@user_id},
                p_project_lease_item_id=>${@project_lease_item_id});
                end;
                ]]></bm:update-sql>
        </bm:operation>
        <bm:operation name="execute">
            <bm:update-sql><![CDATA[
                begin
                prj_project_lease_import_pkg.insert_lease_item_list(
                p_project_lease_item_id=>${@project_lease_item_id});
                end;
                ]]></bm:update-sql>
        </bm:operation>

        <bm:operation name="update">
            <bm:update-sql><![CDATA[
                begin
                prj_project_lease_import_pkg.update_lease_item_data_temp(
                p_prj_lease_item_list_id=>${@prj_lease_item_list_id},
                p_asset_name=>${@asset_name},
                p_specification=>${@specification},
                p_asset_num=>${@asset_num},
                p_asset_type=>${@asset_type},
                p_posted_date=>${@posted_date},
                p_price=>${@price},
                p_manufacturer=>${@manufacturer},
                p_set_number=>${@set_number},
                p_lease_num=>${@lease_num}
                );

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