ccx_getableinfo.lwm 1.55 KB
Newer Older
Spencer Chang's avatar
Spencer Chang committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: lpc 9874 
    $Date:  
    $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
                    hls_ccx_interface_pkg.getvalue(p_table_name => 'ccx_indexconsumecategories', p_chk_list_id => ${@chk_list_id}) ccx_indexconsumecategories,
                    hls_ccx_interface_pkg.getvalue(p_table_name => 'ccx_indexconsumecities', p_chk_list_id => ${@chk_list_id}) ccx_indexconsumecities,
                    hls_ccx_interface_pkg.getvalue(p_table_name => 'ccx_indexmonthconsumes', p_chk_list_id => ${@chk_list_id}) ccx_indexmonthconsumes,
                    hls_ccx_interface_pkg.getvalue(p_table_name => 'ccx_indexproperty', p_chk_list_id => ${@chk_list_id}) ccx_indexproperty,
                    hls_ccx_interface_pkg.getvalue(p_table_name => 'ccx_indextransbehavior', p_chk_list_id => ${@chk_list_id}) ccx_indextransbehavior,
                    hls_ccx_interface_pkg.getvalue(p_table_name => 'ccx_indextranscredits', p_chk_list_id => ${@chk_list_id}) ccx_indextranscredits,
                    hls_ccx_interface_pkg.getvalue(p_table_name => 'ccx_cashout', p_chk_list_id => ${@chk_list_id}) ccx_cashout,
                    hls_ccx_interface_pkg.getvalue(p_table_name => 'ccx_cardinfo', p_chk_list_id => ${@chk_list_id}) ccx_cardinfo
                FROM
                    dual
            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>