Search Results perform_writes

Overview

APPS.EAM_ESTABLISHMENT_UTILITY_PVT is a private PL/SQL utility package within the Oracle Enterprise Asset Management (EAM) module of Oracle E-Business Suite. Its documented purpose is to provide the low-level database access layer for establishment-related safety records, specifically those associated with EAM safety establishments. The package is declared with AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the invoking user rather than the definer, a convention consistent with private implementation packages that are expected to be called by a trusted public API layer such as EAM_PROCESS_SAFETY_PUB.

The source header confirms an origin date of 2011 and a file name of EAMVETUS.pls, reflecting a standard Oracle EBS naming convention for private (PVT) packages that back a corresponding public (PUB) interface. As a private package, it is not intended for direct invocation by external or customer-written code; it forms the internal machinery through which the public safety establishment API persists and retrieves records.

The search phrase "at.e.enterprise private limited no of installation" does not correspond to any documented attribute of this package. The metadata contains no reference to installation counts, customer names, or licensing metrics. This package is a database object and carries no such business data; any association with an installation count is coincidental to the search and unsupported by the ETRM documentation.

Key Procedures and Functions

The ETRM metadata documents six procedures within this package. Each is described below according to its documented purpose; parameter lists are not enumerated except where explicitly shown in the source excerpt.

• QUERY_ROW — Queries the database for an establishment record and returns the matching row. It accepts an establishment identifier and an organization identifier as input and returns a safety establishment record along with a return status.
• INSERT_ROW — Performs an insert into the establishment details table, accepting a safety establishment record as input and returning a status indicator.
• UPDATE_ROW — Performs an update on the establishment details table, accepting a safety establishment record as input and returning both a message token table and a return status.
• DELETE_ROW — Removes an establishment record from the underlying table. Documented by name within the package's six-procedure set.
• PERFORM_WRITES — Coordinates the write operations (insert, update, and delete) against the establishment table. This is the orchestration routine that private utility packages typically expose to the public API.
• CHECK_REQUIRED — Validates that mandatory attributes are present on an establishment record before a write is committed, supporting data integrity at the API boundary.

Tables Accessed

The package references a single documented table through an APPS synonym: EAM_ESTABLISHMENT_DETAILS. All query, insert, update, and delete operations described above resolve to this table. It stores the establishment-level safety data that the EAM safety establishment feature manages, including identifiers keyed by establishment and organization. Because the package accesses the table exclusively through the APPS synonym, it depends on standard EBS synonym and privilege configuration being in place.

Usage Notes

This package is referenced by one other package, consistent with its role as a subordinate utility called by the public safety establishment API. It is typically invoked indirectly rather than directly.

• Oracle EAM safety establishment forms and concurrent processes call the public layer, which in turn delegates persistence to this private package.
• Custom or extension code should not call EAM_ESTABLISHMENT_UTILITY_PVT directly; the supported integration point is the corresponding public API.
• Because the package is AUTHID CURRENT_USER, effective privileges derive from the calling session, so grant structures on EAM_ESTABLISHMENT_DETAILS must permit the invoking user's access path.
• The message token output on UPDATE_ROW indicates integration with the EAM error message framework (EAM_ERROR_MESSAGE_PVT), reinforcing its internal API role.

In releases 12.1.1 and 12.2.2 the package behaves identically from a documented perspective; no version-specific divergence is recorded in the ETRM metadata.