USP_PAYMENT_UPDATE_AUTHORIZATIONCODE_TRANSACTIONID

The save procedure used by the edit dataform template "Payment Update Authorization And TransactionID".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@AUTHORIZATIONCODE	nvarchar(20)	IN
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@TRANSACTIONID	uniqueidentifier	IN

Definition

Copy



          CREATE procedure dbo.USP_PAYMENT_UPDATE_AUTHORIZATIONCODE_TRANSACTIONID
          (
            @ID uniqueidentifier,
            @AUTHORIZATIONCODE nvarchar(20),
            @CHANGEAGENTID uniqueidentifier = null,
            @TRANSACTIONID uniqueidentifier
          )
          as

              set nocount on;

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

              begin try
                      exec USP_PAYMENT_UPDATEAUTHORIZATIONCODE @ID, @AUTHORIZATIONCODE, @CHANGEAGENTID, @TRANSACTIONID
              end try
              begin catch
                  exec dbo.USP_RAISE_ERROR
                  return 1
              end catch

          return 0;