USP_DATAFORMTEMPLATE_ADD_MKTLETTERCODEMEMBERSHIP

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(255)	IN
@MKTEXPORTDEFINITIONID	uniqueidentifier	IN
@INCLUDESRECEIPT	bit	IN
@WORDTEMPLATEFILENAME	nvarchar(255)	IN
@WORDFILE	varbinary	IN
@EXPORTDEFINITIONID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@SITES	xml	IN

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTLETTERCODEMEMBERSHIP]
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier,
  @NAME nvarchar(100),
  @DESCRIPTION nvarchar(255) = null,
  @MKTEXPORTDEFINITIONID uniqueidentifier = null, -- obsolete

  @INCLUDESRECEIPT bit = null,
  @WORDTEMPLATEFILENAME nvarchar(255) = null,
  @WORDFILE varbinary(max) = null,
  @EXPORTDEFINITIONID uniqueidentifier = null,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @SITES xml = null
)
as
  set nocount on;

  begin try

    exec dbo.[USP_DATAFORMTEMPLATE_ADD_MKTLETTERCODE]
      @ID = @ID output,
      @MAILINGTYPECODE = 2,
      @CHANGEAGENTID = @CHANGEAGENTID,
      @NAME = @NAME,
      @DESCRIPTION = @DESCRIPTION,
      @MKTEXPORTDEFINITIONID = null, -- obsolete

      @INCLUDESRECEIPT = @INCLUDESRECEIPT,
      @WORDTEMPLATEFILENAME = @WORDTEMPLATEFILENAME,
      @WORDFILE = @WORDFILE,
      @EXPORTDEFINITIONID = @EXPORTDEFINITIONID,
      @CURRENTAPPUSERID = @CURRENTAPPUSERID,
      @SITES = @SITES;

  end try

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

  return 0;