USP_DATAFORMTEMPLATE_EDITLOAD_R68ONLINESUBMISSIONPREPROCESS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@SETTINGSID	uniqueidentifier	INOUT
@SENDERSETTINGSID	uniqueidentifier	INOUT

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_R68ONLINESUBMISSIONPREPROCESS
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @TSLONG bigint = 0 output,
                @SETTINGSID uniqueidentifier = null output,
                @SENDERSETTINGSID uniqueidentifier = null output
            )
            as
                set nocount on;

                set @DATALOADED = 0
                set @TSLONG = 0

                select
                    @DATALOADED = 1,
                    @TSLONG = R68ONLINESUBMISSIONPARAMETERS.TSLONG,
                    @SETTINGSID = R68ONLINESUBMISSIONSETTINGS.ID,
                    @SENDERSETTINGSID = R68ONLINESUBMISSIONPARAMETERS.R68ONLINESUBMISSIONSETTINGSSENDERINFOID    
                from dbo.R68ONLINESUBMISSIONPARAMETERS
                inner join dbo.R68 on R68ONLINESUBMISSIONPARAMETERS.R68PROCESSID = R68.ID
                inner join dbo.CHARITYCLAIMREFERENCENUMBER on R68.REFERENCENUMBER = CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER
                inner join dbo.R68ONLINESUBMISSIONSETTINGS on CHARITYCLAIMREFERENCENUMBER.ID = R68ONLINESUBMISSIONSETTINGS.CCRNID
                where R68ONLINESUBMISSIONPARAMETERS.ID = @ID

                return 0;