USP_DATAFORMTEMPLATE_EDIT_BATCHEVENTREGISTRANTBATCHROW_3

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@SEQUENCE	int	IN
@EVENTID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN
@DATEPURCHASED	datetime	IN
@EVENTPRICEID	uniqueidentifier	IN
@REGISTRANTSTATUSCODE	tinyint	IN
@WAIVEBENEFITS	bit	IN
@QUANTITY	int	IN
@GUESTS	xml	IN
@REGISTRANTLOOKUPID	nvarchar(100)	IN
@DESIGNATIONID	uniqueidentifier	IN
@REGISTRATIONTYPECODE	tinyint	IN
@REGISTRATIONSTATUSCODE	tinyint	IN
@REGISTRATIONATTENDEDCODE	tinyint	IN
@EVENT_IMPORTLOOKUPID	nvarchar(100)	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHEVENTREGISTRANTBATCHROW_3
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier,
  @SEQUENCE int,
  @EVENTID uniqueidentifier,
  @CONSTITUENTID uniqueidentifier,
  @DATEPURCHASED datetime,
  @EVENTPRICEID uniqueidentifier,
  @REGISTRANTSTATUSCODE tinyint,
  @WAIVEBENEFITS bit,
  @QUANTITY int,
  @GUESTS xml,
  @REGISTRANTLOOKUPID nvarchar(100),
  @DESIGNATIONID uniqueidentifier,
  @REGISTRATIONTYPECODE tinyint,
  @REGISTRATIONSTATUSCODE tinyint ,
  @REGISTRATIONATTENDEDCODE tinyint,
  @EVENT_IMPORTLOOKUPID nvarchar(100)
)
as
begin
  set nocount on;

  declare @OPPORTUNITYID uniqueidentifier;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCHEVENTREGISTRANTBATCHROW
    @ID = @ID,
    @OPPORTUNITYID = @OPPORTUNITYID output;

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHEVENTREGISTRANTBATCHROW_4
    @ID,
    @CHANGEAGENTID,
    @SEQUENCE,
    @EVENTID,
    @CONSTITUENTID,
    @DATEPURCHASED,
    @EVENTPRICEID,
    @REGISTRANTSTATUSCODE,
    @WAIVEBENEFITS,
    @QUANTITY,
    @GUESTS,
    @REGISTRANTLOOKUPID,
    @DESIGNATIONID,
    @REGISTRATIONTYPECODE,
    @REGISTRATIONSTATUSCODE,
    @REGISTRATIONATTENDEDCODE,
    @EVENT_IMPORTLOOKUPID,
    @OPPORTUNITYID;

  return 0;
end