USP_DATAFORMTEMPLATE_PRELOAD_ADD_MGPLEDGEPAYMENT

Stored procedure used to load on the matching gift pledge payment add form.

Parameters

Parameter	Parameter Type	Mode
@APPLICATIONID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	INOUT
@HOUSEHOLDSCANBEDONORS	bit	INOUT
@VIEWFORMID	uniqueidentifier	INOUT
@DATE	datetime	INOUT
@GIFTINKINDUSEAPPRAISALTHRESHOLD	bit	INOUT
@GIFTINKINDAPPRAISALTHRESHOLD	money	INOUT
@CURRENTAPPUSERID	uniqueidentifier	IN
@PDACCOUNTSYSTEMID	uniqueidentifier	INOUT
@SHOWACCOUNTSYSTEM	bit	INOUT
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT
@BASEEXCHANGERATEID	uniqueidentifier	INOUT
@EXCHANGERATE	decimal(20, 8)	INOUT
@APPEALID	uniqueidentifier	INOUT

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_MGPLEDGEPAYMENT
            (
                @APPLICATIONID uniqueidentifier,
                @CONSTITUENTID uniqueidentifier = null output,
                @HOUSEHOLDSCANBEDONORS bit = null output,
                @VIEWFORMID uniqueidentifier = null output,
                @DATE datetime = null output,
                @GIFTINKINDUSEAPPRAISALTHRESHOLD bit = null output,
                @GIFTINKINDAPPRAISALTHRESHOLD money = null output,
                @CURRENTAPPUSERID uniqueidentifier = null,
                @PDACCOUNTSYSTEMID uniqueidentifier = null output,
                @SHOWACCOUNTSYSTEM bit = null output,
                @TRANSACTIONCURRENCYID uniqueidentifier = null output,
                @BASEEXCHANGERATEID uniqueidentifier = null output,
                @EXCHANGERATE decimal(20,8) = null output,
                @APPEALID uniqueidentifier = null output
            )
            as
                set nocount on;

                set @HOUSEHOLDSCANBEDONORS = dbo.UFN_INSTALLATIONINFO_GETHOUSEHOLDSCANBEDONORS();
                set @VIEWFORMID = '2B4A336A-8774-4126-ABCF-5FAD92DFB15A';
                set @DATE = dbo.UFN_DATE_GETEARLIESTTIME(getdate());

                select 
                    @CONSTITUENTID = REVENUE.CONSTITUENTID,
                    @APPEALID = REVENUE.APPEALID
                from dbo.REVENUE
                where REVENUE.ID = @APPLICATIONID;

                select top 1
                    @GIFTINKINDUSEAPPRAISALTHRESHOLD = USEAPPRAISALTHRESHOLD,
                    @GIFTINKINDAPPRAISALTHRESHOLD = APPRAISALTHRESHOLD
                from
                    dbo.GIFTINKINDAPPRAISALSETTINGS;

                exec dbo.USP_PAYMENT_APPLICATIONPAYMENTLOADCURRENCY
                    @APPLICATIONID,
                    @DATE,
                    @CURRENTAPPUSERID,
                    @PDACCOUNTSYSTEMID output,
                    @SHOWACCOUNTSYSTEM output,
                    @TRANSACTIONCURRENCYID output,
                    @BASEEXCHANGERATEID output,
                    @EXCHANGERATE output;

                return 0;