Search Results mtl_conv_audit_id_s

Overview

The APPS.MTL_LOT_CONV_AUDIT_PKG package body provides the PL/SQL implementation behind lot conversion audit tracking in Oracle E-Business Suite. In the Oracle Inventory (INV) module, "lot conversion" refers to the process by which a temporary or pending lot number is converted into a formal, master-assigned lot number within the lot control framework. Because this conversion alters the identity of inventoried material, Oracle maintains an audit trail of each conversion event so that the integrity of lot-tracked inventory can be demonstrated for regulatory, quality, and traceability purposes.

This package encapsulates the persistence logic for that audit trail. Rather than embedding insert and update DML directly inside forms or calling programs, Oracle EBS centralizes the manipulation of the audit table within this single package, ensuring that the audit records are written consistently with proper message handling and API conventions. The package is classified under the ETRM taxonomy as a general-purpose or "OTHER" API rather than a public or private business API, reflecting its role as an internal support package rather than an externally documented interface.

The query string "mtl_conv_audit_id_s" that led to this object corresponds to the MTL_CONV_AUDIT_ID_S database sequence, which the package uses to generate unique primary keys for new audit rows. The package is dependent on the standard Oracle Application Object Library utilities FND_API, FND_MESSAGE, and FND_MSG_PUB, indicating that it follows the conventional EBS API architecture for error signaling and message stacking.

Key Procedures and Functions

The ETRM metadata documents two procedures within this package body:

• INSERT_ROW — Inserts a new audit record into the conversion audit trail. This procedure is responsible for obtaining a fresh identifier from the sequence and populating the audit row with the relevant conversion details supplied by its caller.
• UPDATE_ROW — Updates an existing audit record. This supports subsequent modification of audit entries, for example when additional attributes of a conversion event must be recorded or corrected.

The metadata does not expose parameter lists for these procedures; documented usage should therefore rely on the package specification in the target instance rather than assuming signatures. Additional private helper routines may exist but are not enumerated in the documented metadata.

Tables Accessed

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

• MTL_LOT_CONV_AUDIT — The primary audit table. INSERT_ROW writes new conversion audit records here, and UPDATE_ROW modifies existing ones. This table stores the historical record of lot conversions.
• MTL_CONV_AUDIT_ID_S — The sequence supplying unique primary keys for the audit table. It is the object corresponding to the "mtl_conv_audit_id_s" search term.
• FND_DUAL — The Oracle Application Object Library dual-table construct, used for performing scalar evaluations or sequence retrieval within PL/SQL in a manner consistent with EBS coding standards.

Usage Notes

This package is an internal implementation detail of the lot conversion audit feature. It is not referenced by any database object other than its own specification, meaning it is invoked directly from the forms or concurrent program logic that performs lot conversion, rather than being called by other stored code. Practitioners should therefore treat it as a supporting package: the appropriate entry point for functional work is the lot conversion UI or the corresponding concurrent process, not this package directly.

Because the package follows standard EBS messaging conventions through FND_MSG_PUB, callers are expected to check the message stack for errors after invocation. Customizations that need to read the resulting audit trail should query MTL_LOT_CONV_AUDIT directly, and custom inserts should use the MTL_CONV_AUDIT_ID_S sequence to preserve key uniqueness.