Results for “run_calculation”

8 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

INL_LANDEDCOST_PVT is a private PL/SQL package body in the Oracle E-Business Suite Trade Management (formerly Oracle Landed Cost Management) module, owned by the APPS schema. It encapsulates the core calculation engine that derives landed cost charges — freight, duty, insurance, brokerage, and similar charges — and distributes those charges across shipment lines according to configured allocation and association rules. In EBS 12.1.1 and 12.2.2, landed cost processing allows organizations to capture the true cost of imported or transferred goods by attributing additional charges to the correct inventory valuations. The package coordinates quantity, amount, and price conversions using currency exchange rates and unit-of-measure conversions, then writes the computed results into the landed cost charge line tables consumed downstream by costing and accounting.

The "PVT" classification indicates this is an internal, private API: it is not exposed as a public integration point, and its procedures are designed to be invoked by other INL packages rather than by external callers. The header comment reflects a long maintenance history (through version 120.36.12020000.5), and the inclusion of FND user and login globals plus FND API return-status constants shows the package adheres to the standard EBS API error-handling and logging conventions via INL_LOGGING_PVT.

Key Procedures and Functions

  • RUN_CALCULATION — The primary driver procedure. It orchestrates the landed cost computation for a given shipment context, iterating over charge lines, applying allocation bases, and invoking the conversion helpers to produce final charge amounts.
  • CONVERTED_QTY — Returns the converted quantity for a charge line, translating the shipment line quantity into the charge's unit of measure using the MTL_UNITS_OF_MEASURE conversion factors.
  • CONVERTED_AMT — Returns the converted charge amount, applying currency conversion where the charge currency differs from the ledger currency.
  • CONVERTED_PRICE — Returns the converted unit price associated with a charge, used when the allocation basis is price-driven rather than quantity- or amount-driven.
  • InLoop_Association — A private helper (documented in the source excerpt) that detects circular associations among shipment parents. It returns TRUE when an association loop exists, protecting the calculation from infinite recursion during allocation traversal.

Tables Accessed

The package reads and writes through APPS synonyms. INL_SHIP_HEADERS_ALL, INL_SHIP_LINES, and INL_SHIP_LINES_ALL supply the shipment and line context for which landed costs are calculated. INL_CHARGE_LINES, INL_TAX_LINES, INL_ALLOCATIONS, and INL_ALLOCATIONS_S store the charge definitions, tax components, and allocation bases that drive distribution. INL_ASSOCIATIONS defines parent-child relationships used to propagate charges; it is central to the loop-detection logic. GL_DAILY_RATES and GL_LEDGERS provide currency conversion rates and ledger currency context for CONVERTED_AMT and CONVERTED_PRICE. MTL_UNITS_OF_MEASURE supplies UOM conversion for CONVERTED_QTY. DUAL and PLITBLM are used for scalar evaluation and PL/SQL table handling.

Usage Notes

INL_LANDEDCOST_PVT is referenced by seven other packages, confirming its role as a shared internal service. It is typically invoked from Oracle Landed Cost Management concurrent programs and the landed cost workbench/forms flow when a user submits a calculation for a shipment, and from other INL packages that prepare or validate charge data before posting. Because it is a private API, custom code should not call it directly; the supported approach is to initiate landed cost calculation through the standard concurrent program or public INL API, which in turn drives this package. Direct invocation risks bypassing prerequisite validations (such as association and allocation setup) and is unsupported by Oracle.