<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
          select dbms_lob.substr(t.err_msg) as err_msg from hls_monthy_business_log t where t.csh_date = ${@csh_date}
                ]]>
            </bm:query-sql>
        </bm:operation>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
            	begin
            		hls_monthy_business_pkg.csh_transaction_confirm(
            			p_csh_date=>${@csh_date},
            			p_check_flag=>${@p_check_flag}
            		);
            	end;
            ]]></bm:update-sql>
            <bm:parameters>
                <bm:parameter name="p_check_flag" dataType="java.lang.String" input="false" output="true" outputPath="@p_check_flag"/>
            </bm:parameters>
        </bm:operation>
    </bm:operations>
</bm:model>
