Search Results eam_worep_pub




Overview
Explore in AI Chat

Overview

APPS.EAM_WOREP_PUB is a public PL/SQL package in the Oracle E-Business Suite Enterprise Asset Management (EAM) module. Its name follows the EAM conventions for work order reporting and processing APIs, where the "_PUB" suffix designates the package as a published, supported interface intended for external or cross-module invocation. In EBS 12.1.1 and 12.2.2 the package is owned by the APPS schema and holds a VALID status, indicating it is compiled and available for use.

The package is designed to support the Work Order Reporting process. In EAM, work order reporting captures execution results against a work order — including resource usage, material consumption, completion quantities, and status transitions — and posts those results back to the application. EAM_WOREP_PUB exposes this reporting logic through a programmatic interface rather than restricting it to the standard Oracle Forms UI.

Key Procedures and Functions

The ETRM metadata documents a single public subprogram for this package:

  • WORK_ORDER_CP — The sole documented procedure. The "CP" naming convention in EAM typically denotes a concurrent-program entry point, meaning this procedure is the callable logic behind a concurrent request or batch process related to work order reporting. It is the public hook through which work order reporting operations are initiated programmatically, and is the primary interface consumers of EAM_WOREP_PUB are expected to use.

No parameter lists, return types, or additional overloads are recorded in the documented metadata. Any implementation detail beyond the procedure name should be confirmed against the live package specification in the target instance.

Tables Accessed

The metadata records the package as referencing two identifiers through APPS synonyms: DBMS_LOB and PLITBLM. Neither is a data table in the conventional sense:

  • DBMS_LOB — The Oracle-supplied built-in package for manipulating large objects (CLOBs, BLOBs, BFILEs). Its presence indicates EAM_WOREP_PUB handles LOB data, most plausibly for text or attachment content associated with work order reporting.
  • PLITBLM — An internal Oracle package supporting PL/SQL index-by table (associative array) manipulation, suggesting the package uses collection types as part of its processing logic.

The documented dependency list does not enumerate the EAM base tables (such as work order or reporting transaction tables) that the procedure ultimately touches. Those dependencies should be verified directly from ETRM dependent-code output or by inspecting the package body.

Usage Notes

EAM_WOREP_PUB is a public API and, as reflected in the metadata, is not referenced by any other documented package; instead it is a consumer-facing entry point. Typical invocation paths include:

  • Oracle EAM Forms that call the published API to report work order execution.
  • Concurrent programs that batch-process work order reporting, consistent with the "CP" naming of WORK_ORDER_CP.
  • Custom PL/SQL or integration code that needs to trigger work order reporting from outside the standard UI.

Because the documented metadata is limited to the object header, subprogram name, and high-level dependencies, integrators should treat the specification file as the authoritative source for calling conventions. Direct DML against EAM work order tables should be avoided in favor of this published interface, which encapsulates the application's business rules and validation logic. Oracle proprietary and confidential; confirm behavior against the specific EBS release and patch level in use.