USP_DATAFORMTEMPLATE_PRELOAD_ADD_PLEDGEWRITEOFF

The load procedure used by the edit dataform template "Pledge Write-off Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CONSTITUENTNAME	nvarchar(255)	INOUT
@PLEDGEDATE	datetime	INOUT	Pledged on
@PLEDGEBALANCE	money	INOUT	Pledge balance
@INSTALLMENTS	xml	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_PLEDGEWRITEOFF 
                    (
                        @REVENUEID uniqueidentifier,
                        @CONSTITUENTNAME nvarchar(255) = null output,
                        @PLEDGEDATE datetime = null output,
                        @PLEDGEBALANCE money = null output,
                        @INSTALLMENTS xml = null output
                    )

                    as
                    begin
                        set nocount on;

                        select 
                            @CONSTITUENTNAME = CONSTITUENT.NAME,
                            @PLEDGEDATE = REVENUE.DATE,
                            @PLEDGEBALANCE = dbo.UFN_PLEDGE_GETBALANCE(REVENUE.ID),
                            @INSTALLMENTS = dbo.UFN_INSTALLMENT_GETWRITEOFFINSTALLMENTS_TOITEMLISTXML(REVENUE.ID)
                        from 
                            dbo.REVENUE
                        inner join
                            dbo.CONSTITUENT on REVENUE.CONSTITUENTID = CONSTITUENT.ID
                        where
                            REVENUE.ID = @REVENUEID;

                        return 0;

                    end