USP_DATAFORMTEMPLATE_EDIT_REGISTRANTUNIFIED

USP_DATAFORMTEMPLATE_EDIT_REGISTRANTUNIFIED

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN The input ID parameter indicating the ID of the record being edited.
@CURRENTAPPUSERID uniqueidentifier IN Input parameter indicating the ID of the current user.
@CHANGEAGENTID uniqueidentifier IN Input parameter indicating the ID of the change agent invoking the procedure.
@DATEPURCHASED datetime IN Date
@PACKAGEREGISTRATIONS xml IN Packages
@PACKAGESPRICES xml IN
@SINGLEEVENTREGISTRATIONS xml IN Single events
@WAIVEBENEFITS bit IN Waive benefits
@REGISTRANTMAPPINGS xml IN Guests
@DELETEDREGISTRANTREGISTRATIONMAPS xml IN Deleted registrant registration mappings

Definition

Copy


CREATE procedure USP_DATAFORMTEMPLATE_EDIT_REGISTRANTUNIFIED
(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @DATEPURCHASED datetime,
    @PACKAGEREGISTRATIONS xml,
    @PACKAGESPRICES xml,
    @SINGLEEVENTREGISTRATIONS xml,
    @WAIVEBENEFITS bit,
    @REGISTRANTMAPPINGS xml,
    @DELETEDREGISTRANTREGISTRATIONMAPS xml
)

as
  set nocount on;

    declare @REGISTRATIONTYPECODE tinyint;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REGISTRANTUNIFIED
        @ID = @ID,
        @CURRENTAPPUSERID = @CURRENTAPPUSERID,
        @REGISTRATIONTYPECODE = @REGISTRATIONTYPECODE output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_REGISTRANTUNIFIED_2
        @ID,
        @CURRENTAPPUSERID,
        @CHANGEAGENTID,
        @DATEPURCHASED,
        @PACKAGEREGISTRATIONS,
        @PACKAGESPRICES,
        @SINGLEEVENTREGISTRATIONS,
        @WAIVEBENEFITS,
        @REGISTRANTMAPPINGS,
        @DELETEDREGISTRANTREGISTRATIONMAPS,
        @REGISTRATIONTYPECODE

  return 0;