USP_UPDATE_CMSTRANSACTIONSTATE

Parameters

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

Definition

Copy



            CREATE procedure dbo.USP_UPDATE_CMSTRANSACTIONSTATE
                @ID uniqueidentifier,
                @TRANSACTIONID uniqueidentifier,
                @STATUS integer,
                @STATUSTEXT varchar(20),
                @RESULTCODE integer,
                @DATA nvarchar(max) = null
                as
                begin

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


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

                return 0;
                end