deduction_write_off.lwm 1.14 KB
Newer Older
Spencer Chang's avatar
Spencer Chang committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="execute">
            <bm:update-sql><![CDATA[
                begin
                    CSH_WRITE_OFF_PKG.DEDUCTION_WRITE_OFF
                    (
                        p_session_id=>${/session/@session_id},
                        p_company_id=>${@company_id},
                        p_bp_id=>${@bp_id_tenant},
                        p_transaction_date=>to_date(${@transaction_date},'YYYY-MM-DD'),
                        p_description=>${@transaction_description},
                        p_user_id=>${/session/@user_id},
                        p_transaction_id=>${@transaction_id}
                    );
                end;]]></bm:update-sql>
        </bm:operation>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
        		
        		begin
        		  csh_transaction_wfl_pkg.wf_workflow_start(p_session_id => ${/session/@session_id},p_user_id => ${/session/@user_id});
        		end;
        		
        	]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>