DELETE FROM "YRREQCHG" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("REQCHG_DOCNO" = :Original_REQCHG_DOCNO)) INSERT INTO "YRREQCHG" ("COOP_ID", "REQCHG_DOCNO", "DIV_YEAR", "MEMBER_NO", "REQCHG_DATE", "REQCHG_STATUS", "ENTRY_ID", "ENTRY_BYCOOPID", "ENTRY_DATE", "CANCEL_ID", "CANCEL_BYCOOPID", "CANCEL_DATE", "REMARK") VALUES (:COOP_ID, :REQCHG_DOCNO, :DIV_YEAR, :MEMBER_NO, :REQCHG_DATE, :REQCHG_STATUS, :ENTRY_ID, :ENTRY_BYCOOPID, :ENTRY_DATE, :CANCEL_ID, :CANCEL_BYCOOPID, :CANCEL_DATE, :REMARK) SELECT "YRREQCHG"."COOP_ID", "YRREQCHG"."REQCHG_DOCNO", "YRREQCHG"."DIV_YEAR", "YRREQCHG"."MEMBER_NO", "YRREQCHG"."REQCHG_DATE", "YRREQCHG"."REQCHG_STATUS", "YRREQCHG"."ENTRY_ID", "YRREQCHG"."ENTRY_BYCOOPID", "YRREQCHG"."ENTRY_DATE", "YRREQCHG"."CANCEL_ID", "YRREQCHG"."CANCEL_BYCOOPID", "YRREQCHG"."CANCEL_DATE", "YRREQCHG"."REMARK" FROM "YRREQCHG" UPDATE "YRREQCHG" SET "COOP_ID" = :COOP_ID, "REQCHG_DOCNO" = :REQCHG_DOCNO, "DIV_YEAR" = :DIV_YEAR, "MEMBER_NO" = :MEMBER_NO, "REQCHG_DATE" = :REQCHG_DATE, "REQCHG_STATUS" = :REQCHG_STATUS, "ENTRY_ID" = :ENTRY_ID, "ENTRY_BYCOOPID" = :ENTRY_BYCOOPID, "ENTRY_DATE" = :ENTRY_DATE, "CANCEL_ID" = :CANCEL_ID, "CANCEL_BYCOOPID" = :CANCEL_BYCOOPID, "CANCEL_DATE" = :CANCEL_DATE, "REMARK" = :REMARK WHERE (("COOP_ID" = :Original_COOP_ID) AND ("REQCHG_DOCNO" = :Original_REQCHG_DOCNO)) DELETE FROM "YRREQCHGSEQUEST" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("REQCHG_DOCNO" = :Original_REQCHG_DOCNO) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "YRREQCHGSEQUEST" ("COOP_ID", "REQCHG_DOCNO", "SEQ_NO", "SEQUEST_FLAG", "SEQUEST_AMT") VALUES (:COOP_ID, :REQCHG_DOCNO, :SEQ_NO, :SEQUEST_FLAG, :SEQUEST_AMT) SELECT "YRREQCHGSEQUEST"."COOP_ID", "YRREQCHGSEQUEST"."REQCHG_DOCNO", "YRREQCHGSEQUEST"."SEQ_NO", "YRREQCHGSEQUEST"."SEQUEST_FLAG", "YRREQCHGSEQUEST"."SEQUEST_AMT" FROM "YRREQCHGSEQUEST" UPDATE "YRREQCHGSEQUEST" SET "COOP_ID" = :COOP_ID, "REQCHG_DOCNO" = :REQCHG_DOCNO, "SEQ_NO" = :SEQ_NO, "SEQUEST_FLAG" = :SEQUEST_FLAG, "SEQUEST_AMT" = :SEQUEST_AMT WHERE (("COOP_ID" = :Original_COOP_ID) AND ("REQCHG_DOCNO" = :Original_REQCHG_DOCNO) AND ("SEQ_NO" = :Original_SEQ_NO))