USP_GLACCOUNTBATCHBATCHUSERMESSAGE_DELETEBYBATCHID
Auto-generated procedure to handle error/rejection/exception messages for the GLACCOUNTBATCH batch message table
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHID | uniqueidentifier | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 10/27/2011 12:13:23 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.92.537.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_GLACCOUNTBATCHBATCHUSERMESSAGE_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.GLACCOUNTBATCHBATCHUSERMESSAGE where exists (select GLACCOUNTBATCH.ID from dbo.GLACCOUNTBATCH where GLACCOUNTBATCH.ID = GLACCOUNTBATCHBATCHUSERMESSAGE.ID and BATCHID = @BATCHID);
if not @contextCache is null
set CONTEXT_INFO @contextCache;
return 0;