USP_DATAFORMTEMPLATE_PRELOAD_ADD_MKTVENDORCREATIVE

The load procedure used by the edit dataform template "Marketing Vendor Creative Add Form"

Parameters

Parameter Parameter Type Mode Description
@VENDORID uniqueidentifier IN Input parameter indicating the context ID for the record being added.
@CURRENTAPPUSERID uniqueidentifier IN Input parameter indicating the ID of the current user.
@SITEREQUIRED bit INOUT Site required?
@SITEID uniqueidentifier INOUT Site
@BASECURRENCYID uniqueidentifier INOUT Currency

Definition

Copy


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

  set @SITEREQUIRED = dbo.[UFN_SITEREQUIREDFORUSERONFEATURE](@CURRENTAPPUSERID, '8C730B13-7BEE-4EC0-82D5-DF8BD9D8981B', 1);
  set @SITEID = dbo.[UFN_APPUSER_DEFAULTSITEFORUSER](@CURRENTAPPUSERID);
  set @BASECURRENCYID = dbo.[UFN_APPUSER_GETBASECURRENCY](@CURRENTAPPUSERID);

  return 0;