Search Results synchronize_taxlines

Overview

ZX_TRL_PUB_PKG is the public PL/SQL package in Oracle E-Business Tax (EBS Tax / ETRM) that serves as the repository management interface for tax lines and tax distributions. Defined with AUTHID CURRENT_USER and owned by APPS, it exposes procedures used to create, update, delete, cancel, freeze, and synchronize tax lines and summary tax lines held in the tax repository. The package is a foundational component of the tax calculation and tax warehouse architecture, bridging transactional events (such as payables invoices, receivables transactions, and purchasing documents) with the persistent tax lines stored in ZX_LINES and its related tables. Documented API classification is OTHER, and the package is referenced by three other packages, indicating it acts as a shared service layer within the tax module rather than a standalone utility.

Key Procedures and Functions

The documented interface exposes twelve procedures and functions. The flagship API, MANAGE_TAXLINES, creates, updates, deletes, and cancels tax lines and summary tax lines in the tax repository; it accepts an event class record and returns a status code. SYNCHRONIZE_TAXLINES updates the tax repository to reflect current transactional state. DOCUMENT_LEVEL_CHANGES handles deletion, cancellation, and purging of tax lines at the document level. MARK_TAX_LINES_DELETE flags tax lines for removal. MANAGE_TAXDISTRIBUTIONS and FREEZE_TAXDISTRIBUTIONS govern the creation and locking of tax distribution records. UPDATE_TAXLINES refreshes existing tax line records, while DISCARD_TAX_ONLY_LINES removes tax-only lines that carry no corresponding distribution. UPDATE_GL_DATE propagates corrected accounting dates to tax lines, and UPDATE_EXCHANGE_RATE — the procedure most commonly searched by name — refreshes the exchange rate applied to tax lines and their associated distributions, ensuring tax amounts are restated consistently when currency conversion factors change. DELETE_TAX_LINES_AND_DISTS and DELETE_TAX_DISTS provide targeted removal of tax lines with and without related distribution rows. Earlier revisions replaced IN parameters for line PL/SQL tables with global temporary tables and added NOCOPY hints on OUT parameters for performance.

Tables Accessed

The package operates against tax repository and payables tables accessed through APPS synonyms. ZX_LINES and ZX_LINES_SUMMARY are the core tax line and summary stores that every maintenance procedure ultimately affects. ZX_REC_NREC_DIST holds recoverable and non-recoverable tax distributions, and AP_SELF_ASSESSED_TAX_DIST_ALL stores self-assessed tax distributions on payables documents. AP_INVOICE_DISTRIBUTIONS_ALL supplies invoice distribution context used when tax lines and their accounting must align. ZX_EVNT_CLS_MAPPINGS maps event classes to their processing rules, supporting the event-driven entry points. ZX_TRX_HEADERS_GT and PLITBLM are global temporary objects used for in-session staging of transaction headers and line collections, reflecting the package's redesign away from in-memory PL/SQL table parameters.

Usage Notes

ZX_TRL_PUB_PKG is invoked primarily through Oracle EBS Tax forms and concurrent programs, and indirectly by the three packages that reference it. The UPDATE_EXCHANGE_RATE procedure is typically called during invoice or transaction adjustment processing when the exchange rate on a source document is corrected and the resulting tax amounts must be recalculated and restated in the repository. MANAGE_TAXLINES and SYNCHRONIZE_TAXLINES are called by tax calculation and tax warehouse processes. Custom code should treat all procedures as public APIs and rely only on documented signatures; the global temporary table design means callers must populate the appropriate staging structures before invocation. Because the package uses AUTHID CURRENT_USER, execution is subject to the privileges of the calling schema rather than the APPS owner.