USP_BBNC_COMMITDONATIONATTRIBUTES

Commits attributes for donation transactions from Blackbaud Internet Solutions.

Parameters

Parameter	Parameter Type	Mode
@REVENUEID	uniqueidentifier	IN
@XMLITEMS	xml	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            CREATE procedure dbo.USP_BBNC_COMMITDONATIONATTRIBUTES
            (
                @REVENUEID uniqueidentifier = null,                            
                @XMLITEMS xml = null,
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null
            )
            as
            set nocount on;

            declare @ATTRIBUTECOUNT int;

            if @REVENUEID is null
            begin
                raiserror('The revenue ID is required.',16,1);
                return -2;
            end

            if @CHANGEAGENTID is null            
                exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

            if @CHANGEDATE is null
                set @CHANGEDATE = getdate();

            begin try
                exec dbo.USP_BBNC_COMMITDONATIONBUILTINATTRIBUTES @REVENUEID, @XMLITEMS, @CHANGEAGENTID, @CHANGEDATE;

                exec USP_REVENUE_DISQUALIFIED_GIFT_AID_ATTRIBUTE_2 @REVENUEID;     
            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch

            return 0;