Search Results set_project_option

Overview

GMS_COMMON_PKG is a shared utility package body in the APPS schema that supports the Oracle Grants Management (GMS) module within Oracle E-Business Suite 12.1.1 and 12.2.2. Its role is to centralize low-level, cross-functional helper logic used throughout the Grants Management application rather than to expose a formal public API. The package is classified as OTHER in the ETRM metadata, indicating that it is an internal support package rather than a registered, versioned public interface. Its status is VALID and it is owned by APPS, which is consistent with the standard deployment of Grants Management objects within the shared APPS schema.

The package consolidates common validation, numbering, and template-related operations so that grants configuration and award-creation logic can reuse a single implementation. This reduces duplication across the module's forms, concurrent programs, and dependent packages.

Key Procedures and Functions

The ETRM metadata documents four callable units within the package body:

• ISNUMBER — A utility validation routine that determines whether a given value can be interpreted as a number. It is used defensively by other grant routines to validate user input or derived values before numeric processing.
• SET_PROJECT_OPTION — Configures or assigns a project-related option used during grants processing. It supports the linkage between grants constructs and Oracle Projects settings that govern how award-related projects behave.
• IS_PROJECT_TEMPLATE — Evaluates whether a specified project is, or is based upon, a template. This check helps calling code distinguish template projects from operational projects, which is important when creating award-funded projects.
• GETMAX_AWARD_NUMBER — Retrieves the maximum award number currently in use, supporting award numbering and sequencing logic. It is typically consulted when generating or validating the next award identifier.

Tables Accessed

The package references GMS_AWARDS through the APPS synonym. GMS_AWARDS is the principal award entity table in Grants Management, storing award header information. GETMAX_AWARD_NUMBER depends on this table to determine the highest existing award number, and the remaining routines may consult it indirectly when validating award-linked project options or templates. In addition to this application table, the metadata notes dependencies on the APPS schema and the SYS.STANDARD package, the latter reflecting reliance on standard PL/SQL built-in functionality for the ISNUMBER-style evaluations.

The dependency listing also records a self-reference to GMS_COMMON_PKG, indicating internal calls between package members or recursive utility use within the package body itself.

Usage Notes

GMS_COMMON_PKG is referenced by one other database package and does not itself appear as a public API entry point. It is typically invoked internally by Grants Management forms, concurrent programs, and related PL/SQL packages that need consistent handling of award numbering, project template detection, project option configuration, or numeric validation. Because the package is a support utility, it should not be treated as a supported integration surface; customizations and extensions should call documented public APIs where available.

When troubleshooting grants behavior, GMS_COMMON_PKG is relevant because failures in award numbering or project template evaluation often originate in its routines. Because the package body is VALID and small, it is generally recompiled as part of broader GMS patch application. The absence of declared references by external objects confirms its internal, dependency-chain role within the Grants Management suite.