USP_DATAFORMTEMPLATE_PRELOAD_ADD_PENDINGGIFTPAYMENT

Stored procedure used to load on the pending gift 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

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_PENDINGGIFTPAYMENT
(
        @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
)
as
                set nocount on;

                set @HOUSEHOLDSCANBEDONORS = dbo.UFN_INSTALLATIONINFO_GETHOUSEHOLDSCANBEDONORS();
                set @VIEWFORMID = 'a6ac328e-d279-4f12-9429-8d2ccbe9afd3';
                set @DATE = dbo.UFN_DATE_GETEARLIESTTIME(getdate());

                select @CONSTITUENTID = REVENUE.CONSTITUENTID 
                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;