USP_DONORCHALLENGE_DELETE

Executes the "Donor Challenge: Delete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy



CREATE procedure dbo.USP_DONORCHALLENGE_DELETE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as
    set nocount on

    begin try
        declare @CONTEXTCACHE varbinary(128);
        set @CONTEXTCACHE = CONTEXT_INFO();
        set CONTEXT_INFO @CHANGEAGENTID;

        delete from dbo.DONORCHALLENGEENCUMBERED where STATUSTYPECODE in (0,2) and DONORCHALLENGEID = @ID;

        if not @CONTEXTCACHE is null
            set CONTEXT_INFO @CONTEXTCACHE;

        exec dbo.USP_DONORCHALLENGE_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch