USP_DATAFORMTEMPLATE_EDIT_INVITATIONPREPROCESS

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.
@BUSINESSPROCESSVIEWID	uniqueidentifier	IN	Output format
@EVENTID	uniqueidentifier	IN	Event
@MAILDATE	datetime	IN	Mail date
@CREATEOUTPUTIDSET	bit	IN	Create selection from results
@OUTPUTIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEOUTPUTIDSET	bit	IN	Overwrite existing selection
@CUSTOMPARAMETERDATAFORMITEM	xml	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_INVITATIONPREPROCESS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @BUSINESSPROCESSVIEWID uniqueidentifier,
    @EVENTID uniqueidentifier,
    @MAILDATE datetime,
    @CREATEOUTPUTIDSET bit,
    @OUTPUTIDSETNAME nvarchar(100),
    @OVERWRITEOUTPUTIDSET bit,
    @CUSTOMPARAMETERDATAFORMITEM xml
)
as                
    set nocount on;

    declare @CHANNELCODE tinyint;
    declare @CHANNELPREFERENCECODE tinyint;
    declare @MAILPACKAGEID uniqueidentifier;
    declare @EMAILPACKAGEID uniqueidentifier;
    declare @ADDRESSPROCESSINGOPTIONID uniqueidentifier;
    declare @NAMEFORMATPARAMETERID uniqueidentifier;
    declare @HOUSEHOLDINGTYPECODE tinyint;
    declare @HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD bit;
    declare @HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS bit;
    declare @HOUSEHOLDINGONERECORDPERHOUSEHOLD bit;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_INVITATIONPREPROCESS
        @ID = @ID,
        @CHANNELCODE = @CHANNELCODE output,
        @CHANNELPREFERENCECODE = @CHANNELPREFERENCECODE output,
        @MAILPACKAGEID = @MAILPACKAGEID output,
        @EMAILPACKAGEID = @EMAILPACKAGEID output,
        @ADDRESSPROCESSINGOPTIONID = @ADDRESSPROCESSINGOPTIONID output,
        @NAMEFORMATPARAMETERID = @NAMEFORMATPARAMETERID output,
        @HOUSEHOLDINGTYPECODE = @HOUSEHOLDINGTYPECODE output,
        @HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD = @HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD output,
        @HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS = @HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS output,
        @HOUSEHOLDINGONERECORDPERHOUSEHOLD = @HOUSEHOLDINGONERECORDPERHOUSEHOLD output;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_INVITATIONPREPROCESS_2
        @ID,
        @CHANGEAGENTID,
        @BUSINESSPROCESSVIEWID,
        @EVENTID,
        @MAILDATE,
        @CREATEOUTPUTIDSET,
        @OUTPUTIDSETNAME,
        @OVERWRITEOUTPUTIDSET,
        @CUSTOMPARAMETERDATAFORMITEM,
        @CHANNELCODE,
        @CHANNELPREFERENCECODE,
        @MAILPACKAGEID,
        @EMAILPACKAGEID,
        @ADDRESSPROCESSINGOPTIONID,
        @NAMEFORMATPARAMETERID,
        @HOUSEHOLDINGTYPECODE,
        @HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD,
        @HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS,
        @HOUSEHOLDINGONERECORDPERHOUSEHOLD;

    return 0;