DELETE FROM "LNCONTMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LOANCONTRACT_NO" = :Original_LOANCONTRACT_NO)) INSERT INTO "LNCONTMASTER" ("COOP_ID", "LOANCONTRACT_NO", "MEMCOOP_ID", "MEMBER_NO", "LOANTYPE_CODE", "LOANOBJECTIVE_CODE", "LOANREQUEST_DOCNO", "LOANREQUEST_AMT", "LOANAPPROVE_DATE", "LOANAPPROVE_AMT", "WITHDRAWABLE_AMT", "PRINCIPAL_BALANCE", "LOANPAYMENT_TYPE", "PERIOD_INSTALLMENT", "PERIOD_PAYMENT", "PERIOD_LASTPAYMENT", "PAYMENT_STATUS", "LAST_PERIODRCV", "LAST_PERIODPAY", "STARTCONT_DATE", "STARTKEEP_DATE", "STARTKEEP_PERIOD", "LASTRECEIVE_DATE", "LASTPAYMENT_DATE", "LASTCALINT_DATE", "LASTKEEPING_DATE", "LASTPROCESS_DATE", "LASTACCESS_DATE", "CLOSECONT_DATE", "PRINCIPAL_ARREAR", "INTEREST_ARREAR", "INTYEAR_ARREAR", "INTEREST_ACCUM", "INTACCUM_LASTYEAR", "PRINCIPAL_RETURN", "INTEREST_RETURN", "PRNPAYMENT_AMT", "INTPAYMENT_AMT", "LAST_STM_NO", "TRANSFER_STATUS", "PRINCIPAL_TRANS", "TRNFROM_CONTNO", "TRNFROM_MEMNO", "NKEEP_PRINCIPAL", "NKEEP_INTEREST", "RKEEP_PRINCIPAL", "RKEEP_INTEREST", "COMPOUND_STATUS", "COMPOUND_INSTALLMENT", "COMPOUND_DUEDATE", "COMPOUND_PAYMENT", "COMPOUND_PAYSTATUS", "MISSPAY_AMT", "OD_FLAG", "CONTLAW_STATUS", "CONTRACT_STATUS", "APPROVE_ID", "APPROVE_BYCOOPID", "REMARK", "INT_CONTINTTYPE", "INT_CONTINTRATE", "INT_CONTINTTABCODE", "INT_CONTINTINCREASE", "INT_INTSTEPTYPE", "STATUS_DESC", "PERIOD_PAYAMT", "PERIOD_PAYMENT_MAX", "INTMONTH_ARREAR", "LAST_TRANSCONT_NO", "CONTRACT_TIME", "EXPIRECONT_DATE", "EXPENSE_CODE", "EXPENSE_BANK", "EXPENSE_BRANCH", "EXPENSE_ACCID", "COMPOUND_DATE", "COMPOUND_PERIOD", "COMPOUNDDUE_DATE", "BUYSHARE_AMT", "RECEIVEPERIOD_FLAG", "PRNCBALBEGIN_AMT", "CONTRACT_TYPE", "SUMINT_LASTYEAR", "LOAN_NO", "INSURANCE_AMT", "INSTYPE_CODE", "INTARREAR_TRANS", "CANCEL_ID", "CANCEL_DATE", "CANCEL_CAUSE", "COMPOUND_PAYTYPE", "COMPOUND_NMLDATE", "PRINCIPAL_TRANSBAL", "INTARREAR_TRANSBAL", "LOANPAYMENTCHG_DATE", "COMPOUND_INTARRPAYMENT", "INSURECOLL_FLAG", "TRNLNTOCOLL_FLAG", "COUNTPAY_FLAG", "PERIOD_PAYINTARR", "TRNFROM_PRNBAL", "TRNFROM_INTBAL", "PAYOUTORD_FLAG", "IDENTIFYCONT_INTRATE", "OBJINTWARRANT_CODE", "CANCEL_PRNBALAMT", "REQCOOP_ID", "INTCERTIFICATE_STATUS", "INTENDORSE_AMT", "LOANCREDIT_AMT", "INTSET_ARREAR", "LOANPAY_CODE", "LOANPAY_BANK", "LOANPAY_BRANCH", "LOANPAY_ACCID", "LOANPAYSPLIT_FLAG", "CONTCCLCAUSE_CODE", "INTCOMPOUND_ARREAR", "REFRAINAVG_FLAG", "UPDATE_BYENTRYID", "UPDATE_BYENTRYIP", "INTSETBEGIN_AMT", "SUBPERIOD_PERCENT", "SUBPERIOD_AMT", "SUBCOUNT_AMT", "SUBPERIOD_PAYMENT", "FINEYEAR_ARREAR", "FINE_ARREAR", "CURRENT_COOPID", "CONTCOUNT", "CONTCOUNT_END", "LASTREC_NO", "LASTLINE_NO", "LASTPAGE_NO", "LOANPASSBOOK_NO", "INTCOMPENSATE_FLAG", "LASTCALFINE_DATE", "CONTRACTINT_TYPE", "CONTINTEXPIRE_DATE", "CONTRACT_INTEREST", "BFFINEYEAR_ARREAR", "BFINTERESTYEAR_ARREAR", "PRTBOOK_FLAG", "PRTCARD_FLAG", "BFPRINCIPALYEAR_ARREAR", "LASTREC_NO_CARD", "LASTLINE_NO_CARD", "LASTPAGE_NO_CARD") VALUES (:COOP_ID, :LOANCONTRACT_NO, :MEMCOOP_ID, :MEMBER_NO, :LOANTYPE_CODE, :LOANOBJECTIVE_CODE, :LOANREQUEST_DOCNO, :LOANREQUEST_AMT, :LOANAPPROVE_DATE, :LOANAPPROVE_AMT, :WITHDRAWABLE_AMT, :PRINCIPAL_BALANCE, :LOANPAYMENT_TYPE, :PERIOD_INSTALLMENT, :PERIOD_PAYMENT, :PERIOD_LASTPAYMENT, :PAYMENT_STATUS, :LAST_PERIODRCV, :LAST_PERIODPAY, :STARTCONT_DATE, :STARTKEEP_DATE, :STARTKEEP_PERIOD, :LASTRECEIVE_DATE, :LASTPAYMENT_DATE, :LASTCALINT_DATE, :LASTKEEPING_DATE, :LASTPROCESS_DATE, :LASTACCESS_DATE, :CLOSECONT_DATE, :PRINCIPAL_ARREAR, :INTEREST_ARREAR, :INTYEAR_ARREAR, :INTEREST_ACCUM, :INTACCUM_LASTYEAR, :PRINCIPAL_RETURN, :INTEREST_RETURN, :PRNPAYMENT_AMT, :INTPAYMENT_AMT, :LAST_STM_NO, :TRANSFER_STATUS, :PRINCIPAL_TRANS, :TRNFROM_CONTNO, :TRNFROM_MEMNO, :NKEEP_PRINCIPAL, :NKEEP_INTEREST, :RKEEP_PRINCIPAL, :RKEEP_INTEREST, :COMPOUND_STATUS, :COMPOUND_INSTALLMENT, :COMPOUND_DUEDATE, :COMPOUND_PAYMENT, :COMPOUND_PAYSTATUS, :MISSPAY_AMT, :OD_FLAG, :CONTLAW_STATUS, :CONTRACT_STATUS, :APPROVE_ID, :APPROVE_BYCOOPID, :REMARK, :INT_CONTINTTYPE, :INT_CONTINTRATE, :INT_CONTINTTABCODE, :INT_CONTINTINCREASE, :INT_INTSTEPTYPE, :STATUS_DESC, :PERIOD_PAYAMT, :PERIOD_PAYMENT_MAX, :INTMONTH_ARREAR, :LAST_TRANSCONT_NO, :CONTRACT_TIME, :EXPIRECONT_DATE, :EXPENSE_CODE, :EXPENSE_BANK, :EXPENSE_BRANCH, :EXPENSE_ACCID, :COMPOUND_DATE, :COMPOUND_PERIOD, :COMPOUNDDUE_DATE, :BUYSHARE_AMT, :RECEIVEPERIOD_FLAG, :PRNCBALBEGIN_AMT, :CONTRACT_TYPE, :SUMINT_LASTYEAR, :LOAN_NO, :INSURANCE_AMT, :INSTYPE_CODE, :INTARREAR_TRANS, :CANCEL_ID, :CANCEL_DATE, :CANCEL_CAUSE, :COMPOUND_PAYTYPE, :COMPOUND_NMLDATE, :PRINCIPAL_TRANSBAL, :INTARREAR_TRANSBAL, :LOANPAYMENTCHG_DATE, :p1, :INSURECOLL_FLAG, :TRNLNTOCOLL_FLAG, :COUNTPAY_FLAG, :PERIOD_PAYINTARR, :TRNFROM_PRNBAL, :TRNFROM_INTBAL, :PAYOUTORD_FLAG, :IDENTIFYCONT_INTRATE, :OBJINTWARRANT_CODE, :CANCEL_PRNBALAMT, :REQCOOP_ID, :INTCERTIFICATE_STATUS, :INTENDORSE_AMT, :LOANCREDIT_AMT, :INTSET_ARREAR, :LOANPAY_CODE, :LOANPAY_BANK, :LOANPAY_BRANCH, :LOANPAY_ACCID, :LOANPAYSPLIT_FLAG, :CONTCCLCAUSE_CODE, :INTCOMPOUND_ARREAR, :REFRAINAVG_FLAG, :UPDATE_BYENTRYID, :UPDATE_BYENTRYIP, :INTSETBEGIN_AMT, :SUBPERIOD_PERCENT, :SUBPERIOD_AMT, :SUBCOUNT_AMT, :SUBPERIOD_PAYMENT, :FINEYEAR_ARREAR, :FINE_ARREAR, :CURRENT_COOPID, :CONTCOUNT, :CONTCOUNT_END, :LASTREC_NO, :LASTLINE_NO, :LASTPAGE_NO, :LOANPASSBOOK_NO, :INTCOMPENSATE_FLAG, :LASTCALFINE_DATE, :CONTRACTINT_TYPE, :CONTINTEXPIRE_DATE, :CONTRACT_INTEREST, :BFFINEYEAR_ARREAR, :BFINTERESTYEAR_ARREAR, :PRTBOOK_FLAG, :PRTCARD_FLAG, :p4, :LASTREC_NO_CARD, :LASTLINE_NO_CARD, :LASTPAGE_NO_CARD) select * from lncontmaster UPDATE "LNCONTMASTER" SET "COOP_ID" = :COOP_ID, "LOANCONTRACT_NO" = :LOANCONTRACT_NO, "MEMCOOP_ID" = :MEMCOOP_ID, "MEMBER_NO" = :MEMBER_NO, "LOANTYPE_CODE" = :LOANTYPE_CODE, "LOANOBJECTIVE_CODE" = :LOANOBJECTIVE_CODE, "LOANREQUEST_DOCNO" = :LOANREQUEST_DOCNO, "LOANREQUEST_AMT" = :LOANREQUEST_AMT, "LOANAPPROVE_DATE" = :LOANAPPROVE_DATE, "LOANAPPROVE_AMT" = :LOANAPPROVE_AMT, "WITHDRAWABLE_AMT" = :WITHDRAWABLE_AMT, "PRINCIPAL_BALANCE" = :PRINCIPAL_BALANCE, "LOANPAYMENT_TYPE" = :LOANPAYMENT_TYPE, "PERIOD_INSTALLMENT" = :PERIOD_INSTALLMENT, "PERIOD_PAYMENT" = :PERIOD_PAYMENT, "PERIOD_LASTPAYMENT" = :PERIOD_LASTPAYMENT, "PAYMENT_STATUS" = :PAYMENT_STATUS, "LAST_PERIODRCV" = :LAST_PERIODRCV, "LAST_PERIODPAY" = :LAST_PERIODPAY, "STARTCONT_DATE" = :STARTCONT_DATE, "STARTKEEP_DATE" = :STARTKEEP_DATE, "STARTKEEP_PERIOD" = :STARTKEEP_PERIOD, "LASTRECEIVE_DATE" = :LASTRECEIVE_DATE, "LASTPAYMENT_DATE" = :LASTPAYMENT_DATE, "LASTCALINT_DATE" = :LASTCALINT_DATE, "LASTKEEPING_DATE" = :LASTKEEPING_DATE, "LASTPROCESS_DATE" = :LASTPROCESS_DATE, "LASTACCESS_DATE" = :LASTACCESS_DATE, "CLOSECONT_DATE" = :CLOSECONT_DATE, "PRINCIPAL_ARREAR" = :PRINCIPAL_ARREAR, "INTEREST_ARREAR" = :INTEREST_ARREAR, "INTYEAR_ARREAR" = :INTYEAR_ARREAR, "INTEREST_ACCUM" = :INTEREST_ACCUM, "INTACCUM_LASTYEAR" = :INTACCUM_LASTYEAR, "PRINCIPAL_RETURN" = :PRINCIPAL_RETURN, "INTEREST_RETURN" = :INTEREST_RETURN, "PRNPAYMENT_AMT" = :PRNPAYMENT_AMT, "INTPAYMENT_AMT" = :INTPAYMENT_AMT, "LAST_STM_NO" = :LAST_STM_NO, "TRANSFER_STATUS" = :TRANSFER_STATUS, "PRINCIPAL_TRANS" = :PRINCIPAL_TRANS, "TRNFROM_CONTNO" = :TRNFROM_CONTNO, "TRNFROM_MEMNO" = :TRNFROM_MEMNO, "NKEEP_PRINCIPAL" = :NKEEP_PRINCIPAL, "NKEEP_INTEREST" = :NKEEP_INTEREST, "RKEEP_PRINCIPAL" = :RKEEP_PRINCIPAL, "RKEEP_INTEREST" = :RKEEP_INTEREST, "COMPOUND_STATUS" = :COMPOUND_STATUS, "COMPOUND_INSTALLMENT" = :COMPOUND_INSTALLMENT, "COMPOUND_DUEDATE" = :COMPOUND_DUEDATE, "COMPOUND_PAYMENT" = :COMPOUND_PAYMENT, "COMPOUND_PAYSTATUS" = :COMPOUND_PAYSTATUS, "MISSPAY_AMT" = :MISSPAY_AMT, "OD_FLAG" = :OD_FLAG, "CONTLAW_STATUS" = :CONTLAW_STATUS, "CONTRACT_STATUS" = :CONTRACT_STATUS, "APPROVE_ID" = :APPROVE_ID, "APPROVE_BYCOOPID" = :APPROVE_BYCOOPID, "REMARK" = :REMARK, "INT_CONTINTTYPE" = :INT_CONTINTTYPE, "INT_CONTINTRATE" = :INT_CONTINTRATE, "INT_CONTINTTABCODE" = :INT_CONTINTTABCODE, "INT_CONTINTINCREASE" = :INT_CONTINTINCREASE, "INT_INTSTEPTYPE" = :INT_INTSTEPTYPE, "STATUS_DESC" = :STATUS_DESC, "PERIOD_PAYAMT" = :PERIOD_PAYAMT, "PERIOD_PAYMENT_MAX" = :PERIOD_PAYMENT_MAX, "INTMONTH_ARREAR" = :INTMONTH_ARREAR, "LAST_TRANSCONT_NO" = :LAST_TRANSCONT_NO, "CONTRACT_TIME" = :CONTRACT_TIME, "EXPIRECONT_DATE" = :EXPIRECONT_DATE, "EXPENSE_CODE" = :EXPENSE_CODE, "EXPENSE_BANK" = :EXPENSE_BANK, "EXPENSE_BRANCH" = :EXPENSE_BRANCH, "EXPENSE_ACCID" = :EXPENSE_ACCID, "COMPOUND_DATE" = :COMPOUND_DATE, "COMPOUND_PERIOD" = :COMPOUND_PERIOD, "COMPOUNDDUE_DATE" = :COMPOUNDDUE_DATE, "BUYSHARE_AMT" = :BUYSHARE_AMT, "RECEIVEPERIOD_FLAG" = :RECEIVEPERIOD_FLAG, "PRNCBALBEGIN_AMT" = :PRNCBALBEGIN_AMT, "CONTRACT_TYPE" = :CONTRACT_TYPE, "SUMINT_LASTYEAR" = :SUMINT_LASTYEAR, "LOAN_NO" = :LOAN_NO, "INSURANCE_AMT" = :INSURANCE_AMT, "INSTYPE_CODE" = :INSTYPE_CODE, "INTARREAR_TRANS" = :INTARREAR_TRANS, "CANCEL_ID" = :CANCEL_ID, "CANCEL_DATE" = :CANCEL_DATE, "CANCEL_CAUSE" = :CANCEL_CAUSE, "COMPOUND_PAYTYPE" = :COMPOUND_PAYTYPE, "COMPOUND_NMLDATE" = :COMPOUND_NMLDATE, "PRINCIPAL_TRANSBAL" = :PRINCIPAL_TRANSBAL, "INTARREAR_TRANSBAL" = :INTARREAR_TRANSBAL, "LOANPAYMENTCHG_DATE" = :LOANPAYMENTCHG_DATE, "COMPOUND_INTARRPAYMENT" = :p1, "INSURECOLL_FLAG" = :INSURECOLL_FLAG, "TRNLNTOCOLL_FLAG" = :TRNLNTOCOLL_FLAG, "COUNTPAY_FLAG" = :COUNTPAY_FLAG, "PERIOD_PAYINTARR" = :PERIOD_PAYINTARR, "TRNFROM_PRNBAL" = :TRNFROM_PRNBAL, "TRNFROM_INTBAL" = :TRNFROM_INTBAL, "PAYOUTORD_FLAG" = :PAYOUTORD_FLAG, "IDENTIFYCONT_INTRATE" = :IDENTIFYCONT_INTRATE, "OBJINTWARRANT_CODE" = :OBJINTWARRANT_CODE, "CANCEL_PRNBALAMT" = :CANCEL_PRNBALAMT, "REQCOOP_ID" = :REQCOOP_ID, "INTCERTIFICATE_STATUS" = :INTCERTIFICATE_STATUS, "INTENDORSE_AMT" = :INTENDORSE_AMT, "LOANCREDIT_AMT" = :LOANCREDIT_AMT, "INTSET_ARREAR" = :INTSET_ARREAR, "LOANPAY_CODE" = :LOANPAY_CODE, "LOANPAY_BANK" = :LOANPAY_BANK, "LOANPAY_BRANCH" = :LOANPAY_BRANCH, "LOANPAY_ACCID" = :LOANPAY_ACCID, "LOANPAYSPLIT_FLAG" = :LOANPAYSPLIT_FLAG, "CONTCCLCAUSE_CODE" = :CONTCCLCAUSE_CODE, "INTCOMPOUND_ARREAR" = :INTCOMPOUND_ARREAR, "REFRAINAVG_FLAG" = :REFRAINAVG_FLAG, "UPDATE_BYENTRYID" = :UPDATE_BYENTRYID, "UPDATE_BYENTRYIP" = :UPDATE_BYENTRYIP, "INTSETBEGIN_AMT" = :INTSETBEGIN_AMT, "SUBPERIOD_PERCENT" = :SUBPERIOD_PERCENT, "SUBPERIOD_AMT" = :SUBPERIOD_AMT, "SUBCOUNT_AMT" = :SUBCOUNT_AMT, "SUBPERIOD_PAYMENT" = :SUBPERIOD_PAYMENT, "FINEYEAR_ARREAR" = :FINEYEAR_ARREAR, "FINE_ARREAR" = :FINE_ARREAR, "CURRENT_COOPID" = :CURRENT_COOPID, "CONTCOUNT" = :CONTCOUNT, "CONTCOUNT_END" = :CONTCOUNT_END, "LASTREC_NO" = :LASTREC_NO, "LASTLINE_NO" = :LASTLINE_NO, "LASTPAGE_NO" = :LASTPAGE_NO, "LOANPASSBOOK_NO" = :LOANPASSBOOK_NO, "INTCOMPENSATE_FLAG" = :INTCOMPENSATE_FLAG, "LASTCALFINE_DATE" = :LASTCALFINE_DATE, "CONTRACTINT_TYPE" = :CONTRACTINT_TYPE, "CONTINTEXPIRE_DATE" = :CONTINTEXPIRE_DATE, "CONTRACT_INTEREST" = :CONTRACT_INTEREST, "BFFINEYEAR_ARREAR" = :BFFINEYEAR_ARREAR, "BFINTERESTYEAR_ARREAR" = :BFINTERESTYEAR_ARREAR, "PRTBOOK_FLAG" = :PRTBOOK_FLAG, "PRTCARD_FLAG" = :PRTCARD_FLAG, "BFPRINCIPALYEAR_ARREAR" = :p4, "LASTREC_NO_CARD" = :LASTREC_NO_CARD, "LASTLINE_NO_CARD" = :LASTLINE_NO_CARD, "LASTPAGE_NO_CARD" = :LASTPAGE_NO_CARD WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LOANCONTRACT_NO" = :Original_LOANCONTRACT_NO)) DELETE FROM "LNCONTSTATEMENT" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LOANCONTRACT_NO" = :Original_LOANCONTRACT_NO) AND ("SEQ_NO" = :Original_SEQ_NO) AND ("LOANITEMTYPE_CODE" = :Original_LOANITEMTYPE_CODE)) 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", "PRTCARD_FLAG", "PRTBOOK_FLAG", "CALFINEFROM_DATE", "CALFINETO_DATE") 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, :PRTCARD_FLAG, :PRTBOOK_FLAG, :CALFINEFROM_DATE, :CALFINETO_DATE) 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, "PRTCARD_FLAG" = :PRTCARD_FLAG, "PRTBOOK_FLAG" = :PRTBOOK_FLAG, "CALFINEFROM_DATE" = :CALFINEFROM_DATE, "CALFINETO_DATE" = :CALFINETO_DATE WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LOANCONTRACT_NO" = :Original_LOANCONTRACT_NO) AND ("SEQ_NO" = :Original_SEQ_NO) AND ("LOANITEMTYPE_CODE" = :Original_LOANITEMTYPE_CODE)) DELETE FROM "LNCONTCOLL" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LOANCONTRACT_NO" = :Original_LOANCONTRACT_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "LNCONTCOLL" ("COOP_ID", "LOANCONTRACT_NO", "SEQ_NO", "LOANCOLLTYPE_CODE", "REFCOOP_ID", "REF_COLLNO", "DESCRIPTION", "COLL_AMT", "COLL_BALANCE", "USE_AMT", "COLL_PERCENT", "COLL_STATUS", "BASE_PERCENT", "RCVTRNLOAN_FLAG", "REMARK", "RECVTRNLOAN_FLAG", "RECVTRNLOAN_CONTNO", "COLLBASE_AMT", "COLLBASE_PERCENT", "COLLUSED_AMT", "COLLBALANCE_AMT", "COLLMAX_AMT", "COLLACTIVE_AMT", "COLLACTIVE_PERCENT", "SUMCOLLACTIVE_AMT", "LOANREQUEST_AMT", "PRINCIPAL_BALANCE") VALUES (:COOP_ID, :LOANCONTRACT_NO, :SEQ_NO, :LOANCOLLTYPE_CODE, :REFCOOP_ID, :REF_COLLNO, :DESCRIPTION, :COLL_AMT, :COLL_BALANCE, :USE_AMT, :COLL_PERCENT, :COLL_STATUS, :BASE_PERCENT, :RCVTRNLOAN_FLAG, :REMARK, :RECVTRNLOAN_FLAG, :RECVTRNLOAN_CONTNO, :COLLBASE_AMT, :COLLBASE_PERCENT, :COLLUSED_AMT, :COLLBALANCE_AMT, :COLLMAX_AMT, :COLLACTIVE_AMT, :COLLACTIVE_PERCENT, :SUMCOLLACTIVE_AMT, :LOANREQUEST_AMT, :PRINCIPAL_BALANCE) select * from lncontcoll UPDATE "LNCONTCOLL" SET "COOP_ID" = :COOP_ID, "LOANCONTRACT_NO" = :LOANCONTRACT_NO, "SEQ_NO" = :SEQ_NO, "LOANCOLLTYPE_CODE" = :LOANCOLLTYPE_CODE, "REFCOOP_ID" = :REFCOOP_ID, "REF_COLLNO" = :REF_COLLNO, "DESCRIPTION" = :DESCRIPTION, "COLL_AMT" = :COLL_AMT, "COLL_BALANCE" = :COLL_BALANCE, "USE_AMT" = :USE_AMT, "COLL_PERCENT" = :COLL_PERCENT, "COLL_STATUS" = :COLL_STATUS, "BASE_PERCENT" = :BASE_PERCENT, "RCVTRNLOAN_FLAG" = :RCVTRNLOAN_FLAG, "REMARK" = :REMARK, "RECVTRNLOAN_FLAG" = :RECVTRNLOAN_FLAG, "RECVTRNLOAN_CONTNO" = :RECVTRNLOAN_CONTNO, "COLLBASE_AMT" = :COLLBASE_AMT, "COLLBASE_PERCENT" = :COLLBASE_PERCENT, "COLLUSED_AMT" = :COLLUSED_AMT, "COLLBALANCE_AMT" = :COLLBALANCE_AMT, "COLLMAX_AMT" = :COLLMAX_AMT, "COLLACTIVE_AMT" = :COLLACTIVE_AMT, "COLLACTIVE_PERCENT" = :COLLACTIVE_PERCENT, "SUMCOLLACTIVE_AMT" = :SUMCOLLACTIVE_AMT, "LOANREQUEST_AMT" = :LOANREQUEST_AMT, "PRINCIPAL_BALANCE" = :PRINCIPAL_BALANCE WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LOANCONTRACT_NO" = :Original_LOANCONTRACT_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) DELETE FROM "LNCONTPERIODPAYDET" WHERE (("LOANCONTRACT_NO" = :Original_LOANCONTRACT_NO) AND ("COOP_ID" = :Original_COOP_ID) AND ("PERIOD" = :Original_PERIOD)) INSERT INTO "LNCONTPERIODPAYDET" ("LOANCONTRACT_NO", "COOP_ID", "PERIOD", "PERIOD_PAYMENT", "LASTCALFINE_DATE", "FINE_ARREAR", "PRINCIPAL_ARREAR", "EXPIREPERIOD_DATE", "PRINPAID_AMT", "BFLASTCALFINE_DATE") VALUES (:LOANCONTRACT_NO, :COOP_ID, :PERIOD, :PERIOD_PAYMENT, :LASTCALFINE_DATE, :FINE_ARREAR, :PRINCIPAL_ARREAR, :EXPIREPERIOD_DATE, :PRINPAID_AMT, :BFLASTCALFINE_DATE) SELECT LOANCONTRACT_NO, COOP_ID, PERIOD, PERIOD_PAYMENT, LASTCALFINE_DATE, FINE_ARREAR, PRINCIPAL_ARREAR, EXPIREPERIOD_DATE, PRINPAID_AMT, BFLASTCALFINE_DATE FROM LNCONTPERIODPAYDET UPDATE "LNCONTPERIODPAYDET" SET "LOANCONTRACT_NO" = :LOANCONTRACT_NO, "COOP_ID" = :COOP_ID, "PERIOD" = :PERIOD, "PERIOD_PAYMENT" = :PERIOD_PAYMENT, "LASTCALFINE_DATE" = :LASTCALFINE_DATE, "FINE_ARREAR" = :FINE_ARREAR, "PRINCIPAL_ARREAR" = :PRINCIPAL_ARREAR, "EXPIREPERIOD_DATE" = :EXPIREPERIOD_DATE, "PRINPAID_AMT" = :PRINPAID_AMT, "BFLASTCALFINE_DATE" = :BFLASTCALFINE_DATE WHERE (("LOANCONTRACT_NO" = :Original_LOANCONTRACT_NO) AND ("COOP_ID" = :Original_COOP_ID) AND ("PERIOD" = :Original_PERIOD))