USP_DATAFORMTEMPLATE_VIEW_R68ONLINESETTINGS

Parameters

Parameter	Parameter Type	Mode
@DATALOADED	bit	INOUT
@ORGANISATION	nvarchar(160)	INOUT
@REGULATOR	nvarchar(160)	INOUT
@REGULATORNUMBER	nvarchar(20)	INOUT

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_R68ONLINESETTINGS
                (
                    @DATALOADED bit = 0 output,
                    @ORGANISATION nvarchar(160) = null output,
                    @REGULATOR nvarchar(160) = null output,
                    @REGULATORNUMBER nvarchar(20) = null output
                )
                as
                    set nocount on;

                    select @ORGANISATION = ORGANISATION,
                           @REGULATOR = case R68ONLINESUBMISSIONSETTINGS.REGULATORCODE when 101 then R68ONLINESUBMISSIONSETTINGS.OTHERREGULATORNAME else R68ONLINESUBMISSIONSETTINGS.REGULATOR end,
                           @REGULATORNUMBER = case R68ONLINESUBMISSIONSETTINGS.REGULATORCODE when 100 then '' else R68ONLINESUBMISSIONSETTINGS.REGULATORNUMBER end
                    from dbo.R68ONLINESUBMISSIONSETTINGS

                    set @DATALOADED = 1;

                    return 0;