<?xml version="1.0" encoding="UTF-8"?>
<!--$Author: qianming  
    $Date: 2015-9-16 上午11:15:53  
    $Revision: 1.0  
    $Purpose: OA待办推送查询
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:fields>
        <bm:field name="user_id"/>
        <bm:field name="user_desc"/>
        <bm:field name="oa_user"/>
        <bm:field name="oa_key"/>
        <bm:field name="oa_to_do_count"/>
    </bm:fields>
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
            	select 
					user_id,
					user_desc,
					oa_user,
					oa_key,
					oa_to_do_count
				from bgfl_oa_recipient_v
			]]></bm:query-sql>
        </bm:operation>
        <bm:operation name="execute">
            <bm:update-sql><![CDATA[
        	
        	begin
	        	bgfl_oa_backlog_pkg.create_log(p_user_id => ${@user_id},
	                                 p_oa_return => ${@oa_return});
	        end;
        	
        	]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
