USP_DATAFORMTEMPLATE_EDITLOAD_R68ONLINESUBMISSIONGATEWAYSETTINGS

Parameters

Parameter	Parameter Type	Mode
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@GATEWAYSETTINGSID	uniqueidentifier	INOUT
@GATEWAYCODE	tinyint	INOUT

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_R68ONLINESUBMISSIONGATEWAYSETTINGS
                    (
                        @DATALOADED bit = 0 output,
                        @TSLONG bigint = 0 output,
                        @GATEWAYSETTINGSID uniqueidentifier = null output,
                        @GATEWAYCODE tinyint = null output
                    )
                    as

                        set nocount on;

                        set @DATALOADED = 0
                        set @TSLONG = 0

                        select
                            @TSLONG = R68ONLINESUBMISSIONGATEWAYSETTINGS.TSLONG,
                            @GATEWAYSETTINGSID = R68ONLINESUBMISSIONGATEWAYSETTINGS.ID,
                            @GATEWAYCODE = R68ONLINESUBMISSIONGATEWAYSETTINGS.GATEWAYCODE    
                        from dbo.R68ONLINESUBMISSIONGATEWAYSETTINGS

                        set @DATALOADED = 1

                        return 0;