USP_DATAFORMTEMPLATE_VIEW_MKTCOMMUNICATIONEFFORTEXPORTFORMAT

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN
@CURRENTAPPUSERID uniqueidentifier IN
@DATALOADED bit INOUT
@MAILEXPORTDEFINITIONNAME nvarchar(200) INOUT
@MAILEXPORTDEFINITIONIDLOCKED bit INOUT
@PHONEEXPORTDEFINITIONNAME nvarchar(200) INOUT
@PHONEEXPORTDEFINITIONIDLOCKED bit INOUT
@EMAILEXPORTDEFINITIONNAME nvarchar(200) INOUT
@EMAILEXPORTDEFINITIONIDLOCKED bit INOUT
@EXPORTDESCRIPTION nvarchar(255) INOUT
@EXPORTDESCRIPTIONLOCKED bit INOUT
@CURRENCYSYMBOLDISPLAYSETTINGCODE tinyint INOUT
@CURRENCYSYMBOLDISPLAYSETTINGCODELOCKED bit INOUT
@CURRENCYDECIMALDIGITSDISPLAYSETTINGCODE tinyint INOUT
@CURRENCYDECIMALDIGITSDISPLAYSETTINGCODELOCKED bit INOUT
@CURRENCYDECIMALDIGITS int INOUT
@CURRENCYGROUPSEPARATORDISPLAYSETTINGCODE tinyint INOUT
@CURRENCYGROUPSEPARATORDISPLAYSETTINGCODELOCKED bit INOUT
@CURRENCYGROUPSEPARATOR nvarchar(4) INOUT
@CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODE tinyint INOUT
@CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODELOCKED bit INOUT
@CURRENCYDECIMALSEPARATOR nvarchar(4) INOUT
@ORGANIZATIONCURRENCYID uniqueidentifier INOUT
@DATEFORMAT nvarchar(50) INOUT
@DATEFORMATLOCKED bit INOUT
@FUZZYDATEFORMAT nvarchar(50) INOUT
@FUZZYDATEFORMATLOCKED bit INOUT
@MONTHDAYFORMAT nvarchar(50) INOUT
@MONTHDAYFORMATLOCKED bit INOUT
@HOURMINUTEFORMAT nvarchar(50) INOUT
@HOURMINUTEFORMATLOCKED bit INOUT
@CSVLINEBREAKCODE tinyint INOUT
@CSVLINEBREAKCODELOCKED bit INOUT
@SHOWLOCKEDFIELDS bit INOUT

Definition

