Search Results edw_proj_cls

Overview

EDW_PROJ_CLS is a utility package body in the APPS schema that supports Oracle E-Business Suite's Enterprise Data Warehouse (EDW) extraction and reporting infrastructure for Oracle Projects. Its narrow, single-purpose role is to resolve the surrogate foreign key representation of a project classification value so that EDW staging and reporting programs can store a stable, self-describing classification identifier alongside their extracted data. The package belongs to the FI/Projects EDW family (its header references the FIICAPCB.pls source file) and is classified as a non-public "OTHER" API, meaning it is intended for internal consumption by other EDW packages rather than as a supported customer-facing extension point. The two documented dependent packages confirm that EDW_PROJ_CLS acts as a shared helper within the EDW code path rather than a standalone business API.

Key Procedures and Functions

The package exposes a single documented function, GET_CLASS_FK. Its purpose is to return a formatted classification key for a given project and class category. Internally, the function queries the project class assignment, concatenates the stored class code with the EDW instance code supplied by EDW_INSTANCE.GET_CODE using a hyphen delimiter, and returns the resulting string. A local variable named l_cat holds this concatenated result; this is the identifier commonly encountered when reviewing the dependency metadata for this package, since it appears in the source listing that the object registry captures.

• GET_CLASS_FK — Returns the EDW classification foreign-key string for a specified project and class category, combining the project's class code with the current EDW instance identifier.

The function includes explicit exception handling for the no-data-found condition. When no matching classification row exists for the supplied project and category, the function returns a literal sentinel value rather than propagating the exception, ensuring that callers receive a usable placeholder and can continue processing without abending their extraction runs.

Tables Accessed

The package reads from PA_PROJECT_CLASSES, an Oracle Projects table that stores the association between a project and the classification categories and codes assigned to it. The function filters this table by project identifier and class category, retrieving the corresponding class code. All access is read-only; EDW_PROJ_CLS does not insert, update, or delete any data. No other tables are referenced in the documented metadata, though the function depends on EDW_INSTANCE.GET_CODE to obtain the instance-level code component that it concatenates into the returned key.

Usage Notes

Because it is classified as an internal EDW helper, EDW_PROJ_CLS is not intended for direct invocation from Oracle Forms or from customer-written concurrent programs. It is called by the EDW extraction and transformation packages that populate the Projects subject area of the data warehouse, where a consistent, instance-qualified classification key is required to support cross-instance reporting and dimensional joins. Customizations should avoid calling or overriding this package, since its behavior is tied to the EDW load cycle and its return contract includes the sentinel value used to represent unclassified projects. Where a project has no matching entry in PA_PROJECT_CLASSES for the requested category, callers should expect the fallback string and handle it as an unclassified indicator rather than as an error.