USP_DATAFORMTEMPLATE_ADD_PRELOAD_LETTERTEMPLATE

The load procedure used by the edit dataform template "Letter Template Add Form"

Parameters

Parameter Parameter Type Mode Description
@CURRENTAPPUSERID uniqueidentifier IN Input parameter indicating the ID of the current user.
@QUERYVIEWS xml INOUT
@SITEREQUIRED bit INOUT Site required
@SITEID uniqueidentifier INOUT Site

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PRELOAD_LETTERTEMPLATE
(
    @CURRENTAPPUSERID uniqueidentifier,
    @QUERYVIEWS xml = null output,
    @SITEREQUIRED bit = null output,
    @SITEID uniqueidentifier = null output
)
as
    set nocount on;

    set @QUERYVIEWS = dbo.UFN_LETTERTEMPLATE_GETTAGGEDQUERYVIEWS_TOITEMLISTXML();
    set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID);
    set @SITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID);

    return 0;