Search Results inl_simulation_pub

Overview

INL_SIMULATION_PUB is a public PL/SQL package in the Oracle E-Business Suite APPS schema that supports the Oracle Landed Cost Management (LCM) module, internally identified by the product short code INL. Landed Cost Management allows organizations to estimate and apportion additional charges — freight, duty, insurance, and handling — onto received goods so that the true cost of inventory is reflected accurately. Within that functional area, INL_SIMULATION_PUB exists to manage the lifecycle of landed cost simulations: trial calculations that let users model estimated landed costs before committing them to actual receipt and inventory transactions.

The package is classified as a PUB (public) API, meaning its procedures are intended for external invocation by other application modules, concurrent programs, forms, or customer extensions, rather than being restricted to internal private use. It is declared with AUTHID CURRENT_USER, so all SQL executed within it runs under the privileges of the calling schema rather than as the definer. The header carries a version marker of 120.1 dated 2011/01/05, which is consistent with its presence in both EBS 12.1.1 and 12.2.2 code lines.

Key Procedures and Functions

• Purge_Simulations — The single documented procedure in the package. Its name indicates that it removes previously generated landed cost simulation records from the system. It operates against the set of simulation identifiers passed in by the caller, which is expressed through the PL/SQL table type INL_SIMULATION_PVT.simulation_id_tbl declared in the companion private package. This design allows a batch of simulations to be purged in one call rather than one at a time. The procedure also accepts the standard concurrent-processing organization identifier, confirming that purge operations are scoped to a specific inventory organization. A detailed description of the parameter list is outside the scope of this summary; the authoritative definition should be taken directly from the package specification.

Tables Accessed

The ETRM metadata for this package does not enumerate any tables referenced through APPS synonyms. Functionally, a purge routine of this nature would interact with the LCM simulation tables — the parent simulation header and its associated simulation detail lines — to delete simulation records identified by the supplied identifiers. Because the package is defined AUTHID CURRENT_USER, any such access is governed by the privileges of the invoking session rather than by APPS. Consumers should verify the exact set of affected objects against the deployed package body for their specific release, since simulation table structures can differ between 12.1.1 and 12.2.2.

Usage Notes

INL_SIMULATION_PUB is most commonly invoked from within the Landed Cost Management application UI when a user deletes or clears simulation data, or from a concurrent program that performs scheduled housekeeping of obsolete simulation records. The presence of the standard concurrent interface parameters — organization identifier and the commit control flag — indicates that the procedure is designed to be called from concurrent processing as well as interactively, allowing the caller to defer or force a database commit.

Because only one procedure is exposed and the package is referenced by zero other packages, INL_SIMULATION_PUB should be treated as a focused utility rather than a general simulation engine. Custom code calling Purge_Simulations should initialize the message list as required, pass a populated simulation identifier collection, check the returned status, and inspect the message stack on error. Direct DML against the underlying simulation tables is not advisable; the published API is the supported entry point and shields callers from changes in the private implementation.