USP_DATAFORMTEMPLATE_VIEW_APPLICATIONDONATION

The load procedure used by the view dataform template "Payment: Application Donation View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@SPLITID	uniqueidentifier	INOUT	ID
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@APPLICATIONID	uniqueidentifier	INOUT	APPLICATIONID
@APPLICATIONCODE	tinyint	INOUT	Application
@DESCRIPTION	nvarchar(100)	INOUT	Description
@APPLIED	money	INOUT	Applied
@AMOUNTDUE	money	INOUT	Amount Due
@DATEDUE	datetime	INOUT	Date Due
@BALANCE	money	INOUT	Balance
@GIFTFIELDS	xml	INOUT	GIFTFIELDS
@OPPORTUNITYID	uniqueidentifier	INOUT	Opportunity
@APPEALID	uniqueidentifier	INOUT	Appeal
@DESIGNATIONID	uniqueidentifier	INOUT	Designation
@CATEGORYCODEID	uniqueidentifier	INOUT	Category
@DECLINESGIFTAID	bit	INOUT	Constituent declines Gift Aid for this application
@ISGIFTAIDSPONSORSHIP	bit	INOUT	Gift Aid sponsorship

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_APPLICATIONDONATION
                (
                    @ID uniqueidentifier,
                    @SPLITID uniqueidentifier = null output,
                    @DATALOADED bit = 0 output,
                    @APPLICATIONID uniqueidentifier = null output,    
                    @APPLICATIONCODE tinyint = null output,
                    @DESCRIPTION nvarchar(100) = null output,
                    @APPLIED money = null output,
                    @AMOUNTDUE money = null output,
                    @DATEDUE datetime = null output,
                    @BALANCE money = null output,
                    @GIFTFIELDS xml = null output,
                    @OPPORTUNITYID uniqueidentifier = null output,
                    @APPEALID uniqueidentifier = null output,
                    @DESIGNATIONID uniqueidentifier = null output,
                    @CATEGORYCODEID uniqueidentifier = null output,
                    @DECLINESGIFTAID bit = null output,
          @ISGIFTAIDSPONSORSHIP bit = null output
                )
                as
                set nocount on;

                declare @REVENUEID uniqueidentifier;

                set @DATALOADED = 0;

                select @REVENUEID = REVENUEID 
                from dbo.REVENUESPLIT where ID = @ID;

                select
                    @DATALOADED = 1,
                    @SPLITID = ID,
                    @APPLICATIONID = APPLICATIONID,
                    @APPLICATIONCODE = APPLICATIONCODE,
                    @DESCRIPTION = DESCRIPTION,
                    @APPLIED = APPLIED,
                    @AMOUNTDUE = AMOUNTDUE,
                    @DATEDUE = DATEDUE,
                    @BALANCE = BALANCE,
                    @GIFTFIELDS = GIFTFIELDS
                from dbo.UFN_REVENUE_GETAPPLICATIONS(@REVENUEID)
                where @ID = @ID;

                return 0;