Search Results edw_demand_class_pkg

Overview

The APPS.EDW_DEMAND_CLASS_PKG package body is a PL/SQL component belonging to the Oracle E-Business Suite data warehouse and analytics infrastructure. Its name follows the EDW (Enterprise Data Warehouse) naming convention used across Oracle's supply chain and demand planning modules, indicating that it supports extraction, transformation, and lookup operations associated with demand classification. In the broader context of Oracle EBS 12.1.1 and 12.2.2, packages with this prefix typically serve as helper utilities for the Oracle Demand Planning and Advanced Supply Chain Planning collections, providing standardized access to classification hierarchies and reference data used during planning data refreshes. The package is documented under the ETRM repository with an API classification of OTHER, meaning it is not an officially published public API but a supporting database object. It is stored in the APPS schema, is marked VALID, and exposes a single documented callable entity alongside a dependency on EDW_LOCAL_INSTANCE.

Key Procedures and Functions

The package body documents one callable procedure or function:

• GET_DEMAND_CLASS_FK — This routine returns a foreign key value associated with a demand class. Consistent with the EDW naming pattern, its purpose is to resolve or retrieve the surrogate or foreign key that identifies a demand class record within the warehouse schema, allowing calling code to map a demand class description or identifier into the internal key expected by downstream tables. The procedure abstracts the lookup logic so that other EDW components do not need to query the underlying reference tables directly.

No other procedures or functions are documented for this package body. The single-entry interface suggests a narrow, purpose-built utility rather than a general-purpose API.

Tables Accessed

The ETRM metadata records one table reference accessed through APPS synonyms:

• EDW_LOCAL_INSTANCE — This table is a standard EDW infrastructure table that stores instance-level configuration and context information for the data warehouse environment. Access to this table indicates that the package resolves demand class keys in relation to the active warehouse instance, ensuring that lookups are scoped to the correct source instance or collection. This aligns with the typical behavior of EDW helper routines, which frequently consult instance metadata to determine the correct environment before returning classification keys.

No additional application tables are documented as dependencies. The package also references the STANDARD package from SYS and the EDW_DEMAND_CLASS_PKG specification itself, which is expected for any compiled PL/SQL unit.

Usage Notes

Because EDW_DEMAND_CLASS_PKG is classified as OTHER and is not referenced by any other database object, it is intended to be invoked directly by custom code, concurrent program logic, or planning collection routines rather than being called through a broader API chain. Typical invocation scenarios include:

• Custom PL/SQL or workflow code that needs to translate a demand class into its warehouse foreign key during data migration, interface, or reporting tasks.
• Concurrent programs and demand planning collection processes that require consistent demand class key resolution during data refresh.
• Extension code in 12.1.1 or 12.2.2 environments where demand planning integration requires mapping demand class values to EDW surrogate keys.

Administrators should note that the package is schema-resident in APPS and valid in the reference environment. Any grants required to execute it must be issued against the APPS schema, and callers should confirm the availability of the EDW_LOCAL_INSTANCE row corresponding to their operating instance before relying on the returned key.