USP_DATAFORMTEMPLATE_VIEW_REVENUE

The load procedure used by the view dataform template "Revenue Detail View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@RECEIPTAMOUNT	money	INOUT	Receipt amount
@APPEAL	nvarchar(100)	INOUT	Appeal
@ACKNOWLEDGESTATUS	nvarchar(20)	INOUT	Acknowledge status
@SOURCEDATE	datetime	INOUT	Source date
@SOURCEID	uniqueidentifier	INOUT	Source ID
@TYPECODE	nvarchar(22)	INOUT	Type code

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_REVENUE
                (
                    @ID uniqueidentifier,    
                    @DATALOADED bit = 0 output,
                    @RECEIPTAMOUNT money = null output,
                    @APPEAL nvarchar(100) = null output,
                    @ACKNOWLEDGESTATUS nvarchar(20) = null output,
                    @SOURCEDATE datetime = null output,
                    @SOURCEID uniqueidentifier = null output,
                    @TYPECODE nvarchar(22) = null output
                )
                as
                set nocount on;

                set @DATALOADED = 0;
/* TODO REVISIT                
                select
                    @DATALOADED = 1,
                    @RECEIPTAMOUNT = REVENUE.RECEIPTAMOUNT,
                    @APPEAL = dbo.UFN_APPEAL_GETNAME(APPEALID),
                    @ACKNOWLEDGESTATUS = dbo.UFN_REVENUE_GETACKNOWLEDGESTATUS(REVENUE.ID),
                    @TYPECODE = REVENUE.TYPECODE
                from dbo.REVENUE                
                where REVENUE.ID = @ID;

                if @TYPECODE = 4 or @TYPECODE = 8 --Pledge payment or MG Pledge payment
                    select 
                        @SOURCEDATE = REVENUE.DATE,
                        @SOURCEID = REVENUE.ID
                    from dbo.REVENUE                    
                    inner join dbo.INSTALLMENTPAYMENT on INSTALLMENTPAYMENT.PLEDGEID = REVENUE.ID
                    where INSTALLMENTPAYMENT.PAYMENTID = @ID;

                if @TYPECODE = 5
                    select
                        @SOURCEDATE = REVENUE.DATE,
                        @SOURCEID = REVENUE.ID
                    from dbo.REVENUE                     
                    inner join dbo.RECURRINGGIFTACTIVITY on RECURRINGGIFTACTIVITY.SOURCEREVENUEID = REVENUE.ID
                    where RECURRINGGIFTACTIVITY.PAYMENTREVENUEID = @ID; 
*/                    
                return 0;