USP_BATCHRE7INTEGRATIONGIVINGSUMMARYBATCHSYSTEMMESSAGE_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: 3/19/2013 1:29:15 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_BATCHRE7INTEGRATIONGIVINGSUMMARYBATCHSYSTEMMESSAGE_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.BATCHRE7INTEGRATIONGIVINGSUMMARYBATCHSYSTEMMESSAGE where exists (select BATCHRE7INTEGRATIONGIVINGSUMMARY.ID from dbo.BATCHRE7INTEGRATIONGIVINGSUMMARY where BATCHRE7INTEGRATIONGIVINGSUMMARY.ID = BATCHRE7INTEGRATIONGIVINGSUMMARYBATCHSYSTEMMESSAGE.ID and BATCHID = @BATCHID);
if not @contextCache is null
set CONTEXT_INFO @contextCache;
return 0;