Search Results site_enabled

Overview

The APPS.GMS_INSTALL package is a utility package within the Oracle E-Business Suite Grants Management (OGM) module. Its primary business function is to determine the implementation and configuration status of Oracle Grants Management (also referred to as OGM) for a given organization or login context. The package provides a centralized mechanism for other application components to query whether Grants Management functionality is enabled, whether specific features such as the FAB (Funds Available Balance or related funding control) capability are active, and whether particular projects qualify as sponsored projects. Because GMS_INSTALL is referenced by 26 other packages, it functions as a foundational dependency within the Grants Management architecture, allowing downstream code to conditionally execute logic based on the installation and setup state of the module.

Key Procedures and Functions

The package exposes several documented functions, each with a distinct role in verifying Grants Management configuration:

• ENABLED — Overloaded to check the OGM implementation status. One form evaluates status for the current login organization, and a second form accepts an x_org_id parameter to evaluate status for a specific organization. Returns a boolean indicating whether OGM is implemented.
• FAB_ENABLED — Overloaded similarly to ENABLED. One version checks FAB implementation status for the login responsibility, and the other accepts an x_org_id to check FAB implementation status for a specific organization. Returns FALSE when FAB is not implemented.
• SITE_ENABLED — Determines whether the Grants Management site-level implementation is active, typically used to gate module-wide behavior.
• IS_SPONSORED_PROJECT — Evaluates whether a given project is classified as a sponsored project, a core concept in Grants Management where sponsored projects are funded by external sponsors.
• SET_ORG_ARRAY — Populates an internal organizational array, supporting multi-organization (MOAC) processing for the package's status checks.
• GMS_ENABLED_MOAC — Provides a Multi-Org Access Control (MOAC) aware check for whether Grants Management is enabled across the relevant operating units.

Tables Accessed

The package references several underlying tables through APPS synonyms:

• GMS_IMPLEMENTATIONS and GMS_IMPLEMENTATIONS_ALL — Store the implementation and configuration records that determine whether Grants Management and its features (such as FAB) are enabled for an organization. These are the primary sources for the ENABLED and FAB_ENABLED checks.
• PA_PROJECTS_ALL and PA_PROJECT_TYPES_ALL — Support the IS_SPONSORED_PROJECT logic, used to resolve project attributes and project type classifications that identify sponsored projects.
• DUAL — Used for simple single-row evaluations, such as deriving booleans from organizational context.
• PLITBLM — A PL/SQL index-by table construct used internally to manage organizational arrays, supporting the SET_ORG_ARRAY and MOAC-related functions.

Usage Notes

GMS_INSTALL is typically invoked as a programmatic guard rather than directly through a user interface. Forms, concurrent programs, and custom PL/SQL routines within the Grants Management and Projects families call its functions to conditionally enable or suppress Grants Management-specific behavior. For example, a form may call GMS_INSTALL.ENABLED to decide whether to display Grants Management fields, while a concurrent program may call GMS_ENABLED_MOAC to validate the operating unit context before processing sponsored project data. Because the package is referenced by 26 other packages, changes to its logic or return behavior can have broad cascading effects. The package uses AUTHID CURRENT_USER and includes RESTRICT_REFERENCES pragmas on key functions (WNDS, WNPS) to optimize PL/SQL execution and enforce purity constraints. Administrators and developers should treat its boolean-returning functions as authoritative indicators of Grants Management availability for the login organization, a specific org_id, or the active MOAC context.