USP_DATAFORMTEMPLATE_PRELOAD_ADD_MKTSEGMENTATIONPASSIVE

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

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@MAILINGTYPECODE	tinyint	INOUT	Marketing effort type
@SITEID	uniqueidentifier	INOUT	Site
@SITEREQUIRED	bit	INOUT	Site required?
@SOURCECODEID	uniqueidentifier	INOUT	Source code
@ACTIVATIONKPIS	xml	INOUT	Activation KPIs
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency ID

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_PRELOAD_ADD_MKTSEGMENTATIONPASSIVE]
(
  @CURRENTAPPUSERID uniqueidentifier,
  @MAILINGTYPECODE tinyint = null output,
  @SITEID uniqueidentifier = null output,
  @SITEREQUIRED bit = null output,
  @SOURCECODEID uniqueidentifier = null output,
  @ACTIVATIONKPIS xml = null output,
  @BASECURRENCYID uniqueidentifier = null output
)
as
  set nocount on;

  set @MAILINGTYPECODE = 4;

  set @SITEID = dbo.[UFN_APPUSER_DEFAULTSITEFORUSER](@CURRENTAPPUSERID);
  set @SITEREQUIRED = dbo.[UFN_SITEREQUIREDFORUSERONFEATURE](@CURRENTAPPUSERID, '5F6A5AA7-B9C6-4E81-850F-AFBC1AABC814', 1);

  select top 1 
    @SOURCECODEID = [ID]
   from dbo.[MKTSOURCECODE]
   where dbo.[UFN_SITEALLOWEDFORUSER](@CURRENTAPPUSERID, [MKTSOURCECODE].[SITEID]) = 1
     and [ISDEFAULT] <> 0 and [ISACTIVE] <> 0
     and not exists(select top 1 1 from dbo.[MKTSOURCECODEITEM] as [I] inner join dbo.[MKTSOURCECODEPARTDEFINITION] as [PD] on [PD].[ID] = [I].[MKTSOURCECODEPARTDEFINITIONID] where [I].[SOURCECODEID] = [MKTSOURCECODE].[ID] and [PD].[ITEMTYPECODE] = 6)
     and not exists(select top 1 1 from dbo.[MKTSOURCECODEITEM] as [I] inner join dbo.[MKTSOURCECODEPARTDEFINITION] as [PD] on [PD].[ID] = [I].[MKTSOURCECODEPARTDEFINITIONID] where [I].[SOURCECODEID] = [MKTSOURCECODE].[ID] and [PD].[ITEMTYPECODE] = 7);

  -- load KPI values

  declare @KPITABLE as table (
    [KPICATALOGID] uniqueidentifier,
    [SELECTED] bit,
    [NAME] nvarchar(255),
    [GOALTYPECODE] tinyint,
    [DEFAULT] bit);

  insert into @KPITABLE
    exec dbo.[USP_MKTSEGMENTATIONACTIVATEKPI_GETDEFAULTS] 4, @CURRENTAPPUSERID;

  set @ACTIVATIONKPIS = (
    select 
      [KPICATALOGID],
      [SELECTED],
      [NAME],
      [GOALTYPECODE],
      [DEFAULT]
    from @KPITABLE
  for xml raw('ITEM'), type, elements, root('ACTIVATIONKPIS'), binary base64);  

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

  return 0;