USP_UPDATE_CMSTRANSACTIONSTATUS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@TRANSACTIONID	uniqueidentifier	IN
@STATUS	int	IN
@STATUSTEXT	varchar(20)	IN
@RESULTCODE	int	IN

Definition

Copy



            create procedure dbo.USP_UPDATE_CMSTRANSACTIONSTATUS
                @ID uniqueidentifier,
                @TRANSACTIONID uniqueidentifier,
                @STATUS integer,
                @STATUSTEXT varchar(20),
                @RESULTCODE integer
                as
                begin

                declare @CHANGEAGENTID uniqueidentifier;
                exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;


                    update [dbo].[CMSTRANSACTIONS]
                    set 
                        STATUS = @STATUS, 
                        STATUSTEXT = @STATUSTEXT,
                        RESULTCODE = @RESULTCODE,
                        CHANGEDBYID = @CHANGEAGENTID
                    where ID = @ID and STATUS<>256 and TRANSACTIONID = @TRANSACTIONID;        

                return 0;
                end