USP_CREDITCARDPROCESSING_SETBATCHINSTANCEFORRESUME

Sets the batch ID temporarily on the credit card process so the process can be resumed if it fails while validating the batch.

Parameters

Parameter	Parameter Type	Mode
@CREDITCARDPROCESSINGID	uniqueidentifier	IN
@BATCHID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_CREDITCARDPROCESSING_SETBATCHINSTANCEFORRESUME
            (
                @CREDITCARDPROCESSINGID uniqueidentifier,
                @BATCHID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier
            )
            as begin
                declare @CURRENTDATE datetime;
                set @CURRENTDATE = getdate();

                update dbo.CREDITCARDPROCESSING set
                    BATCHID = @BATCHID,
                    BATCHINSTANCESETFORRESUME = 1,
                    DATECHANGED = @CURRENTDATE,
                    CHANGEDBYID = @CHANGEAGENTID
                where
                    ID = @CREDITCARDPROCESSINGID;

                return 0;                    
            end