DELETE FROM "AMSECWINS" WHERE (("APPLICATION" = :Original_APPLICATION) AND ("WINDOW_ID" = :Original_WINDOW_ID)) SELECT APPLICATION, WINDOW_ID, WIN_OBJECT, WIN_DESCRIPTION, WIN_PARAMETER, WIN_TITLE, WIN_TOOLBAR, OPEN_TYPE, ICON_LABEL, ICON_PICTURE, USED_FLAG, GROUP_CODE, WIN_ORDER, WEB_REDIRECT, WEBWINWORK_CODE, COOP_CONTROL,APV_FLAG FROM AMSECWINS WHERE (APPLICATION = :as_application) AND (COOP_CONTROL = :as_coop_control) UPDATE "AMSECWINS" SET "APPLICATION" = :APPLICATION, "WINDOW_ID" = :WINDOW_ID, "WIN_OBJECT" = :WIN_OBJECT, "WIN_DESCRIPTION" = :WIN_DESCRIPTION, "WIN_PARAMETER" = :WIN_PARAMETER, "WIN_TITLE" = :WIN_TITLE, "WIN_TOOLBAR" = :WIN_TOOLBAR, "OPEN_TYPE" = :OPEN_TYPE, "ICON_LABEL" = :ICON_LABEL, "ICON_PICTURE" = :ICON_PICTURE, "USED_FLAG" = :USED_FLAG, "GROUP_CODE" = :GROUP_CODE, "WIN_ORDER" = :WIN_ORDER, "WEB_REDIRECT" = :WEB_REDIRECT, "WEBWINWORK_CODE" = :WEBWINWORK_CODE, "COOP_CONTROL" = :COOP_CONTROL, "APV_FLAG" = :APV_FLAG WHERE (("APPLICATION" = :Original_APPLICATION) AND ("WINDOW_ID" = :Original_WINDOW_ID)) DELETE FROM "AMSECWINSGROUP" WHERE (("APPLICATION" = :Original_APPLICATION) AND ("GROUP_CODE" = :Original_GROUP_CODE)) INSERT INTO "AMSECWINSGROUP" ("APPLICATION", "GROUP_CODE", "GROUP_DESC", "GROUP_ORDER", "COOP_CONTROL") VALUES (:APPLICATION, :GROUP_CODE, :GROUP_DESC, :GROUP_ORDER, :COOP_CONTROL) select * from amsecwinsgroup where application=:as_application and coop_control=:as_coop_control UPDATE "AMSECWINSGROUP" SET "APPLICATION" = :APPLICATION, "GROUP_CODE" = :GROUP_CODE, "GROUP_DESC" = :GROUP_DESC, "GROUP_ORDER" = :GROUP_ORDER, "COOP_CONTROL" = :COOP_CONTROL WHERE (("APPLICATION" = :Original_APPLICATION) AND ("GROUP_CODE" = :Original_GROUP_CODE))