USP_DATAFORMTEMPLATE_EDITSAVE_WPPHILANTHROPICGIFT

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
@ORGANIZATION	nvarchar(200)	IN	Organization
@LOCATION	nvarchar(100)	IN	Location
@GIFTYEAR	UDT_YEAR	IN	Gift year
@TYPE	nvarchar(75)	IN	Gift type
@CATEGORY	nvarchar(500)	IN	Category
@LO	money	IN	Amount range
@HI	money	IN	High amount
@NAME	nvarchar(200)	IN	Name
@ORGANIZATIONWEBADDRESS	nvarchar(2000)	IN	Web address
@SOURCEMATERIAL	nvarchar(2000)	IN	Source material
@GIFTYEARHI	UDT_YEAR	IN	End year
@GIFTYEARLO	UDT_YEAR	IN	Start year
@EIN	nvarchar(50)	IN	EIN

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITSAVE_WPPHILANTHROPICGIFT(
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @SOURCE nvarchar(100),
                @CNOTES nvarchar(1024),
                @ORGANIZATION nvarchar(200),
                @LOCATION nvarchar(100),
                @GIFTYEAR dbo.UDT_YEAR,
                @TYPE nvarchar(75),
                @CATEGORY nvarchar(500),
                @LO money,
                @HI money,
                @NAME nvarchar(200),
                @ORGANIZATIONWEBADDRESS nvarchar(2000),
                @SOURCEMATERIAL nvarchar(2000),
                @GIFTYEARHI dbo.UDT_YEAR,
                @GIFTYEARLO dbo.UDT_YEAR,
                @EIN nvarchar(50)
            ) as begin

                declare @MATCHADDRESS nvarchar(100) = null,
                        @MATCHCITY nvarchar(20) = null,
                        @MATCHSTATE nvarchar(2) = null,
                        @MATCHZIP nvarchar(5) = null    

                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_WPPHILANTHROPICGIFT @MATCHADDRESS = @MATCHADDRESS output,
                        @MATCHCITY = @MATCHCITY output, @MATCHSTATE = @MATCHSTATE output, @MATCHZIP = @MATCHZIP output

                exec dbo.USP_DATAFORMTEMPLATE_EDITSAVE_WPPHILANTHROPICGIFT_2
                    @ID,
                    @CHANGEAGENTID,
                    @SOURCE,
                    @CNOTES,
                    @ORGANIZATION,
                    @LOCATION,
                    @GIFTYEAR,
                    @TYPE,
                    @CATEGORY,
                    @LO,
                    @HI,
                    @NAME,
                    @ORGANIZATIONWEBADDRESS,
                    @SOURCEMATERIAL,
                    @GIFTYEARHI,
                    @GIFTYEARLO,
                    @EIN,
                    @MATCHADDRESS,
                    @MATCHCITY,
                    @MATCHSTATE,
                    @MATCHZIP

            end