USP_DATAFORMTEMPLATE_EDITLOAD_COAUPDATECREATEPROCESS

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
@INCLUDECONSTITUENTDNM	bit	INOUT
@ADDRESSINCLUDECODE	tinyint	INOUT
@ADDRESSTYPECODEID	uniqueidentifier	INOUT
@INCLUDEADDRESSESDNM	bit	INOUT
@CREATEOUTPUTIDSET	bit	INOUT
@OUTPUTIDSETNAME	nvarchar(100)	INOUT
@OVERWRITEOUTPUTIDSET	bit	INOUT
@OWNERID	uniqueidentifier	INOUT
@SUBMITHOUSEHOLD	bit	INOUT

Definition

Copy



          create procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_COAUPDATECREATEPROCESS
          (
            @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,
            @INCLUDECONSTITUENTDNM bit = 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,
            @SUBMITHOUSEHOLD bit = null output
          )
          as
            set nocount on;

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

            select @DATALOADED = 1,
              @TSLONG = TSLONG,
              @IDSETREGISTERID = IDSETREGISTERID,
              @INCLUDECONSTITUENTDNM = INCLUDECONSTITUENTDNM,
              @ADDRESSINCLUDECODE = ADDRESSINCLUDECODE,
              @ADDRESSTYPECODEID = ADDRESSTYPECODEID,
              @INCLUDEADDRESSESDNM = INCLUDEADDRESSESDNM,
              @CREATEOUTPUTIDSET = CREATEOUTPUTIDSET,
              @OUTPUTIDSETNAME = OUTPUTIDSETNAME,
              @OVERWRITEOUTPUTIDSET = OVERWRITEOUTPUTIDSET,
              @OWNERID = dbo.UFN_BUSINESSPROCESSINSTANCE_GETOWNER('113412a7-daa5-4ef6-9c0d-8aaa9024e06a', @ID),
              @SUBMITHOUSEHOLD = SUBMITHOUSEHOLD
            from dbo.COAUPDATECREATEPROCESS
            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;