USP_DATAFORMTEMPLATE_ADD_MKTSEGMENTATIONPASSIVESEGMENTGROUP_PRELOAD

The load procedure used by the edit dataform template "Public Media Marketing Effort Segment Group Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTATIONID	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.
@SOURCECODEID	uniqueidentifier	INOUT	Source code ID
@SEGMENTATIONSITEID	uniqueidentifier	INOUT	Marketing effort site ID
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency ID

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTSEGMENTATIONPASSIVESEGMENTGROUP_PRELOAD]
(
  @SEGMENTATIONID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @SOURCECODEID uniqueidentifier = null output,
  @SEGMENTATIONSITEID uniqueidentifier = null output,
  @BASECURRENCYID uniqueidentifier = null output
)
as
  set nocount on;

  -- check if the mailing is currently being activated

  declare @R int;
  exec @R = dbo.[USP_MKTSEGMENTATION_CHECKACTIVATION] @SEGMENTATIONID;
  if @R <> 0
    return 1;

  select
    @SOURCECODEID = [SOURCECODEID],
    @SEGMENTATIONSITEID = [SITEID],
    @BASECURRENCYID = [BASECURRENCYID]
  from dbo.[MKTSEGMENTATION]
  where [ID] = @SEGMENTATIONID;

  return 0;