USP_DATAFORMTEMPLATE_EDITLOAD_MKTCOMMUNICATIONEFFORTASKLADDEROVERRIDES

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MKTCOMMUNICATIONEFFORTASKLADDEROVERRIDES
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @ASKLADDEROVERRIDES xml = null output,
  @BASECURRENCYID uniqueidentifier = null output
)
as

  set nocount on;

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

  select
    @DATALOADED = 1,
    @TSLONG = [MKTSEGMENTATION].[TSLONG],
    @BASECURRENCYID = [MKTSEGMENTATION].[BASECURRENCYID]
  from 
    dbo.[MKTSEGMENTATION]
  where 
    [MKTSEGMENTATION].[ID] = @ID;

  if @DATALOADED = 1
  begin
    -- check if the mailing is currently being activated
    declare @RESULT int;
    exec @RESULT = dbo.[USP_MKTSEGMENTATION_CHECKACTIVATION] @ID;
    if @RESULT <> 0
    begin
      set @DATALOADED = 0;
      return 1;
    end

    set @ASKLADDEROVERRIDES = dbo.[UFN_MKTCOMUNICATIONEFFORTASKLADDEROVERRIDES_GETITEMLIST_TOITEMLISTXML](@ID);;
  end

  return 0;