USP_DATAFORMTEMPLATE_EDIT_APPEALMAILINGSETUPLETTERS

This procedure saves the communication letters associated with a given appeal mailing setup.

Parameters

Parameter	Parameter Type	Mode
@SEGMENTATIONID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@MAILEXPORTDEFINITIONID	uniqueidentifier	IN
@EMAILEXPORTDEFINITIONID	uniqueidentifier	IN
@LETTERS	xml	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_APPEALMAILINGSETUPLETTERS
(
    @SEGMENTATIONID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @MAILEXPORTDEFINITIONID uniqueidentifier = null,
    @EMAILEXPORTDEFINITIONID uniqueidentifier = null,
    @LETTERS xml = null
)
as
begin

    declare @CURRENTDATE datetime = getDate();
    declare @ACTIVE bit = 0;

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

    select
        @ACTIVE = ACTIVE
    from dbo.MKTSEGMENTATION
    where ID = @SEGMENTATIONID;

    -- Rollback active mailings before you can update move segmentation segments around

    if @ACTIVE = 1 or dbo.UFN_MKTSEGMENTATION_HASACTIVESEGMENTS(@SEGMENTATIONID) = 1
        exec dbo.USP_MKTSEGMENTATIONACTIVATE_ROLLBACK @SEGMENTATIONID, @CHANGEAGENTID, 1, 1;

    update dbo.APPEALMAILINGSETUP set
        MAILEXPORTDEFINITIONID = @MAILEXPORTDEFINITIONID,
        EMAILEXPORTDEFINITIONID = @EMAILEXPORTDEFINITIONID,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE
    where ID = @SEGMENTATIONID;        

    exec dbo.USP_COMMUNICATIONS_CREATEORUPDATE_LETTERS @SEGMENTATIONID, @CURRENTAPPUSERID, @CHANGEAGENTID, 1, @MAILEXPORTDEFINITIONID, @EMAILEXPORTDEFINITIONID, @LETTERS;

end