hls_attachment_tmp.lwm

<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: trd
    $Date: 2023-03-21 14:20:22
    $Revision: 1.0
    $Purpose:
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="delete">
            <bm:update-sql><![CDATA[
            	begin
            	   delete from hls_journal_imp_tem ot where ot.session_id = ${/session/@session_id};
            	end;
            ]]></bm:update-sql>
        </bm:operation>
          <bm:operation name="insert">
                    <bm:update-sql><![CDATA[
                     BEGIN
                        INSERT INTO hls_journal_imp_tem
                           (session_id, journal_header_id)
                         VALUES
                           (${/session/@session_id}, ${@journal_header_id});
                        END;
                    ]]></bm:update-sql>
          </bm:operation>
         <bm:operation name="query">
            <bm:query-sql><![CDATA[
              select ot.journal_header_id from hls_journal_imp_tem ot where ot.session_id = ${/session/@session_id}
            ]]></bm:query-sql>
                </bm:operation>
    </bm:operations>
</bm:model>