Search Results process_lot_serial

Overview

APPS.EAM_WO_COMP_UTILITY_PVT is a private (PVT) PL/SQL package body in the Oracle Enterprise Asset Management (EAM) module. It provides the internal write-side utility layer that supports work order completion and un-completion processing within Oracle EBS 12.1.1 and 12.2.2. The package encapsulates the database inserts and updates required when an EAM work order operation is completed or reversed, isolating that persistence logic behind the public EAM_PROCESS_WO_PUB API.

The header history identifies the file as EAMVWCUB.pls, with an initial creation date of 14-FEB-2005 and a revision level of 120.16 (21-AUG-2006). The package name, G_PKG_NAME, is declared as the constant 'EAM_WO_COMP_UTILITY_PVT'. Because it is classified as a private package, it is not intended for direct invocation by external or customer code; it is a supporting internal component of the EAM work order processing framework. A search for "process_lot_serial" does not resolve to a documented procedure in this package. Its documented procedures are PERFORM_WRITES, INSERT_ROW, and UPDATE_ROW, which handle the persistence of work order completion records.

Key Procedures and Functions

• PERFORM_WRITES — The orchestrating routine. It accepts an EAM work order completion record (of type EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type) and returns a return status plus a message token table. It inspects the transaction type on the incoming record and branches to the write logic only when the transaction type equals G_OPR_COMPLETE or G_OPR_UNCOMPLETE (constants defined in EAM_PROCESS_WO_PVT). When either condition is met, it calls Insert_Row. It also emits debug output through EAM_ERROR_MESSAGE_PVT.Write_Debug when debugging is enabled via EAM_PROCESS_WO_PVT.Get_Debug.
• INSERT_ROW — Performs the insert of the work order completion record. It receives the completion record and returns status and message token information, using the standard EAM message-token mechanism for error reporting.
• UPDATE_ROW — Performs the corresponding update of an existing work order completion record, again returning status and message tokens for downstream error handling.

Tables Accessed

The package references the following objects through APPS synonyms, supporting completion persistence and validation:

• EAM_JOB_COMPLETION_TXNS and EAM_WORK_ORDER_DETAILS — the primary work order completion and detail records inserted or updated.
• EAM_ASSET_STATUS_HISTORY and EAM_ASSET_STATUS_HISTORY_S — asset status change auditing triggered by completion activity.
• MTL_MATERIAL_TRANSACTIONS_S — material transaction sequencing tied to consumed or returned inventory.
• MTL_SYSTEM_ITEMS — item validation and attribute lookup.
• WIP_DISCRETE_JOBS and WIP_EAM_WORK_REQUESTS — linkage to the associated work order and EAM work request.
• EAM_WO_STATUSES_V — work order status view used for status validation.
• DUAL and PLITBLM — utility references commonly used for scalar selection and PL/SQL table handling.

Usage Notes

EAM_WO_COMP_UTILITY_PVT is invoked internally by one other package, consistent with its private classification. It is not called directly from Oracle Forms, concurrent programs, or custom code. Integrations and extensions that need to complete or un-complete an EAM work order should call the public APIs EAM_PROCESS_WO_PUB / EAM_PROCESS_WO_PVT, which in turn drive this utility. The transaction-type guard in PERFORM_WRITES ensures writes occur only for complete and un-complete operations, protecting data integrity for other transaction types.