<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: qwm  
    $Date: 2012-11-28 上午11:21:37  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
            /* select t.sql_statement sql_text
             from psr_report_headers t
            where t.report_header_id = 10081 */
            select psr_report_pkg.create_report(
            			p_report_header_id  =>${@report_header_id},
                        p_parameter_1       =>${@parameter_1},
                        p_parameter_1_value =>${@parameter_1_value},
                        p_parameter_2       =>${@parameter_2},
                        p_parameter_2_value =>${@parameter_2_value},
                        p_parameter_3       =>${@parameter_3},
                        p_parameter_3_value =>${@parameter_3_value},
                        p_parameter_4       =>${@parameter_4},
                        p_parameter_4_value =>${@parameter_4_value},
                        p_parameter_5       =>${@parameter_5},
                        p_parameter_5_value =>${@parameter_5_value},
                        p_parameter_6       =>${@parameter_6},
                        p_parameter_6_value =>${@parameter_6_value},
                        p_parameter_7       =>${@parameter_7},
                        p_parameter_7_value =>${@parameter_7_value},
                        p_parameter_8       =>${@parameter_8},
                        p_parameter_8_value =>${@parameter_8_value},
                        p_parameter_9       =>${@parameter_9},
                        p_parameter_9_value =>${@parameter_9_value},
                        p_user_id           =>${/session/@user_id}) sql_text from dual
            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:fields>
        <bm:field name="sql_text" databaseType="VARCHAR2" datatype="java.lang.String"/>
    </bm:fields>
</bm:model>
