USP_DATAFORMTEMPLATE_EDIT_MKTCOMMUNICATIONEFFORTASKLADDEROVERRIDES

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MKTCOMMUNICATIONEFFORTASKLADDEROVERRIDES 
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @ASKLADDEROVERRIDES xml
)
as

  set nocount on;

  declare @CURRENTDATE datetime = getdate();

  begin try
    if (select [ACTIVE] from dbo.[MKTSEGMENTATION] where [ID] = @ID) = 0
      -- check if the mailing is currently being activated
      exec dbo.[USP_MKTSEGMENTATION_CHECKACTIVATION] @ID;

    if @CHANGEAGENTID is null  
      exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

      exec dbo.[USP_MKTCOMUNICATIONEFFORTASKLADDEROVERRIDES_GETITEMLIST_UPDATEFROMXML] @ID, @ASKLADDEROVERRIDES, @CHANGEAGENTID, @CURRENTDATE;

    -- clear the record count cache
    exec dbo.[USP_MKTSEGMENTATION_CLEARCACHE] @ID, 1;
  end try

  begin catch
    exec dbo.[USP_RAISE_ERROR];
    return 1;
  end catch
return 0;