USP_DATAFORMTEMPLATE_ADD_BATCHREVENUEREGISTRANTUNIFIED_PRELOAD

The load procedure used by the edit dataform template "Revenue Batch Registrant Unified Add Form"

Parameters

Parameter Parameter Type Mode Description
@EVENTID uniqueidentifier IN Input parameter indicating the context ID for the record being added.
@EVENTNAME nvarchar(100) INOUT Event
@MAINEVENTID uniqueidentifier INOUT MAINEVENTID
@MAINEVENTNAME nvarchar(100) INOUT Main event
@PACKAGESPRICES xml INOUT
@MULTICOMPONENTEVENTSWITHPRICES xml INOUT
@MULTICOMPONENTEVENTPRICEBENEFITS xml INOUT
@MULTICOMPONENTEVENTPREFERENCEGROUPS xml INOUT
@MULTICOMPONENTEVENTAPPEALS xml INOUT
@CONSTITUENTRECORDTYPEID uniqueidentifier INOUT
@MULTICOMPONENTEVENTSCHEDULES xml INOUT
@CURRENTAPPUSERID uniqueidentifier IN Input parameter indicating the ID of the current user.
@SINGLEEVENTLIST xml INOUT
@EVENTCURRENCY xml INOUT
@REGISTRATIONTYPECODE tinyint INOUT

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_BATCHREVENUEREGISTRANTUNIFIED_PRELOAD
                    (
                        @EVENTID uniqueidentifier,
                        @EVENTNAME nvarchar(100) = null output,
                        @MAINEVENTID uniqueidentifier = null output,
                        @MAINEVENTNAME nvarchar(100) = null output,
                        @PACKAGESPRICES xml = null output,
                        @MULTICOMPONENTEVENTSWITHPRICES xml = null output,
                        @MULTICOMPONENTEVENTPRICEBENEFITS xml = null output,
                        @MULTICOMPONENTEVENTPREFERENCEGROUPS xml = null output,
                        @MULTICOMPONENTEVENTAPPEALS xml = null output,
                        @CONSTITUENTRECORDTYPEID uniqueidentifier = null output,
                        @MULTICOMPONENTEVENTSCHEDULES xml = null output,
                        @CURRENTAPPUSERID uniqueidentifier,
                        @SINGLEEVENTLIST xml = null output,
                        @EVENTCURRENCY xml = null output,
                        @REGISTRATIONTYPECODE tinyint = null output
                    )
                    as
                        set nocount on;


                            exec dbo.USP_DATAFORMTEMPLATE_ADD_REGISTRANTUNIFIED_PRELOAD
                            @EVENTID,
                            @EVENTNAME output,
                            @MAINEVENTID output,
                            @MAINEVENTNAME output,
                            @PACKAGESPRICES output,
                            @MULTICOMPONENTEVENTSWITHPRICES output,
                            @MULTICOMPONENTEVENTPRICEBENEFITS output,
                            @MULTICOMPONENTEVENTPREFERENCEGROUPS output,
                            @MULTICOMPONENTEVENTAPPEALS output,
                            @CONSTITUENTRECORDTYPEID output,
                            @MULTICOMPONENTEVENTSCHEDULES output,
                            @CURRENTAPPUSERID,
                            @SINGLEEVENTLIST output,
                            @EVENTCURRENCY output;


                        return 0;