USP_DATAFORMTEMPLATE_EDITLOAD_STEWARDSHIPPACKAGEPROCESS

The load procedure used by the edit dataform template "Stewardship Package 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?
@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.
@OWNERID	uniqueidentifier	INOUT
@EXCLUSIONDATETYPECODE	tinyint	INOUT	Consider exclusions as of
@EXCLUSIONASOFDATE	datetime	INOUT	Consider exclusions as of
@EXCLUDEDECEASED	bit	INOUT	Exclude deceased constituents
@EXCLUDEINACTIVE	bit	INOUT	Exclude inactive constituents
@EXCLUSIONS	xml	INOUT	Exclusions
@CUSTOMPARAMETERDATAFORMITEM	xml	INOUT
@REQUIREDEXCLUSIONS	xml	INOUT	Required exclusions
@BUSINESSPROCESSPARAMETERSETID	uniqueidentifier	INOUT
@DISPLAYEDFILENAME	nvarchar(255)	INOUT	Word template

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_STEWARDSHIPPACKAGEPROCESS
(
  @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,                        
  @TSLONG bigint = 0 output,
  @OWNERID uniqueidentifier = null output,
  @EXCLUSIONDATETYPECODE tinyint = null output,
  @EXCLUSIONASOFDATE datetime = null output,
  @EXCLUDEDECEASED bit = null output,
  @EXCLUDEINACTIVE bit = null output,
  @EXCLUSIONS xml = null output,
  @CUSTOMPARAMETERDATAFORMITEM xml = null output,
  --@OVERRIDEREQUIREDEXCLUSIONS bit = null output,

  @REQUIREDEXCLUSIONS xml = null output,
  @BUSINESSPROCESSPARAMETERSETID uniqueidentifier = null output,
  @DISPLAYEDFILENAME nvarchar(255) = null output
)
as
  set nocount on;

  set @DATALOADED = 0;
  set @TSLONG = 0;
  set @BUSINESSPROCESSPARAMETERSETID = @ID;

  select
    @DATALOADED = 1,
    @TSLONG = TSLONG,
    @NAME = STEWARDSHIPPACKAGEPROCESS.NAME,
    @DESCRIPTION = DESCRIPTION,
    @WORDTEMPLATEFILENAME = WORDTEMPLATEFILENAME,
    @DISPLAYEDFILENAME = WORDTEMPLATEFILENAME,
    @WORDFILE = WORDFILE,
    @BUSINESSPROCESSVIEWID = BUSINESSPROCESSVIEWID,
    @CREATEOUTPUTIDSET = CREATEOUTPUTIDSET,
    @OUTPUTIDSETNAME = OUTPUTIDSETNAME,
    @OVERWRITEOUTPUTIDSET = OVERWRITEOUTPUTIDSET,
    @OWNERID = dbo.UFN_BUSINESSPROCESSINSTANCE_GETOWNER('B4184ABE-C618-466F-90A2-B96B88644A17' ,@ID),
    @CUSTOMPARAMETERDATAFORMITEM = CUSTOMPARAMETERDATAFORMITEM
  from dbo.STEWARDSHIPPACKAGEPROCESS 
  where
    ID = @ID;

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

  select 
    @EXCLUSIONDATETYPECODE = DATETYPECODE,
    @EXCLUSIONASOFDATE = ASOFDATE,
    @EXCLUDEDECEASED = EXCLUDEDECEASED,
    @EXCLUDEINACTIVE = EXCLUDEINACTIVE,
    @EXCLUSIONS = dbo.UFN_BUSINESSPROCESSCOMMPREF_GETEXCLUSIONS_TOITEMLISTXML(@ID)
    --@OVERRIDEREQUIREDEXCLUSIONS = OVERRIDEREQUIREDEXCLUSIONS

  from dbo.BUSINESSPROCESSCOMMPREF
  where BUSINESSPROCESSPARAMETERSETID = @ID;                            

  set @REQUIREDEXCLUSIONS = dbo.UFN_SOLICITCODE_GETREQUIRED_TOITEMLISTXML();
  --if @OVERRIDEREQUIREDEXCLUSIONS = 1

  --    set @REQUIREDEXCLUSIONS = dbo.UFN_BUSINESSPROCESSCOMMPREF_GETREQUIREDEXCLUSIONS_TOITEMLISTXML(@ID)

  --else

  --    select top 1 

  --        @EXCLUDEDECEASED = EXCLUDEDECEASED,

  --        @EXCLUDEINACTIVE = EXCLUDEINACTIVE,

  --        @REQUIREDEXCLUSIONS = dbo.UFN_SOLICITCODE_GETREQUIRED_TOITEMLISTXML()

  --    from dbo.EXCLUSIONSETTINGS;


  return 0;