USP_DATAFORMTEMPLATE_VIEW_PLEDGEWRITEOFFPROCESS

The load procedure used by the view dataform template "Pledge Write-off Process View 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.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(255)	INOUT	Description
@IDSETREGISTERNAME	nvarchar(100)	INOUT	Selection
@CREATEOUTPUTIDSET	bit	INOUT	Create output selection
@REASON	nvarchar(300)	INOUT	Details
@POSTSTATUS	nvarchar(11)	INOUT	GL post status
@POSTDATE	datetime	INOUT	GL post date
@OUTPUTIDSETNAME	nvarchar(100)	INOUT	Output selection name
@OVERWRITEOUTPUTIDSET	bit	INOUT	Overwrite existing selection
@BUSINESSPROCESSCATALOGID	uniqueidentifier	INOUT	BUSINESSPROCESSCATALOGID
@PARAMETERSID	uniqueidentifier	INOUT	PARAMETERSID
@REASONCODEANDDESCRIPTION	nvarchar(63)	INOUT	Reason code

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PLEDGEWRITEOFFPROCESS
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @NAME nvarchar(100)= null output,
                    @DESCRIPTION nvarchar(255)= null output, 
                    @IDSETREGISTERNAME nvarchar(100) = null output,
                    @CREATEOUTPUTIDSET bit = null output,
                    @REASON nvarchar(300) = null output,
                    @POSTSTATUS nvarchar(11) = null output,
                    @POSTDATE datetime = null output,
                    @OUTPUTIDSETNAME nvarchar(100) = null output,
                    @OVERWRITEOUTPUTIDSET bit = null output,
                    @BUSINESSPROCESSCATALOGID uniqueidentifier = null output,
                    @PARAMETERSID uniqueidentifier = null output,
                    @REASONCODEANDDESCRIPTION nvarchar(63) = null output
                )
                as
                begin
                    set nocount on;

                    set @DATALOADED = 0;

                    select 
                        @DATALOADED = 1,
                        @NAME = NAME,
                        @DESCRIPTION = DESCRIPTION,
                        @IDSETREGISTERNAME =  dbo.UFN_IDSET_GETNAME(IDSETREGISTERID),
                        @CREATEOUTPUTIDSET = CREATEOUTPUTIDSET,
                        @POSTSTATUS = POSTSTATUS,
                        @POSTDATE = POSTDATE,
                        @REASON = REASON,
                        @OUTPUTIDSETNAME = OUTPUTIDSETNAME,
                        @OVERWRITEOUTPUTIDSET = OVERWRITEOUTPUTIDSET,
                        @BUSINESSPROCESSCATALOGID = '17CC2C7F-8B70-4a07-A0E7-164060D215F5',
                        @PARAMETERSID = @ID,
                        @REASONCODEANDDESCRIPTION = dbo.UFN_WRITEOFFREASONCODE_TRANSLATE(PLEDGEWRITEOFFPROCESS.REASONCODEID)
                    from
                        dbo.PLEDGEWRITEOFFPROCESS
                    where
                        ID = @ID;

                    return 0;
                end