DELETE FROM "HRUCFDEPTLINE" WHERE (("DEPTLINE_CODE" = :Original_DEPTLINE_CODE)) INSERT INTO "HRUCFDEPTLINE" ("DEPTLINE_CODE", "DEPTLINE_DESC") VALUES (:DEPTLINE_CODE, :DEPTLINE_DESC) select deptline_code, deptline_desc from hrucfdeptline UPDATE "HRUCFDEPTLINE" SET "DEPTLINE_CODE" = :DEPTLINE_CODE, "DEPTLINE_DESC" = :DEPTLINE_DESC WHERE (("DEPTLINE_CODE" = :Original_DEPTLINE_CODE))