<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="delete">
            <bm:update-sql><![CDATA[
    			delete from hl_hsbc_doc_temp t where t.session_id = ${/session/@session_id}
    		]]></bm:update-sql>
        </bm:operation>
        <bm:operation name="insert">
            <bm:update-sql><![CDATA[
            	begin
            		hl_hsbc_interface_pkg.insert_doc_temp_return(
            			  p_session_id=>${/session/@session_id},
			              p_return_id=>${@return_id},
			              p_return_transaction_id=>${@return_transaction_id},
			              p_tranamount =>${@this_return_amount},
			              p_user_id=>${/session/@user_id},
				          p_button_id => ${/parameter/@button_id}
            		);
            	end;
            ]]></bm:update-sql>
        </bm:operation>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
        		begin
				  hl_hsbc_interface_pkg.create_batch_return(p_session_id => ${/session/@session_id},
				                                       p_bank_account_id => ${@bank_account_id},
				                                       p_user_id => ${/session/@user_id});
				end;
        	]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
