USP_DATAFORMTEMPLATE_EDITLOAD_MKTCOMMUNICATIONEFFORTACTIVATIONSETTINGS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@RUNSEGMENTATIONSEGMENTREFRESHPROCESS	bit	INOUT
@RUNSEGMENTATIONSEGMENTREFRESHPROCESSLOCKED	bit	INOUT
@RUNMARKETINGEXCLUSIONSREPORT	bit	INOUT
@RUNMARKETINGEXCLUSIONSREPORTLOCKED	bit	INOUT
@CACHESOURCEANALYSISRULEDATA	bit	INOUT
@CACHESOURCEANALYSISRULEDATALOCKED	bit	INOUT
@RUNSEGMENTATIONSEGMENTCALCULATEPROCESS	bit	INOUT
@RUNSEGMENTATIONSEGMENTREFRESHPROCESSACTIVATE	bit	INOUT
@RUNMARKETINGEXCLUSIONSREPORTACTIVATE	bit	INOUT
@CACHESOURCEANALYSISRULEDATAACTIVATE	bit	INOUT
@ACTIVATEOPTIONSLOCKED	bit	INOUT
@EXPORTAFTERACTIVATE	bit	INOUT
@EXPORTAFTERACTIVATELOCKED	bit	INOUT
@CACHESOURCEANALYSISRULEDATAACTIVATELOCKED	bit	INOUT
@SEGMENTATIONSEGMENTREFRESHPROCESSLASTRUN	datetime	INOUT
@MARKETINGEXCLUSIONSREPORTLASTRUN	datetime	INOUT
@CACHESOURCEANALYSISRULEDATALASTRUN	datetime	INOUT
@SEGMENTATIONSEGMENTCALCULATEPROCESSLASTRUN	datetime	INOUT
@EXPORTAFTERACTIVATELASTRUN	datetime	INOUT
@ISBBEC	bit	INOUT

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTCOMMUNICATIONEFFORTACTIVATIONSETTINGS]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @RUNSEGMENTATIONSEGMENTREFRESHPROCESS bit = null output,
  @RUNSEGMENTATIONSEGMENTREFRESHPROCESSLOCKED bit = null output,
  @RUNMARKETINGEXCLUSIONSREPORT bit = null output,
  @RUNMARKETINGEXCLUSIONSREPORTLOCKED bit = null output,
  @CACHESOURCEANALYSISRULEDATA bit = null output,
  @CACHESOURCEANALYSISRULEDATALOCKED bit = null output,
  @RUNSEGMENTATIONSEGMENTCALCULATEPROCESS bit = null output,
  @RUNSEGMENTATIONSEGMENTREFRESHPROCESSACTIVATE bit = null output,
  @RUNMARKETINGEXCLUSIONSREPORTACTIVATE bit = null output,
  @CACHESOURCEANALYSISRULEDATAACTIVATE bit = null output,
  @ACTIVATEOPTIONSLOCKED bit = null output,
  @EXPORTAFTERACTIVATE bit = null output,
  @EXPORTAFTERACTIVATELOCKED bit = null output,
  @CACHESOURCEANALYSISRULEDATAACTIVATELOCKED bit = null output,
  @SEGMENTATIONSEGMENTREFRESHPROCESSLASTRUN datetime = null output,
  @MARKETINGEXCLUSIONSREPORTLASTRUN datetime = null output,
  @CACHESOURCEANALYSISRULEDATALASTRUN datetime = null output,
  @SEGMENTATIONSEGMENTCALCULATEPROCESSLASTRUN datetime = null output,
  @EXPORTAFTERACTIVATELASTRUN datetime = null output,
  @ISBBEC bit = null output
)
as

  set nocount on;

  set @DATALOADED = 0;
  set @TSLONG = 0;

  select
    @DATALOADED = 1,
    @TSLONG = [MKTSEGMENTATION].[TSLONG],
    @RUNSEGMENTATIONSEGMENTREFRESHPROCESS = isnull([MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[RUNSEGMENTATIONSEGMENTREFRESHPROCESS], 0),
    @RUNMARKETINGEXCLUSIONSREPORT = isnull([MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[RUNMARKETINGEXCLUSIONSREPORT], 0),
    @CACHESOURCEANALYSISRULEDATA = isnull([MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[CACHESOURCEANALYSISRULEDATA], 0),
    @RUNSEGMENTATIONSEGMENTCALCULATEPROCESS = isnull([MKTSEGMENTATIONACTIVATEPROCESS].[RUNSEGMENTATIONSEGMENTCALCULATEPROCESS], 0),
    @RUNSEGMENTATIONSEGMENTREFRESHPROCESSACTIVATE = isnull([MKTSEGMENTATIONACTIVATEPROCESS].[RUNSEGMENTATIONSEGMENTREFRESHPROCESS], 0),
    @RUNMARKETINGEXCLUSIONSREPORTACTIVATE = isnull([MKTSEGMENTATIONACTIVATEPROCESS].[RUNMARKETINGEXCLUSIONSREPORT], 0),
    @CACHESOURCEANALYSISRULEDATAACTIVATE = isnull([MKTSEGMENTATIONACTIVATEPROCESS].[CACHESOURCEANALYSISRULEDATA], 0),
    @EXPORTAFTERACTIVATE = isnull([MKTSEGMENTATION].[RUNACTIVATEANDEXPORT], 0),
    --Last run values

    @SEGMENTATIONSEGMENTREFRESHPROCESSLASTRUN = [LASTRUN].[SEGMENTATIONSEGMENTREFRESHPROCESSLASTRUN],
    @MARKETINGEXCLUSIONSREPORTLASTRUN = [LASTRUN].[MARKETINGEXCLUSIONSREPORTLASTRUN],
    @CACHESOURCEANALYSISRULEDATALASTRUN = [LASTRUN].[CACHESOURCEANALYSISRULEDATALASTRUN],
    @SEGMENTATIONSEGMENTCALCULATEPROCESSLASTRUN = [LASTRUN].[SEGMENTATIONSEGMENTCALCULATEPROCESSLASTRUN],
    @EXPORTAFTERACTIVATELASTRUN = [LASTRUN].[EXPORTPROCESSLASTRUN]

  from
    dbo.[MKTSEGMENTATION]
    inner join dbo.[MKTSEGMENTATIONSEGMENTCALCULATEPROCESS] on [MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[SEGMENTATIONID] = [MKTSEGMENTATION].[ID]
    inner join dbo.[MKTSEGMENTATIONACTIVATEPROCESS] on [MKTSEGMENTATIONACTIVATEPROCESS].[SEGMENTATIONID] = [MKTSEGMENTATION].[ID]
    left join dbo.[UFN_MKTCOMMUNICATIONEFFORT_GETLASTRUNDATE_BULK]() as [LASTRUN] on [LASTRUN].[SEGMENTATIONID] = [MKTSEGMENTATION].[ID]
  where
    [MKTSEGMENTATION].[ID] = @ID;

  if @DATALOADED = 1
    begin

      set @ISBBEC = (case when dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('BB9873D7-F1ED-430A-8AB4-F09F47056538') = 0 then 1 else 0 end);

      /* Get template locked settings */  
      if exists(select top 1 1 from dbo.[MKTCOMMUNICATIONTEMPLATE] where [MKTSEGMENTATIONID] = @ID)
        begin

          select
            @RUNSEGMENTATIONSEGMENTREFRESHPROCESSLOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[RUNSEGMENTATIONSEGMENTREFRESHPROCESSLOCKED],
            @RUNMARKETINGEXCLUSIONSREPORTLOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[RUNMARKETINGEXCLUSIONSREPORTLOCKED],
            @CACHESOURCEANALYSISRULEDATALOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[CACHESOURCEANALYSISRULEDATALOCKED],
            @ACTIVATEOPTIONSLOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[ACTIVATEOPTIONSLOCKED],
            @EXPORTAFTERACTIVATELOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[EXPORTAFTERACTIVATELOCKED],
            @CACHESOURCEANALYSISRULEDATAACTIVATELOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[CACHESOURCEANALYSISRULEDATAACTIVATELOCKED]
          from dbo.[MKTCOMMUNICATIONTEMPLATE]
          inner join dbo.[MKTCOMMUNICATIONTEMPLATEDEFAULT] on [MKTCOMMUNICATIONTEMPLATEDEFAULT].[COMMUNICATIONTEMPLATEID] = [MKTCOMMUNICATIONTEMPLATE].[ID]
          where [MKTCOMMUNICATIONTEMPLATE].[MKTSEGMENTATIONID] = @ID;

        end

    end

  return 0;