USP_DATAFORMTEMPLATE_PRELOAD_ADD_PLEDGEPAYMENT

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

Parameters

Parameter	Parameter Type	Mode
@APPLICATIONID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	INOUT
@HOUSEHOLDSCANBEDONORS	bit	INOUT
@VIEWFORMID	uniqueidentifier	INOUT
@DATE	datetime	INOUT
@FINDERNUMBER	bigint	INOUT
@SOURCECODE	nvarchar(50)	INOUT
@APPEALID	uniqueidentifier	INOUT
@CHANNELCODEID	uniqueidentifier	INOUT
@MAILINGID	uniqueidentifier	INOUT
@PACKAGE	nvarchar(100)	INOUT
@SEGMENT	nvarchar(100)	INOUT
@GIFTINKINDUSEAPPRAISALTHRESHOLD	bit	INOUT
@GIFTINKINDAPPRAISALTHRESHOLD	money	INOUT
@GIVENANONYMOUSLY	bit	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_PLEDGEPAYMENT
            (
                @APPLICATIONID uniqueidentifier,
                @CONSTITUENTID uniqueidentifier = null output,
                @HOUSEHOLDSCANBEDONORS bit = null output,
                @VIEWFORMID uniqueidentifier = null output,
                @DATE datetime = null output,
                @FINDERNUMBER bigint = null output,
                @SOURCECODE nvarchar(50) = null output,
                @APPEALID uniqueidentifier = null output,
                @CHANNELCODEID uniqueidentifier = null output,
                @MAILINGID uniqueidentifier = null output,
                @PACKAGE nvarchar(100) = null output,
                @SEGMENT nvarchar(100) = null output,
                @GIFTINKINDUSEAPPRAISALTHRESHOLD bit = null output,
                @GIFTINKINDAPPRAISALTHRESHOLD money = null output,
                @GIVENANONYMOUSLY bit = 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 = '6C4958A9-7A6C-4C23-A1BB-8EA0CFA267B4';
                set @DATE = dbo.UFN_DATE_GETEARLIESTTIME(getdate());

                declare @PLEDGEACCOUNTSYSTEMID uniqueidentifier;
                declare @PLEDGETRANSACTIONCURRENCYID uniqueidentifier;
                declare @PLEDGEBASECURRENCYID uniqueidentifier;

                select
                    @CONSTITUENTID = REVENUE.CONSTITUENTID,
                    @FINDERNUMBER = REVENUE.FINDERNUMBER,
                    @SOURCECODE = REVENUE.SOURCECODE,
                    @MAILINGID = REVENUE.MAILINGID,
                    @CHANNELCODEID = REVENUE.CHANNELCODEID,
                    @GIVENANONYMOUSLY = REVENUE.GIVENANONYMOUSLY,
                    @APPEALID = REVENUE.APPEALID
                from 
                    dbo.REVENUE
                where 
                    REVENUE.ID = @APPLICATIONID;

                if @FINDERNUMBER <> 0
                    select
                        @PACKAGE = dbo.UFN_MKTPACKAGE_GETNAME(MKTSEGMENTATIONSEGMENT.PACKAGEID),
                        @SEGMENT = dbo.UFN_MKTSEGMENT_GETNAME(MKTSEGMENTATIONSEGMENT.SEGMENTID)
                    from dbo.CONSTITUENTAPPEAL
                    inner join dbo.CONSTITUENT on CONSTITUENT.ID = CONSTITUENTAPPEAL.CONSTITUENTID
                    left outer join dbo.MKTSEGMENTATIONSEGMENT on MKTSEGMENTATIONSEGMENT.ID = CONSTITUENTAPPEAL.MKTSEGMENTATIONSEGMENTID
                    where  
                        CONSTITUENTAPPEAL.FINDERNUMBER = @FINDERNUMBER;

                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;