<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: sf $Date: 2019-01-14 16:29:48 $Revision: 1.0 $Purpose: --> <bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false"> <bm:operations> <bm:operation name="query"> <bm:query-sql><![CDATA[ select * from exp_emp_assign_e_v t1 #WHERE_CLAUSE# ]]></bm:query-sql> </bm:operation> <bm:operation name="update"> <bm:update-sql><![CDATA[ begin csh_transaction_pkg.update_muti_confirmed_flag( p_transaction_id =>${@transaction_id}, p_wanted_confirmed_flag =>${@wanted_confirmed_flag}, p_wanted_written_off_flag=>${@wanted_written_off_flag}, p_confirmed_by =>${@confirmed_by}, p_transaction_type =>${@transaction_type}, p_user_id =>${/session/@user_id} ); end; ]]></bm:update-sql> </bm:operation> <bm:operation name="insert"> <bm:update-sql><![CDATA[ ]]></bm:update-sql> </bm:operation> </bm:operations> <bm:query-fields> <bm:query-field name="user_id" queryOperator="="/> </bm:query-fields> </bm:model>