Search Results adjust_lines

Overview

INL_SHIPMENT_PVT is the private PL/SQL API package for Oracle Landed Cost Management (LCM), exposed under the APPS schema with AUTHID CURRENT_USER. It encapsulates the core business logic used to validate, adjust, match, and complete landed cost shipments within Oracle E-Business Suite 12.1.1 and 12.2.2. Landed Cost Management allows organizations to allocate freight, duty, insurance, and other charges across received goods and to reconcile those charges against supplier invoices and purchase order receipts. INL_SHIPMENT_PVT serves as the workhorse behind the public LCM APIs and the LCM user interface, holding logic that is intentionally not published for direct customer invocation. The package header declares a substantial set of record types — including INL_ASSOC_TP for association records and INL_CHL_LINE_TP for charge-line data spanning parties, sites, tax classifications, and assessable values — reflecting the breadth of shipment and charge processing it supports.

Key Procedures and Functions

The package exposes twenty-five documented procedures and functions. The validation group includes VALIDATE_SHIPMENT, which confirms that a shipment is eligible for processing, VALIDATE_INVOPENPERIOD, which verifies that the inventory accounting period is open, and SET_TOREVALIDATE, which flags records for revalidation. Adjustment procedures include ADJUST_SHIPLINES, ADJUST_CHARGELINES, ADJUST_TAXLINES, and the encompassing ADJUST_LINES, which together recalculate allocated amounts on shipment lines, charge lines, and tax lines.

The quantity group comprises GET_1ARYQTY, GET_1ARY2ARYQTY, and GET_SRCAVAILABLEQTY, which derive primary and available source quantities for allocation. Matching-related procedures include GET_MATCHEDAMT, which returns matched amounts against charge lines, and UPDATE_PENDINGMATCHINGFLAG, which maintains the pending-matching indicator on shipment records. Tolerance checks are handled by CHECK_POTOLERANCES and CHECK_POPRICETOLERANCE.

Shipment lifecycle procedures include COMPLETE_SHIPMENT and COMPLETE_PENDINGSHIPMENT, DISCARD_UPDATES, DELETE_CHARGEASSOC, and PROCESSACTION, which dispatches processing actions. GET_LASTUPDATEDATEFORSHIP returns the last modification date of a shipment for concurrency and audit purposes.

Tables Accessed

The package reads and writes the core LCM tables. INL_SHIP_HEADERS, INL_SHIP_HEADERS_ALL, and INL_SHIP_LINES store shipment definitions and line detail. INL_CHARGE_LINES and INL_CHARGE_LINES_S hold landed cost charge definitions and their translation rows. INL_MATCHES and INL_MATCH_AMOUNTS record the matching of charges to receipts and invoices, and underpin GET_MATCHEDAMT. INL_ASSOCIATIONS and INL_ASSOCIATIONS_S store the association between charges and their parent transactions. INL_ALLOCATIONS contains allocation basis and quantity information, and INL_PARAMETERS holds LCM system parameters. INL_SHIP_HOLDS and INL_SHIP_HOLDS_S store hold information. HZ_PARTIES-related party site tables — HZ_PARTY_SITES and HZ_LOCATIONS — provide party, site, and location validation for shipment and charge records.

Usage Notes

Because this is a private (PVT) API, it is not intended for direct invocation by customers or third-party extensions. It is referenced by four other packages and invoked indirectly through the published LCM public APIs and the Landed Cost Management forms, such as the shipment and charge entry screens. Concurrent programs that process shipment completion, allocation recalculation, and matching also call into this package. Custom code should call the corresponding public LCM APIs rather than INL_SHIPMENT_PVT directly, since private APIs may change between releases without notice. The package relies on FND_API constants for validation levels and uses standard FND message and error-handling conventions.