USP_DATALIST_REVALUECOMMITMENTSPROCESS

Returns a list of Revalue Foreign-Denominated Commitments Business process parameter sets.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEFILTERMODE	tinyint	IN	Sites
@SITESSELECTED	xml	IN
@SECURITYFEATUREID	uniqueidentifier	IN	Input parameter indicating the ID of the feature to use for site security checking.
@SECURITYFEATURETYPE	tinyint	IN	Input parameter indicating the type of the feature to use for site security checking.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_REVALUECOMMITMENTSPROCESS
                (
                    @CURRENTAPPUSERID uniqueidentifier = null,
                    @SITEFILTERMODE tinyint = 0,
                    @SITESSELECTED xml = null,
                    @SECURITYFEATUREID uniqueidentifier = null,
                    @SECURITYFEATURETYPE tinyint = null
                )
                as
                    set nocount on;

                    select
                        REVALUECOMMITMENTSPROCESS.ID,
                        BUSINESSPROCESSINSTANCE.OWNERID,
                        REVALUECOMMITMENTSPROCESS.NAME,
                        REVALUECOMMITMENTSPROCESS.DESCRIPTION,
                        REVALUECOMMITMENTSPROCESS.INCLUDEGRANTAWARDS,
                        REVALUECOMMITMENTSPROCESS.INCLUDEPLANNEDGIFTS,
                        REVALUECOMMITMENTSPROCESS.INCLUDEPLEDGES,
                        REVALUECOMMITMENTSPROCESS.INCLUDERECURRINGGIFTS,                        
                        (select IDSETREGISTER.NAME from dbo.IDSETREGISTER where IDSETREGISTER.ID = REVALUECOMMITMENTSPROCESS.IDSETREGISTERID) as IDSETREGISTERNAME,
                        REVALUECOMMITMENTSPROCESS.CURRENCYEXCHANGERATEASOFDATETIMEOFFSET,
                        (select TIMEZONEENTRY.NAME from dbo.TIMEZONEENTRY where TIMEZONEENTRY.ID = REVALUECOMMITMENTSPROCESS.TIMEZONEENTRYID) [TIMEZONEENTRYNAME],
                        coalesce(SITE.NAME,'All Sites') SITES,
                        REVALUECOMMITMENTSPROCESS.INCLUDEINSTALLMENTPLANS                        
                    from
                        dbo.REVALUECOMMITMENTSPROCESS
                        left join dbo.BUSINESSPROCESSINSTANCE on REVALUECOMMITMENTSPROCESS.ID = BUSINESSPROCESSINSTANCE.BUSINESSPROCESSPARAMETERSETID
                        left join dbo.SITE on SITE.ID = BUSINESSPROCESSINSTANCE.SITEID
                    where 
                        dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, REVALUECOMMITMENTSPROCESS.ID) = 1
                    and (
                            --(

                                --(--Check site security

                                --    select count(*) 

                                --    from dbo.UFN_SITEID_MAPFROM_RECEIPTINGPROCESSID(RECEIPTINGPROCESS.ID) as RECEIPTINGPROCESSSSITE 

                                --    where (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[REVALUECOMMITMENTSPROCESS].[SITEID] or (SITEID is null and [REVALUECOMMITMENTSPROCESS].[SITEID] is null)))

                                --) > 0

                            --)

                            --and (--Apply site filter

                                @SITEFILTERMODE = 0
                                    or BUSINESSPROCESSINSTANCE.SITEID in (
                                        select SITEID
                                        from dbo.UFN_SITE_BUILDDATALISTSITEFILTER (@CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED) 
                                    )
                            --)

                    )
                    order by
                        REVALUECOMMITMENTSPROCESS.NAME;