USP_DATAFORMTEMPLATE_ADD_PRELOAD_STEWARDSHIPPLANTEMPLATE
The load procedure used by the edit dataform template "Stewardship Plan Template Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
| @SITEREQUIRED | bit | INOUT | Site required |
| @SITES | xml | INOUT | Sites |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PRELOAD_STEWARDSHIPPLANTEMPLATE
(
@CURRENTAPPUSERID uniqueidentifier,
@SITEREQUIRED bit = null output,
@SITES xml = null output
)
as
set nocount on;
set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID);
declare @DEFAULTSITEID uniqueidentifier
set @DEFAULTSITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID)
if @DEFAULTSITEID is not null
set @SITES = (select newid() as ID, @DEFAULTSITEID as SITEID for xml raw('ITEM'),type,elements,root('SITES'),BINARY BASE64)
return 0;