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;