USP_DATAFORMTEMPLATE_EDIT_COAUPDATECREATEPROCESS

          create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_COAUPDATECREATEPROCESS
          (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null,
            @IDSETREGISTERID uniqueidentifier,
            @INCLUDECONSTITUENTDNM bit,
            @ADDRESSINCLUDECODE tinyint,
            @ADDRESSTYPECODEID uniqueidentifier,
            @INCLUDEADDRESSESDNM bit,
            @CREATEOUTPUTIDSET bit,
            @OUTPUTIDSETNAME nvarchar(100),
            @OVERWRITEOUTPUTIDSET bit,
            @SUBMITHOUSEHOLD bit
          )
          as
            set nocount on;

            declare @CURRENTDATE datetime;
            set @CURRENTDATE = getdate();

            begin try
              if @CHANGEAGENTID is null  
                exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

            if not @ADDRESSINCLUDECODE = 2
              set @ADDRESSTYPECODEID = NULL

              if @ID is null
              begin
                set @ID = NewID();

                insert into dbo.COAUPDATECREATEPROCESS
                (ID,
                  IDSETREGISTERID,
                  INCLUDECONSTITUENTDNM,
                  ADDRESSINCLUDECODE,
                  ADDRESSTYPECODEID,
                  INCLUDEADDRESSESDNM,
                  CREATEOUTPUTIDSET,
                  OUTPUTIDSETNAME,
                  OVERWRITEOUTPUTIDSET,
                  SUBMITHOUSEHOLD,
                  ADDEDBYID,
                  CHANGEDBYID,
                  DATEADDED,
                  DATECHANGED)
                values
                (@ID,
                  @IDSETREGISTERID,
                  @INCLUDECONSTITUENTDNM,
                  @ADDRESSINCLUDECODE,
                  @ADDRESSTYPECODEID,
                  @INCLUDEADDRESSESDNM,
                  @CREATEOUTPUTIDSET,
                  @OUTPUTIDSETNAME,
                  @OVERWRITEOUTPUTIDSET,
                  @SUBMITHOUSEHOLD,
                  @CHANGEAGENTID,
                  @CHANGEAGENTID,
                  @CURRENTDATE,
                  @CURRENTDATE);
              end
              else
              begin
                update dbo.COAUPDATECREATEPROCESS
                set IDSETREGISTERID = @IDSETREGISTERID,
                  INCLUDECONSTITUENTDNM = @INCLUDECONSTITUENTDNM,
                  CHANGEDBYID = @CHANGEAGENTID,
                  DATECHANGED = @CURRENTDATE,
                  ADDRESSINCLUDECODE = @ADDRESSINCLUDECODE,
                  ADDRESSTYPECODEID = @ADDRESSTYPECODEID,
                  INCLUDEADDRESSESDNM = @INCLUDEADDRESSESDNM,
                  CREATEOUTPUTIDSET = @CREATEOUTPUTIDSET,
                  OUTPUTIDSETNAME = @OUTPUTIDSETNAME,
                  OVERWRITEOUTPUTIDSET = @OVERWRITEOUTPUTIDSET,
                  SUBMITHOUSEHOLD = @SUBMITHOUSEHOLD
                where ID = @ID;
              end

            --Keep the old SUBMIT process in sync for backwards compatibility

            declare @COAUPDATEID uniqueidentifier = (select [COAUPDATEID] from dbo.[COAUPDATECREATEPROCESS] where [ID] = @ID);
            declare @COAUPDATESUBMITPROCESSID uniqueidentifier = (select [ID] from dbo.[COAUPDATESUBMITPROCESS] where [COAUPDATEID] = @COAUPDATEID);
            if @COAUPDATESUBMITPROCESSID is not null
              exec dbo.[USP_DATAFORMTEMPLATE_EDIT_COAUPDATESUBMITPROCESS2]
                @COAUPDATESUBMITPROCESSID,
                @CHANGEAGENTID,
                @IDSETREGISTERID,
                @INCLUDECONSTITUENTDNM,
                @ADDRESSINCLUDECODE,
                @ADDRESSTYPECODEID,
                @INCLUDEADDRESSESDNM,
                @CREATEOUTPUTIDSET,
                @OUTPUTIDSETNAME,
                @OVERWRITEOUTPUTIDSET,
                @SUBMITHOUSEHOLD;

            end try

            begin catch
              exec dbo.USP_RAISE_ERROR;
              return 1;
            end catch

            return 0;