Search Results ego_common_pvt




Overview
Explore in AI Chat

Overview

APPS.EGO_COMMON_PVT is a private PL/SQL package body in the Oracle E-Business Suite "EGO" (Enterprise Goods and Objects / Product Information Management) technology stack. It provides shared utility and infrastructure services that support the higher-level public APIs, forms, and concurrent programs within the EGO product family. Because it is classified as a Private (PVT) API, it is intended for internal consumption by Oracle's own EGO code rather than for direct invocation by customer extensions; nonetheless, its functions are often referenced indirectly through dependent packages. The package does not expose business transactions itself; instead it centralizes cross-cutting concerns such as product installation detection, schema resolution, profile option handling, and diagnostic logging that other EGO modules require. Its status is VALID, and while it references a number of other database objects, it is not referenced by any object in the reverse-dependency sense on the database side, though nine other packages depend on it at the application layer.

Key Procedures and Functions

The documented API surface comprises six procedures and functions, each serving a distinct infrastructure purpose.

  • IS_EGO_INSTALLED — Determines whether the EGO product has been fully installed or is currently enabled in the environment, allowing callers to guard execution paths accordingly.
  • GET_PROD_SCHEMA — Resolves and returns the database schema associated with a product, supporting schema-aware queries and dynamic SQL.
  • SAVE_USR_ORG_CTX_PROF_VAL — Persists user, organization, and context-related profile option values, enabling preference and context state to be stored centrally.
  • CANCEL_NIR_FOR_DELETE_ITEM — Handles cancellation of New Item Requests (NIRs) when an item is being deleted, maintaining data integrity across the item lifecycle.
  • GET_OPTION_VALUE — Retrieves the value of a configured option, providing callers with a consistent way to read EGO default option settings.
  • WRITE_DIAGNOSTIC — Writes diagnostic or debug information, typically to the FND logging subsystem, to aid troubleshooting and monitoring.

Tables Accessed

The package body references three documented tables, accessed through APPS synonyms:

  • EGO_DEFAULT_OPTIONS — Stores default configuration options for the EGO application; read primarily by GET_OPTION_VALUE.
  • FND_PRODUCT_INSTALLATIONS — Records which Oracle products are installed and their status; consulted by IS_EGO_INSTALLED and GET_PROD_SCHEMA.
  • FND_PROFILE_OPTIONS — Holds profile option definitions and values; used to resolve and store context/profile settings via SAVE_USR_ORG_CTX_PROF_VAL.

Additional dependencies include the standard FND_API, FND_GLOBAL, FND_MESSAGE, FND_LOG, FND_PROFILE, and FND_INSTALLATION packages, which supply the messaging, logging, profile, and installation primitives underpinning this package's utility functions.

Usage Notes

EGO_COMMON_PVT is invoked from Oracle Forms, other EGO packages, and EGO concurrent programs rather than being called directly by end users or custom code. Its functions are exercised transparently whenever dependent EGO modules need to check installation state, resolve schemas, read or save options and profile values, cancel NIRs during item deletion, or emit diagnostic logs. Because the metadata documents no reverse database dependencies but nine dependent application packages, integrators should treat it as a foundational internal utility that must remain consistent across patch applications. Customizations should call the corresponding public EGO APIs instead of this private package to preserve upgrade safety.