USP_BBNC_COMMITDONORINFORMATIONBIOADD_1_1

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@BBNCMAPID	int	INOUT
@TITLECODEID	uniqueidentifier	IN
@FIRSTNAME	nvarchar(50)	IN
@KEYNAME	nvarchar(100)	IN
@CONSTITUENCYCODEID	uniqueidentifier	IN
@XMLITEMS	xml	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN
@MIDDLENAME	nvarchar(50)	IN
@ISORGANIZATION	bit	IN

Definition

Copy



            CREATE procedure dbo.USP_BBNC_COMMITDONORINFORMATIONBIOADD_1_1
            (
                @ID uniqueidentifier = null output,
                @BBNCMAPID int = null output,
                @TITLECODEID uniqueidentifier = null,
                @FIRSTNAME nvarchar(50) = '',
                @KEYNAME nvarchar(100),
                @CONSTITUENCYCODEID uniqueidentifier = null,
                @XMLITEMS xml = null,
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null,
                @MIDDLENAME nvarchar(50) = '',
                @ISORGANIZATION bit=0
            )
            as
                set nocount on;

                declare @SUFFIXCODEID uniqueidentifier = null;

                exec dbo.USP_BBNC_COMMITDONORINFORMATIONBIOADD_1_2
                @ID output,
                @BBNCMAPID  output,
                @TITLECODEID,
                @FIRSTNAME,
                @KEYNAME ,
                @CONSTITUENCYCODEID ,
                @XMLITEMS,
                @CHANGEAGENTID ,
                @CHANGEDATE ,
                @MIDDLENAME ,
                @ISORGANIZATION,
                @SUFFIXCODEID

                return 0;