USP_DATAFORMTEMPLATE_EDITLOAD_PLEDGEWRITEOFF

The load procedure used by the edit dataform template "Pledge Write-off Edit 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.
@CONSTITUENTNAME	nvarchar(255)	INOUT
@PLEDGEDATE	datetime	INOUT	Pledged on
@PLEDGEBALANCE	money	INOUT	Pledge balance
@DATE	datetime	INOUT	Date
@WRITEOFFTOTALAMOUNT	money	INOUT	Amount
@POSTSTATUSCODE	tinyint	INOUT	GL post status
@POSTDATE	datetime	INOUT	GL post date
@REASON	nvarchar(300)	INOUT	Write-off reason
@INSTALLMENTS	xml	INOUT
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PLEDGEWRITEOFF
                    (
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @CONSTITUENTNAME nvarchar(255) = null output,
                        @PLEDGEDATE datetime = null output,
                        @PLEDGEBALANCE money = null output,
                        @DATE datetime = null output,
                        @WRITEOFFTOTALAMOUNT money = null output,
                        @POSTSTATUSCODE tinyint = null output,
                        @POSTDATE datetime = null output,
                        @REASON nvarchar(300) = null output,
                        @INSTALLMENTS xml = null output,
                        @TSLONG bigint = 0 output
                    )
                    as
                    begin

                        set nocount on;

                        set @DATALOADED = 0;
                        set @TSLONG = 0;

                        select
                            @CONSTITUENTNAME = CONSTITUENT.NAME,
                            @PLEDGEDATE = REVENUE.DATE,
                            @PLEDGEBALANCE = dbo.UFN_PLEDGE_GETBALANCE(REVENUE.ID),
                            @DATE = WRITEOFF.DATE,
                            @WRITEOFFTOTALAMOUNT = (select sum(AMOUNT) from dbo.INSTALLMENTWRITEOFF where WRITEOFFID = WRITEOFF.ID),
                            @POSTSTATUSCODE = WRITEOFF.POSTSTATUSCODE,
                            @POSTDATE = WRITEOFF.POSTDATE,
                            @REASON = WRITEOFF.REASON,
                            @INSTALLMENTS = dbo.UFN_WRITEOFF_GETINSTALLMENTSFOREDIT_TOITEMLISTXML(WRITEOFF.ID),
                            @TSLONG = WRITEOFF.TSLONG,
                            @DATALOADED = 1
                        from 
                            dbo.WRITEOFF
                        inner join 
                            dbo.REVENUE on WRITEOFF.REVENUEID = REVENUE.ID
                        inner join
                            dbo.CONSTITUENT on REVENUE.CONSTITUENTID = CONSTITUENT.ID
                        where 
                            WRITEOFF.ID = @ID;

                        return 0;

                    end