USP_BBNC_COMMITDONATIONADDCATEGORY

Adds a revenue category for a Blackbaud Internet Solutions donation batch.

Parameters

Parameter	Parameter Type	Mode
@REVENUEID	uniqueidentifier	INOUT
@CATEGORYCODEID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            CREATE procedure dbo.USP_BBNC_COMMITDONATIONADDCATEGORY
            (
                @REVENUEID uniqueidentifier = null output,
                @CATEGORYCODEID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null
            )
            as
            set nocount on;

            if @CATEGORYCODEID is null
              return 0;

            if @CHANGEDATE is null
                set @CHANGEDATE = getdate();
            if @CHANGEAGENTID is null
                exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

            begin try
                insert into dbo.REVENUECATEGORY
                (
                    ID,
                    GLREVENUECATEGORYMAPPINGID,
                    ADDEDBYID, 
                    CHANGEDBYID, 
                    DATEADDED, 
                    DATECHANGED
                )
                select
                    REVENUESPLIT.ID,
                    @CATEGORYCODEID,
                    @CHANGEAGENTID, 
                    @CHANGEAGENTID, 
                    @CHANGEDATE, 
                    @CHANGEDATE
                from REVENUESPLIT
                where REVENUESPLIT.REVENUEID = @REVENUEID;
            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch

            return 0;