Search Results generate_taxes

Overview

INL_TAX_PVT is a private PL/SQL package in the APPS schema that supports Oracle E-Business Suite's international trade and landed cost tax processing, particularly within the context of receiving, shipments, and customs-related tax determination. The "_PVT" suffix indicates that this package is classified as a private API: it is intended for internal use by Oracle's own EBS modules and companion packages rather than as a public integration point for customer extensions. Its principal responsibility is to invoke the E-Business Tax (EBTax) engine to calculate taxes on shipment and receipt lines, and to retrieve default tax detail attributes used when constructing tax lines.

The package is referenced by three other packages, confirming that it functions as a subordinate utility invoked by higher-level landed cost and trade management routines rather than being called directly by end users.

Key Procedures and Functions

• GENERATE_TAXES — Drives the creation of tax lines for a set of shipment or receipt lines. It resolves the applicable tax event class mapping and calls the tax engine to produce the tax lines persisted to INL_TAX_LINES. This is the entry point that orchestrates tax generation for a shipment header and its associated lines.
• CALCULATE_TAX — Performs the underlying tax computation for a given transaction line, applying the tax code, tax classification, and fiscal classification attributes supplied by the caller. It is the workhorse invoked by GENERATE_TAXES to obtain the calculated tax amounts returned to the calling process.
• GET_DEFAULTTAXDETATTRIBS — Returns the default tax detail attributes (tax determinants and factor values) required to build a tax line record. This function is the object the user searched for; it supplies the defaulting logic that determines which tax attributes apply before calculation proceeds, ensuring that tax lines are constructed with complete and consistent detail factors.

Tables Accessed

• INL_SHIP_HEADERS, INL_SHIP_LINES, INL_SHIP_LINE_GROUPS — Source shipment and line data providing the taxable transaction context (dates, parties, quantities, item attributes).
• INL_TAX_LINES, INL_TAX_LINES_S — Target tables where calculated tax lines and their detail records are written.
• INL_CHARGE_LINES, INL_ASSOCIATIONS, INL_ASSOCIATIONS_S — Charge and association records linking shipment lines to tax treatment and cost elements.
• ZX_EVNT_CLS_MAPPINGS — EBTax event class mapping used to determine the correct tax event class for the transaction.
• ZX_LINES, ZX_LINES_DET_FACTORS — EBTax tax line and determinant/factor tables that store the engine's results and the attributes that drove them.
• PO_HEADERS, PO_LINES_ALL, PO_LINE_LOCATIONS — Purchase order data referenced when shipments originate from purchasing documents.
• FND_CURRENCIES — Provides currency attributes for conversion and tax reporting.

Usage Notes

INL_TAX_PVT is an internal package and should not be called directly from custom code; Oracle does not document its parameter signatures as a supported interface. It is invoked by the landed cost and trade management flows during shipment processing, typically after receipt or shipment lines have been created, so that EBTax calculations are persisted before the transaction is finalized and accounted. GET_DEFAULTTAXDETATTRIBS is called internally during tax-line construction to supply default determinants. Because the source header references INL_TAX_PVT as version 120.6.12010000.5 (2008), the package is stable and unchanged across the 12.1.1 and 12.2.2 releases. Developers extending trade tax logic should use the supported EBTax public APIs (ZX_APIs) rather than this private package, and should treat any direct dependency on INL_TAX_PVT as unsupported and upgrade-sensitive.