USP_DATAFORMTEMPLATE_ADD_PRELOAD_FAFBENEFIT
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENTAPPUSERID | uniqueidentifier | IN | |
| @SITEREQUIRED | bit | INOUT | |
| @SITES | xml | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PRELOAD_FAFBENEFIT
(
@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;