USP_ADJUSTMENTHISTORY_WRITEOFFS_FIXFORDELETE

Fixes adjustment history for all write-off items for a pledge in preparation for the deletion of that pledge.

Parameters

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

Definition

Copy



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

            declare @WRITEOFFID uniqueidentifier;

            declare WRITEOFF_CURSOR cursor local fast_forward for
                select ID from dbo.WRITEOFF where REVENUEID = @REVENUEID;

            open WRITEOFF_CURSOR;
                fetch next from WRITEOFF_CURSOR into @WRITEOFFID;
                while @@FETCH_STATUS = 0
                begin

                    exec dbo.USP_ADJUSTMENTHISTORY_WRITEOFF_FIXFORDELETE @WRITEOFFID, @CHANGEAGENTID, @CHANGEDATE;

                    fetch next from WRITEOFF_CURSOR into @WRITEOFFID;
                end                

            --When a cursor is used, it should be explicitly closed/deallocated in case of blocking or USP running long

            close WRITEOFF_CURSOR;
            deallocate WRITEOFF_CURSOR;