<?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>
