<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: hp $Date: 2014-11-18 上午11:46:19 $Revision: 1.0 $Purpose: --> <bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="INS_INSURANCE_CONTENT" defaultOrderBy="t1.ref_n01 asc" needAccessControl="false"> <bm:fields> <bm:field name="content_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTENT_ID" prompt="INS_INSURANCE_CONTENT.CONTENT_ID"/> <bm:field name="project_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PROJECT_ID" prompt="INS_INSURANCE_CONTENT.PROJECT_ID"/> <bm:field name="clause_usage" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CLAUSE_USAGE" prompt="INS_INSURANCE_CONTENT.CLAUSE_USAGE"/> <bm:field name="templet_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TEMPLET_ID" prompt="INS_INSURANCE_CONTENT.TEMPLET_ID"/> <bm:field name="prj_project_bp_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PRJ_PROJECT_BP_ID" prompt="INS_INSURANCE_CONTENT.PRJ_PROJECT_BP_ID"/> <bm:field name="mortgage_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="MORTGAGE_ID" prompt="INS_INSURANCE_CONTENT.MORTGAGE_ID"/> <bm:field name="content_print_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTENT_PRINT_FLAG" prompt="INS_INSURANCE_CONTENT.CONTENT_PRINT_FLAG"/> <bm:field name="available_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="AVAILABLE_FLAG" prompt="INS_INSURANCE_CONTENT.AVAILABLE_FLAG"/> <bm:field name="sign_date" databaseType="DATE" datatype="java.util.Date" physicalName="SIGN_DATE" prompt="INS_INSURANCE_CONTENT.SIGN_DATE"/> <bm:field name="sign_place" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SIGN_PLACE" prompt="INS_INSURANCE_CONTENT.SIGN_PLACE"/> <bm:field name="signer_opposite_side" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SIGNER_OPPOSITE_SIDE" prompt="INS_INSURANCE_CONTENT.SIGNER_OPPOSITE_SIDE"/> <bm:field name="notary" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NOTARY" prompt="INS_INSURANCE_CONTENT.NOTARY"/> <bm:field name="ref_v01" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V01" prompt="INS_INSURANCE_CONTENT.REF_V01"/> <bm:field name="ref_v02" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V02" prompt="INS_INSURANCE_CONTENT.REF_V02"/> <bm:field name="ref_v03" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V03" prompt="INS_INSURANCE_CONTENT.REF_V03"/> <bm:field name="ref_v04" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V04" prompt="INS_INSURANCE_CONTENT.REF_V04"/> <bm:field name="ref_v05" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V05" prompt="INS_INSURANCE_CONTENT.REF_V05"/> <bm:field name="ref_n01" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N01" prompt="INS_INSURANCE_CONTENT.REF_N01"/> <bm:field name="ref_n02" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N02" prompt="INS_INSURANCE_CONTENT.REF_N02"/> <bm:field name="ref_n03" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N03" prompt="INS_INSURANCE_CONTENT.REF_N03"/> <bm:field name="ref_n04" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N04" prompt="INS_INSURANCE_CONTENT.REF_N04"/> <bm:field name="ref_n05" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N05" prompt="INS_INSURANCE_CONTENT.REF_N05"/> <bm:field name="ref_d01" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D01" prompt="INS_INSURANCE_CONTENT.REF_D01"/> <bm:field name="ref_d02" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D02" prompt="INS_INSURANCE_CONTENT.REF_D02"/> <bm:field name="ref_d03" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D03" prompt="INS_INSURANCE_CONTENT.REF_D03"/> <bm:field name="ref_d04" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D04" prompt="INS_INSURANCE_CONTENT.REF_D04"/> <bm:field name="ref_d05" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D05" prompt="INS_INSURANCE_CONTENT.REF_D05"/> <bm:field name="content_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTENT_NUMBER" prompt="INS_INSURANCE_CONTENT.CONTENT_NUMBER"/> <bm:field name="template_class" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TEMPLATE_CLASS" prompt="INS_INSURANCE_CONTENT.TEMPLATE_CLASS"/> <bm:field name="template_file" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TEMPLATE_FILE" prompt="INS_INSURANCE_CONTENT.TEMPLATE_FILE"/> <bm:field name="template_desc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TEMPLATE_DESC" prompt="INS_INSURANCE_CONTENT.TEMPLATE_DESC"/> <bm:field name="template_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TEMPLATE_CODE" prompt="INS_INSURANCE_CONTENT.TEMPLATE_CODE"/> <bm:field name="file_name"/> <bm:field name="file_path"/> </bm:fields> <bm:features> <f:standard-who/> </bm:features> <bm:primary-key> <bm:pk-field name="content_id"/> </bm:primary-key> <bm:query-fields> <bm:query-field field="content_print_flag" queryOperator="="/> <bm:query-field field="content_id" queryOperator="="/> <bm:query-field field="template_class" queryOperator="="/> </bm:query-fields> <bm:operations> <bm:operation name="execute"> <bm:update-sql><![CDATA[ begin ins_insurance_content_pkg.update_content_info(p_content_id =>to_number(${@content_id}), p_policy_id =>to_number(${@policy_id}), p_file_path =>${@file_path}, p_file_name =>${@file_name}, p_type =>${@type}, p_user_id => ${/session/@user_id}); end; ]]></bm:update-sql> </bm:operation> </bm:operations> </bm:model>