USP_BATCHBBNCDONATION_DELETE

Deletes a Blackbaud Internet Solutions donation transaction from the system for a given batch.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



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

                -- TMV 5/29/2008 CR285803-101707 Donation IDs can be reused when a team fundraising offline

                -- gift is edited after being deleted (shown as rejected in BBNC)

                delete from dbo.BBNCDOWNLOADEDTRANSACTION
                where
                    ID = (select BATCHBBNCDONATION.BBNCID from dbo.BATCHBBNCDONATION where BATCHBBNCDONATION.ID = @ID);

                exec USP_BATCHBBNCDONATION_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID

                return 0;