USP_DATAFORMTEMPLATE_EDIT_LETTERCODE_3

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
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@WORDFILE	varbinary	IN	File
@WORDTEMPLATEFILENAME	nvarchar(255)	IN	Word template
@DISPLAYEDFILENAME	nvarchar(255)	IN	Word template
@QUERYVIEWID	uniqueidentifier	IN	Output format
@FILECHANGED	bit	IN	File changed?
@CUSTOMPARAMETERDATAFORMITEM	xml	IN
@EXPORTDEFINITIONID	uniqueidentifier	IN	Export definition

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_LETTERCODE_3
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100),
    @DESCRIPTION nvarchar(255),
    @IDSETREGISTERID uniqueidentifier,
    @WORDFILE varbinary(max),
    @WORDTEMPLATEFILENAME nvarchar(255),
    @DISPLAYEDFILENAME nvarchar(255),
    @QUERYVIEWID uniqueidentifier,
    @FILECHANGED bit,
    @CUSTOMPARAMETERDATAFORMITEM xml,
    @EXPORTDEFINITIONID uniqueidentifier
)

as
  set nocount on;

    declare @CURRENTAPPUSERID uniqueidentifier = null;
    declare @SITES xml;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_LETTERCODE_2
        @ID = @ID,
        @SITES = @SITES output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_LETTERCODE_4
        @ID,
        @CHANGEAGENTID,
        @NAME,
        @DESCRIPTION,
        @IDSETREGISTERID,
        @WORDFILE,
        @WORDTEMPLATEFILENAME,
        @DISPLAYEDFILENAME,
        @QUERYVIEWID,
        @FILECHANGED,
        @CUSTOMPARAMETERDATAFORMITEM,
        @EXPORTDEFINITIONID,
        @CURRENTAPPUSERID,
        @SITES

  return 0;