USP_REVENUE_CREATERECOGNITIONS

Creates recognition credits for all splits on a revenue.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN
@SOURCERECURRINGGIFTREVENUESPLITID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_REVENUE_CREATERECOGNITIONS
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @CHANGEDATE datetime,
                @SOURCERECURRINGGIFTREVENUESPLITID uniqueidentifier = null
            )
            as
                set nocount on;

                declare @SPLITID uniqueidentifier

                declare SPLITSCURSOR cursor local fast_forward for
                    select LI.ID 
                    from dbo.FINANCIALTRANSACTIONLINEITEM LI
                    inner join dbo.REVENUESPLIT_EXT RS on RS.ID = LI.ID
                    where LI.FINANCIALTRANSACTIONID = @ID and LI.DELETEDON is null and LI.TYPECODE != 1;

                open SPLITSCURSOR;
                fetch next from SPLITSCURSOR into @SPLITID;

                while (@@FETCH_STATUS = 0)
                begin
                  exec dbo.[USP_REVENUEDETAIL_CREATERECOGNITIONS] @SPLITID, @CHANGEAGENTID, @CHANGEDATE, @SOURCERECURRINGGIFTREVENUESPLITID;
                  fetch next from SPLITSCURSOR into @SPLITID;
                end

                close SPLITSCURSOR;
                deallocate SPLITSCURSOR;