USP_R68_UPDATETAXCLAIMNUMBERS

Clears the R68DETAIL table of records for a given parameter set instance of the R68 business process.

Parameters

Parameter	Parameter Type	Mode	Description
@PROCESSID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_R68_UPDATETAXCLAIMNUMBERS
            (
                @PROCESSID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null
            )
            as 
            set nocount on;

            declare @TAXCLAIMNUMBER nvarchar(10)

            select
                @TAXCLAIMNUMBER = TAXCLAIMNUMBER
            from dbo.R68
            where ID = @PROCESSID

            update dbo.REVENUESPLITGIFTAID set 
                TAXCLAIMNUMBER = @TAXCLAIMNUMBER, 
                DATECHANGED = getdate(), 
                CHANGEDBYID = @CHANGEAGENTID,
                INCLUDETRANSITIONALAMOUNTCODE = case when dbo.UFN_REVENUESPLITGIFTAID_TRANSITIONALREFLIEFEXPIRED(ID, 0) = 0 then 1 else 2 end
            where ID in (select REVENUESPLITID from dbo.R68DETAIL where R68ID = @PROCESSID)

            update dbo.R68 set
                LOCKED = 1,
                DATECHANGED = getdate(), 
                CHANGEDBYID = @CHANGEAGENTID
            where ID = @PROCESSID