csh_asset_wfl.lwm 2.22 KB
<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: 38823
    $Date: 2022-01-19
    $Revision: 1
    $Purpose:
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false">
    <bm:operations>
        <bm:operation name="insert">
            <bm:parameters>
                <bm:parameter name="batch_id" output="true" outputPath="@batch_id"/>
            </bm:parameters>
            <bm:update-sql><![CDATA[
        declare
        v_batch_id  hl_asset_manage_fee_batch.batch_id%TYPE := hl_asset_manage_fee_batch_s.nextval;
        begin
         ${@batch_id} := v_batch_id;
         insert into hl_asset_manage_fee_batch
                         (batch_id,
                          wfl_instance_id,
                          wfl_status,
                          created_by,
                          creation_date,
                          last_updated_by,
                          last_update_date,
                          submit_date,
                          approved_date,
                          payment_req_id)
                          values
                          (v_batch_id,
                           null,
                           null,
                           ${/session/@user_id},
                           sysdate,
                           ${/session/@user_id},
                           sysdate,
                           null,
                           null,
                           null
                          );
        end;
            ]]></bm:update-sql>
        </bm:operation>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
   update hl_asset_manage_fee t1
   set t1.batch_id =${/parameter/@batch_id},
   t1.last_updated_by = ${/session/@user_id},
   t1.last_update_date = sysdate
   where t1.fee_id = ${@fee_id}
            ]]></bm:update-sql>
        </bm:operation>
        <bm:operation name="execute">
            <bm:update-sql><![CDATA[
            begin
              hl_asset_manage_fee_pkg.asset_fee_wfl_start(p_batch_id =>${/parameter/@batch_id},
                                                          p_user_id =>${/session/@user_id});
            end;
            ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>