USP_SAVE_COMMUNICATIONLETTEREMAILSTATUSID

Associate the given email status id with the given communication letter.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@EMAILSTATUSID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure USP_SAVE_COMMUNICATIONLETTEREMAILSTATUSID
(
    @ID uniqueidentifier,
    @EMAILSTATUSID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null
)
as
begin

    set nocount on;

    if @CHANGEAGENTID is null
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    declare @CURRENTDATE datetime;
    set @CURRENTDATE = getdate();

    update
        COMMUNICATIONLETTER
    set
        EMAILSTATUSID = @EMAILSTATUSID,
        DATECHANGED = @CURRENTDATE,
        CHANGEDBYID = @CHANGEAGENTID
    where
        ID = @ID
end