DELETE FROM "LNCONTSTATEMENT" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LOANCONTRACT_NO" = :Original_LOANCONTRACT_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "LNCONTSTATEMENT" ("COOP_ID", "LOANCONTRACT_NO", "SEQ_NO", "LOANITEMTYPE_CODE", "SLIP_DATE", "OPERATE_DATE", "ACCOUNT_DATE", "REF_DOCNO", "PERIOD", "PRINCIPAL_PAYMENT", "INTEREST_PAYMENT", "PRINCIPAL_BALANCE", "PRNCALINT_AMT", "CALINT_FROM", "CALINT_TO", "BFINTARREAR_AMT", "INTEREST_PERIOD", "INTEREST_ARREAR", "INTEREST_RETURN", "MONEYTYPE_CODE", "ITEM_STATUS", "ENTRY_ID", "ENTRY_DATE", "ENTRY_BYCOOPID", "BFCONTSTATUS_DESC", "BFPERIOD_ARREAR", "PRINCIPAL_ARREAR", "PRN_BAL", "FINE_AMT", "REF_SLIPNO", "BFINTEREST_ARREAR", "BFINTRETURN_AMT", "REMARK", "TEMP_DATE", "INTACCUM_DATE", "INTCOMPARR_BAL", "CALAVG_STATUS", "FINEYEAR_ARREAR", "FINE_ARREAR", "BFPRINCIPAL_ARREAR", "BFFINEYEAR_AMT", "BFINTYEARARR_AMT", "INTARR_PAYMENT", "FINEARR_PAYMENT", "INT_COMPENSATE", "FINE_PERIOD", "FINE_PAYMENT", "FINE_RETURN", "BFFINE_ARREAR", "PRINCIPALPAY_PERIOD", "INTYEAR_COMPENSATE", "BFINT_PREIOD", "BFFINE_PREIOD", "BFPRINARR_5YEARS", "BFINTARR_5YEARS", "BFFINEARR_5YEARS", "PRTCARD_FLAG", "PRTBOOK_FLAG") VALUES (:COOP_ID, :LOANCONTRACT_NO, :SEQ_NO, :LOANITEMTYPE_CODE, :SLIP_DATE, :OPERATE_DATE, :ACCOUNT_DATE, :REF_DOCNO, :PERIOD, :PRINCIPAL_PAYMENT, :INTEREST_PAYMENT, :PRINCIPAL_BALANCE, :PRNCALINT_AMT, :CALINT_FROM, :CALINT_TO, :BFINTARREAR_AMT, :INTEREST_PERIOD, :INTEREST_ARREAR, :INTEREST_RETURN, :MONEYTYPE_CODE, :ITEM_STATUS, :ENTRY_ID, :ENTRY_DATE, :ENTRY_BYCOOPID, :BFCONTSTATUS_DESC, :BFPERIOD_ARREAR, :PRINCIPAL_ARREAR, :PRN_BAL, :FINE_AMT, :REF_SLIPNO, :BFINTEREST_ARREAR, :BFINTRETURN_AMT, :REMARK, :TEMP_DATE, :INTACCUM_DATE, :INTCOMPARR_BAL, :CALAVG_STATUS, :FINEYEAR_ARREAR, :FINE_ARREAR, :BFPRINCIPAL_ARREAR, :BFFINEYEAR_AMT, :BFINTYEARARR_AMT, :INTARR_PAYMENT, :FINEARR_PAYMENT, :INT_COMPENSATE, :FINE_PERIOD, :FINE_PAYMENT, :FINE_RETURN, :BFFINE_ARREAR, :PRINCIPALPAY_PERIOD, :INTYEAR_COMPENSATE, :BFINT_PREIOD, :BFFINE_PREIOD, :BFPRINARR_5YEARS, :BFINTARR_5YEARS, :BFFINEARR_5YEARS, :PRTCARD_FLAG, :PRTBOOK_FLAG) select * from lncontstatement UPDATE "LNCONTSTATEMENT" SET "COOP_ID" = :COOP_ID, "LOANCONTRACT_NO" = :LOANCONTRACT_NO, "SEQ_NO" = :SEQ_NO, "LOANITEMTYPE_CODE" = :LOANITEMTYPE_CODE, "SLIP_DATE" = :SLIP_DATE, "OPERATE_DATE" = :OPERATE_DATE, "ACCOUNT_DATE" = :ACCOUNT_DATE, "REF_DOCNO" = :REF_DOCNO, "PERIOD" = :PERIOD, "PRINCIPAL_PAYMENT" = :PRINCIPAL_PAYMENT, "INTEREST_PAYMENT" = :INTEREST_PAYMENT, "PRINCIPAL_BALANCE" = :PRINCIPAL_BALANCE, "PRNCALINT_AMT" = :PRNCALINT_AMT, "CALINT_FROM" = :CALINT_FROM, "CALINT_TO" = :CALINT_TO, "BFINTARREAR_AMT" = :BFINTARREAR_AMT, "INTEREST_PERIOD" = :INTEREST_PERIOD, "INTEREST_ARREAR" = :INTEREST_ARREAR, "INTEREST_RETURN" = :INTEREST_RETURN, "MONEYTYPE_CODE" = :MONEYTYPE_CODE, "ITEM_STATUS" = :ITEM_STATUS, "ENTRY_ID" = :ENTRY_ID, "ENTRY_DATE" = :ENTRY_DATE, "ENTRY_BYCOOPID" = :ENTRY_BYCOOPID, "BFCONTSTATUS_DESC" = :BFCONTSTATUS_DESC, "BFPERIOD_ARREAR" = :BFPERIOD_ARREAR, "PRINCIPAL_ARREAR" = :PRINCIPAL_ARREAR, "PRN_BAL" = :PRN_BAL, "FINE_AMT" = :FINE_AMT, "REF_SLIPNO" = :REF_SLIPNO, "BFINTEREST_ARREAR" = :BFINTEREST_ARREAR, "BFINTRETURN_AMT" = :BFINTRETURN_AMT, "REMARK" = :REMARK, "TEMP_DATE" = :TEMP_DATE, "INTACCUM_DATE" = :INTACCUM_DATE, "INTCOMPARR_BAL" = :INTCOMPARR_BAL, "CALAVG_STATUS" = :CALAVG_STATUS, "FINEYEAR_ARREAR" = :FINEYEAR_ARREAR, "FINE_ARREAR" = :FINE_ARREAR, "BFPRINCIPAL_ARREAR" = :BFPRINCIPAL_ARREAR, "BFFINEYEAR_AMT" = :BFFINEYEAR_AMT, "BFINTYEARARR_AMT" = :BFINTYEARARR_AMT, "INTARR_PAYMENT" = :INTARR_PAYMENT, "FINEARR_PAYMENT" = :FINEARR_PAYMENT, "INT_COMPENSATE" = :INT_COMPENSATE, "FINE_PERIOD" = :FINE_PERIOD, "FINE_PAYMENT" = :FINE_PAYMENT, "FINE_RETURN" = :FINE_RETURN, "BFFINE_ARREAR" = :BFFINE_ARREAR, "PRINCIPALPAY_PERIOD" = :PRINCIPALPAY_PERIOD, "INTYEAR_COMPENSATE" = :INTYEAR_COMPENSATE, "BFINT_PREIOD" = :BFINT_PREIOD, "BFFINE_PREIOD" = :BFFINE_PREIOD, "BFPRINARR_5YEARS" = :BFPRINARR_5YEARS, "BFINTARR_5YEARS" = :BFINTARR_5YEARS, "BFFINEARR_5YEARS" = :BFFINEARR_5YEARS, "PRTCARD_FLAG" = :PRTCARD_FLAG, "PRTBOOK_FLAG" = :PRTBOOK_FLAG WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LOANCONTRACT_NO" = :Original_LOANCONTRACT_NO) AND ("SEQ_NO" = :Original_SEQ_NO))