USP_AWARDMANAGEMENTINTEGRATIONERROR_DELETEBYID_WITHCHANGEAGENTID

/*
Generated by Blackbaud AppFx Platform
Date:  2/6/2025 2:51:38 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3901.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_AWARDMANAGEMENTINTEGRATIONERROR_DELETEBYID_WITHCHANGEAGENTID(@ID UNIQUEIDENTIFIER,@CHANGEAGENTID UNIQUEIDENTIFIER=NULL)
AS

    /*    
    Sets Context Info to the CHANGEAGENTID
    Deletes a row in the AWARDMANAGEMENTINTEGRATIONERROR table with the given ID
    Resets Context info to the previous value

    The Context Info will be used by delete triggers to log the AUDITCHANGEAGENTID 
    as the supplied @CHANGEAGENTID rather than the default change agent id.
    */

    set nocount on;

    declare @e int;
    declare @contextCache varbinary(128);

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

    /* set CONTEXT_INFO to @CHANGEAGENTID */
    if not @CHANGEAGENTID is null
        set CONTEXT_INFO @CHANGEAGENTID

    delete from dbo.AWARDMANAGEMENTINTEGRATIONERROR where ID=@ID;

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

    select @e=@@error;

    if @e<>0 return -456; --always return non-zero sp result if an error occurs


    return 0;