USP_DATAFORMTEMPLATE_VIEW_APPLICATIONOTHER

The load procedure used by the view dataform template "Payment: Application Other View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@SPLITID	uniqueidentifier	INOUT	ID
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@APPLICATIONID	uniqueidentifier	INOUT	APPLICATIONID
@APPLICATIONCODE	tinyint	INOUT	Application
@DESCRIPTION	nvarchar(100)	INOUT	Description
@APPLIED	money	INOUT	Applied
@AMOUNTDUE	money	INOUT	Amount Due
@DATEDUE	datetime	INOUT	Date Due
@BALANCE	money	INOUT	Balance
@OTHERFIELDS	xml	INOUT	OTHERFIELDS
@OTHERTYPECODEID	uniqueidentifier	INOUT	Other type
@APPEALID	uniqueidentifier	INOUT	Appeal
@DESIGNATIONID	uniqueidentifier	INOUT	Designation
@CATEGORYCODEID	uniqueidentifier	INOUT	Category

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_APPLICATIONOTHER
                (
                    @ID uniqueidentifier,
                    @SPLITID uniqueidentifier = null output,
                    @DATALOADED bit = 0 output,
                    @APPLICATIONID uniqueidentifier = null output,    
                    @APPLICATIONCODE tinyint = null output,
                    @DESCRIPTION nvarchar(100) = null output,
                    @APPLIED money = null output,
                    @AMOUNTDUE money = null output,
                    @DATEDUE datetime = null output,
                    @BALANCE money = null output,
                    @OTHERFIELDS xml = null output,
                    @OTHERTYPECODEID uniqueidentifier = null output,
                    @APPEALID uniqueidentifier = null output,
                    @DESIGNATIONID uniqueidentifier = null output,
                    @CATEGORYCODEID uniqueidentifier = null output
                )
                as
                set nocount on;

                declare @REVENUEID uniqueidentifier;

                set @DATALOADED = 0;

                select @REVENUEID = REVENUEID 
                from dbo.REVENUESPLIT where ID = @ID;

                select
                    @DATALOADED = 1,
                    @SPLITID = ID,
                    @APPLICATIONID = APPLICATIONID,
                    @APPLICATIONCODE = APPLICATIONCODE,
                    @DESCRIPTION = DESCRIPTION,
                    @APPLIED = APPLIED,
                    @AMOUNTDUE = AMOUNTDUE,
                    @DATEDUE = DATEDUE,
                    @BALANCE = BALANCE,
                    @OTHERFIELDS = OTHERFIELDS
                from dbo.UFN_REVENUE_GETAPPLICATIONS(@REVENUEID)
                where @ID = @ID;

                return 0;