USP_DATAFORMTEMPLATE_PRELOAD_ADD_MKTMARKETINGPLANMAILING

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

Parameters

Parameter	Parameter Type	Mode	Description
@PARENTMARKETINGPLANITEMID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CAPTION	nvarchar(50)	INOUT	Caption
@LEVEL	int	INOUT	Level
@MARKETINGPLANID	uniqueidentifier	INOUT	Marketing plan item
@SOURCECODEID	uniqueidentifier	INOUT	Source code

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_PRELOAD_ADD_MKTMARKETINGPLANMAILING]
(
  @PARENTMARKETINGPLANITEMID uniqueidentifier,
  @CAPTION nvarchar(50) = null output,
  @LEVEL integer = null output,
  @MARKETINGPLANID uniqueidentifier = null output,
  @SOURCECODEID uniqueidentifier = null output
)
as
  set nocount on;

  declare @MARKETINGPLANSITEID uniqueidentifier;

  select 
    @LEVEL = [MKTMARKETINGPLANITEM].[LEVEL] + 1,
    @MARKETINGPLANID = [MKTMARKETINGPLANITEM].[MARKETINGPLANID],
    @MARKETINGPLANSITEID = [MKTMARKETINGPLAN].[SITEID]
  from dbo.[MKTMARKETINGPLANITEM]
  inner join dbo.[MKTMARKETINGPLAN] on [MKTMARKETINGPLAN].[ID] = [MKTMARKETINGPLANITEM].[MARKETINGPLANID]
  where [MKTMARKETINGPLANITEM].[ID] = @PARENTMARKETINGPLANITEMID;

  select
    @CAPTION = CAPTION
  from dbo.[MKTMARKETINGPLANITEMTEMPLATEITEM]
  where [MARKETINGPLANID] = @MARKETINGPLANID
  and [LEVEL] = @LEVEL;

  select top 1 @SOURCECODEID = [ID]
  from dbo.[MKTSOURCECODE]
  where ([SITEID] = @MARKETINGPLANSITEID or ([SITEID] is null and @MARKETINGPLANSITEID is null)) 
  and [ISDEFAULT] <> 0
  -- do not display empty source code layouts

  and exists (select top 1 1 from dbo.[MKTSOURCECODEITEM] where [MKTSOURCECODEITEM].[SOURCECODEID] = [MKTSOURCECODE].[ID]);

  return 0;