USP_DATAFORMTEMPLATE_EDITSAVE_WPBUSINESSOWNERSHIP

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SOURCE	nvarchar(100)	IN	Source
@CNOTES	nvarchar(1024)	IN	Notes
@FULLNAME	nvarchar(100)	IN	Name
@TITLE	nvarchar(100)	IN	Title
@LINE1	nvarchar(150)	IN	Address
@CITY	nvarchar(30)	IN	City
@STATE	nvarchar(100)	IN	State
@ZIP	nvarchar(10)	IN	ZIP
@BIO	nvarchar(1500)	IN	Biography
@HELDCODE	tinyint	IN	Held
@COMPANY	nvarchar(100)	IN	Company
@PHONE	nvarchar(20)	IN	Phone
@LINE_OF_BUSINESS_DESCRIPTION	nvarchar(50)	IN	Description
@SALES_VOLUME	money	IN	Sales
@YEAR_STARTED	UDT_YEAR	IN	Year started
@EMPLOYEES_TOTAL	int	IN	# of employees
@SIC_CODE	nvarchar(4)	IN	SIC code
@DUNS	nvarchar(10)	IN	DUNS
@PERCENTAGE	decimal(20, 4)	IN	% ownership
@VALUATION	money	IN	Valuation

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITSAVE_WPBUSINESSOWNERSHIP (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @SOURCE nvarchar(100),
                @CNOTES nvarchar(1024),
                @FULLNAME nvarchar(100),
                @TITLE nvarchar(100),
                @LINE1 nvarchar(150),
                @CITY nvarchar(30),
                @STATE nvarchar(100),
                @ZIP nvarchar(10),
                @BIO nvarchar(1500),
                @HELDCODE tinyint,
                @COMPANY nvarchar(100),
                @PHONE nvarchar(20),
                @LINE_OF_BUSINESS_DESCRIPTION nvarchar(50),
                @SALES_VOLUME money,
                @YEAR_STARTED dbo.UDT_YEAR,
                @EMPLOYEES_TOTAL int,
                @SIC_CODE nvarchar(4),
                @DUNS nvarchar(10),
                @PERCENTAGE decimal(20,4),
                @VALUATION money
            ) as begin
                set nocount on;

                declare @MAILINGLINE1 nvarchar(150);
                declare @MAILINGCITY nvarchar(30);
                declare @MAILINGSTATE nvarchar(100);
                declare @MAILINGZIP nvarchar(10);
                declare @HOMELINE1 nvarchar(150);
                declare @HOMECITY nvarchar(30);
                declare @HOMESTATE nvarchar(100);
                declare @HOMEZIP nvarchar(10);
                declare @SICNAME nvarchar(100);
                declare @YEAROFBIRTH dbo.UDT_YEAR;
                declare @GENDERCODE tinyint;
                declare @RATIO decimal(20,4);
                declare @WPBUSINESSOWNERSHIPBIOS xml;
                declare @WPBUSINESSOWNERSHIPOWNERSHIP xml;

                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_WPBUSINESSOWNERSHIP
                    @ID = @ID,
                    @MAILINGLINE1 = @MAILINGLINE1,
                    @MAILINGCITY = @MAILINGCITY,
                    @MAILINGSTATE = @MAILINGSTATE,
                    @MAILINGZIP = @MAILINGZIP,
                    @HOMELINE1 = @HOMELINE1,
                    @HOMECITY = @HOMECITY,
                    @HOMESTATE = @HOMESTATE,
                    @HOMEZIP = @HOMEZIP,
                    @SICNAME = @SICNAME,
                    @YEAROFBIRTH = @YEAROFBIRTH,
                    @GENDERCODE = @GENDERCODE,
                    @RATIO = @RATIO,
                    @WPBUSINESSOWNERSHIPBIOS = @WPBUSINESSOWNERSHIPBIOS,
                    @WPBUSINESSOWNERSHIPOWNERSHIP = @WPBUSINESSOWNERSHIPOWNERSHIP;

                exec dbo.USP_DATAFORMTEMPLATE_EDITSAVE_WPBUSINESSOWNERSHIP_2 @ID, @CHANGEAGENTID, @SOURCE, @CNOTES,
                    @FULLNAME, @TITLE, @LINE1, @CITY, @STATE, @ZIP, @BIO, @HELDCODE, @COMPANY, @PHONE, @LINE_OF_BUSINESS_DESCRIPTION,
                    @SALES_VOLUME, @YEAR_STARTED, @EMPLOYEES_TOTAL,    @SIC_CODE, @DUNS, @PERCENTAGE, @VALUATION, @MAILINGLINE1,
                    @MAILINGCITY, @MAILINGSTATE, @MAILINGZIP, @HOMELINE1, @HOMECITY, @HOMESTATE, @HOMEZIP, @SICNAME,
                    @YEAROFBIRTH, @GENDERCODE, @RATIO, @WPBUSINESSOWNERSHIPBIOS, @WPBUSINESSOWNERSHIPOWNERSHIP

                return 0;                        
            end;