USP_DATAFORMTEMPLATE_EDITLOAD_MKTCOMMUNICATIONEFFORTADDRESSPROCESSING

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@ADDRESSPROCESSINGLOCKED	bit	INOUT
@USEADDRESSPROCESSING	bit	INOUT
@ADDRESSPROCESSINGOPTIONID	uniqueidentifier	INOUT
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE	tinyint	INOUT
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATE	datetime	INOUT
@NAMEFORMATPARAMETERID	uniqueidentifier	INOUT

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTCOMMUNICATIONEFFORTADDRESSPROCESSING]
(
  @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @ADDRESSPROCESSINGLOCKED bit = null output,
  @USEADDRESSPROCESSING bit = null output,
  @ADDRESSPROCESSINGOPTIONID uniqueidentifier = null output,
  @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE tinyint = null output,
  @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE datetime = null output,
  @NAMEFORMATPARAMETERID uniqueidentifier = null output
)
as

  set nocount on;

  select
    @DATALOADED = 1,
    @TSLONG = [MKTSEGMENTATION].[TSLONG],
    @USEADDRESSPROCESSING = [MKTSEGMENTATION].[USEADDRESSPROCESSING],
    @ADDRESSPROCESSINGOPTIONID = [MKTSEGMENTATION].[ADDRESSPROCESSINGOPTIONID],
    @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE = [MKTSEGMENTATION].[ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE],
    @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE = [MKTSEGMENTATION].[ADDRESSPROCESSINGOPTIONSEASONALASOFDATE],
    @NAMEFORMATPARAMETERID = [MKTSEGMENTATION].[NAMEFORMATPARAMETERID]
  from dbo.[MKTSEGMENTATION]
  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
            @ADDRESSPROCESSINGLOCKED = [MKTCOMMUNICATIONTEMPLATEDEFAULT].[ADDRESSPROCESSINGLOCKED]
          from dbo.[MKTCOMMUNICATIONTEMPLATE]
          inner join dbo.[MKTCOMMUNICATIONTEMPLATEDEFAULT] on [MKTCOMMUNICATIONTEMPLATEDEFAULT].[COMMUNICATIONTEMPLATEID] = [MKTCOMMUNICATIONTEMPLATE].[ID]
          where [MKTCOMMUNICATIONTEMPLATE].[MKTSEGMENTATIONID] = @ID;

        end

      /* Load primary address processing option and name format id if not using address processing */
      if @USEADDRESSPROCESSING = 0
        begin

          select top 1 @ADDRESSPROCESSINGOPTIONID = [ID] from dbo.[ADDRESSPROCESSINGOPTION] where [ISDEFAULT] = 1 and dbo.[UFN_SITEALLOWEDFORUSER](@CURRENTAPPUSERID, [SITEID]) = 1;
          select top 1 @NAMEFORMATPARAMETERID = [ID] from dbo.[NAMEFORMATPARAMETER] where [ISDEFAULT] = 1 and dbo.[UFN_SITEALLOWEDFORUSER](@CURRENTAPPUSERID, [SITEID]) = 1;

        end

    end

  return 0;