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)) DELETE FROM "LNLAWMBMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO)) INSERT INTO "LNLAWMBMASTER" ("COOP_ID", "MEMBER_NO", "PRENAME_CODE", "MEMB_NAME", "MEMB_SURNAME", "MEMBGROUP_CODE", "MEMBTYPE_CODE", "BIRTH_DATE", "MEMBER_DATE", "ADDR_NO", "ADDR_MOO", "ADDR_SOI", "ADDR_VILLAGE", "ADDR_ROAD", "TAMBOL_CODE", "AMPHUR_CODE", "PROVINCE_CODE", "ADDR_POSTCODE", "ADDR_PHONE", "MATE_NAME", "CARD_PERSON", "REMARK", "MEMBER_TYPE", "T_PROVINCE", "T_AMPHUR", "T_TAMBOL") VALUES (:COOP_ID, :MEMBER_NO, :PRENAME_CODE, :MEMB_NAME, :MEMB_SURNAME, :MEMBGROUP_CODE, :MEMBTYPE_CODE, :BIRTH_DATE, :MEMBER_DATE, :ADDR_NO, :ADDR_MOO, :ADDR_SOI, :ADDR_VILLAGE, :ADDR_ROAD, :TAMBOL_CODE, :AMPHUR_CODE, :PROVINCE_CODE, :ADDR_POSTCODE, :ADDR_PHONE, :MATE_NAME, :CARD_PERSON, :REMARK, :MEMBER_TYPE, :T_PROVINCE, :T_AMPHUR, :T_TAMBOL) select * from LNLAWMBMASTER UPDATE "LNLAWMBMASTER" SET "COOP_ID" = :COOP_ID, "MEMBER_NO" = :MEMBER_NO, "PRENAME_CODE" = :PRENAME_CODE, "MEMB_NAME" = :MEMB_NAME, "MEMB_SURNAME" = :MEMB_SURNAME, "MEMBGROUP_CODE" = :MEMBGROUP_CODE, "MEMBTYPE_CODE" = :MEMBTYPE_CODE, "BIRTH_DATE" = :BIRTH_DATE, "MEMBER_DATE" = :MEMBER_DATE, "ADDR_NO" = :ADDR_NO, "ADDR_MOO" = :ADDR_MOO, "ADDR_SOI" = :ADDR_SOI, "ADDR_VILLAGE" = :ADDR_VILLAGE, "ADDR_ROAD" = :ADDR_ROAD, "TAMBOL_CODE" = :TAMBOL_CODE, "AMPHUR_CODE" = :AMPHUR_CODE, "PROVINCE_CODE" = :PROVINCE_CODE, "ADDR_POSTCODE" = :ADDR_POSTCODE, "ADDR_PHONE" = :ADDR_PHONE, "MATE_NAME" = :MATE_NAME, "CARD_PERSON" = :CARD_PERSON, "REMARK" = :REMARK, "MEMBER_TYPE" = :MEMBER_TYPE, "T_PROVINCE" = :T_PROVINCE, "T_AMPHUR" = :T_AMPHUR, "T_TAMBOL" = :T_TAMBOL WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO)) DELETE FROM "LNLAWCOLL" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LOANCONTRACT_NO" = :Original_LOANCONTRACT_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "LNLAWCOLL" ("COOP_ID", "LOANCONTRACT_NO", "SEQ_NO", "LOANCOLLTYPE_CODE", "REF_COLLNO", "DESCRIPTION", "COLL_AMT", "COLL_BALANCE", "COLL_STATUS", "REMARK", "COLLBASE_AMT", "COLLBALANCE_AMT", "COLLACTIVE_AMT") VALUES (:COOP_ID, :LOANCONTRACT_NO, :SEQ_NO, :LOANCOLLTYPE_CODE, :REF_COLLNO, :DESCRIPTION, :COLL_AMT, :COLL_BALANCE, :COLL_STATUS, :REMARK, :COLLBASE_AMT, :COLLBALANCE_AMT, :COLLACTIVE_AMT) select * from LNLAWCOLL UPDATE "LNLAWCOLL" SET "COOP_ID" = :COOP_ID, "LOANCONTRACT_NO" = :LOANCONTRACT_NO, "SEQ_NO" = :SEQ_NO, "LOANCOLLTYPE_CODE" = :LOANCOLLTYPE_CODE, "REF_COLLNO" = :REF_COLLNO, "DESCRIPTION" = :DESCRIPTION, "COLL_AMT" = :COLL_AMT, "COLL_BALANCE" = :COLL_BALANCE, "COLL_STATUS" = :COLL_STATUS, "REMARK" = :REMARK, "COLLBASE_AMT" = :COLLBASE_AMT, "COLLBALANCE_AMT" = :COLLBALANCE_AMT, "COLLACTIVE_AMT" = :COLLACTIVE_AMT WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LOANCONTRACT_NO" = :Original_LOANCONTRACT_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) DELETE FROM "LNLAWOBJ" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LOANCONTRACT_NO" = :Original_LOANCONTRACT_NO) AND ("LOANOBJ_CODE" = :Original_LOANOBJ_CODE) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "LNLAWOBJ" ("COOP_ID", "LOANCONTRACT_NO", "LOANOBJ_CODE", "SEQ_NO", "LOANOBJ_DESC", "LOANOBJ_AMT") VALUES (:COOP_ID, :LOANCONTRACT_NO, :LOANOBJ_CODE, :SEQ_NO, :LOANOBJ_DESC, :LOANOBJ_AMT) select * from lnlawobj UPDATE "LNLAWOBJ" SET "COOP_ID" = :COOP_ID, "LOANCONTRACT_NO" = :LOANCONTRACT_NO, "LOANOBJ_CODE" = :LOANOBJ_CODE, "SEQ_NO" = :SEQ_NO, "LOANOBJ_DESC" = :LOANOBJ_DESC, "LOANOBJ_AMT" = :LOANOBJ_AMT WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LOANCONTRACT_NO" = :Original_LOANCONTRACT_NO) AND ("LOANOBJ_CODE" = :Original_LOANOBJ_CODE) AND ("SEQ_NO" = :Original_SEQ_NO))