USP_BATCHRE7INTEGRATIONGIVINGSUMMARYBATCHUSERMESSAGE_DELETEBYBATCHID
Auto-generated procedure to handle error/rejection/exception messages for the BATCHRE7INTEGRATIONGIVINGSUMMARY batch message table
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHID | uniqueidentifier | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 1/27/2010 7:30:12 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.5.465.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_BATCHRE7INTEGRATIONGIVINGSUMMARYBATCHUSERMESSAGE_DELETEBYBATCHID
(
@BATCHID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier
)
as
set nocount on;
declare @contextCache varbinary(128);
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
set @contextCache = CONTEXT_INFO();
set CONTEXT_INFO @CHANGEAGENTID;
delete from dbo.BATCHRE7INTEGRATIONGIVINGSUMMARYBATCHUSERMESSAGE where exists (select BATCHRE7INTEGRATIONGIVINGSUMMARY.ID from dbo.BATCHRE7INTEGRATIONGIVINGSUMMARY where BATCHRE7INTEGRATIONGIVINGSUMMARY.ID = BATCHRE7INTEGRATIONGIVINGSUMMARYBATCHUSERMESSAGE.ID and BATCHID = @BATCHID);
if not @contextCache is null
set CONTEXT_INFO @contextCache;
return 0;