USP_REVENUESPLITGIFTAID_CREATEREVERSALSFORDELETEDSPLITS

This procedure creates reversal GL distributions for revenue split gift aid records.

Parameters

Parameter	Parameter Type	Mode
@OLDGIFTAID	xml	IN
@REVENUESTREAMS	xml	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            create procedure dbo.USP_REVENUESPLITGIFTAID_CREATEREVERSALSFORDELETEDSPLITS
            (
                @OLDGIFTAID xml,
                @REVENUESTREAMS xml,
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null
            )
            with execute as owner
            as
            begin
                set nocount on;

                declare @REVENUESPLITID uniqueidentifier;

                declare GL_CURSOR cursor local fast_forward for
                    select T.c.value('(ID)[1]','uniqueidentifier') as ID from @OLDGIFTAID.nodes('/GIFTAIDQUALIFICATIONSTATUS/ITEM') T(c);

                open GL_CURSOR;

                fetch next from GL_CURSOR into @REVENUESPLITID;

                while (@@FETCH_STATUS = 0)
                begin
                    if not exists (select 1 from dbo.UFN_REVENUE_GETAPPLICATIONS_FROMXML(@REVENUESTREAMS) where ID = @REVENUESPLITID)
                        and exists (select 1 from dbo.REVENUESPLITGIFTAIDPOSTED where ID = @REVENUESPLITID) 
                        and (dbo.UFN_REVENUESPLITGIFTAID_HASPENDINGADJUSTMENT(@REVENUESPLITID) = 0)
                    begin
                        exec dbo.USP_GLTRANSACTION_ADDGIFTAIDREVERSALS @REVENUESPLITID, @CHANGEAGENTID, @CHANGEDATE;
                    end

                    fetch next from GL_CURSOR into @REVENUESPLITID;
                end

                close GL_CURSOR; 
                deallocate GL_CURSOR;
            end