USP_CREDITCARDPROCESSINGSTATEBBPSPROCESS_SETPROCESSTRANSACTIONS

Marks that processing has begun for a BBPS batch process.

Parameters

Parameter Parameter Type Mode Description
@BBPSBATCHPROCESSID uniqueidentifier IN
@CHANGEAGENTID uniqueidentifier IN

Definition

Copy


            create procedure dbo.USP_CREDITCARDPROCESSINGSTATEBBPSPROCESS_SETPROCESSTRANSACTIONS
            (
                @BBPSBATCHPROCESSID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier
            )
            as
            begin
                declare @CURRENTDATE datetime;
                set @CURRENTDATE = getdate();            

                update dbo.CREDITCARDPROCESSINGSTATEBBPSPROCESS set
                    PROCESSTRANSACTIONSCALLED = 1,
                    DATECHANGED = @CURRENTDATE,
                    CHANGEDBYID = @CHANGEAGENTID
                where
                    BBPSBATCHPROCESSID = @BBPSBATCHPROCESSID;
            end