Search Results cst_eam_workorders_pvt




Overview
Explore in AI Chat

Overview

APPS.CST_EAM_WORKORDERS_PVT is a private PL/SQL package within the Oracle E-Business Suite Cost Management (CST) application module. Its name associates it with Enterprise Asset Management (EAM) work orders, and its API classification as PVT indicates that it is a private utility package rather than a public, supported application programming interface. In Oracle EBS, private packages are generally invoked by other internal modules within the same product rather than by external callers or customer extensions.

Based on the EAM work order context and the documented procedures, the package appears to support the generation and reporting of estimated versus actual cost detail for EAM work orders. It assembles cost information into XML form, likely to feed reporting, printing, or cost inquiry output. The package is documented in ETRM 12.2.2 with a status of VALID and is owned by the APPS schema, which is the standard installation owner for shared Oracle EBS application code.

Key Procedures and Functions

The ETRM metadata documents three procedures or functions within this package:

  • EAM_EST_ACTUAL_DETAILS — The principal business procedure implied by its name. It addresses estimated versus actual cost details for EAM work orders, providing the data foundation from which cost comparisons are derived. This is the procedure most closely aligned with the package's stated business purpose.
  • GENERATE_XMLDATA — Produces XML-formatted output, consistent with the package's dependency on DBMS_XMLGEN and DBMS_LOB. It transforms the underlying cost query results into an XML data stream suitable for reporting or downstream consumption.
  • DISPLAY_PARAMETERS — A diagnostic or utility routine used to display the parameters associated with the package's operations. Such procedures are commonly used for debugging, tracing, and confirming input values during execution.

Parameter lists are not documented in the available metadata and are therefore not reproduced here.

Tables Accessed

The package accesses the following tables via APPS synonyms, according to documented metadata:

  • CST_COST_GROUPS — Stores cost group definitions. Cost groups classify inventory and work-in-process costs by organization and category, and are required to resolve the correct costing context for an EAM work order.
  • CST_COST_TYPES — Defines cost types such as standard, average, or actual. Cost type selection is essential when comparing estimated costs against actual costs, which is the core function suggested by EAM_EST_ACTUAL_DETAILS.
  • WIP_ENTITIES — The central work-in-process entity table that holds work order and job definitions. For EAM work orders, this table supplies the work order identity and hierarchy that the cost detail report is built around.
  • DBMS_LOB — An Oracle supplied package for large object manipulation, used to handle the XML output produced by GENERATE_XMLDATA.
  • DBMS_XMLGEN — An Oracle supplied package that generates XML from SQL query results, the mechanism underlying the XML data production procedure.

Usage Notes

CST_EAM_WORKORDERS_PVT is a private package and is not intended for direct invocation by customer code, concurrent programs, or Oracle Forms outside its owning module. It is referenced by the APPS.CST_EAM_WORKORDERS_PVT package itself and by no other documented packages, confirming its role as an internal building block. Typical invocation occurs from higher-level Cost Management or EAM components that need EAM work order estimated-to-actual cost detail rendered as XML, commonly in support of cost inquiry screens or report output.

Because the package status is VALID and it depends only on standard Oracle supplied utilities and core cost tables, it is expected to function across both Oracle EBS 12.1.1 and 12.2.2. Integrators and developers should treat this package as read-only reference material, and should rely on published public APIs rather than calling CST_EAM_WORKORDERS_PVT directly, since private packages may change without notice across patches and releases.