Search Results po_tax_interface_pvt




Overview
Explore in AI Chat

Overview

PO_TAX_INTERFACE_PVT is a private PL/SQL package body in the APPS schema that provides the internal tax calculation engine for Oracle Purchasing in Oracle E-Business Suite 12.1.1 and 12.2.2. The package bridges Purchasing transaction data with the E-Business Tax (EBTax) services exposed through ZX_API_PUB and the ZX global temporary tables. It derives tax lines, recovery rates, and tax distributions for purchase orders, releases, and requisitions, supporting both document entry and document modification flows.

Consistent with the PVT classification, the package is not a public API. Its procedures are invoked by other Purchasing packages and by the core Purchasing transaction logic rather than by external integrations. The ETRM metadata confirms that PO_TAX_INTERFACE_PVT is referenced by eighteen other database objects and is not referenced by any object outside its dependency set, reinforcing its role as an internal implementation layer beneath the public Purchasing APIs.

Key Procedures and Functions

The package exposes fifteen documented procedures and functions:

Tables Accessed

The package reads and writes the principal Purchasing transaction tables. PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, PO_DISTRIBUTIONS_ALL, and PO_RELEASES_ALL supply the document, line, shipment, distribution, and release data used in tax determination. PO_REQUISITION_HEADERS_ALL, PO_REQUISITION_LINES_ALL, and PO_REQ_DISTRIBUTIONS_ALL serve the requisition-side calculation paths.

Tax results and errors are persisted through ZX_LINES, ZX_LINES_DET_FACTORS, ZX_TRANSACTION_LINES_GT, ZX_TRX_HEADERS_GT, ZX_ITM_DISTRIBUTIONS_GT, ZX_REC_NREC_DIST, ZX_REC_NREC_DIST_GT, ZX_ERRORS_GT, and ZX_VALIDATION_ERRORS_GT. Supporting lookups include FINANCIALS_SYSTEM_PARAMS_ALL, FND_CURRENCIES, GL_SETS_OF_BOOKS, HR_ALL_ORGANIZATION_UNITS, HZ_PARTY_SITES, MTL_SYSTEM_ITEMS_B, MTL_UNITS_OF_MEASURE, PO_VENDORS, PO_VENDOR_SITES_ALL, and PO_SYSTEM_PARAMETERS_ALL. PO_SESSION_GT and PO_SESSION_GT_S hold session-scoped document context during processing.

Usage Notes

PO_TAX_INTERFACE_PVT is ordinarily invoked indirectly through the Purchasing forms, the Purchasing public APIs, and concurrent processes that create or modify purchasing documents. Oracle E-Business Tax integration is transparent to the user: when a purchase order, release, or requisition is entered, approved, or amended, the Purchasing layer calls into this package to obtain tax lines and distributions.

Customizations should treat the package as private and unsupported for direct invocation. Because it depends on the ZX schema objects and on PO_SESSION_GT session context, callers must first establish the correct session and system parameters. Any direct call should be wrapped in standard FND_API error handling, and the global error record should be inspected after invocation to detect tax validation failures.