USP_DATAFORMTEMPLATE_EDITLOAD_DECEASEDFINDERCREATEPROCESS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@RECORDTYPEID	uniqueidentifier	INOUT
@QUERYID	uniqueidentifier	INOUT
@QUERYTYPE	nvarchar(10)	INOUT
@IDSETREGISTERID	uniqueidentifier	INOUT
@ADDRESSINCLUDECODE	tinyint	INOUT
@ADDRESSTYPECODEID	uniqueidentifier	INOUT
@INCLUDEADDRESSESDNM	bit	INOUT
@CREATEOUTPUTIDSET	bit	INOUT
@OUTPUTIDSETNAME	nvarchar(100)	INOUT
@OVERWRITEOUTPUTIDSET	bit	INOUT
@OWNERID	uniqueidentifier	INOUT

Definition

Copy



          create procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_DECEASEDFINDERCREATEPROCESS
          (
            @ID uniqueidentifier,
            @DATALOADED bit = 0 output,
            @TSLONG bigint = 0 output,
            @RECORDTYPEID uniqueidentifier = null output,
            @QUERYID uniqueidentifier = null output,
            @QUERYTYPE nvarchar(10) = null output,
            @IDSETREGISTERID uniqueidentifier = null output,
            @ADDRESSINCLUDECODE tinyint = null output,
            @ADDRESSTYPECODEID uniqueidentifier = null output,
            @INCLUDEADDRESSESDNM bit = null output,
            @CREATEOUTPUTIDSET bit = null output,
            @OUTPUTIDSETNAME nvarchar(100) = null output,
            @OVERWRITEOUTPUTIDSET bit = null output,
            @OWNERID uniqueidentifier = null output
          )
          as
            set nocount on;

            set @DATALOADED = 0;
            set @TSLONG = 0;

            select 
              @DATALOADED = 1,
              @TSLONG = TSLONG,
              @IDSETREGISTERID = IDSETREGISTERID,
              @ADDRESSINCLUDECODE = ADDRESSINCLUDECODE,
              @ADDRESSTYPECODEID = ADDRESSTYPECODEID,
              @INCLUDEADDRESSESDNM = INCLUDEADDRESSESDNM,
              @CREATEOUTPUTIDSET = CREATEOUTPUTIDSET,
              @OUTPUTIDSETNAME = OUTPUTIDSETNAME,
              @OVERWRITEOUTPUTIDSET = OVERWRITEOUTPUTIDSET,
              @OWNERID = dbo.UFN_BUSINESSPROCESSINSTANCE_GETOWNER('18F4FBE4-8AFB-4FFE-84E1-F1FC59948775' ,@ID)
            from 
              dbo.DECEASEDFINDERCREATEPROCESS
            where
              ID = @ID;

            select @RECORDTYPEID = ID from dbo.RECORDTYPE where upper(NAME) = 'CONSTITUENT';                    
            select @QUERYID = dbo.UFN_IDSET_GETQUERYID(@IDSETREGISTERID);
            select @QUERYTYPE = dbo.UFN_IDSET_GETQUERYTYPE(@IDSETREGISTERID);

            return 0;