USP_DATAFORMTEMPLATE_PRELOAD_ADD_MKTSEGMENTATIONAPPEAL

The load procedure used by the edit dataform template "Marketing Effort Appeal Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@STARTDATE	datetime	INOUT	Start date
@SITEREQUIRED	bit	INOUT	Site Required
@SITEID	uniqueidentifier	INOUT	Site
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency
@CURRENCYID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_PRELOAD_ADD_MKTSEGMENTATIONAPPEAL]
(
  @CURRENTAPPUSERID uniqueidentifier,
  @STARTDATE datetime = null output,
  @SITEREQUIRED bit = null output,
  @SITEID uniqueidentifier = null output,
  @BASECURRENCYID uniqueidentifier = null output,
  @CURRENCYID uniqueidentifier
)
as
  begin
    set nocount on;

    select
      @STARTDATE = dbo.[UFN_DATE_GETEARLIESTTIME](getdate()),
      @SITEREQUIRED = dbo.[UFN_SITEREQUIREDFORUSERONFEATURE](@CURRENTAPPUSERID, '5902b648-d89d-4446-8a33-e3767ad6b4c0', 1),
      @SITEID = dbo.[UFN_APPUSER_DEFAULTSITEFORUSER](@CURRENTAPPUSERID);

    if @CURRENCYID is null
      set @BASECURRENCYID = dbo.[UFN_APPUSER_GETBASECURRENCY](@CURRENTAPPUSERID);
    else
      set @BASECURRENCYID = @CURRENCYID;

    return 0;
  end