USP_DATAFORMTEMPLATE_VIEW_RECOGNITIONPROGRAMREVENUE

The load procedure used by the view dataform template "Recognition Program Revenue Criteria 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.
@TYPESTOINCLUDE	nvarchar(300)	INOUT	Revenue types to include
@STARTDATE	datetime	INOUT	Recognition effective date
@MAXIMUMAMOUNT	money	INOUT	Maximum recognition amount
@REVENUESELECTION	nvarchar(100)	INOUT	Additional revenue selection
@PLANNEDGIFT	nvarchar(100)	INOUT	Planned giving
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency
@RECOGNITIONCREDITTYPELIST	nvarchar(2000)	INOUT	Include recognition credit types of
@INCLUDECREDITWITHOUTTYPE	tinyint	INOUT	Include recognition credits without specified type
@ALLCREDITTYPESSELECTED	tinyint	INOUT	All credit types
@USEGROSSAMOUNT	bit	INOUT

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_RECOGNITIONPROGRAMREVENUE
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @TYPESTOINCLUDE nvarchar(300) = null output,
                @STARTDATE datetime = null output,
                @MAXIMUMAMOUNT money = null output,
                @REVENUESELECTION nvarchar(100) = null output,
                @PLANNEDGIFT nvarchar(100) = null output,
                @BASECURRENCYID uniqueidentifier = null output,
                @RECOGNITIONCREDITTYPELIST nvarchar(2000) = null output,
                @INCLUDECREDITWITHOUTTYPE tinyint = null output,
                @ALLCREDITTYPESSELECTED tinyint = null output,
                @USEGROSSAMOUNT bit = null output 
            )
            as
                set nocount on;

                set @DATALOADED = 0;

                select @DATALOADED = 1,
                       @STARTDATE = STARTDATE,
                       @MAXIMUMAMOUNT = MAXIMUMAMOUNT,
                       @REVENUESELECTION = dbo.UFN_IDSET_GETNAME(SELECTIONID),
                       @PLANNEDGIFT = PLANNEDGIFT,
                       @BASECURRENCYID = BASECURRENCYID,
                       @INCLUDECREDITWITHOUTTYPE = INCLUDECREDITWITHOUTTYPE,
                       @USEGROSSAMOUNT = USEGROSSAMOUNT
                from dbo.RECOGNITIONPROGRAM
                where ID = @ID;

                select @TYPESTOINCLUDE = dbo.UFN_RECOGNITIONPROGRAM_GETGIFTTYPES_LIST(@ID);    

                set @RECOGNITIONCREDITTYPELIST = (select stuff((select '; ' + DESCRIPTION
                                                    from dbo.UFN_RECOGNITIONPROGRAM_GETCREDITTYPES(@ID)    
                                                    order by SEQUENCE
                                       for xml path(''), type).value('.', 'nvarchar(max)'), 1, 2, ''))

                set @ALLCREDITTYPESSELECTED = case 
                                            when exists (select 1 from dbo.REVENUERECOGNITIONTYPECODE
                                                left join dbo.UFN_RECOGNITIONPROGRAM_GETCREDITTYPES(@ID) CT on REVENUERECOGNITIONTYPECODE.ID = CT.REVENUERECOGNITIONTYPECODEID
                                                where CT.ID is null) 
                                            then 0
                                            else 1 
                                        end;

                return 0;