USP_DATAFORMTEMPLATE_EDIT_DECEASEDFINDERCREATEPROCESS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@IDSETREGISTERID	uniqueidentifier	IN
@ADDRESSINCLUDECODE	tinyint	IN
@ADDRESSTYPECODEID	uniqueidentifier	IN
@INCLUDEADDRESSESDNM	bit	IN
@CREATEOUTPUTIDSET	bit	IN
@OUTPUTIDSETNAME	nvarchar(100)	IN
@OVERWRITEOUTPUTIDSET	bit	IN
Definition

Copy


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

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

            if not @ADDRESSINCLUDECODE = 2
              set @ADDRESSTYPECODEID = NULL

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

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

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

            end try

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

            return 0;