USP_DATAFORMTEMPLATE_EDIT_EVENTMANAGEMENTOPTIONS

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.
@HASTASKSANDCOORDINATORS	bit	IN
@HASREGISTRANTSANDOPTIONS	bit	IN	Registrants/Options
@HASSPEAKERS	bit	IN	Speakers
@HASEXPENSES	bit	IN	Expenses
@HASINVITATIONS	bit	IN	Invitations
@HASAPPEALS	bit	IN	Appeals
@HASDOCUMENTATION	bit	IN	Documentation
@HASJOBOCCURRENCES	bit	IN	Job occurrences
@HASLODGINGOPTIONS	bit	IN	Lodging options

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_EVENTMANAGEMENTOPTIONS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @HASTASKSANDCOORDINATORS bit,
    @HASREGISTRANTSANDOPTIONS bit,
    @HASSPEAKERS bit,
    @HASEXPENSES bit,
    @HASINVITATIONS bit,
    @HASAPPEALS bit,
    @HASDOCUMENTATION bit,
    @HASJOBOCCURRENCES bit,
    @HASLODGINGOPTIONS bit
)

as
    set nocount on;

    declare @HASCAMPAIGNS bit;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EVENTMANAGEMENTOPTIONS
        @ID = @ID,
        @HASCAMPAIGNS = @HASCAMPAIGNS output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_EVENTMANAGEMENTOPTIONS_2
        @ID,
        @CHANGEAGENTID,
        @HASTASKSANDCOORDINATORS,
        @HASREGISTRANTSANDOPTIONS,
        @HASSPEAKERS,
        @HASEXPENSES,
        @HASINVITATIONS,
        @HASAPPEALS,
        @HASDOCUMENTATION,
        @HASJOBOCCURRENCES,
        @HASLODGINGOPTIONS,
        @HASCAMPAIGNS

    return 0;