DELETE FROM "LNLOANCONSTANT" WHERE (("COOP_ID" = :Original_COOP_ID)) INSERT INTO "LNLOANCONSTANT" ("COOP_ID", "MAXALLLOAN_AMOUNT", "DAYINYEAR", "FORMATYEAR_TYPE", "FORMATMONTH_TYPE", "CONTRACT_FORMAT", "COUNTDATE_TYPE", "INTROUND_TYPE", "GRTRIGHT_CONTFLAG", "GRTRIGHT_MEMFLAG", "GRTRIGHT_CONTRACT", "GRTRIGHT_MEMBER", "INCLUINTARR_STATUS", "GENBF_STATUS", "STARTCALINT_TYPE", "CALINT_FUTURE", "FURTUREINT_RECIEVE", "PRINTCONTRACT", "INTROUNDSUM_TYPE", "INTROUND_FORMAT", "INTROUND_NUM", "RECEIPTSPLIT_FLAG", "KPPROCMRT_TYPE", "FIXPAYCAL_TYPE", "COUNTDATEFST_TYPE", "INSVAT_RATE", "INSCOORDINATE_RATE", "INSDISCOUNT_RATE", "TRNCOLLSPLIT_TYPE", "TRNCOLLCONTNO_TYPE", "TRNCOLLCONTNO_REF", "INTFUTMINUSINTRET_FLAG", "INSURANCEDEFALSE_AMT", "KEEPORDER_TYPE", "KPITEMARRDOUBLE_FLAG", "FINEPX_PERCENT", "FINEPX_FLAG", "FINEARRROUND_TYPE", "MAXKPLNBLANCE_AMT", "GENCONTNO_FLAG", "INTROUNDKP_TYPE", "LNPAYARREAR_PERC", "LNPAYARREAR_TYPE", "LNPAYARREAR_STATUS", "RDINTSATANG_TYPE", "RDINTSATANG_TABCODE", "RDINTSATANGSUM_TYPE", "RDINTDEC_TYPE", "FIXPAYINTOVERFST_TYPE", "FIXPAYINTOVERFSTPRN_TYPE", "FIXPAYINTOVERNXT_TYPE", "FIXPAYINTOVERNXTPRN_TYPE", "INTDATEVIEW_TYPE", "GRTRIGHT_TYPE", "INTDATEINC_FIRSTRCV", "INTDATEINC_LASTPAY", "RDINTDEC_DIGIT", "GRTMEMCO_CONTFLAG", "GRTMEMCO_MEMFLAG", "GRTMEMCO_CONTRACT", "GRTMEMCO_MEMBER", "COOP_NO", "INSFLOOD_AMT", "LNOVERRETRY_SHRFORMAT", "LNOVERRETRY_SHRRATIO", "LNOVERRETRY_SHRPERC", "LNOVERRETRY_CMFORMAT", "LNOVERRETRY_CMRATIO", "LNOVERRETRY_CMPERC", "CONTCOUNT", "CONTCOUNT_END", "PAGETOTAL_PB", "LINENOMIDPAGE_PB", "NLINENEXTMID_PB", "LINEPERPAGE_PB", "LINEPERPAGE_PB_CARD", "LINENOMIDPAGE_PB_CARD", "NLINENEXTMID_PB_CARD", "PAGETOTAL_PB_CARD") VALUES (:COOP_ID, :MAXALLLOAN_AMOUNT, :DAYINYEAR, :FORMATYEAR_TYPE, :FORMATMONTH_TYPE, :CONTRACT_FORMAT, :COUNTDATE_TYPE, :INTROUND_TYPE, :GRTRIGHT_CONTFLAG, :GRTRIGHT_MEMFLAG, :GRTRIGHT_CONTRACT, :GRTRIGHT_MEMBER, :INCLUINTARR_STATUS, :GENBF_STATUS, :STARTCALINT_TYPE, :CALINT_FUTURE, :FURTUREINT_RECIEVE, :PRINTCONTRACT, :INTROUNDSUM_TYPE, :INTROUND_FORMAT, :INTROUND_NUM, :RECEIPTSPLIT_FLAG, :KPPROCMRT_TYPE, :FIXPAYCAL_TYPE, :COUNTDATEFST_TYPE, :INSVAT_RATE, :INSCOORDINATE_RATE, :INSDISCOUNT_RATE, :TRNCOLLSPLIT_TYPE, :TRNCOLLCONTNO_TYPE, :TRNCOLLCONTNO_REF, :p1, :INSURANCEDEFALSE_AMT, :KEEPORDER_TYPE, :KPITEMARRDOUBLE_FLAG, :FINEPX_PERCENT, :FINEPX_FLAG, :FINEARRROUND_TYPE, :MAXKPLNBLANCE_AMT, :GENCONTNO_FLAG, :INTROUNDKP_TYPE, :LNPAYARREAR_PERC, :LNPAYARREAR_TYPE, :LNPAYARREAR_STATUS, :RDINTSATANG_TYPE, :RDINTSATANG_TABCODE, :RDINTSATANGSUM_TYPE, :RDINTDEC_TYPE, :FIXPAYINTOVERFST_TYPE, :p4, :FIXPAYINTOVERNXT_TYPE, :p7, :INTDATEVIEW_TYPE, :GRTRIGHT_TYPE, :INTDATEINC_FIRSTRCV, :INTDATEINC_LASTPAY, :RDINTDEC_DIGIT, :GRTMEMCO_CONTFLAG, :GRTMEMCO_MEMFLAG, :GRTMEMCO_CONTRACT, :GRTMEMCO_MEMBER, :COOP_NO, :INSFLOOD_AMT, :LNOVERRETRY_SHRFORMAT, :LNOVERRETRY_SHRRATIO, :LNOVERRETRY_SHRPERC, :LNOVERRETRY_CMFORMAT, :LNOVERRETRY_CMRATIO, :LNOVERRETRY_CMPERC, :CONTCOUNT, :CONTCOUNT_END, :PAGETOTAL_PB, :LINENOMIDPAGE_PB, :NLINENEXTMID_PB, :LINEPERPAGE_PB, :LINEPERPAGE_PB_CARD, :LINENOMIDPAGE_PB_CARD, :NLINENEXTMID_PB_CARD, :PAGETOTAL_PB_CARD) SELECT * FROM LNLOANCONSTANT UPDATE "LNLOANCONSTANT" SET "COOP_ID" = :COOP_ID, "MAXALLLOAN_AMOUNT" = :MAXALLLOAN_AMOUNT, "DAYINYEAR" = :DAYINYEAR, "FORMATYEAR_TYPE" = :FORMATYEAR_TYPE, "FORMATMONTH_TYPE" = :FORMATMONTH_TYPE, "CONTRACT_FORMAT" = :CONTRACT_FORMAT, "COUNTDATE_TYPE" = :COUNTDATE_TYPE, "INTROUND_TYPE" = :INTROUND_TYPE, "GRTRIGHT_CONTFLAG" = :GRTRIGHT_CONTFLAG, "GRTRIGHT_MEMFLAG" = :GRTRIGHT_MEMFLAG, "GRTRIGHT_CONTRACT" = :GRTRIGHT_CONTRACT, "GRTRIGHT_MEMBER" = :GRTRIGHT_MEMBER, "INCLUINTARR_STATUS" = :INCLUINTARR_STATUS, "GENBF_STATUS" = :GENBF_STATUS, "STARTCALINT_TYPE" = :STARTCALINT_TYPE, "CALINT_FUTURE" = :CALINT_FUTURE, "FURTUREINT_RECIEVE" = :FURTUREINT_RECIEVE, "PRINTCONTRACT" = :PRINTCONTRACT, "INTROUNDSUM_TYPE" = :INTROUNDSUM_TYPE, "INTROUND_FORMAT" = :INTROUND_FORMAT, "INTROUND_NUM" = :INTROUND_NUM, "RECEIPTSPLIT_FLAG" = :RECEIPTSPLIT_FLAG, "KPPROCMRT_TYPE" = :KPPROCMRT_TYPE, "FIXPAYCAL_TYPE" = :FIXPAYCAL_TYPE, "COUNTDATEFST_TYPE" = :COUNTDATEFST_TYPE, "INSVAT_RATE" = :INSVAT_RATE, "INSCOORDINATE_RATE" = :INSCOORDINATE_RATE, "INSDISCOUNT_RATE" = :INSDISCOUNT_RATE, "TRNCOLLSPLIT_TYPE" = :TRNCOLLSPLIT_TYPE, "TRNCOLLCONTNO_TYPE" = :TRNCOLLCONTNO_TYPE, "TRNCOLLCONTNO_REF" = :TRNCOLLCONTNO_REF, "INTFUTMINUSINTRET_FLAG" = :p1, "INSURANCEDEFALSE_AMT" = :INSURANCEDEFALSE_AMT, "KEEPORDER_TYPE" = :KEEPORDER_TYPE, "KPITEMARRDOUBLE_FLAG" = :KPITEMARRDOUBLE_FLAG, "FINEPX_PERCENT" = :FINEPX_PERCENT, "FINEPX_FLAG" = :FINEPX_FLAG, "FINEARRROUND_TYPE" = :FINEARRROUND_TYPE, "MAXKPLNBLANCE_AMT" = :MAXKPLNBLANCE_AMT, "GENCONTNO_FLAG" = :GENCONTNO_FLAG, "INTROUNDKP_TYPE" = :INTROUNDKP_TYPE, "LNPAYARREAR_PERC" = :LNPAYARREAR_PERC, "LNPAYARREAR_TYPE" = :LNPAYARREAR_TYPE, "LNPAYARREAR_STATUS" = :LNPAYARREAR_STATUS, "RDINTSATANG_TYPE" = :RDINTSATANG_TYPE, "RDINTSATANG_TABCODE" = :RDINTSATANG_TABCODE, "RDINTSATANGSUM_TYPE" = :RDINTSATANGSUM_TYPE, "RDINTDEC_TYPE" = :RDINTDEC_TYPE, "FIXPAYINTOVERFST_TYPE" = :FIXPAYINTOVERFST_TYPE, "FIXPAYINTOVERFSTPRN_TYPE" = :p4, "FIXPAYINTOVERNXT_TYPE" = :FIXPAYINTOVERNXT_TYPE, "FIXPAYINTOVERNXTPRN_TYPE" = :p7, "INTDATEVIEW_TYPE" = :INTDATEVIEW_TYPE, "GRTRIGHT_TYPE" = :GRTRIGHT_TYPE, "INTDATEINC_FIRSTRCV" = :INTDATEINC_FIRSTRCV, "INTDATEINC_LASTPAY" = :INTDATEINC_LASTPAY, "RDINTDEC_DIGIT" = :RDINTDEC_DIGIT, "GRTMEMCO_CONTFLAG" = :GRTMEMCO_CONTFLAG, "GRTMEMCO_MEMFLAG" = :GRTMEMCO_MEMFLAG, "GRTMEMCO_CONTRACT" = :GRTMEMCO_CONTRACT, "GRTMEMCO_MEMBER" = :GRTMEMCO_MEMBER, "COOP_NO" = :COOP_NO, "INSFLOOD_AMT" = :INSFLOOD_AMT, "LNOVERRETRY_SHRFORMAT" = :LNOVERRETRY_SHRFORMAT, "LNOVERRETRY_SHRRATIO" = :LNOVERRETRY_SHRRATIO, "LNOVERRETRY_SHRPERC" = :LNOVERRETRY_SHRPERC, "LNOVERRETRY_CMFORMAT" = :LNOVERRETRY_CMFORMAT, "LNOVERRETRY_CMRATIO" = :LNOVERRETRY_CMRATIO, "LNOVERRETRY_CMPERC" = :LNOVERRETRY_CMPERC, "CONTCOUNT" = :CONTCOUNT, "CONTCOUNT_END" = :CONTCOUNT_END, "PAGETOTAL_PB" = :PAGETOTAL_PB, "LINENOMIDPAGE_PB" = :LINENOMIDPAGE_PB, "NLINENEXTMID_PB" = :NLINENEXTMID_PB, "LINEPERPAGE_PB" = :LINEPERPAGE_PB, "LINEPERPAGE_PB_CARD" = :LINEPERPAGE_PB_CARD, "LINENOMIDPAGE_PB_CARD" = :LINENOMIDPAGE_PB_CARD, "NLINENEXTMID_PB_CARD" = :NLINENEXTMID_PB_CARD, "PAGETOTAL_PB_CARD" = :PAGETOTAL_PB_CARD WHERE (("COOP_ID" = :Original_COOP_ID))