USP_DATAFORMTEMPLATE_VIEW_CORRESPONDENCEPROCESS

The load procedure used by the view dataform template "Correspondence View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(255)	INOUT	Description
@IDSETREGISTERNAME	nvarchar(300)	INOUT	Include selection
@CORRESPONDENCECODE	nvarchar(255)	INOUT	Correspondence code
@OUTPUTFORMAT	nvarchar(255)	INOUT	Output format
@CREATEOUTPUTIDSET	nvarchar(3)	INOUT	Create output selection
@OUTPUTIDSETNAME	nvarchar(100)	INOUT	Output selection name
@OVERWRITEOUTPUTIDSET	nvarchar(3)	INOUT	Overwrite existing selection
@BUSINESSPROCESSCATALOGID	uniqueidentifier	INOUT	BUSINESSPROCESSCATALOGID
@PARAMETERSID	uniqueidentifier	INOUT	PARAMETERSID
@LETTERFILENAME	nvarchar(255)	INOUT	Letter template
@LABELFILENAME	nvarchar(255)	INOUT	Label template
@ISACTIVE	bit	INOUT	ISACTIVE
@EXPORTDEFINITION	nvarchar(200)	INOUT	Export definition

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CORRESPONDENCEPROCESS
                (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @NAME nvarchar(100) = null output, 
                @DESCRIPTION nvarchar(255) = null output, 
                @IDSETREGISTERNAME nvarchar(300) = null output, 
                @CORRESPONDENCECODE nvarchar(255) = null output, 
                @OUTPUTFORMAT nvarchar(255) = null output,
                @CREATEOUTPUTIDSET nvarchar(3) = null output,
                @OUTPUTIDSETNAME nvarchar(100) = null output, 
                @OVERWRITEOUTPUTIDSET nvarchar(3) = null output,                
                @BUSINESSPROCESSCATALOGID uniqueidentifier = null output,
                @PARAMETERSID uniqueidentifier = null output,
                @LETTERFILENAME nvarchar(255) = null output,
                @LABELFILENAME nvarchar(255) = null output,
                @ISACTIVE bit = null output,
                @EXPORTDEFINITION nvarchar(200) = null output
                )
            as
            begin
                set nocount on;

                set @DATALOADED = 0;

                select
                    @DATALOADED = 1,
                    @NAME = CORRESPONDENCEPROCESS.NAME, 
                    @DESCRIPTION = CORRESPONDENCEPROCESS.DESCRIPTION,                     
                    @IDSETREGISTERNAME =  dbo.UFN_IDSET_GETNAME(IDSETREGISTERID), 
                    @CORRESPONDENCECODE = CORRESPONDENCECODE.NAME, 
                    @OUTPUTFORMAT = BUSINESSPROCESSVIEW.CAPTION,
                    @CREATEOUTPUTIDSET = case CREATEOUTPUTIDSET when 0 then 'No' else 'Yes' end,
                    @OUTPUTIDSETNAME = OUTPUTIDSETNAME, 
                    @OVERWRITEOUTPUTIDSET = case OVERWRITEOUTPUTIDSET when 0 then 'No' else 'Yes' end,                    
                    @BUSINESSPROCESSCATALOGID = '52776E74-DF72-451C-82D5-519549DAE34B',
                    @PARAMETERSID = @ID,
                    @LETTERFILENAME = CORRESPONDENCEPROCESS.LETTERFILENAME,
                    @LABELFILENAME = CORRESPONDENCEPROCESS.LABELFILENAME,
                    @ISACTIVE = CORRESPONDENCEPROCESS.ISACTIVE,
                    @EXPORTDEFINITION = EXPORTDEFINITION.NAME
                from dbo.CORRESPONDENCEPROCESS
                left join dbo.CORRESPONDENCECODE on CORRESPONDENCEPROCESS.CORRESPONDENCECODEID = CORRESPONDENCECODE.ID
                left join dbo.QUERYVIEWCATALOG on CORRESPONDENCEPROCESS.QUERYVIEWID = QUERYVIEWCATALOG.ID
                left join dbo.BUSINESSPROCESSVIEW on QUERYVIEWCATALOG.ID = BUSINESSPROCESSVIEW.QUERYVIEWCATALOGID
                left join dbo.EXPORTDEFINITION on EXPORTDEFINITION.ID = CORRESPONDENCEPROCESS.EXPORTDEFINITIONID
                where
                    CORRESPONDENCEPROCESS.ID = @ID;

                return 0;
            end