USP_REVENUEBATCH_CLEARSCHEDULEISPENDINGFLAG

Clears the ISPENDING flag on any revenue schedule records this batch row had initially set it for.

Parameters

Parameter	Parameter Type	Mode
@REVENUEBATCHID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTDATE	datetime	IN

Definition

Copy



            CREATE procedure dbo.USP_REVENUEBATCH_CLEARSCHEDULEISPENDINGFLAG
            (
                @REVENUEBATCHID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @CURRENTDATE datetime = null
            )
            as
                set nocount on;

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

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

                update dbo.REVENUESCHEDULE
                    set REVENUESCHEDULE.ISPENDING = 0,
                        REVENUESCHEDULE.CHANGEDBYID = @CHANGEAGENTID,
                        REVENUESCHEDULE.DATECHANGED = @CURRENTDATE
                from dbo.REVENUESCHEDULE
                inner join dbo.BATCHREVENUEAPPLICATION as [STREAMS] on [STREAMS].REVENUEID = REVENUESCHEDULE.ID and [STREAMS].WASGENERATED = 1
                where [STREAMS].BATCHREVENUEID = @REVENUEBATCHID;

                update dbo.REVENUESCHEDULE
                    set REVENUESCHEDULE.ISPENDING = 0,
                        REVENUESCHEDULE.CHANGEDBYID = @CHANGEAGENTID,
                        REVENUESCHEDULE.DATECHANGED = @CURRENTDATE
                from
                    dbo.REVENUESCHEDULE
                    inner join dbo.BATCHREVENUE on BATCHREVENUE.PAYINGPENDINGREVENUEID = REVENUESCHEDULE.ID
                where BATCHREVENUE.ID = @REVENUEBATCHID;