Search Results eam_request_utility_pvt




Overview
Explore in AI Chat

Overview

The APPS.EAM_REQUEST_UTILITY_PVT package is a private (PVT-classified) PL/SQL utility package within the Oracle Enterprise Asset Management (EAM) module. It exists to service the work request processing infrastructure, providing low-level row manipulation primitives that operate against the EAM work request data model. The package spec header identifies the source file as EAMVRQUS.pls and dates initial creation to 14-FEB-2005. Its documented purpose is simply "Spec of package EAM_REQUEST_UTILITY_PVT," confirming that it is a supporting component rather than a public API.

The "PVT" suffix in Oracle EBS naming conventions signals that the package is not intended for direct customer invocation. Instead, it is called internally by other EAM packages that orchestrate work request lifecycle events. The ETRM metadata records that this package is referenced by one other package, reinforcing its role as a dependent utility layer beneath a higher-level processing facade such as EAM_PROCESS_WO_PUB. The procedures accept the shared record type defined by EAM_PROCESS_WO_PUB.eam_request_rec_type, which allows the utility layer to remain decoupled from individual column parameters.

Key Procedures and Functions

The package exposes three documented procedures or functions:

  • INSERT_ROW — Inserts a work request row based on the inbound eam_request_rec_type record. It returns a status indicator and an error message token table for diagnostics.
  • DELETE_ROW — Removes a work request row corresponding to the supplied record, again returning a return status and message token collection.
  • COPY_WR_ATTACHMENT_TO_WO — Copies attachments associated with a work request onto the resulting work order, preserving documentary evidence through the transition from request to released work order.

All three procedures follow the standard EBS error-handling pattern: an x_return_status output (typically FND_API.G_RET_STS_SUCCESS, ERROR, or UNEXPECTED_ERROR) accompanied by a Mesg_Token_Tbl_Type collection from EAM_ERROR_MESSAGE_PVT for token substitution in user-visible messages.

Tables Accessed

The ETRM metadata documents three tables accessed via APPS synonyms:

  • WIP_EAM_WORK_REQUESTS — the primary work request entity. INSERT_ROW writes new requests here and DELETE_ROW removes them.
  • EAM_WO_SERVICE_ASSOCIATION — links work requests to service associations, supporting the attachment-copy logic executed by COPY_WR_ATTACHMENT_TO_WO.
  • FND_ATTACHED_DOCUMENTS — the standard Oracle Documents repository table. It is read to retrieve attachments against the work request and written to create their work order equivalents.

Usage Notes

Because this is a private package, it should never be called directly from custom code. It is invoked in practice from within Oracle EAM forms (such as the Work Request entry form) and from concurrent programs that process work requests and convert them to work orders. Customizations that must interact with work request data should target the public EAM_PROCESS_WO_PUB API, which in turn delegates to this utility package. Developers upgrading between 12.1.1 and 12.2.2 should verify that any wrapper code depends only on the public API surface, since private packages are subject to change without notice and are excluded from Oracle's compatibility guarantees.