Results for “any_tax_attributes_updated”

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

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:

• CALCULATE_TAX, CALCULATE_TAX_REQUISITION, and CALCULATE_TAX_YES_NO drive tax determination and calculation for purchase orders, requisitions, and recalculation triggered by user response to tax-related prompts.
• DETERMINE_RECOVERY_PO, DETERMINE_RECOVERY_REL, and DETERMINE_RECOVERY_REQ resolve recoverable and non-recoverable tax amounts for purchase orders, releases, and requisitions respectively.
• SHIPMENT_DIST_DELETED_FROM_OA handles cleanup of tax records when a shipment or distribution is removed through Oracle Applications flows.
• INITIALIZE_GLOBAL_ERROR_RECORD and APPEND_ERROR manage the global error collection used to report tax validation failures back to the calling process.
• ANY_TAX_ATTRIBUTES_UPDATED determines whether tax-relevant attributes have changed, allowing the caller to skip unnecessary recalculation.
• CANCEL_TAX_LINES removes or reverses previously derived tax lines when a document is cancelled or modified.
• GLOBAL_DOCUMENT_UPDATE applies tax results across all lines and distributions of a document.
• UNAPPROVE_DOC_HEADER and UNAPPROVE_SCHEDULES revert approved documents and schedules to an unapproved state so that tax recalculation can proceed.

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.