Search Results eam_op_comp_default_pvt




Overview
Explore in AI Chat

Overview

APPS.EAM_OP_COMP_DEFAULT_PVT is a private (PVT) PL/SQL package that belongs to the Oracle Enterprise Asset Management (eAM) module of Oracle E-Business Suite. Its name reflects its purpose: it supplies default values for the operation completion transaction records processed by the eAM work order completion flow. The package is tightly coupled to the public API EAM_PROCESS_WO_PUB, which is the supported entry point for creating, updating, and validating work order operation completion data. Where EAM_PROCESS_WO_PUB defines the public record type used to carry completion information, EAM_OP_COMP_DEFAULT_PVT performs the internal work of filling in attributes that the caller has left null before the public API proceeds with validation and processing.

The header comment in the package spec indicates it was created in February 2005 and its file name (EAMVOCDS.pls) is short for "EAM VO Completion Defaults," confirming its role in the completion-transaction defaulting layer. It is a private package, meaning it is not intended to be called directly by customer code; Oracle can change its signature without notice, and support for direct invocation is not provided.

Key Procedures and Functions

The package exposes a single documented procedure:

  • Populate_Null_Columns — Accepts an eAM operation completion record (of type EAM_PROCESS_WO_PUB.eam_op_comp_rec_type) and returns a populated copy of that record along with a return status. The procedure inspects the incoming record and supplies default values for any attributes that were left blank, so that downstream validation and processing logic in EAM_PROCESS_WO_PUB operates on a fully formed record. The no-copy (NOCOPY) OUT parameters indicate the procedure is designed for performance-sensitive execution, returning the modified record and status without duplicating the record in memory.

Tables Accessed

The package reads and writes the following objects, all referenced through APPS synonyms:

  • EAM_OP_COMPLETION_TXNS_S — the sequence used to generate unique identifiers for operation completion transaction records. It is invoked during defaulting so newly defaulted records receive a valid primary key.
  • QA_COLLECTION_ID_S — the sequence supplying collection identifiers used by Oracle Quality when completion transactions capture quality results. Defaulting this value ensures quality data can be associated with the completion.
  • WIP_OPERATIONS — the Work in Process operations table. The procedure reads this table to obtain operation-level attributes (such as operation details and defaults) that are propagated onto the completion record when the caller does not supply them.
  • DUAL — used for single-row sequence and expression evaluations that conform to the standard dual-table construct.

Usage Notes

EAM_OP_COMP_DEFAULT_PVT is not a public API and should not be called from custom code. In the documented metadata, it is referenced by one other package, which is the normal pattern for a private helper: the public eAM work order processing layer invokes it internally when a caller submits a completion record whose optional attributes are null. The typical invocation path is therefore through EAM_PROCESS_WO_PUB, whether called from the eAM work order completion forms, from concurrent programs that process work order completions in batch, or from custom integrations that use the supported public API.

Because the package depends on WIP_OPERATIONS and the eAM completion sequences, behavior is consistent with the environment in which the calling public API runs. When troubleshooting completion records that fail validation due to missing values, the Populate_Null_Columns procedure is the component responsible for having supplied (or failed to supply) those defaults. This package is available in both Oracle EBS 12.1.1 and 12.2.2, with the same private API classification and the same single documented procedure.