Copy 


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTCOMMUNICATIONEFFORTEXPORTFORMAT]
(
  @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @MAILEXPORTDEFINITIONNAME nvarchar(200) = null output,
  @MAILEXPORTDEFINITIONIDLOCKED bit = null output,
  @PHONEEXPORTDEFINITIONNAME nvarchar(200) = null output,
  @PHONEEXPORTDEFINITIONIDLOCKED bit = null output,
  @EMAILEXPORTDEFINITIONNAME nvarchar(200) = null output,
  @EMAILEXPORTDEFINITIONIDLOCKED bit = null output,
  @EXPORTDESCRIPTION nvarchar(255) = null output,
  @EXPORTDESCRIPTIONLOCKED bit = null output,
  @CURRENCYSYMBOLDISPLAYSETTINGCODE tinyint = null output,
  @CURRENCYSYMBOLDISPLAYSETTINGCODELOCKED bit = null output,
  @CURRENCYDECIMALDIGITSDISPLAYSETTINGCODE tinyint = null output,
  @CURRENCYDECIMALDIGITSDISPLAYSETTINGCODELOCKED bit = null output,
  @CURRENCYDECIMALDIGITS int = null output,
  @CURRENCYGROUPSEPARATORDISPLAYSETTINGCODE tinyint = null output,
  @CURRENCYGROUPSEPARATORDISPLAYSETTINGCODELOCKED bit = null output,
  @CURRENCYGROUPSEPARATOR nvarchar(4) = null output,
  @CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODE tinyint = null output,
  @CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODELOCKED bit = null output,
  @CURRENCYDECIMALSEPARATOR nvarchar(4) = null output,
  @ORGANIZATIONCURRENCYID uniqueidentifier = null output,
  @DATEFORMAT nvarchar(50) = null output,
  @DATEFORMATLOCKED bit = null output,
  @FUZZYDATEFORMAT nvarchar(50) = null output,
  @FUZZYDATEFORMATLOCKED bit = null output,
  @MONTHDAYFORMAT nvarchar(50) = null output,
  @MONTHDAYFORMATLOCKED bit = null output,
  @HOURMINUTEFORMAT nvarchar(50) = null output,
  @HOURMINUTEFORMATLOCKED bit = null output,
  @CSVLINEBREAKCODE tinyint = null output,
  @CSVLINEBREAKCODELOCKED bit = null output,
  @SHOWLOCKEDFIELDS bit = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

  select
    @DATALOADED = 1,
    @MAILEXPORTDEFINITIONNAME = (select [EXPORTDEFINITION].[NAME] from dbo.[EXPORTDEFINITION] where [EXPORTDEFINITION].[ID] = [MKTSEGMENTATIONEXPORTPROCESS].[MAILEXPORTDEFINITIONID]),
    @PHONEEXPORTDEFINITIONNAME = (select [EXPORTDEFINITION].[NAME] from dbo.[EXPORTDEFINITION] where [EXPORTDEFINITION].[ID] = [MKTSEGMENTATIONEXPORTPROCESS].[PHONEEXPORTDEFINITIONID]),
    @EMAILEXPORTDEFINITIONNAME = (select [EXPORTDEFINITION].[NAME] from dbo.[EXPORTDEFINITION] where [EXPORTDEFINITION].[ID] = [MKTSEGMENTATIONEXPORTPROCESS].[EMAILEXPORTDEFINITIONID]),
    @EXPORTDESCRIPTION = [MKTSEGMENTATIONEXPORTPROCESS].[DESCRIPTION],
    @CURRENCYSYMBOLDISPLAYSETTINGCODE = [BUSINESSPROCESSEXPORTFORMAT].[CURRENCYSYMBOLDISPLAYSETTINGCODE],
    @CURRENCYDECIMALDIGITSDISPLAYSETTINGCODE = [BUSINESSPROCESSEXPORTFORMAT].[CURRENCYDECIMALDIGITSDISPLAYSETTINGCODE],
    @CURRENCYDECIMALDIGITS = [BUSINESSPROCESSEXPORTFORMAT].[CURRENCYDECIMALDIGITS],
    @CURRENCYGROUPSEPARATORDISPLAYSETTINGCODE = [BUSINESSPROCESSEXPORTFORMAT].[CURRENCYGROUPSEPARATORDISPLAYSETTINGCODE],
    @CURRENCYGROUPSEPARATOR = [BUSINESSPROCESSEXPORTFORMAT].[CURRENCYGROUPSEPARATOR],
    @CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODE = [BUSINESSPROCESSEXPORTFORMAT].[CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODE],
    @CURRENCYDECIMALSEPARATOR = [BUSINESSPROCESSEXPORTFORMAT].[CURRENCYDECIMALSEPARATOR],
    @DATEFORMAT = [BUSINESSPROCESSEXPORTFORMAT].[DATEFORMAT],
    @FUZZYDATEFORMAT = [BUSINESSPROCESSEXPORTFORMAT].[FUZZYDATEFORMAT],
    @MONTHDAYFORMAT = [BUSINESSPROCESSEXPORTFORMAT].[MONTHDAYFORMAT],
    @HOURMINUTEFORMAT = [BUSINESSPROCESSEXPORTFORMAT].[HOURMINUTEFORMAT],
    @CSVLINEBREAKCODE = [BUSINESSPROCESSEXPORTFORMAT].[CSVLINEBREAKCODE],
    @SHOWLOCKEDFIELDS = isnull([MKTCOMMUNICATIONEFFORTUSERSETTINGS].[SHOWLOCKEDFIELDS], 0)
  from dbo.[MKTSEGMENTATION]
  inner join dbo.[MKTSEGMENTATIONEXPORTPROCESS] on [MKTSEGMENTATIONEXPORTPROCESS].[SEGMENTATIONID] = [MKTSEGMENTATION].[ID]
  inner join dbo.[MKTSEGMENTATIONEXPORTPROCESSEXPORTFORMAT] on [MKTSEGMENTATIONEXPORTPROCESSEXPORTFORMAT].[PARAMETERSETID] = [MKTSEGMENTATIONEXPORTPROCESS].[ID]
  inner join dbo.[BUSINESSPROCESSEXPORTFORMAT] on [BUSINESSPROCESSEXPORTFORMAT].[ID] = [MKTSEGMENTATIONEXPORTPROCESSEXPORTFORMAT].[ID]
  left join dbo.[MKTCOMMUNICATIONEFFORTUSERSETTINGS] on [MKTSEGMENTATION].[ID] = [MKTCOMMUNICATIONEFFORTUSERSETTINGS].[SEGMENTATIONID] and [MKTCOMMUNICATIONEFFORTUSERSETTINGS].[APPUSERID] = @CURRENTAPPUSERID
  where [MKTSEGMENTATION].[ID] = @ID;

  if @DATALOADED = 1
    begin

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

          select
            @MAILEXPORTDEFINITIONIDLOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[MAILEXPORTDEFINITIONIDLOCKED],
            @PHONEEXPORTDEFINITIONIDLOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[PHONEEXPORTDEFINITIONIDLOCKED],
            @EMAILEXPORTDEFINITIONIDLOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[EMAILEXPORTDEFINITIONIDLOCKED],
            @EXPORTDESCRIPTIONLOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[EXPORTDESCRIPTIONLOCKED],
            @CURRENCYSYMBOLDISPLAYSETTINGCODELOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[CURRENCYSYMBOLDISPLAYSETTINGCODELOCKED],
            @CURRENCYDECIMALDIGITSDISPLAYSETTINGCODELOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[CURRENCYDECIMALDIGITSDISPLAYSETTINGCODELOCKED],
            @CURRENCYGROUPSEPARATORDISPLAYSETTINGCODELOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[CURRENCYGROUPSEPARATORDISPLAYSETTINGCODELOCKED],
            @CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODELOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODELOCKED],
            @DATEFORMATLOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[DATEFORMATLOCKED],
            @FUZZYDATEFORMATLOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[FUZZYDATEFORMATLOCKED],
            @MONTHDAYFORMATLOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[MONTHDAYFORMATLOCKED],
            @HOURMINUTEFORMATLOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[HOURMINUTEFORMATLOCKED],
            @CSVLINEBREAKCODELOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[CSVLINEBREAKCODELOCKED]
          from dbo.[MKTCOMMUNICATIONTEMPLATE]
          inner join dbo.[MKTCOMMUNICATIONTEMPLATEDEFAULT] on [MKTCOMMUNICATIONTEMPLATEDEFAULT].[COMMUNICATIONTEMPLATEID] = [MKTCOMMUNICATIONTEMPLATE].[ID]
          where [MKTCOMMUNICATIONTEMPLATE].[MKTSEGMENTATIONID] = @ID;

        end

      set @ORGANIZATIONCURRENCYID = dbo.[UFN_CURRENCY_GETORGANIZATIONCURRENCY]();
    end

  return 0;