Search Results insert_mtlt

Overview

GML_RCV_COMMON_APIS is a Process Manufacturing (OPM) PL/SQL package owned by the APPS schema. Its header carries the source-control identifier GMLRCVAS.pls 120.0, indicating that the package body and specification were last stamped in the 2005 development cycle that predates the 12.1.1 and 12.2.2 releases; the object has therefore remained stable across both release trains. Within Oracle EBS it provides shared receiving utilities for lot-controlled inventory, specifically the manipulation of temporary lot records staged during the receiving transaction flow before the records are validated and posted to the permanent inventory tables.

The package exposes a public record type, trans_rec_type, describing a transaction identifier, primary quantity, item number, and unit of measure, together with the associative-array collection type trans_rec_tb_tp indexed by BINARY_INTEGER. These types are used by callers to pass a set of replacement transactions into the lot-breaking routines.

Key Procedures and Functions

• INSERT_MTLT — the procedure most commonly searched for. It accepts a single record modelled on the MTL_TRANSACTION_LOTS_TEMP row structure and inserts that row into the temporary lot table. In practice it is the sanctioned insertion point used when a receiving transaction must be split and the resulting child lot rows need to be staged for downstream processing.
• BREAK_LOTS_ONLY — a Boolean-returning function that performs a lot-only split of an existing temporary transaction identified by p_original_tid, using the caller-supplied table of replacement transactions. Unlike the full BREAK procedure it does not evaluate serial control, so it is appropriate only where the item is lot-controlled but not serial-controlled.
• BREAK — the generalised split procedure. It takes the original transaction temporary identifier, the replacement transaction table, and both a lot control code and a serial control code, allowing the caller to drive the split logic according to the item's lot and serial attributes as resolved by the calling form or program.

Only these three program units are documented; the package is classified as OTHER rather than a public API, so no formal interface guarantee is published in the ETRM repository.

Tables Accessed

• MTL_TRANSACTION_LOTS_TEMP — the primary table. It is both the source of the row passed into INSERT_MTLT (via the %ROWTYPE parameter) and the table against which temporary transaction identifiers are resolved by the break routines. All insert, split, and reassignment activity in this package is confined to this staging table; permanent inventory tables are not touched.
• PLITBLM — an APPS synonym referencing a legacy Process Manufacturing table retained for compatibility. Its reference here reflects the package's origins in the OPM receiving code path.

Usage Notes

The package is an internal implementation object rather than an end-user entry point. It is invoked when a user splits a lot during receiving or lot entry in the Process Manufacturing inventory forms, and it is referenced by one other APPS package, which is the more likely integration surface for custom development. Because the split logic depends on control codes resolved by the caller, custom code invoking BREAK directly must supply correct lot and serial control codes; BREAK_LOTS_ONLY offers a narrower, safer alternative for lot-only items. All work occurs against temporary tables, so the final commit and posting of the receiving transaction remain the responsibility of the calling code. As with any undocumented internal package, customers and integrators should treat it as subject to change and confirm behaviour against the target release before relying on it.