Search Results get_event_class_code

Overview

The APPS.INL_TAX_PVT package body is the private implementation unit of the Oracle E-Business Suite Tax solution delivered through the E-Business Tax / ETRM (E-Business Tax Repository and Maintenance) framework in Release 12.1.1 and 12.2.2. Its primary business function is to derive, prorate, and record tax values associated with procurement and receiving transactions where the tax is calculated outside the standard Payables flow — most notably taxes applied to purchase order (PO) line locations that must be imported into the tax repository. The package header version recorded in the source header (INLVTAXB.pls 120.8.12010000.13, dated 2008/12/09) confirms it is part of the core Oracle inbound tax (INL) module and has been stabilized across the 12.1 and 12.2 code lines.

The package belongs to the PVT (private) API classification, meaning its procedures are intended strictly for internal consumption by other INL/E-Business Tax packages and are not exposed as public integration points. Practically, this means support for direct invocation is limited and Oracle may change the signatures between point releases.

Key Procedures and Functions

Three documented program units are recorded for this package:

• GENERATE_TAXES — Orchestrates the creation of tax lines for the relevant inbound transaction context, drawing on the association and line data held in the INL tables and the tax determination produced for the event class.
• CALCULATE_TAX — Performs the actual tax computation for a given line or grouping, applying the applicable rate and returning the calculated tax amount for subsequent persistence.
• GET_DEFAULTTAXDETATTRIBS — Returns the default tax determinant attributes used when no explicit value is supplied, ensuring that tax determination has the minimum attribute set required by the E-Business Tax engine.

The source excerpt additionally documents the private helper Prorate_TaxValues (version 1.0), which imports tax lines from PO. It accepts a PO line location identifier, functional currency information (currency code, conversion type, conversion date, conversion rate), transaction quantity, and transaction unit price, and returns the prorated tax amount and recoverable tax amount via IN OUT NOCOPY parameters alongside a standard API return status. The proration logic selects quantity and (quantity * unit_price) from PO_LINE_LOCATIONS and derives a proration rate against the original PO currency basis. Consistent with Oracle API conventions, it initializes x_return_status to FND_API.G_RET_STS_SUCCESS and brackets execution with INL_LOGGING_PVT.Log_BeginProc / Log_Statement debug calls.

Tables Accessed

The package reads and writes the INL staging and transactional tables that hold inbound shipping and tax data: INL_SHIP_HEADERS, INL_SHIP_LINE_GROUPS, INL_SHIP_LINES, INL_CHARGE_LINES, INL_TAX_LINES and its _S (sequence/interface) counterpart, and INL_ASSOCIATIONS / INL_ASSOCIATIONS_S. Sourcing data is read from PO_HEADERS, PO_LINES_ALL, and PO_LINE_LOCATIONS. Tax determination and calculation reference the E-Business Tax engine tables ZX_EVNT_CLS_MAPPINGS, ZX_LINES, and ZX_LINES_DET_FACTORS, with currency validation against FND_CURRENCIES. The presence of ZX_EVNT_CLS_MAPPINGS is directly relevant to the get_event_class_code lookup, since that table maps application event classes to the tax event class codes consumed during tax line generation.

Usage Notes

INL_TAX_PVT is referenced by three other packages and is typically invoked indirectly — from the inbound tax processing flow, from concurrent programs that import PO taxes, or from the receiving and Payables tax integration paths rather than from a user-facing form. Custom code should never call the PVT procedures directly; where extension is required, the recommended approach is to subscribe to the surrounding business events or call the corresponding public E-Business Tax APIs. Debugging is supported through the INL_LOGGING_PVT module, which records procedure entry and statement-level trace information when logging is enabled.