USP_DATAFORMTEMPLATE_EDITLOAD_PREREGISTEREDPROGRAMEVENTREGISTRANT_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@CONSTITUENTID	uniqueidentifier	INOUT
@EVENTID	uniqueidentifier	INOUT
@REGISTRANTREGISTRATIONINFORMATION	xml	INOUT
@NOTES	nvarchar(255)	INOUT
@REGISTRANTNAME	nvarchar(255)	INOUT

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PREREGISTEREDPROGRAMEVENTREGISTRANT_2
                    (
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @TSLONG bigint = 0 output,
                        @CONSTITUENTID uniqueidentifier = null output,
                        @EVENTID uniqueidentifier = null output,
                        @REGISTRANTREGISTRATIONINFORMATION xml = null output,
                        @NOTES nvarchar(255) = null output,
                        @REGISTRANTNAME nvarchar(255) = null output
                    )
                    as
                    begin
                        set nocount on;

                        set @DATALOADED = 0;
                        set @TSLONG = 0;

                        select
                            @EVENTID = EVENTID,
                            @CONSTITUENTID = CONSTITUENTID,
                            @NOTES = NOTES,
                            @DATALOADED = 1,
                            @REGISTRANTNAME = dbo.UFN_CONSTITUENT_BUILDNAME(REGISTRANT.CONSTITUENTID),
                            @REGISTRANTREGISTRATIONINFORMATION = dbo.UFN_REGISTRANT_GETREGISTRATIONINFORMATION_TOITEMLISTXML(@ID)
                        from dbo.REGISTRANT
                        where REGISTRANT.ID = @ID;

                        return 0;
                    end