USP_DATAFORMTEMPLATE_VIEW_GLPROCESSSTATUSPAGEDATA

The load procedure used by the view dataform template "Post To GL Process Status Page Expression 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.
@ISLEGACYGL	bit	INOUT	Is legacy GL
@ISBASICGL	bit	INOUT	Is basic GL
@PARAMETERSETID	uniqueidentifier	INOUT	Parameter Set
@PARAMETERSETNAME	nvarchar(100)	INOUT	Parameter Set Name
@ENABLEDOWNLOAD	bit	INOUT	Enable download
@BUSINESSPROCESSCATALOGID	uniqueidentifier	INOUT	Business process catalog ID
@BUSINESSPROCESSSTATUSID	uniqueidentifier	INOUT	Business process status ID
@PROCESSCOMPLETED	bit	INOUT	Process completed
@HASEXCEPTIONS	bit	INOUT	Has exceptions
@HASGLBATCH	bit	INOUT	Has GL Batch
@PAGECONTEXTID	uniqueidentifier	INOUT	Page context ID

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_GLPROCESSSTATUSPAGEDATA
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @ISLEGACYGL bit = null output,
                    @ISBASICGL bit = null output,
                    @PARAMETERSETID uniqueidentifier = null output,
                    @PARAMETERSETNAME nvarchar(100) = null output,
                    @ENABLEDOWNLOAD bit = null output,
                    @BUSINESSPROCESSCATALOGID uniqueidentifier = null output,
                    @BUSINESSPROCESSSTATUSID uniqueidentifier = null output,
                    @PROCESSCOMPLETED bit = null output,
                    @HASEXCEPTIONS bit = null output,
                    @HASGLBATCH bit = null output,
                    @PAGECONTEXTID uniqueidentifier = null output
                )
                as 
                begin 
                    select
                        @DATALOADED = 1,
                        @ISLEGACYGL = 
                            case 
                                when GLBATCH.POSTPROCESSTYPECODE = 0 then 1 
                                else 0
                            end,
                        @ISBASICGL = 
                            case 
                                when GLBATCH.POSTPROCESSTYPECODE = 1 then 1 
                                else 0
                            end,
                        @PARAMETERSETID = BUSINESSPROCESSSTATUS.ID,
                        @PARAMETERSETNAME = POSTTOGLPROCESS.NAME,

                        @ENABLEDOWNLOAD = 
                            case when BUSINESSPROCESSSTATUS.STATUSCODE = 0 and BUSINESSPROCESSSTATUS.NUMBERPROCESSED > 0 then 1 
                                else 0 
                            end,
                        @BUSINESSPROCESSCATALOGID = BUSINESSPROCESSSTATUS.BUSINESSPROCESSCATALOGID,
                        @BUSINESSPROCESSSTATUSID = @ID,
                        @PROCESSCOMPLETED = 
                            case when BUSINESSPROCESSSTATUS.STATUSCODE = 0 then 1 
                                else 0
                            end,
                        @HASEXCEPTIONS = 
                            case when BUSINESSPROCESSSTATUS.NUMBEROFEXCEPTIONS > 0 then 1
                                else 0
                            end,
                        @HASGLBATCH = 
                            case 
                                when GLBATCH.ID is null then 0 
                                else 1
                            end,
                        @PAGECONTEXTID = @ID
                    from dbo.BUSINESSPROCESSSTATUS
                    left join dbo.GLBATCH on GLBATCH.POSTPROCESSSTATUSID = BUSINESSPROCESSSTATUS.ID
                    left join dbo.POSTTOGLPROCESS on POSTTOGLPROCESS.ID = BUSINESSPROCESSSTATUS.BUSINESSPROCESSPARAMETERSETID
                    where BUSINESSPROCESSSTATUS.ID = @ID;

                    set @ISLEGACYGL = 1;
                end