USP_DATAFORMTEMPLATE_PRELOAD_ADD_MKTPACKAGE

The load procedure used by the edit dataform template "Package 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
@CREATIVECOSTS	money	INOUT	Creative costs
@BASECURRENCYID	uniqueidentifier	INOUT	Currency

Definition

Copy


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

  set @SITEREQUIRED = dbo.[UFN_SITEREQUIREDFORUSERONFEATURE](@CURRENTAPPUSERID, 'D85DD414-BED5-4FBE-B5F9-0C8369D456F7', 1);
  set @SITEID = dbo.[UFN_APPUSER_DEFAULTSITEFORUSER](@CURRENTAPPUSERID);

  set @CREATIVECOSTS = 0;

  set @BASECURRENCYID = dbo.[UFN_APPUSER_GETBASECURRENCY](@CURRENTAPPUSERID);

  return 0;