USP_DATAFORMTEMPLATE_EDITLOAD_MKTCOMMUNICATIONEFFORTEXPORTFORMAT

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@EXPORTDEFINITIONRECORDTYPE	nvarchar(50)	INOUT
@EXPORTDEFINITIONRECORDTYPEID	uniqueidentifier	INOUT
@EXPORTDEFINITIONQUERYVIEWID	uniqueidentifier	INOUT
@MAILEXPORTDEFINITIONID	uniqueidentifier	INOUT
@MAILEXPORTDEFINITIONIDLOCKED	bit	INOUT
@PHONEEXPORTDEFINITIONID	uniqueidentifier	INOUT
@PHONEEXPORTDEFINITIONIDLOCKED	bit	INOUT
@EMAILEXPORTDEFINITIONID	uniqueidentifier	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

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTCOMMUNICATIONEFFORTEXPORTFORMAT]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @EXPORTDEFINITIONRECORDTYPE nvarchar(50) = null output,
  @EXPORTDEFINITIONRECORDTYPEID uniqueidentifier = null output,
  @EXPORTDEFINITIONQUERYVIEWID uniqueidentifier = null output,
  @MAILEXPORTDEFINITIONID uniqueidentifier = null output,
  @MAILEXPORTDEFINITIONIDLOCKED bit = null output,
  @PHONEEXPORTDEFINITIONID uniqueidentifier = null output,
  @PHONEEXPORTDEFINITIONIDLOCKED bit = null output,
  @EMAILEXPORTDEFINITIONID uniqueidentifier = 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
)
as

  set nocount on;

  select
    @DATALOADED = 1,
    @TSLONG = [MKTSEGMENTATION].[TSLONG],
    @EXPORTDEFINITIONRECORDTYPE = dbo.[UFN_MKTEXPORTDEFINITION_GETRECORDTYPEFROMMAILINGTYPECODE]([MKTSEGMENTATION].[MAILINGTYPECODE]),
    @EXPORTDEFINITIONRECORDTYPEID = dbo.[UFN_MKTEXPORTDEFINITION_GETRECORDTYPEIDFROMMAILINGTYPECODE]([MKTSEGMENTATION].[MAILINGTYPECODE]),
    @EXPORTDEFINITIONQUERYVIEWID = dbo.[UFN_MKTEXPORTDEFINITION_GETQUERYVIEWIDFROMMAILINGTYPECODE]([MKTSEGMENTATION].[MAILINGTYPECODE]),
    @MAILEXPORTDEFINITIONID = [MKTSEGMENTATIONEXPORTPROCESS].[MAILEXPORTDEFINITIONID],
    @PHONEEXPORTDEFINITIONID = [MKTSEGMENTATIONEXPORTPROCESS].[PHONEEXPORTDEFINITIONID],
    @EMAILEXPORTDEFINITIONID = [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]
  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]
  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;