Search Results eam_construction_unit_pub




Overview
Explore in AI Chat

Overview

EAM_CONSTRUCTION_UNIT_PVT is the private implementation package for Oracle Enterprise Asset Management (EAM) construction units in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the APPS schema and is classified as a PVT (private) API package, meaning its procedures are not intended for direct invocation by external or customer-developed code. Instead, it serves as the internal workhorse behind the public counterpart package, APPS.EAM_CONSTRUCTION_UNIT_PUB, which is the sanctioned entry point for programmatic interaction with construction unit records.

Construction units in EAM represent logical groupings of assets and work associated with capital or construction projects. This package encapsulates the validation and persistence logic required to create, modify, and replicate such construction unit records while enforcing the business rules of the EAM module. The private designation allows Oracle to evolve the internal logic without exposing those changes as a supported interface.

Key Procedures and Functions

The package exposes eight documented procedures and functions that together provide the full lifecycle management of construction unit data:

  • CREATE_CONSTRUCTION_UNIT — Creates a new construction unit record, populating the base table with validated attribute values.
  • UPDATE_CONSTRUCTION_UNIT — Modifies an existing construction unit, applying the same validation regime as creation.
  • COPY_CONSTRUCTION_UNIT — Duplicates an existing construction unit, enabling rapid setup of similar records without re-entering all attributes.
  • VALIDATE_CU_DETAILS — Performs the core business-rule validation on construction unit attributes, typically invoked before create or update operations commit.
  • SET_DEBUG — Enables debug mode, causing the package to emit diagnostic output during subsequent processing.
  • GET_DEBUG — Returns the current debug flag state.
  • DEBUG — Writes debug messages when debug mode is active, supporting troubleshooting of API execution.
  • DUMP_ERROR_STACK — Outputs the PL/SQL error stack, assisting developers in diagnosing runtime exceptions during API calls.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

  • EAM_CONSTRUCTION_UNITS — The primary transactional table holding construction unit records; the target of create, update, and copy operations.
  • MTL_SYSTEM_ITEMS_B and MTL_SYSTEM_ITEMS_KFV — Item master base table and its key flexfield view, referenced to validate and resolve item references associated with construction units.
  • MTL_PARAMETERS — Organization-level inventory parameters used to derive defaulting and validation context for the operating organization.
  • WIP_ACCOUNTING_CLASSES — Accounting class definitions referenced for cost and accounting validation.
  • PLITBLM — The standard EBS PL/SQL table used for message handling, supporting the error and diagnostic framework.

Usage Notes

EAM_CONSTRUCTION_UNIT_PVT should never be called directly from custom code or concurrent programs. The supported interface is EAM_CONSTRUCTION_UNIT_PUB, which is documented in the dependency chain as both calling and being called by the private package. Oracle EAM forms and any seeded concurrent programs route their construction unit maintenance operations through the public API, which in turn delegates to this private package for validation and DML.

Because the package depends on FND_API and the STANDARD library, it participates in the standard EBS API error-handling and messaging model, returning success, error, or unexpected-error statuses upward to the public layer. Developers troubleshooting construction unit issues may enable SET_DEBUG and inspect output produced by DEBUG, then use DUMP_ERROR_STACK to capture the PL/SQL error context when an unexpected exception propagates.

As a PVT package with VALID status in both EBS 12.1.1 and 12.2.2, its internal signatures are subject to change during patching without notice, reinforcing the guidance to code exclusively against the public API.