Search Results get_class_fk

Overview

EDW_PROJ_CLS is an Oracle EBS Application Object Library package owned by the APPS schema and classified under the ETRM as "OTHER" API classification. Its name — EDW prefix — associates it with the Enterprise Data Warehouse (EDW) or Business Intelligence extract layer rather than with an online transactional flow. The package encapsulates a single public function, GET_CLASS_FK, whose purpose is to resolve the surrogate or foreign key value used to represent a project classification within the warehouse model. In the Oracle Projects data model, a project may carry many classification assignments, each defined by a class category and a class code drawn from the PA_PROJECT_CLASSES table. Downstream warehouse and reporting structures require a stable, single-column key that identifies such an assignment, and GET_CLASS_FK supplies that key given the project and the classification code. Because the package is declared with a public specification exposing exactly one function, its role is strictly a lookup utility: it does not maintain classification data, does not enforce business processing rules, and does not participate in the Projects transaction APIs.

Key Procedures and Functions

• GET_CLASS_FK — The only documented procedure or function in the package. It accepts a project identifier and a classification code (class number), and returns a VARCHAR2 value representing the foreign key for that project classification. The function is the entry point that callers use when translating human-facing or transactional classification values into the key form expected by warehouse tables. Its declaration includes PRAGMA RESTRICT_REFERENCES with the WNDS, WNPS, and RNPS settings, signalling that the function writes no database state, writes no package state, and reads no package state. This purity constraint confirms the function is a read-only resolve utility and permits it to be invoked from SQL statements as well as PL/SQL.

Tables Accessed

The documented table reference is PA_PROJECT_CLASSES, accessed through the APPS synonym layer. PA_PROJECT_CLASSES stores the assignment of a class code to a project within a class category, and it is the natural source for deriving the classification key. GET_CLASS_FK reads this table to locate the row matching the supplied project identifier and class code, and returns the identifying key value associated with that row. No insert, update, or delete activity is documented, which is consistent with the RESTRICT_REFERENCES purity declaration. Because the package is part of the warehouse extract layer, reads are expected to be performed in batch or report contexts rather than in high-volume online transactions.

Usage Notes

EDW_PROJ_CLS is referenced by two other packages according to the documented metadata, indicating it is a subordinate utility consumed by higher-level warehouse or reporting code rather than being called directly from Oracle Forms or by end users. Typical invocation occurs within PL/SQL extract programs, custom warehouse loads, and BI staging routines that need to normalize project classification assignments into key form. The function may also be embedded in SQL statements, given its RESTRICT_REFERENCES purity settings. The package header carries an early header revision string, and the metadata confirms it remains available in Oracle EBS 12.1.1 and 12.2.2. Customizations should treat it as a read-only helper and avoid introducing writes; where additional classification attributes are required, the underlying PA_PROJECT_CLASSES table should be queried directly rather than extending this package.