USP_DATAFORMTEMPLATE_VIEW_APPEALMAILINGSETUPLETTER

The load procedure used by the view dataform template "Appeal Mailing Setup Letter View"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@SEQUENCE	int	INOUT	Order
@NAME	nvarchar(100)	INOUT	Name
@CHANNELCODE	tinyint	INOUT	CHANNELCODE
@SENDTOOPTIONCODE	tinyint	INOUT	SENDTOOPTIONCODE
@CONSTITUENTINCLUDECODE	tinyint	INOUT	CONSTITUENTINCLUDECODE
@CONSIDERREVENUEHISTORY	bit	INOUT	CONSIDERREVENUEHISTORY
@REVENUECRITERIACODE	tinyint	INOUT	REVENUECRITERIACODE
@LOWREVENUEAMOUNT	money	INOUT	LOWREVENUEAMOUNT
@HIGHREVENUEAMOUNT	money	INOUT	HIGHREVENUEAMOUNT
@SELECTIONS	xml	INOUT	SELECTIONS

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_APPEALMAILINGSETUPLETTER
(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @SEQUENCE int = null output,
    @NAME nvarchar(100) = null output,
    @CHANNELCODE tinyint = null output,
    @SENDTOOPTIONCODE tinyint = null output,
    @CONSTITUENTINCLUDECODE tinyint = null output,
    @CONSIDERREVENUEHISTORY bit = null output,
    @REVENUECRITERIACODE tinyint = null output,
    @LOWREVENUEAMOUNT money = null output,
    @HIGHREVENUEAMOUNT money = null output,
    @SELECTIONS xml = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select 
        @DATALOADED = 1,
        @SEQUENCE = SEQUENCE,
        @NAME = NAME,
        @CHANNELCODE = CHANNELCODE,
        @SENDTOOPTIONCODE = SENDTOOPTIONCODE,
        @CONSTITUENTINCLUDECODE = CONSTITUENTINCLUDECODE,
        @CONSIDERREVENUEHISTORY = CONSIDERREVENUEHISTORY,
        @REVENUECRITERIACODE = REVENUECRITERIACODE,
        @LOWREVENUEAMOUNT = LOWREVENUEAMOUNT,
        @HIGHREVENUEAMOUNT = HIGHREVENUEAMOUNT,
        @SELECTIONS = 
            case
                when (CHANNELCODE = 0 or CHANNELCODE = 1) and EMAILSEGMENTID is not null then dbo.UFN_MKTSEGMENT_GETSELECTIONS_TOITEMLISTXML(EMAILSEGMENTID, @CURRENTAPPUSERID)
                when (CHANNELCODE = 0 or CHANNELCODE = 2) and MAILSEGMENTID is not null then dbo.UFN_MKTSEGMENT_GETSELECTIONS_TOITEMLISTXML(MAILSEGMENTID, @CURRENTAPPUSERID)
            end
--           dbo.UFN_APPEALMAILINGSETUP_GETLETTERS_TOITEMLISTXML(APPEALMAILINGSETUPLETTER.ID)

    from dbo.APPEALMAILINGSETUPLETTER
    where ID = @ID;

    return 0;