Search Results shipment_dist_deleted_from_oa

Overview

PO_TAX_INTERFACE_PVT is a private PL/SQL package owned by APPS that provides the core tax calculation and tax-line maintenance engine for Oracle Purchasing and Oracle Payables integration. In Oracle EBS 12.1.1 and 12.2.2, it serves as the internal workhorse behind the public tax APIs, orchestrating the calculation, recovery determination, and lifecycle management of tax lines associated with purchase orders, releases, and requisitions. The package maintains a global record type, po_tax_errors_type, together with the G_TAX_ERRORS_TBL table, which accumulates structured error information (error level, document type, document, line, shipment, distribution, and message text) as tax processing executes. This design allows callers to retrieve a consolidated set of validation and processing errors after a batch operation, which is essential when tax is calculated across many documents in a single run.

Key Procedures and Functions

The documented API surface consists of fifteen procedures and functions, several provided in overloaded forms to support both single-document and bulk table-based processing.

• CALCULATE_TAX — Overloaded procedure that drives tax calculation for purchase orders and releases; one signature operates on PL/SQL tables of header and release identifiers for bulk processing, while the other handles a single header/release combination.
• CALCULATE_TAX_REQUISITION — Performs the equivalent tax calculation for requisition headers.
• DETERMINE_RECOVERY_PO, DETERMINE_RECOVERY_REL, DETERMINE_RECOVERY_REQ — Determine recoverable versus non-recoverable tax amounts for purchase orders, releases, and requisitions respectively.
• CALCULATE_TAX_YES_NO — Function returning a flag indicating whether tax should be calculated for a given header, release, or requisition combination.
• SHIPMENT_DIST_DELETED_FROM_OA — Handles the deletion of shipments and distributions originating from Oracle Applications, keeping tax records consistent.
• INITIALIZE_GLOBAL_ERROR_RECORD — Resets the global error record before a new tax processing cycle.
• APPEND_ERROR — The user-searched procedure; appends a structured error entry to G_TAX_ERRORS_TBL, capturing the error level, document type code, document, line, shipment, distribution identifiers, and message text so that callers may report all tax failures encountered.
• ANY_TAX_ATTRIBUTES_UPDATED — Detects whether tax-relevant attributes have changed, triggering recalculation.
• CANCEL_TAX_LINES — Cancels existing tax lines when documents are modified or voided.
• GLOBAL_DOCUMENT_UPDATE — Applies document-level updates across affected tax records.
• UNAPPROVE_DOC_HEADER and UNAPPROVE_SCHEDULES — Revert approved documents and schedules to a state requiring tax re-evaluation.

Tables Accessed

The package reads and writes a broad set of Purchasing and reference tables through APPS synonyms. Document tables include PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, PO_DISTRIBUTIONS_ALL, and PO_RELEASES_ALL, which supply the transaction structure against which tax is computed. Requisition data is drawn from PO_REQUISITION_HEADERS_ALL, PO_REQUISITION_LINES_ALL, and PO_REQ_DISTRIBUTIONS_ALL. Reference data includes FINANCIALS_SYSTEM_PARAMS_ALL for tax and financial options, FND_CURRENCIES for currency attributes, HR_ALL_ORGANIZATION_UNITS for operating unit context, HZ_PARTY_SITES for supplier site and location information, and MTL_SYSTEM_ITEMS_B plus MTL_UNITS_OF_MEASURE for item and UOM attributes. PO_SESSION_GT provides session-level global temporary storage used during processing.

Usage Notes

As a PVT (private) package, PO_TAX_INTERFACE_PVT is not intended for direct invocation by external custom code; it is called internally by Purchasing forms, concurrent programs, and higher-level public tax APIs during document entry, approval, and tax recalculation workflows. It is referenced by 18 other packages, reflecting its central role in the tax processing chain. Developers investigating the "append_error" search term should note that APPEND_ERROR is the mechanism by which tax processing failures are collected into G_TAX_ERRORS_TBL; because the package includes a global record and error table, callers must invoke INITIALIZE_GLOBAL_ERROR_RECORD before each processing cycle and inspect the accumulated rows afterward to surface actionable messages. Oracle does not guarantee the stability of PVT package signatures across patches, so customizations should avoid direct dependencies on these procedures.