USP_DATAFORMTEMPLATE_EDIT_TRIBUTE

The save procedure used by the edit dataform template "Tribute Edit Form".

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.
@TRIBUTETYPECODEID	uniqueidentifier	IN	Tribute type
@TRIBUTETEXT	nvarchar(255)	IN	Tribute text
@TRIBUTEEID	uniqueidentifier	IN	Tributee
@DESIGNATIONID	uniqueidentifier	IN	Default designation
@NAMEFORMATFUNCTIONID	uniqueidentifier	IN	Name format
@SITES	xml	IN	Sites

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_TRIBUTE
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @TRIBUTETYPECODEID uniqueidentifier,
                        @TRIBUTETEXT nvarchar(255),
                        @TRIBUTEEID uniqueidentifier,
                        @DESIGNATIONID uniqueidentifier,
                        @NAMEFORMATFUNCTIONID uniqueidentifier,
                        @SITES xml
                    )
                    as

                        set nocount on;

                        declare @TRIBUTELETTERCODEID uniqueidentifier;

                        exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_TRIBUTE @ID=@ID, @TRIBUTELETTERCODEID=@TRIBUTELETTERCODEID output;

                        exec dbo.USP_DATAFORMTEMPLATE_EDIT_TRIBUTE_2
                            @ID,
                            @CHANGEAGENTID,
                            @TRIBUTETYPECODEID,
                            @TRIBUTETEXT,
                            @TRIBUTEEID,
                            @DESIGNATIONID,
                            @NAMEFORMATFUNCTIONID,
                            @SITES,
                            @TRIBUTELETTERCODEID;

                    return 0;