USP_DATAFORMTEMPLATE_EDITLOAD_STEWARDSHIPPACKAGEPREPROCESS

The load procedure used by the edit dataform template "Stewardship Package Preprocess Edit 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
@WORDTEMPLATEFILENAME	nvarchar(255)	INOUT	Word template
@WORDFILE	varbinary	INOUT	File
@BUSINESSPROCESSVIEWID	uniqueidentifier	INOUT	Output format
@BUSINESSPROCESSOUTPUTDATALISTIDS	xml	INOUT
@CREATEOUTPUTIDSET	bit	INOUT	Create selection from results
@OUTPUTIDSETNAME	nvarchar(100)	INOUT	Selection name
@OVERWRITEOUTPUTIDSET	bit	INOUT	Overwrite existing selection
@FILECHANGED	bit	INOUT	File changed?
@STEWARDSHIPPACKAGEPROCESSID	uniqueidentifier	INOUT
@CUSTOMPARAMETERDATAFORMITEM	xml	INOUT
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_STEWARDSHIPPACKAGEPREPROCESS
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @NAME nvarchar(100) = null output,
                @DESCRIPTION nvarchar(255) = null output,
                @WORDTEMPLATEFILENAME nvarchar(255) = null output,
                @WORDFILE varbinary(max) = null output,                        
                @BUSINESSPROCESSVIEWID uniqueidentifier = null output,
                @BUSINESSPROCESSOUTPUTDATALISTIDS xml = null output,
                @CREATEOUTPUTIDSET bit = null output,
                @OUTPUTIDSETNAME nvarchar(100) = null output,
                @OVERWRITEOUTPUTIDSET bit = null output,   
                @FILECHANGED bit = null output,        
                @STEWARDSHIPPACKAGEPROCESSID uniqueidentifier = null output,
                @CUSTOMPARAMETERDATAFORMITEM xml = null output,
                @TSLONG bigint = 0 output
            )
            as
                set nocount on;

                set @DATALOADED = 0;
                set @TSLONG = 0;

                select
                    @DATALOADED = 1,
                    @TSLONG = TSLONG,
                    @NAME = STEWARDSHIPPACKAGEPROCESS.NAME,
                    @DESCRIPTION = DESCRIPTION,
                    @WORDTEMPLATEFILENAME = WORDTEMPLATEFILENAME,
                    @WORDFILE = WORDFILE,
                    @BUSINESSPROCESSVIEWID = BUSINESSPROCESSVIEWID,
                    @CREATEOUTPUTIDSET = CREATEOUTPUTIDSET,
                    @OUTPUTIDSETNAME = OUTPUTIDSETNAME,
                    @OVERWRITEOUTPUTIDSET = OVERWRITEOUTPUTIDSET,
                    @CUSTOMPARAMETERDATAFORMITEM = CUSTOMPARAMETERDATAFORMITEM,
                    @STEWARDSHIPPACKAGEPROCESSID = ID
                from
                    dbo.STEWARDSHIPPACKAGEPROCESS 
                where
                    ID = @ID;

                select @BUSINESSPROCESSOUTPUTDATALISTIDS = dbo.UFN_BUSINESSPROCESS_GETBUSINESSPROCESSVIEWANDDATALIST_TOITEMLISTXML('StewardshipPackageProcessOutputDataListID');

                return 0;