DELETE FROM "LNLAWMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LOANCONTRACT_NO" = :Original_LOANCONTRACT_NO)) INSERT INTO "LNLAWMASTER" ("COOP_ID", "LOANCONTRACT_NO", "MEMCOOP_ID", "MEMBER_NO", "LOANTYPE_CODE", "LOANOBJECTIVE_CODE", "LOANREQUEST_DOCNO", "LOANREQUEST_AMT", "LOANAPPROVE_DATE", "LOANAPPROVE_AMT", "WITHDRAWABLE_AMT", "PRINCIPAL_BALANCE", "PRINCIPAL_CALINTAMT", "PRINCIPAL_FIXAMT", "LOANPAYMENT_TYPE", "PERIOD_INSTALLMENT", "PERIOD_PAYMENT", "RED_DOCNO", "BLACK_DOCNO", "REF_CONTRACTNO", "INT_RATE", "FINE_RATE", "PERIOD_LASTPAYMENT", "PAYMENT_STATUS", "LAST_PERIODPAY", "STARTCONT_DATE", "LASTRECEIVE_DATE", "LASTPAYMENT_DATE", "LASTCALINT_DATE", "LASTPROCESS_DATE", "LASTACCESS_DATE", "CLOSECONT_DATE", "PRINCIPAL_ARREAR", "INTEREST_ARREAR", "INTYEAR_ARREAR", "INTEREST_ACCUM", "INTACCUM_LASTYEAR", "PRINCIPAL_RETURN", "INTEREST_RETURN", "LAST_STM_NO", "OD_FLAG", "CONTRACT_STATUS", "APPROVE_ID", "APPROVE_BYCOOPID", "REMARK", "PERIOD_PAYAMT", "PERIOD_PAYMENT_MAX", "EXPIRECONT_DATE", "CANCEL_ID", "CANCEL_DATE", "CANCEL_CAUSE", "FINEYEAR_ARREAR", "FINE_ARREAR", "LASTREC_NO", "LASTLINE_NO", "LASTPAGE_NO", "LASTCALFINE_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, :PRINCIPAL_CALINTAMT, :PRINCIPAL_FIXAMT, :LOANPAYMENT_TYPE, :PERIOD_INSTALLMENT, :PERIOD_PAYMENT, :RED_DOCNO, :BLACK_DOCNO, :REF_CONTRACTNO, :INT_RATE, :FINE_RATE, :PERIOD_LASTPAYMENT, :PAYMENT_STATUS, :LAST_PERIODPAY, :STARTCONT_DATE, :LASTRECEIVE_DATE, :LASTPAYMENT_DATE, :LASTCALINT_DATE, :LASTPROCESS_DATE, :LASTACCESS_DATE, :CLOSECONT_DATE, :PRINCIPAL_ARREAR, :INTEREST_ARREAR, :INTYEAR_ARREAR, :INTEREST_ACCUM, :INTACCUM_LASTYEAR, :PRINCIPAL_RETURN, :INTEREST_RETURN, :LAST_STM_NO, :OD_FLAG, :CONTRACT_STATUS, :APPROVE_ID, :APPROVE_BYCOOPID, :REMARK, :PERIOD_PAYAMT, :PERIOD_PAYMENT_MAX, :EXPIRECONT_DATE, :CANCEL_ID, :CANCEL_DATE, :CANCEL_CAUSE, :FINEYEAR_ARREAR, :FINE_ARREAR, :LASTREC_NO, :LASTLINE_NO, :LASTPAGE_NO, :LASTCALFINE_DATE, :CONTRACT_INTEREST, :BFFINEYEAR_ARREAR, :BFINTERESTYEAR_ARREAR, :PRTBOOK_FLAG, :PRTCARD_FLAG, :p1, :LASTREC_NO_CARD, :LASTLINE_NO_CARD, :LASTPAGE_NO_CARD) select * from LNLAWMASTER UPDATE "LNLAWMASTER" 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, "PRINCIPAL_CALINTAMT" = :PRINCIPAL_CALINTAMT, "PRINCIPAL_FIXAMT" = :PRINCIPAL_FIXAMT, "LOANPAYMENT_TYPE" = :LOANPAYMENT_TYPE, "PERIOD_INSTALLMENT" = :PERIOD_INSTALLMENT, "PERIOD_PAYMENT" = :PERIOD_PAYMENT, "RED_DOCNO" = :RED_DOCNO, "BLACK_DOCNO" = :BLACK_DOCNO, "REF_CONTRACTNO" = :REF_CONTRACTNO, "INT_RATE" = :INT_RATE, "FINE_RATE" = :FINE_RATE, "PERIOD_LASTPAYMENT" = :PERIOD_LASTPAYMENT, "PAYMENT_STATUS" = :PAYMENT_STATUS, "LAST_PERIODPAY" = :LAST_PERIODPAY, "STARTCONT_DATE" = :STARTCONT_DATE, "LASTRECEIVE_DATE" = :LASTRECEIVE_DATE, "LASTPAYMENT_DATE" = :LASTPAYMENT_DATE, "LASTCALINT_DATE" = :LASTCALINT_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, "LAST_STM_NO" = :LAST_STM_NO, "OD_FLAG" = :OD_FLAG, "CONTRACT_STATUS" = :CONTRACT_STATUS, "APPROVE_ID" = :APPROVE_ID, "APPROVE_BYCOOPID" = :APPROVE_BYCOOPID, "REMARK" = :REMARK, "PERIOD_PAYAMT" = :PERIOD_PAYAMT, "PERIOD_PAYMENT_MAX" = :PERIOD_PAYMENT_MAX, "EXPIRECONT_DATE" = :EXPIRECONT_DATE, "CANCEL_ID" = :CANCEL_ID, "CANCEL_DATE" = :CANCEL_DATE, "CANCEL_CAUSE" = :CANCEL_CAUSE, "FINEYEAR_ARREAR" = :FINEYEAR_ARREAR, "FINE_ARREAR" = :FINE_ARREAR, "LASTREC_NO" = :LASTREC_NO, "LASTLINE_NO" = :LASTLINE_NO, "LASTPAGE_NO" = :LASTPAGE_NO, "LASTCALFINE_DATE" = :LASTCALFINE_DATE, "CONTRACT_INTEREST" = :CONTRACT_INTEREST, "BFFINEYEAR_ARREAR" = :BFFINEYEAR_ARREAR, "BFINTERESTYEAR_ARREAR" = :BFINTERESTYEAR_ARREAR, "PRTBOOK_FLAG" = :PRTBOOK_FLAG, "PRTCARD_FLAG" = :PRTCARD_FLAG, "BFPRINCIPALYEAR_ARREAR" = :p1, "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))