USP_DATAFORMTEMPLATE_EDIT_WEALTHCAPACITY_2

The save procedure used by the edit dataform template "Wealth Capacity Edit Form 2".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@WEALTHCAPACITYFORMULAID	uniqueidentifier	IN	Wealth capacity formula
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@ESTIMATEDWEALTHID	uniqueidentifier	IN	Estimated wealth
@ESTIMATEDWEALTHVALUE	money	IN	Estimated wealth value
@OVERALLRATINGCODEID	uniqueidentifier	IN	Overall rating
@MAJORGIVINGCAPACITYID	uniqueidentifier	IN	Major giving capacity
@MAJORGIVINGCAPACITYVALUE	money	IN	Major giving capacity value
@SYSTEMCALCULATED	bit	IN	System calculated

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_WEALTHCAPACITY_2 (
                @ID uniqueidentifier,
                @WEALTHCAPACITYFORMULAID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @ESTIMATEDWEALTHID uniqueidentifier,
                @ESTIMATEDWEALTHVALUE money,
                @OVERALLRATINGCODEID uniqueidentifier,
                @MAJORGIVINGCAPACITYID uniqueidentifier,
                @MAJORGIVINGCAPACITYVALUE money,
                @SYSTEMCALCULATED bit
            ) as
            begin
                declare @MAJORGIVINGCAPACITYBASISVALUE nvarchar(250)

                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_WEALTHCAPACITY_3
                    @ID = @ID,
                    @MAJORGIVINGCAPACITYBASISVALUE = @MAJORGIVINGCAPACITYBASISVALUE output;

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_WEALTHCAPACITY_3
                    @ID,
                    @WEALTHCAPACITYFORMULAID,
                    @CHANGEAGENTID,
                    @ESTIMATEDWEALTHID,
                    @ESTIMATEDWEALTHVALUE,
                    @OVERALLRATINGCODEID,
                    @MAJORGIVINGCAPACITYID,
                    @MAJORGIVINGCAPACITYVALUE,
                    @SYSTEMCALCULATED,
                    @MAJORGIVINGCAPACITYBASISVALUE
            end