USP_INVITATIONHISTORY_DELETEBYBUSINESSPROCESSSTATUSID

Updates the invitation history record with the specified business process status identifier or creates one if no such record exists.

Parameters

Parameter	Parameter Type	Mode	Description
@BUSINESSPROCESSSTATUSID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_INVITATIONHISTORY_DELETEBYBUSINESSPROCESSSTATUSID
            (
                @BUSINESSPROCESSSTATUSID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier
            )
            as                    
                set nocount on;

                declare @contextCache varbinary(128);

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

                begin try
                    /* cache current context information */
                    set @contextCache = CONTEXT_INFO();

                    /* set CONTEXT_INFO to @CHANGEAGENTID */
                    set CONTEXT_INFO @CHANGEAGENTID;

                    delete from
                        dbo.INVITATIONHISTORY
                    where
                        BUSINESSPROCESSSTATUSGUID = @BUSINESSPROCESSSTATUSID;

                    /* reset CONTEXT_INFO to previous value */
                    if not @contextCache is null
                        set CONTEXT_INFO @contextCache;
                end try

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

                return 0;