USP_BUSINESSPROCESSCOMMPREF_ADD

Creates communication preferences for a business process.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@BUSINESSPROCESSCATALOGID	uniqueidentifier	IN
@BUSINESSPROCESSPARAMETERSETID	uniqueidentifier	IN
@EXCLUSIONDATETYPECODE	tinyint	IN
@EXCLUSIONASOFDATE	datetime	IN
@EXCLUDEDECEASED	bit	IN
@EXCLUDEINACTIVE	bit	IN
@EXCLUSIONS	xml	IN
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_BUSINESSPROCESSCOMMPREF_ADD
            (
                @ID uniqueidentifier = null output,                        
                @CHANGEAGENTID uniqueidentifier,                        
                @BUSINESSPROCESSCATALOGID uniqueidentifier = null,
                @BUSINESSPROCESSPARAMETERSETID uniqueidentifier = null,
                @EXCLUSIONDATETYPECODE tinyint = 0,
                @EXCLUSIONASOFDATE datetime = null,
                @EXCLUDEDECEASED bit = null,
                @EXCLUDEINACTIVE bit = null,
                @EXCLUSIONS xml = null,
                --@OVERRIDEREQUIREDEXCLUSIONS bit = 0,

                --@REQUIREDEXCLUSIONS xml = null,

                @CURRENTAPPUSERID uniqueidentifier = null
                --@INCLUSIONS xml = null

            )
            as
                set nocount on;

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

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

                if @ID is null
                    set @ID = newid();

                begin try                        
                    insert into dbo.BUSINESSPROCESSCOMMPREF 
                        (ID, 
                        BUSINESSPROCESSCATALOGID, 
                        BUSINESSPROCESSPARAMETERSETID, 
                        DATETYPECODE,
            EXCLUDEDECEASED,
            EXCLUDEINACTIVE,
                        ASOFDATE,             
                        ADDEDBYID, 
                        CHANGEDBYID, 
                        DATEADDED, 
                        DATECHANGED)
                    values
                        (@ID,
                        @BUSINESSPROCESSCATALOGID,
                        @BUSINESSPROCESSPARAMETERSETID,
                        @EXCLUSIONDATETYPECODE,
            @EXCLUDEDECEASED,
            @EXCLUDEINACTIVE,
                        @EXCLUSIONASOFDATE,
                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        @CURRENTDATE,
                        @CURRENTDATE);

                    exec dbo.USP_BUSINESSPROCESSCOMMPREF_GETEXCLUSIONS_ADDFROMXML @BUSINESSPROCESSPARAMETERSETID, @EXCLUSIONS, @CHANGEAGENTID;
                    --exec dbo.USP_BUSINESSPROCESSCOMMPREF_GETINCLUSIONS_ADDFROMXML @BUSINESSPROCESSPARAMETERSETID, @INCLUSIONS, @CHANGEAGENTID;


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

                return 0;