USP_PAYMENT_UPDATEAUTHORIZATIONCODE

            CREATE procedure dbo.USP_PAYMENT_UPDATEAUTHORIZATIONCODE
            (
                @PAYMENTID uniqueidentifier,
                @AUTHORIZATIONCODE nvarchar(20),
                @CHANGEAGENTID uniqueidentifier = null,
                @TRANSACTIONID uniqueidentifier = null,
        @MERCHANTACCOUNTID uniqueidentifier = null
            )
            as
                set nocount on

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

                declare @CURRENTDATE datetime
                set @CURRENTDATE = GetDate()

                begin try
                    declare @REVENUEPAYMENTMETHODID uniqueidentifier
                    select top 1 @REVENUEPAYMENTMETHODID = ID
                    from dbo.REVENUEPAYMENTMETHOD
                    where
                        REVENUEID = @PAYMENTID and
                        PAYMENTMETHODCODE = 2

                    if @REVENUEPAYMENTMETHODID is not null
                        update dbo.CREDITCARDPAYMENTMETHODDETAIL set
                            AUTHORIZATIONCODE = @AUTHORIZATIONCODE,
                            TRANSACTIONID = @TRANSACTIONID,
              MERCHANTACCOUNTID = @MERCHANTACCOUNTID,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE
                        where ID = @REVENUEPAYMENTMETHODID
                    else
                        raiserror('BBERR_PAYMENTDOESNTEXISTORDOESNTHAVECCPAYMENTMETHOD', 13, 1)                            
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;

                    return 1
                end catch

                return 0