USP_DATAFORMTEMPLATE_VIEW_CREDITCARDTRANSACTIONSETTLEMENT_PAGEEXPRESSION

Parameters

Parameter	Parameter Type	Mode
@DATALOADED	bit	INOUT
@SHOWINITIALSETTLEMENTFORM	bit	INOUT
@AUTOSETTLEENABLED	bit	INOUT

Definition

Copy


            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CREDITCARDTRANSACTIONSETTLEMENT_PAGEEXPRESSION
            (
                @DATALOADED bit = 0 output,
                @SHOWINITIALSETTLEMENTFORM bit = null output,
                @AUTOSETTLEENABLED bit = null output
            )
            as
                set nocount on;

                set @SHOWINITIALSETTLEMENTFORM = 1;

                if exists (select 1 from dbo.[CREDITCARDPAYMENTMETHODDETAIL] where [SETTLEMENTTYPECODE] <> 0)
                    or exists (select 1 from dbo.[CREDITPAYMENT] where [SETTLEMENTTYPECODE] <> 0)
                    or exists (select 1 from dbo.PROCESSORTRANSACTIONSETTLEMENTIMPORT)
                    set @SHOWINITIALSETTLEMENTFORM = 0;

                select @AUTOSETTLEENABLED = ENABLED from dbo.SCHEDULE where ID = '0A350644-832E-45BE-99FC-90BCCA0AD216'

                set @DATALOADED = 1;

                return 0;