USP_BUSINESSPROCESSCOMMPREF_DELETE

Deletes a business process communication preferences.

Parameters

Parameter	Parameter Type	Mode
@BUSINESSPROCESSCATALOGID	uniqueidentifier	IN
@BUSINESSPROCESSPARAMETERSETID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_BUSINESSPROCESSCOMMPREF_DELETE
            (
                @BUSINESSPROCESSCATALOGID uniqueidentifier,
                @BUSINESSPROCESSPARAMETERSETID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier                            
            )
            as
            begin

                --Cache CONTEXT INFO

                declare @contextCache varbinary(128);
                set @contextCache = CONTEXT_INFO();

                if not @CHANGEAGENTID is null
                set CONTEXT_INFO @CHANGEAGENTID;

                delete from dbo.BUSINESSPROCESSCOMMPREF 
                where BUSINESSPROCESSCATALOGID = @BUSINESSPROCESSCATALOGID and BUSINESSPROCESSPARAMETERSETID = @BUSINESSPROCESSPARAMETERSETID;

                delete from dbo.BUSINESSPROCESSCOMMPREFEXCLUSIONS
                where BUSINESSPROCESSPARAMETERSETID = @BUSINESSPROCESSPARAMETERSETID;

                --delete from dbo.BUSINESSPROCESSCOMMPREFINCLUSIONS

                --where BUSINESSPROCESSPARAMETERSETID = @BUSINESSPROCESSPARAMETERSETID;


                --Restore CONTEXT INFO 

                if not @contextCache is null
                    set CONTEXT_INFO @contextCache;                 
            end