USP_DATAFORMTEMPLATE_VIEW_MKTSEGMENTATIONBASICDEVELOPMENT_EXPRESSION

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN
@DATALOADED bit INOUT
@SEGMENTATIONID uniqueidentifier INOUT
@PARENTID uniqueidentifier INOUT
@PARENTNAME nvarchar(100) INOUT
@PARENTACTIVE bit INOUT
@NAME nvarchar(100) INOUT
@ACTIVE bit INOUT
@NUMSEGMENTS int INOUT
@MARKETINGPLANITEMID uniqueidentifier INOUT
@GIFTSOURCESDEFINED bit INOUT
@SMARTQUERIESEXIST bit INOUT
@GALILEOINSTALLED bit INOUT
@UPDATEMAILINGCOUNTSPROCESSID uniqueidentifier INOUT
@SEGMENTATIONEXPORTPROCESSID uniqueidentifier INOUT
@SEGMENTATIONREFRESHPROCESSID uniqueidentifier INOUT
@EVENTINSTANCEID uniqueidentifier INOUT
@ONLYHASVENDORMANAGEDLISTSEGMENTS bit INOUT
@HASVENDORMANAGEDLISTSEGMENTS bit INOUT
@ISCALCULATING bit INOUT
@ISACTIVATING bit INOUT
@SEGMENTATIONSEGMENTCALCULATEPROCESSID uniqueidentifier INOUT
@SEGMENTATIONACTIVATEPROCESSID uniqueidentifier INOUT
@MAILINGTYPECODE tinyint INOUT
@ADDRESSPROCESSINGOPTIONID uniqueidentifier INOUT
@NAMEFORMATPARAMETERID uniqueidentifier INOUT
@ISBBEC bit INOUT
@HASTESTMAILINGS bit INOUT
@RECORDCOUNTCACHEISCURRENT bit INOUT
@SEGMENTATIONSEGMENTREFRESHPROCESSID uniqueidentifier INOUT
@SEGMENTATIONEXPORTPROCESSRUN bit INOUT
@SEGMENTATIONEXCLUSIONSPROCESSID uniqueidentifier INOUT
@SOURCECODEID uniqueidentifier INOUT
@WHITEMAILSEGMENTCOUNT int INOUT
@HASPACKAGE bit INOUT
@HASAPPEAL bit INOUT
@HASASKLADDEROVERRIDES bit INOUT
@CREATEDFROMPLAN bit INOUT
@SEGMENTEDHOUSEFILEEFFORT bit INOUT
@ISHISTORICAL bit INOUT
@EFFORTEXCLUSIONSPROCESSRUN bit INOUT

Definition

Copy 

create procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTSEGMENTATIONBASICDEVELOPMENT_EXPRESSION]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @SEGMENTATIONID uniqueidentifier = null output,
  @PARENTID uniqueidentifier = null output,
  @PARENTNAME nvarchar(100) = null output,
  @PARENTACTIVE bit = null output,
  @NAME nvarchar(100) = null output,
  @ACTIVE bit = null output,
  @NUMSEGMENTS int = null output,
  @MARKETINGPLANITEMID uniqueidentifier = null output,
  @GIFTSOURCESDEFINED bit = null output,
  @SMARTQUERIESEXIST bit = null output,
  @GALILEOINSTALLED bit = null output,
  @UPDATEMAILINGCOUNTSPROCESSID uniqueidentifier = null output,
  @SEGMENTATIONEXPORTPROCESSID uniqueidentifier = null output,
  @SEGMENTATIONREFRESHPROCESSID uniqueidentifier = null output,
  @EVENTINSTANCEID uniqueidentifier = null output,
  @ONLYHASVENDORMANAGEDLISTSEGMENTS bit = null output,
  @HASVENDORMANAGEDLISTSEGMENTS bit = null output,
  @ISCALCULATING bit = null output,
  @ISACTIVATING bit = null output,
  @SEGMENTATIONSEGMENTCALCULATEPROCESSID uniqueidentifier = null output,
  @SEGMENTATIONACTIVATEPROCESSID uniqueidentifier = null output,
  @MAILINGTYPECODE tinyint = null output,
  @ADDRESSPROCESSINGOPTIONID uniqueidentifier = null output,
  @NAMEFORMATPARAMETERID uniqueidentifier = null output,
  @ISBBEC bit = null output,
  @HASTESTMAILINGS bit = null output,
  @RECORDCOUNTCACHEISCURRENT bit = null output,
  @SEGMENTATIONSEGMENTREFRESHPROCESSID uniqueidentifier = null output,
  @SEGMENTATIONEXPORTPROCESSRUN bit = null output,
  @SEGMENTATIONEXCLUSIONSPROCESSID uniqueidentifier = null output,
  @SOURCECODEID uniqueidentifier = null output,
  @WHITEMAILSEGMENTCOUNT integer = null output,
  @HASPACKAGE bit = null output,
  @HASAPPEAL bit = null output,
  @HASASKLADDEROVERRIDES bit = null output,
  @CREATEDFROMPLAN bit = null output,
  @SEGMENTEDHOUSEFILEEFFORT bit = null output,
  @ISHISTORICAL bit = null output,
  @EFFORTEXCLUSIONSPROCESSRUN bit = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

  exec dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTSEGMENTATION_EXPRESSION]
    @ID = @ID,
    @DATALOADED = @DATALOADED output,
    @SEGMENTATIONID = @SEGMENTATIONID output,
    @PARENTID = @PARENTID output,
    @PARENTNAME = @PARENTNAME output,
    @PARENTACTIVE = @PARENTACTIVE output,
    @NAME = @NAME output,
    @ACTIVE = @ACTIVE output,
    @SOURCECODEID = @SOURCECODEID output,
    @NUMSEGMENTS = @NUMSEGMENTS output,
    @MARKETINGPLANITEMID = @MARKETINGPLANITEMID output,
    @GIFTSOURCESDEFINED = @GIFTSOURCESDEFINED output,
    @SMARTQUERIESEXIST = @SMARTQUERIESEXIST output,
    @GALILEOINSTALLED = @GALILEOINSTALLED output,
    @UPDATEMAILINGCOUNTSPROCESSID = @UPDATEMAILINGCOUNTSPROCESSID output,
    @SEGMENTATIONEXPORTPROCESSID = @SEGMENTATIONEXPORTPROCESSID output,
    @SEGMENTATIONREFRESHPROCESSID = @SEGMENTATIONREFRESHPROCESSID output,
    @SEGMENTATIONEXCLUSIONSPROCESSID = @SEGMENTATIONEXCLUSIONSPROCESSID output,
    @EVENTINSTANCEID = @EVENTINSTANCEID output,
    @ONLYHASVENDORMANAGEDLISTSEGMENTS = @ONLYHASVENDORMANAGEDLISTSEGMENTS output,
    @HASVENDORMANAGEDLISTSEGMENTS = @HASVENDORMANAGEDLISTSEGMENTS output,
    @ISCALCULATING = @ISCALCULATING output,
    @ISACTIVATING = @ISACTIVATING output,
    @SEGMENTATIONSEGMENTREFRESHPROCESSID = @SEGMENTATIONSEGMENTREFRESHPROCESSID output,
    @SEGMENTATIONSEGMENTCALCULATEPROCESSID = @SEGMENTATIONSEGMENTCALCULATEPROCESSID output,
    @SEGMENTATIONACTIVATEPROCESSID = @SEGMENTATIONACTIVATEPROCESSID output,
    @MAILINGTYPECODE = @MAILINGTYPECODE output,
    @ADDRESSPROCESSINGOPTIONID = @ADDRESSPROCESSINGOPTIONID output,
    @NAMEFORMATPARAMETERID = @NAMEFORMATPARAMETERID output,
    @ISBBEC = @ISBBEC output,
    @HASTESTMAILINGS = @HASTESTMAILINGS output,
    @RECORDCOUNTCACHEISCURRENT = @RECORDCOUNTCACHEISCURRENT output,
    @WHITEMAILSEGMENTCOUNT = @WHITEMAILSEGMENTCOUNT output,
    @HASPACKAGE = @HASPACKAGE output,
    @HASAPPEAL = @HASAPPEAL output,
    @HASASKLADDEROVERRIDES = @HASASKLADDEROVERRIDES output,
    @CREATEDFROMPLAN = @CREATEDFROMPLAN output,
    @SEGMENTEDHOUSEFILEEFFORT = @SEGMENTEDHOUSEFILEEFFORT output,
    @ISHISTORICAL = @ISHISTORICAL output,
    @SEGMENTATIONEXPORTPROCESSRUN = @SEGMENTATIONEXPORTPROCESSRUN output,
    @EFFORTEXCLUSIONSPROCESSRUN = @EFFORTEXCLUSIONSPROCESSRUN output;

  return 0;