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;