USP_DATAFORMTEMPLATE_PRELOAD_ADD_MKTSEED

The load procedure used by the edit dataform template "Seed 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?
@SITEID uniqueidentifier INOUT Site
@COUNTRYID uniqueidentifier INOUT Country

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_PRELOAD_ADD_MKTSEED]
(
  @CURRENTAPPUSERID uniqueidentifier,
  @SITEREQUIRED bit = null output,
  @SITEID uniqueidentifier = null output,
  @COUNTRYID uniqueidentifier = null output
)
as
  set nocount on;

  set @SITEREQUIRED = dbo.[UFN_SITEREQUIREDFORUSERONFEATURE](@CURRENTAPPUSERID, 'F61161C5-9123-470A-B96A-E8CCCC301BC6', 1);
  set @SITEID = dbo.[UFN_APPUSER_DEFAULTSITEFORUSER](@CURRENTAPPUSERID);

  set @COUNTRYID = dbo.[UFN_COUNTRY_GETDEFAULT]();

  return 0;