Search Results g_all_attribute




Overview
Explore in AI Chat

Overview

GMO_CONSTANTS_GRP is a "group" (GRP) API classification package belonging to the APPS schema in Oracle EBS Release 12.1.1 and 12.2.2. The GMO prefix associates it with Oracle Process Manufacturing (OPM) — specifically the "GMO" module (Process Execution / Manufacturing Execution, sometimes referenced as the OPM common data layer). As a constants group package, its role is to centralize and expose globally scoped PL/SQL constant and configuration values used throughout the GMO subsystem. Rather than embedding literal values redundantly across many packages and forms, GMO_CONSTANTS_GRP provides a single authoritative access point, ensuring consistency and simplifying maintenance when values change.

The source body shows a single public routine, with an in-package global variable designated by the G_ prefix (i.e., G_ALL_ATTRIBUTE) acting as the underlying storage for the returned constant.

Key Procedures and Functions

  • ALL_ATTRIBUTE — A function returning VARCHAR2 that exposes the package-level constant G_ALL_ATTRIBUTE. Its purpose is to provide a canonical literal (typically a wildcard or "all" selection token, such as the character used to indicate "all attributes" in query or filter logic) that callers reference instead of hard-coding the value in their own code. Encapsulating the literal in a function keeps dependent logic insulated from future changes to the constant's actual value.

The documented package contains only this one function. No procedures or additional functions are present in the excerpted body.

Tables Accessed

The ETRM metadata lists no tables referenced via APPS synonyms for this package. This is consistent with its design intent: as a constants group, it holds static values in PL/SQL source and performs no SQL DML or queries. It therefore neither reads from nor writes to any database table, which also means it incurs no SQL execution overhead and can be called safely at any point in a session without concern for transactional state.

Usage Notes

Because GMO_CONSTANTS_GRP exposes a fixed constant, it is typically invoked as a lightweight in-line function wherever the "all attributes" token is required. The ETRM metadata notes that it is referenced by 14 other packages, indicating broad reuse across the GMO schema and its dependent modules.

Typical invocation patterns include:

  • Direct calls within other APPS packages (the 14 referencing packages) where the constant needs to be compared against or substituted into an attribute value.
  • Oracle Forms or shared PL/SQL libraries in the OPM/Process Execution stack where the same "all" semantics apply to attribute filtering.
  • Custom extensions or custom code that must honor the same convention used by seeded GMO logic.

No concurrent program or formal validation interface is documented. The package carries the standard Oracle header ($Header: GMOGCONB.pls 120.0), reflecting a shipped, supported object. Developers should treat the value returned by ALL_ATTRIBUTE as read-only configuration and avoid hard-coding the literal elsewhere; if the underlying constant ever changes, all 14 dependent packages automatically inherit the new value through this single access point.