USP_DATAFORMTEMPLATE_EDIT_APPEALMAILINGTASK

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@SUBJECT	nvarchar(100)	IN	Subject
@NOTES	nvarchar(256)	IN	Notes
@DATEDUE	UDT_FUZZYDATE	IN	Date due
@DATECOMPLETED	datetime	IN	Date completed
@STATUSCODE	tinyint	IN	Status
@OWNERID	uniqueidentifier	IN	Owner
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_APPEALMAILINGTASK
(
    @ID uniqueidentifier,
    @SUBJECT nvarchar(100),
    @NOTES nvarchar(256),
    @DATEDUE dbo.UDT_FUZZYDATE,
    @DATECOMPLETED datetime,
    @STATUSCODE tinyint,
    @OWNERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CURRENTAPPUSERID uniqueidentifier
)
as
    set nocount on;

    declare @REMINDERS xml;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_APPEALMAILINGTASK
        @ID = @ID,
        @REMINDERS = @REMINDERS output;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_APPEALMAILINGTASK_2 @ID, @SUBJECT, @NOTES, @DATEDUE,
        @DATECOMPLETED, @STATUSCODE, @OWNERID, @CHANGEAGENTID, @CURRENTAPPUSERID, @REMINDERS;

    return 0;