USP_DATAFORMTEMPLATE_EDIT_MKTLETTERCODE

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@WORDFILE	varbinary	IN	File
@WORDTEMPLATEFILENAME	nvarchar(255)	IN	Word template
@DISPLAYEDFILENAME	nvarchar(255)	IN	Word template
@MKTEXPORTDEFINITIONID	uniqueidentifier	IN	Export definition (obsolete)
@FILECHANGED	bit	IN	File changed?
@INCLUDESRECEIPT	bit	IN	Letter includes receipt
@EXPORTDEFINITIONID	uniqueidentifier	IN	Export definition

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_MKTLETTERCODE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100),
    @DESCRIPTION nvarchar(255),
    @WORDFILE varbinary(max),
    @WORDTEMPLATEFILENAME nvarchar(255),
    @DISPLAYEDFILENAME nvarchar(255),
    @MKTEXPORTDEFINITIONID uniqueidentifier, -- obsolete

  @FILECHANGED bit,
    @INCLUDESRECEIPT bit,
    @EXPORTDEFINITIONID uniqueidentifier
)

as
  set nocount on;

    declare @CURRENTAPPUSERID uniqueidentifier;
    declare @SITES xml;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MKTLETTERCODE
        @ID = @ID,
        @CURRENTAPPUSERID = @CURRENTAPPUSERID output,
        @SITES = @SITES output;

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_MKTLETTERCODE_2
        @ID,
        @CHANGEAGENTID,
        @NAME,
        @DESCRIPTION,
        @WORDFILE,
        @WORDTEMPLATEFILENAME,
        @DISPLAYEDFILENAME,
        @MKTEXPORTDEFINITIONID,
        @FILECHANGED,
        @INCLUDESRECEIPT,
        @EXPORTDEFINITIONID,
        @CURRENTAPPUSERID,
        @SITES

  return 0;