<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: qm $Date: 2014-4-21 上午10:00:36 $Revision: 1.0 $Purpose: --> <bm:model xmlns:o="leaf.database.local.oracle" xmlns:e="leaf.service.exception" xmlns:f="leaf.database.features" xmlns:bm="http://www.leaf-framework.org/schema/bm" alias="t1" baseTable="AST_CON_INSURANCE"> <bm:fields> <bm:field name="contract_id" databaseType="NUMBER" datatype="java.lang.Long" insertExpression="${/parameter/@contract_id}" physicalName="CONTRACT_ID" prompt="AST_CON_INSURANCE.CONTRACT_ID"/> <bm:field name="ast_con_car_insurance_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="AST_CON_CAR_INSURANCE_ID" prompt="AST_CON_INSURANCE.AST_CON_CAR_INSURANCE_ID"/> <bm:field name="item_detail_id" databaseType="NUMBER" datatype="java.lang.Long" insertExpression="${/parameter/@item_detail_id}" physicalName="ITEM_DETAIL_ID" prompt="AST_CON_INSURANCE.ITEM_DETAIL_ID"/> <bm:field name="bp_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_ID" prompt="AST_CON_INSURANCE.BP_ID"/> <bm:field name="insurance_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INSURANCE_NUMBER" prompt="AST_CON_INSURANCE.INSURANCE_NUMBER"/> <bm:field name="insurance_description" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INSURANCE_DESCRIPTION" prompt="AST_CON_INSURANCE.INSURANCE_DESCRIPTION"/> <bm:field name="insure_date" databaseType="DATE" datatype="java.util.Date" physicalName="INSURE_DATE" prompt="AST_CON_INSURANCE.INSURE_DATE"/> <bm:field name="insurance_date_from" databaseType="DATE" datatype="java.util.Date" physicalName="INSURANCE_DATE_FROM" prompt="AST_CON_INSURANCE.INSURANCE_DATE_FROM"/> <bm:field name="insurance_date_to" databaseType="DATE" datatype="java.util.Date" physicalName="INSURANCE_DATE_TO" prompt="AST_CON_INSURANCE.INSURANCE_DATE_TO"/> <bm:field name="insurance_year" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INSURANCE_YEAR" prompt="AST_CON_INSURANCE.INSURANCE_YEAR"/> <bm:field name="compulsory_insurance_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COMPULSORY_INSURANCE_AMOUNT" prompt="AST_CON_INSURANCE.COMPULSORY_INSURANCE_AMOUNT"/> <bm:field name="commercial_insurance_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COMMERCIAL_INSURANCE_AMOUNT" prompt="AST_CON_INSURANCE.COMMERCIAL_INSURANCE_AMOUNT"/> <bm:field name="damage_insurance_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DAMAGE_INSURANCE_FLAG" prompt="AST_CON_INSURANCE.DAMAGE_INSURANCE_FLAG"/> <bm:field name="third_party_insurance_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="THIRD_PARTY_INSURANCE_FLAG" prompt="AST_CON_INSURANCE.THIRD_PARTY_INSURANCE_FLAG"/> <bm:field name="pilfer_insurance_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PILFER_INSURANCE_FLAG" prompt="AST_CON_INSURANCE.PILFER_INSURANCE_FLAG"/> <bm:field name="basic_non_deductible_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BASIC_NON_DEDUCTIBLE_FLAG" prompt="AST_CON_INSURANCE.BASIC_NON_DEDUCTIBLE_FLAG"/> <bm:field name="glass_insurance_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GLASS_INSURANCE_FLAG" prompt="AST_CON_INSURANCE.GLASS_INSURANCE_FLAG"/> <bm:field name="seat_insurance_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SEAT_INSURANCE_FLAG" prompt="AST_CON_INSURANCE.SEAT_INSURANCE_FLAG"/> <bm:field name="combustion_insurance_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMBUSTION_INSURANCE_FLAG" prompt="AST_CON_INSURANCE.COMBUSTION_INSURANCE_FLAG"/> <bm:field name="add_non_deductible_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ADD_NON_DEDUCTIBLE_FLAG" prompt="AST_CON_INSURANCE.ADD_NON_DEDUCTIBLE_FLAG"/> <bm:field name="ref_v01" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V01" prompt="AST_CON_INSURANCE.REF_V01"/> <bm:field name="ref_v02" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V02" prompt="AST_CON_INSURANCE.REF_V02"/> <bm:field name="ref_v03" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V03" prompt="AST_CON_INSURANCE.REF_V03"/> <bm:field name="ref_v04" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V04" prompt="AST_CON_INSURANCE.REF_V04"/> <bm:field name="ref_v05" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V05" prompt="AST_CON_INSURANCE.REF_V05"/> <bm:field name="ref_n01" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N01" prompt="AST_CON_INSURANCE.REF_N01"/> <bm:field name="ref_n02" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N02" prompt="AST_CON_INSURANCE.REF_N02"/> <bm:field name="ref_n03" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N03" prompt="AST_CON_INSURANCE.REF_N03"/> <bm:field name="ref_n04" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N04" prompt="AST_CON_INSURANCE.REF_N04"/> <bm:field name="ref_n05" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N05" prompt="AST_CON_INSURANCE.REF_N05"/> <bm:field name="ref_d01" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D01" prompt="AST_CON_INSURANCE.REF_D01"/> <bm:field name="ref_d02" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D02" prompt="AST_CON_INSURANCE.REF_D02"/> <bm:field name="ref_d03" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D03" prompt="AST_CON_INSURANCE.REF_D03"/> <bm:field name="ref_d04" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D04" prompt="AST_CON_INSURANCE.REF_D04"/> <bm:field name="ref_d05" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D05" prompt="AST_CON_INSURANCE.REF_D05"/> <bm:field name="compulsory_rebate_rate" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COMPULSORY_REBATE_RATE" prompt="AST_CON_INSURANCE.COMPULSORY_REBATE_RATE"/> <bm:field name="combustion_rebate_rate" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COMBUSTION_REBATE_RATE" prompt="AST_CON_INSURANCE.COMBUSTION_REBATE_RATE"/> <bm:field name="compulsory_rebate" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COMPULSORY_REBATE" prompt="AST_CON_INSURANCE.COMPULSORY_REBATE"/> <bm:field name="combustion_rebate" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COMBUSTION_REBATE" prompt="AST_CON_INSURANCE.COMBUSTION_REBATE"/> <bm:field name="insure_place" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INSURE_PLACE" prompt="AST_CON_INSURANCE.INSURE_PLACE"/> <bm:field name="insure_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INSURE_NAME" prompt="AST_CON_INSURANCE.INSURE_NAME"/> <bm:field name="first_beneficiary" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FIRST_BENEFICIARY" prompt="AST_CON_INSURANCE.FIRST_BENEFICIARY"/> <bm:field name="insurance_party" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INSURANCE_PARTY" prompt="AST_CON_INSURANCE.INSURANCE_PARTY"/> <bm:field name="damage_insurance_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DAMAGE_INSURANCE_AMOUNT" prompt="AST_CON_INSURANCE.DAMAGE_INSURANCE_AMOUNT"/> <bm:field name="third_party_insurance_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="THIRD_PARTY_INSURANCE_AMOUNT" prompt="AST_CON_INSURANCE.THIRD_PARTY_INSURANCE_AMOUNT"/> <bm:field name="basic_non_deductible_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BASIC_NON_DEDUCTIBLE_AMOUNT" prompt="AST_CON_INSURANCE.BASIC_NON_DEDUCTIBLE_AMOUNT"/> <bm:field name="pilfer_insurance_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PILFER_INSURANCE_AMOUNT" prompt="AST_CON_INSURANCE.PILFER_INSURANCE_AMOUNT"/> <bm:field name="commercial_insurance_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMMERCIAL_INSURANCE_FLAG" prompt="AST_CON_INSURANCE.COMMERCIAL_INSURANCE_FLAG"/> <bm:field name="document_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOCUMENT_STATUS" prompt="AST_CON_INSURANCE.DOCUMENT_STATUS"/> <bm:field name="payment_finish_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PAYMENT_FINISH_FLAG" prompt="AST_CON_INSURANCE.PAYMENT_FINISH_FLAG"/> <bm:field name="glass_insurance_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="GLASS_INSURANCE_AMOUNT" prompt="AST_CON_INSURANCE.GLASS_INSURANCE_AMOUNT"/> <bm:field name="seat_insurance_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="SEAT_INSURANCE_AMOUNT" prompt="AST_CON_INSURANCE.SEAT_INSURANCE_AMOUNT"/> <bm:field name="combustion_insurance_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COMBUSTION_INSURANCE_AMOUNT" prompt="AST_CON_INSURANCE.COMBUSTION_INSURANCE_AMOUNT"/> <bm:field name="insurance_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INSURANCE_TYPE" prompt="AST_CON_INSURANCE.INSURANCE_TYPE"/> <bm:field name="others_insurance_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="OTHERS_INSURANCE_AMOUNT" prompt="AST_CON_INSURANCE.OTHERS_INSURANCE_AMOUNT"/> <bm:field name="travel_tax" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TRAVEL_TAX" prompt="AST_CON_INSURANCE.TRAVEL_TAX"/> <bm:field name="protege_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PROTEGE_NAME" prompt="AST_CON_INSURANCE.PROTEGE_NAME"/> <bm:field name="confirm_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONFIRM_FLAG" prompt="AST_CON_INSURANCE.CONFIRM_FLAG"/> <bm:field name="insurance_financing" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INSURANCE_FINANCING" prompt="AST_CON_INSURANCE.INSURANCE_FINANCING"/> <bm:field name="insurance_company" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INSURANCE_COMPANY" prompt="AST_CON_INSURANCE.INSURANCE_COMPANY"/> <bm:field name="tci_place" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TCI_PLACE" prompt="AST_CON_INSURANCE.TCI_PLACE"/> <bm:field name="vci_palce" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VCI_PALCE" prompt="AST_CON_INSURANCE.VCI_PALCE"/> <bm:field name="tci_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TCI_TYPE" prompt="AST_CON_INSURANCE.TCI_TYPE"/> <bm:field name="vci_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VCI_TYPE" prompt="AST_CON_INSURANCE.VCI_TYPE"/> <bm:field name="insurance_pay_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INSURANCE_PAY_TYPE" prompt="AST_CON_INSURANCE.INSURANCE_PAY_TYPE"/> <bm:field name="insurance_commission_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INSURANCE_COMMISSION_TYPE" prompt="AST_CON_INSURANCE.INSURANCE_COMMISSION_TYPE"/> <bm:field name="insurance_years" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INSURANCE_YEARS" prompt="AST_CON_INSURANCE.INSURANCE_YEARS"/> <bm:field name="compulsory_insurance_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMPULSORY_INSURANCE_FLAG" prompt="AST_CON_INSURANCE.COMPULSORY_INSURANCE_FLAG"/> <bm:field name="travel_tax_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TRAVEL_TAX_FLAG" prompt="AST_CON_INSURANCE.TRAVEL_TAX_FLAG"/> <bm:field name="rot_insurance" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ROT_INSURANCE" prompt="AST_CON_INSURANCE.ROT_INSURANCE"/> <bm:field name="wuyou_rot_insurance" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WUYOU_ROT_INSURANCE" prompt="AST_CON_INSURANCE.WUYOU_ROT_INSURANCE"/> <bm:field name="vci_rot_insurance" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VCI_ROT_INSURANCE" prompt="AST_CON_INSURANCE.VCI_ROT_INSURANCE"/> <bm:field name="damage_insurance_limit" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DAMAGE_INSURANCE_LIMIT" prompt="AST_CON_INSURANCE.DAMAGE_INSURANCE_LIMIT"/> <bm:field name="third_party_insurance" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="THIRD_PARTY_INSURANCE" prompt="AST_CON_INSURANCE.THIRD_PARTY_INSURANCE"/> <bm:field name="vehicle_resp_ins_driver" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VEHICLE_RESP_INS_DRIVER" prompt="AST_CON_INSURANCE.VEHICLE_RESP_INS_DRIVER"/> <bm:field name="vehicle_resp_ins_passenger" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VEHICLE_RESP_INS_PASSENGER" prompt="AST_CON_INSURANCE.VEHICLE_RESP_INS_PASSENGER"/> <bm:field name="nick_insurance" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NICK_INSURANCE" prompt="AST_CON_INSURANCE.NICK_INSURANCE"/> <bm:field name="stop_walking_insurance" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STOP_WALKING_INSURANCE" prompt="AST_CON_INSURANCE.STOP_WALKING_INSURANCE"/> <bm:field name="glass_insurance" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GLASS_INSURANCE" prompt="AST_CON_INSURANCE.GLASS_INSURANCE"/> <bm:field name="specify_insurance_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SPECIFY_INSURANCE_FLAG" prompt="AST_CON_INSURANCE.SPECIFY_INSURANCE_FLAG"/> <bm:field name="wading_drive_insurance" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WADING_DRIVE_INSURANCE" prompt="AST_CON_INSURANCE.WADING_DRIVE_INSURANCE"/> <bm:field name="damage_nopay_insurance_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DAMAGE_NOPAY_INSURANCE_FLAG" prompt="AST_CON_INSURANCE.DAMAGE_NOPAY_INSURANCE_FLAG"/> <bm:field name="vehicle_resp_ins_d_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="VEHICLE_RESP_INS_D_AMOUNT" prompt="AST_CON_INSURANCE.VEHICLE_RESP_INS_D_AMOUNT"/> <bm:field name="vehicle_resp_ins_p_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="VEHICLE_RESP_INS_P_AMOUNT" prompt="AST_CON_INSURANCE.VEHICLE_RESP_INS_P_AMOUNT"/> <bm:field name="nick_insurance_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="NICK_INSURANCE_AMOUNT" prompt="AST_CON_INSURANCE.NICK_INSURANCE_AMOUNT"/> <bm:field name="stop_walk_insu_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="STOP_WALK_INSU_AMOUNT" prompt="AST_CON_INSURANCE.STOP_WALK_INSU_AMOUNT"/> <bm:field name="specify_insurance_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="SPECIFY_INSURANCE_AMOUNT" prompt="AST_CON_INSURANCE.SPECIFY_INSURANCE_AMOUNT"/> <bm:field name="wading_driving_insu_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="WADING_DRIVING_INSU_AMOUNT" prompt="AST_CON_INSURANCE.WADING_DRIVING_INSU_AMOUNT"/> <bm:field name="damage_nopay_insu_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DAMAGE_NOPAY_INSU_AMOUNT" prompt="AST_CON_INSURANCE.DAMAGE_NOPAY_INSU_AMOUNT"/> <bm:field name="project_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PROJECT_ID" prompt="AST_CON_INSURANCE.PROJECT_ID"/> <bm:field name="wading_driving_insurance" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WADING_DRIVING_INSURANCE" prompt="AST_CON_INSURANCE.WADING_DRIVING_INSURANCE"/> <bm:field name="vci_insurance_company" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VCI_INSURANCE_COMPANY" prompt="AST_CON_INSURANCE.VCI_INSURANCE_COMPANY"/> <bm:field name="vci_insurance_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VCI_INSURANCE_NUMBER" prompt="AST_CON_INSURANCE.VCI_INSURANCE_NUMBER"/> <bm:field name="vci_insurance_date_from" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VCI_INSURANCE_DATE_FROM" prompt="AST_CON_INSURANCE.VCI_INSURANCE_DATE_FROM"/> <bm:field name="vci_insurance_date_to" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VCI_INSURANCE_DATE_TO" prompt="AST_CON_INSURANCE.VCI_INSURANCE_DATE_TO"/> <bm:field name="vci_ins_under_co" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VCI_INS_UNDER_CO" prompt="AST_CON_INSURANCE.VCI_INS_UNDER_CO"/> <bm:field name="link1" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LINK1" prompt="AST_CON_INSURANCE.LINK1"/> <bm:field name="tci_insurance_company" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TCI_INSURANCE_COMPANY" prompt="AST_CON_INSURANCE.TCI_INSURANCE_COMPANY"/> <bm:field name="tci_insurance_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TCI_INSURANCE_NUMBER" prompt="AST_CON_INSURANCE.TCI_INSURANCE_NUMBER"/> <bm:field name="tci_insurance_date_from" databaseType="DATE" datatype="java.util.Date" physicalName="TCI_INSURANCE_DATE_FROM" prompt="AST_CON_INSURANCE.TCI_INSURANCE_DATE_FROM"/> <bm:field name="tci_insurance_date_to" databaseType="DATE" datatype="java.util.Date" physicalName="TCI_INSURANCE_DATE_TO" prompt="AST_CON_INSURANCE.TCI_INSURANCE_DATE_TO"/> <bm:field name="link2" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LINK2" prompt="AST_CON_INSURANCE.LINK2"/> <bm:field name="vci_place" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VCI_PLACE" prompt="AST_CON_INSURANCE.VCI_PLACE"/> </bm:fields> <bm:primary-key> <bm:pk-field name="ast_con_car_insurance_id"/> </bm:primary-key> <bm:features> <f:standard-who/> <o:sequence-pk sequenceName="AST_CON_INSURANCE_S"/> </bm:features> <e:exception-descriptor-config> <e:exception-descriptor exception="java.sql.SQLException" handleClass="leaf.database.SQLExceptionDescriptor"> <e:error-message code="1" message="该保单号已经存在,请查证后输入"/> </e:exception-descriptor> </e:exception-descriptor-config> <bm:query-fields> <bm:query-field field="contract_id" queryOperator="="/> </bm:query-fields> <bm:operations> <bm:operation name="insert"> <bm:update-sql><![CDATA[ DECLARE BEGIN INSERT INTO AST_CON_INSURANCE ( contract_id, ast_con_car_insurance_id, item_detail_id, vci_insurance_company, commercial_insurance_amount, vci_insurance_number, vci_insurance_date_from, vci_insurance_date_to, vci_place, tci_insurance_company, compulsory_insurance_amount, tci_insurance_number, tci_insurance_date_from, tci_insurance_date_to, tci_place, travel_tax, pilfer_insurance_amount, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE ) VALUES ( ${/parameter/@contract_id}, AST_CON_INSURANCE_S.NEXTVAL, ${/parameter/@item_detail_id}, ${@vci_insurance_company}, ${@commercial_insurance_amount}, ${@vci_insurance_number}, to_date(${@vci_insurance_date_from},'yyyy-mm-dd'), to_date(${@vci_insurance_date_to},'yyyy-mm-dd'), ${@vci_place}, ${@tci_insurance_company}, ${@compulsory_insurance_amount}, ${@tci_insurance_number}, to_date(${@tci_insurance_date_from},'yyyy-mm-dd'), to_date(${@vci_insurance_date_to},'yyyy-mm-dd'), ${@tci_place}, ${@travel_tax}, ${@pilfer_insurance_amount}, ${/session/@user_id}, sysdate, ${/session/@user_id}, sysdate ) RETURNING ast_con_car_insurance_id INTO ${@ast_con_car_insurance_id}; END; ]]></bm:update-sql> </bm:operation> <bm:operation name="delete"> <bm:update-sql><![CDATA[ begin delete from AST_CON_INSURANCE a where a.ast_con_car_insurance_id =${@ast_con_car_insurance_id}; delete from ast_car_insurance_records t where t.ast_con_car_insurance_id =${@ast_con_car_insurance_id}; end; ]]></bm:update-sql> </bm:operation> </bm:operations> </bm:model>