USP_CREDITCARDPROCESSING_VIEW

Returns information about a credit card processing business process.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@NAME	nvarchar(100)	INOUT
@DESCRIPTION	nvarchar(255)	INOUT
@BATCHNUMBER	nvarchar(100)	INOUT
@MERCHANTACCOUNTID	uniqueidentifier	INOUT
@PARAMETERSID	uniqueidentifier	INOUT
@WILLRESUME	bit	INOUT
@MERCHANTACCOUNTS	xml	INOUT

Definition

Copy



            CREATE procedure dbo.USP_CREDITCARDPROCESSING_VIEW
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @NAME nvarchar(100) = null output,
                @DESCRIPTION nvarchar(255) = null output,
                @BATCHNUMBER nvarchar(100) = null output,
                @MERCHANTACCOUNTID uniqueidentifier = null output,
                @PARAMETERSID uniqueidentifier = null output,
                @WILLRESUME bit = null output,
                @MERCHANTACCOUNTS xml = null output
            )
            as
                set nocount on

                declare @BATCHID uniqueidentifier
                select
                    @DATALOADED = 1,
                    @NAME = CREDITCARDPROCESSING.NAME,
                    @DESCRIPTION = CREDITCARDPROCESSING.DESCRIPTION,
                    @BATCHNUMBER = BATCH.BATCHNUMBER,
                    @MERCHANTACCOUNTID = CREDITCARDPROCESSING.MERCHANTACCOUNTID,
                    @PARAMETERSID = @ID,
                    @BATCHID = BATCH.ID
                from dbo.CREDITCARDPROCESSING
                left join dbo.BATCH on BATCH.ID = CREDITCARDPROCESSING.BATCHID
                where
                    CREDITCARDPROCESSING.ID = @ID

                set @MERCHANTACCOUNTS =(
                    select 
                        MERCHANTACCOUNTID,
                        CURRENCY.ISO4217
                    from CREDITCARDPROCESSINGMERCHANTACCOUNT
                        inner join dbo.CURRENCY on CURRENCY.ID = CREDITCARDPROCESSINGMERCHANTACCOUNT.CURRENCYID
                    where CREDITCARDPROCESSINGID = @ID
                    for xml raw('ITEM'),type,elements,root('MERCHANTACCOUNTS'),BINARY BASE64
                );

                if exists (select * from dbo.UFN_CREDITCARDPROCESSING_GETRESUMEINFO(@BATCHID))
                    set @WILLRESUME = 1
                else
                    set @WILLRESUME = 0