<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: gzj $Date: 2022-10-9 14:14:34 $Revision: 1.0 $Purpose: --> <bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false"> <!-- <bm:fields>--> <!-- <bm:field name="sbo_file_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ATTACH_FILE_NAME" prompt="HLS.ATTACH_FILE_NAME"/>--> <!-- <bm:field name="business_file_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ATTACH_FILE_NAME" prompt="HLS.ATTACH_FILE_NAME"/>--> <!-- </bm:fields>--> <bm:operations> <bm:operation name="query"> <bm:query-sql><![CDATA[ SELECT t.* , (SELECT sv.code_value_name FROM sys_code_values_v sv WHERE sv.code = 'HLS_REPORT_NAME' and sv.code_value = t.report_name and sv.code_enabled_flag = 'Y') report_name_desc, hls_sys_upload_pkg.get_atm_file_names(p_table_pk_value => t.tab_id, p_source_type => 'SBO_REPORT', p_user_id => 10423) AS sbo_file_name, hls_sys_upload_pkg.get_atm_file_names(p_table_pk_value => t.tab_id, p_source_type => 'BUSINESS_REPORT', p_user_id => 10423) AS business_file_name FROM con_monthly_statement t where t.monthly_date = (${@year}||${@month}) and t.history_flag = 'N' order by t.tab_id asc ]]></bm:query-sql> </bm:operation> <bm:operation name="update"> <bm:update-sql><![CDATA[ begin con_monthly_statement_pkg.create_monthly_statement(p_user_id =>${/session/@user_id}, p_date =>${@date}); end; ]]></bm:update-sql> </bm:operation> </bm:operations> </bm:model>