USP_SAVE_CMSTRANSACTIONSTATE

Parameters

Parameter	Parameter Type	Mode
@TRANSACTIONID	uniqueidentifier	IN
@ORDERID	uniqueidentifier	IN
@DATA	ntext	IN
@STATUS	int	IN
@STATUSTEXT	varchar(20)	IN
@TYPE	varchar(20)	IN
@RESULTCODE	int	IN
@FAILDATA	nvarchar(1000)	IN

Definition

Copy



      CREATE procedure dbo.USP_SAVE_CMSTRANSACTIONSTATE
        @TRANSACTIONID uniqueidentifier,
        @ORDERID uniqueidentifier,
        @DATA ntext,
        @STATUS integer,
        @STATUSTEXT varchar(20),
        @TYPE varchar(20),
        @RESULTCODE integer,
        @FAILDATA nvarchar(1000)
      as
      begin

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

           declare @ID as uniqueidentifier = newid();

         insert into [dbo].[CMSTRANSACTIONS](ID,  TRANSACTIONID,  ORDERID,  DATA,   STATUS,   STATUSTEXT,   TYPE,   RESULTCODE,   FAILDATA,   ADDEDBYID,      CHANGEDBYID)
         values                             (@ID, @TRANSACTIONID, @ORDERID, @DATA,  @STATUS,  @STATUSTEXT,  @TYPE,  @RESULTCODE,  @FAILDATA,  @CHANGEAGENTID, @CHANGEAGENTID);

              --return CMS tran ID to maintain the record

              select @ID;

      end