USP_DATAFORMTEMPLATE_EDITSAVE_WPBUSINESSOWNERSHIP_2

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	Job title
@LINE1	nvarchar(150)	IN	Company address
@CITY	nvarchar(30)	IN	Company city
@STATE	nvarchar(100)	IN	Company state
@ZIP	nvarchar(10)	IN	Company 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
@MAILINGLINE1	nvarchar(150)	IN	Mailing address
@MAILINGCITY	nvarchar(30)	IN	Mailing city
@MAILINGSTATE	nvarchar(100)	IN	Mailing state
@MAILINGZIP	nvarchar(10)	IN	Mailing ZIP
@HOMELINE1	nvarchar(150)	IN	Home address
@HOMECITY	nvarchar(30)	IN	Home city
@HOMESTATE	nvarchar(100)	IN	Home state
@HOMEZIP	nvarchar(10)	IN	Home ZIP
@SICNAME	nvarchar(100)	IN	Trade name
@YEAROFBIRTH	UDT_YEAR	IN	Year of birth
@GENDERCODE	tinyint	IN	Gender
@RATIO	decimal(20, 4)	IN	Ratio
@WPBUSINESSOWNERSHIPBIOS	xml	IN
@WPBUSINESSOWNERSHIPOWNERSHIP	xml	IN

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITSAVE_WPBUSINESSOWNERSHIP_2 (
                @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,
                @MAILINGLINE1 nvarchar(150),
                @MAILINGCITY nvarchar(30),
                @MAILINGSTATE nvarchar(100),
                @MAILINGZIP nvarchar(10),
                @HOMELINE1 nvarchar(150),
                @HOMECITY nvarchar(30),
                @HOMESTATE nvarchar(100),
                @HOMEZIP nvarchar(10),
                @SICNAME nvarchar(100),
                @YEAROFBIRTH dbo.UDT_YEAR,
                @GENDERCODE tinyint,
                @RATIO decimal(20,4),
                @WPBUSINESSOWNERSHIPBIOS xml,
                @WPBUSINESSOWNERSHIPOWNERSHIP xml
            ) as begin
            set nocount on;

                declare @SIC_CODE1 nvarchar(4),
                    @SIC_CODE2 nvarchar(4),
                    @SIC_CODE3 nvarchar(4),
                    @SIC_CODE4 nvarchar(4),
                    @SIC_CODE5 nvarchar(4),
                    @SIC_CODE6 nvarchar(4),
                    @RATIO1 decimal(20,4),
                    @RATIO2 decimal(20,4),
                    @RATIO3 decimal(20,4),
                    @RATIO4 decimal(20,4),
                    @RATIO5 decimal(20,4),
                    @RATIO6 decimal(20,4)

                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_WPBUSINESSOWNERSHIP
                    @ID = @ID,
                    @SIC_CODE1 = @SIC_CODE1,
                    @SIC_CODE2 = @SIC_CODE2,
                    @SIC_CODE3 = @SIC_CODE3,
                    @SIC_CODE4 = @SIC_CODE4,
                    @SIC_CODE5 = @SIC_CODE5,
                    @SIC_CODE6 = @SIC_CODE6,
                    @RATIO1 = @RATIO1,
                    @RATIO2 = @RATIO2,
                    @RATIO3 = @RATIO3,
                    @RATIO4 = @RATIO4,
                    @RATIO5 = @RATIO5,
                    @RATIO6 = @RATIO6;

                exec dbo.USP_DATAFORMTEMPLATE_EDITSAVE_WPBUSINESSOWNERSHIP_3 @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, @SIC_CODE1, @SIC_CODE2,
                    @SIC_CODE3, @SIC_CODE4, @SIC_CODE5, @SIC_CODE6, @RATIO1, @RATIO2, @RATIO3, @RATIO4, @RATIO5, @RATIO6

                return 0;                        
            end;