Search Results process_lpn_trx

Overview

INV_TRX_MGR_CP is an Oracle E-Business Suite inventory package owned by the APPS schema and classified under the ETRM API taxonomy as OTHER. Its name carries the _CP suffix, indicating that it is a concurrent-program wrapper package: an entry point designed to be invoked by a concurrent program rather than a rich public API consumed directly by application forms or integration code. In Oracle EBS 12.1.1 and 12.2.2 the package serves as the server-side control layer that the Inventory transaction worker uses to move staged transaction rows from the open interface into the final transaction tables.

The package is deliberately thin. The header, whose revision string ($Header: INVTRXCS.pls 120.1 2005/06/17) places its last substantial revision in the mid-2000s, exposes a single procedure and no package-level state, constants, exceptions, or helper functions. All substantive business logic resides in the underlying inventory transaction manager packages; INV_TRX_MGR_CP supplies only the concurrent-program contract. This narrow footprint explains why the ETRM repository records no packages that reference it and no objects it references beyond those reached through APPS synonyms.

Key Procedures and Functions

The package declares exactly one documented procedure, PROCESS_LPN_TRX. Its role is to process a batch of transaction rows staged in the material transaction interface table (MMTT) that have been associated with a license plate number (LPN), driving them through the same validation and inventory-update logic used by standard transaction processing. The procedure is a concurrent-program style interface, relying on the standard EBS return convention to communicate outcome.

• PROCESS_LPN_TRX — processes the LPN-tagged batch of pending interface rows identified by the transaction header ID passed to it; accepts the standard concurrent-program return code and error buffer as output parameters, and the transaction header ID as its single input.

No other procedures or functions are documented for this package in the 12.2.2 metadata.

Tables Accessed

The ETRM metadata for INV_TRX_MGR_CP does not enumerate any tables accessed directly. The procedure is a wrapper, so its data manipulation is performed by the underlying transaction manager routines that it invokes. The table explicitly referenced in the documented header comments is MMTT, the material transaction interface table, described there as holding the batch of rows to be processed for a given transaction header ID. Consistent with the naming convention and its internal transaction code, this package participates in processing inventory interface rows defined by the INV_TRX_MGR_CP.TRX_TYPE value. All such tables are reached through APPS synonyms rather than through package-owned schema objects, which is the normal pattern for a wrapper of this kind.

Usage Notes

INV_TRX_MGR_CP is intended to be executed as a concurrent program. The procedure exposes the standard concurrent-program parameter signature, making it suitable for registration against a concurrent program definition and for submission through the standard concurrent manager. Typical callers are therefore the concurrent program registration and the standard request submission framework rather than application forms or hand-written business APIs.

Because the package is APPS-owned and thin, customizations that extend LPN transaction processing should generally be placed in the underlying transaction manager packages rather than in this wrapper. Direct invocation from custom PL/SQL is possible but is not the designed use case; the return code and error buffer are calibrated for the concurrent manager, and invoking the procedure repeatedly against the same transaction header ID may re-process rows that MMTT has already consumed. In the 12.1.1 and 12.2.2 file systems, the package is compiled into the APPS schema alongside the rest of the INV product code, and its behavior is available through the INV_TRX_MGR_CP public specification shown in the ETRM source excerpt.