USP_WPRELATIONSHIP_BO_ADD

Adds WealthPoint Business Ownership relationship information.
Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@DUNS	nvarchar(9)	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
Definition

Copy


            CREATE procedure dbo.USP_WPRELATIONSHIP_BO_ADD(
                @ID uniqueidentifier = null output,
                @CHANGEAGENTID uniqueidentifier = null,
                @DUNS nvarchar(9) = '',
                @CURRENTAPPUSERID uniqueidentifier = null
            ) as begin
                set nocount on;

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                declare @CURRENTDATE datetime;    
                set @CURRENTDATE = getdate();

                select @ID = ID from dbo.WPRELATIONSHIP_BO where DUNS = coalesce(@DUNS,'');

                begin try
                    if @ID is null begin
                        set @ID = newid();

                        insert into dbo.WPRELATIONSHIP_BO (
                            ID,
                            DUNS,
                            CHANGEDBYID,
                            ADDEDBYID,
                            DATEADDED,
                            DATECHANGED
                        ) values (
                            @ID,
                            coalesce(@DUNS, ''),
                            @CHANGEAGENTID,
                            @CHANGEAGENTID,
                            @CURRENTDATE,
                            @CURRENTDATE
                        );
                    end
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                end catch

                return 0;
            end