USP_BUSINESSPROCESSSTATUS_PROCESSCOMPLETED

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@NUMBERPROCESSED	int	IN
@NUMBEROFEXCEPTIONS	int	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy


                -- set the ENDEDON date
                CREATE procedure dbo.USP_BUSINESSPROCESSSTATUS_PROCESSCOMPLETED
                    @ID uniqueidentifier,        
                    @NUMBERPROCESSED int, 
                    @NUMBEROFEXCEPTIONS int,
                    @CHANGEAGENTID uniqueidentifier
                with execute as caller                
                as
                begin
                    set nocount on

                    declare @CURRENTDATE datetime
                    set @CURRENTDATE = GetDate()

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

                    update 
                        dbo.BUSINESSPROCESSSTATUS 
                    set
                        STATUSCODE = 0,            
                        NUMBERPROCESSED = @NUMBERPROCESSED,
                        NUMBEROFEXCEPTIONS = @NUMBEROFEXCEPTIONS,
                        ENDEDON = @CURRENTDATE,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                    where
                        ID = @ID
                end