USP_DATAFORMTEMPLATE_VIEW_STEWARDSHIPPACKAGEPROCESS

The load procedure used by the view dataform template "Stewardship Package Process 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
@CREATEOUTPUTIDSET	nvarchar(3)	INOUT	Create output selection
@OUTPUTIDSETNAME	nvarchar(100)	INOUT	Output selection name
@OVERWRITEOUTPUTIDSET	nvarchar(3)	INOUT	Overwrite existing selection
@BUSINESSPROCESSVIEWID	uniqueidentifier	INOUT	BUSINESSPROCESSVIEWID
@OUTPUTFORMAT	nvarchar(255)	INOUT	Output format
@WORDTEMPLATEFILENAME	nvarchar(255)	INOUT	Cover Letter template
@BUSINESSPROCESSCATALOGID	uniqueidentifier	INOUT	BUSINESSPROCESSCATALOGID
@DESIGNATIONLEVELID	uniqueidentifier	INOUT	DESIGNATIONLEVELID
@PURPOSENAME	nvarchar(100)	INOUT	Purpose
@PARAMETERSETID	uniqueidentifier	INOUT	PARAMETERSID

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_STEWARDSHIPPACKAGEPROCESS
                    (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @NAME nvarchar(100) = null output, 
                    @DESCRIPTION nvarchar(255) = null output, 
                    @CREATEOUTPUTIDSET nvarchar(3) = null output,
                    @OUTPUTIDSETNAME nvarchar(100) = null output, 
                    @OVERWRITEOUTPUTIDSET nvarchar(3) = null output,    
                    @BUSINESSPROCESSVIEWID uniqueidentifier = null output,                                                       
                    @OUTPUTFORMAT nvarchar(255) = null output,                                                       
                    @WORDTEMPLATEFILENAME nvarchar(255) = null output,            
                    @BUSINESSPROCESSCATALOGID uniqueidentifier = null output,
                    @DESIGNATIONLEVELID uniqueidentifier = null output,                                   
                    @PURPOSENAME nvarchar(100) = null output,                                   
                    @PARAMETERSETID uniqueidentifier = null output            
                    )
                as
                begin
                    set nocount on

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @NAME = STEWARDSHIPPACKAGEPROCESS.NAME, 
                        @DESCRIPTION = STEWARDSHIPPACKAGEPROCESS.DESCRIPTION, 
                        @CREATEOUTPUTIDSET = case CREATEOUTPUTIDSET when 0 then 'No' else 'Yes' end,
                        @OUTPUTIDSETNAME = STEWARDSHIPPACKAGEPROCESS.OUTPUTIDSETNAME, 
                        @OVERWRITEOUTPUTIDSET = case STEWARDSHIPPACKAGEPROCESS.OVERWRITEOUTPUTIDSET when 0 then 'No' else 'Yes' end,                    
                        @BUSINESSPROCESSVIEWID = STEWARDSHIPPACKAGEPROCESS.BUSINESSPROCESSVIEWID,                                          
                        @OUTPUTFORMAT = dbo.UFN_BUSINESSPROCESSVIEW_GETNAME(STEWARDSHIPPACKAGEPROCESS.BUSINESSPROCESSVIEWID),                                                                  
                        @WORDTEMPLATEFILENAME = STEWARDSHIPPACKAGEPROCESS.WORDTEMPLATEFILENAME,
                        @BUSINESSPROCESSCATALOGID = 'B4184ABE-C618-466F-90A2-B96B88644A17',
                        @DESIGNATIONLEVELID = DESIGNATIONLEVEL.ID,
                        @PURPOSENAME = DESIGNATIONLEVEL.NAME,
                        @PARAMETERSETID = STEWARDSHIPPACKAGEPROCESS.ID                        
                    from
                        dbo.DESIGNATIONLEVEL 
                           inner join dbo.STEWARDSHIPPACKAGEPROCESS on DESIGNATIONLEVEL.STEWARDSHIPPACKAGEPROCESSID = STEWARDSHIPPACKAGEPROCESS.ID
                    where
                        DESIGNATIONLEVEL.ID = @ID

                    return 0
                end