Search Results delete_tax_dists

Overview

ZX_NEW_SERVICES_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as an "OTHER" API in the E-Business Tax (ZX) module. It provides the procedural backbone for lifecycle operations performed against E-Business Tax distribution records stored in ZX_REC_NREC_DIST — the table that holds both recoverable and non-recoverable tax distribution lines generated during tax calculation, reversal, and adjustment processing. In EBS 12.1.1 and 12.2.2 the package is compiled with AUTHID CURRENT_USER, and its public specification is declared as a package interface designed to be called by other tax APIs and internal processing flows rather than directly by end users. The package complements the calculation APIs (ZX_API_PUB) by handling post-calculation activities: freezing distributions so they are locked from further recalculation, cancelling tax lines, purging or regenerating tax distributions, and synchronising descriptive flexfield (DFF) attribute values attached to those distributions.

Key Procedures and Functions

The documented interface exposes four procedures:

• FREEZE_TAX_DISTS_FOR_ITEMS — Marks selected tax distribution rows as frozen so subsequent recalculation or adjustment processes do not overwrite them. It operates against a set of transaction line distribution identifiers supplied by the caller.
• CANCEL_TAX_LINES — Cancels tax lines associated with a given transaction or distribution set, typically as part of a reversal or void of a previously calculated tax result.
• DELETE_TAX_DISTS — Removes tax distribution records, allowing them to be regenerated or discarded. This is the procedure most commonly referenced by the search term delete_tax_dists.
• SYNC_TAX_DIST_DFF — Synchronises the descriptive flexfield attribute columns (ATTRIBUTE1 through ATTRIBUTE15 and ATTRIBUTE_CATEGORY) on ZX_REC_NREC_DIST. The package declares a tax_dist_dff_rec_type record and associated index-by tables specifically for DFF attribute handling.

Tables Accessed

The package reads and writes ZX_REC_NREC_DIST, its primary target for distribution deletion, freezing, and DFF synchronisation. It references ZX_LINES, ZX_LINES_SUMMARY, ZX_LINES_DET_FACTORS and its _S sequence to resolve and update the tax lines underlying each distribution. ZX_TRANSACTION_LINES_GT and ZX_TRX_HEADERS_GT act as temporary interface stores for line and header context. ZX_REVERSE_DIST_GT and ZX_TAX_DIST_ID_GT hold transient sets of distribution identifiers and reversal data. ZX_ERRORS_GT captures error messages surfaced through the API return status. ZX_EVNT_CLS_MAPPINGS and ZX_EVNT_TYP_MAPPINGS supply event classification and type mapping metadata used to determine applicable processing rules. DUAL supports single-row computations, and PLITBLM is the standard PL/SQL table lookup used for collection handling.

Usage Notes

ZX_NEW_SERVICES_PKG is invoked by internal E-Business Tax processing logic and by one documented dependent package; it is not exposed through a standard EBS form or a seeded concurrent program. Customisations that need to delete or refresh tax distributions, freeze distributions before adjustments, or push updated DFF values onto distribution rows typically call these procedures from custom concurrent programs, workflow PL/SQL activities, or extension hooks on taxable transaction flow (for example after Payables or Receivables invoice processing). Because the procedures are API-style, callers should pass in IN OUT NOCOPY transaction records such as ZX_API_PUB.transaction_rec_type, supply the standard API_VERSION, INIT_MSG_LIST, COMMIT and VALIDATION_LEVEL conventions, and always inspect X_RETURN_STATUS, X_MSG_COUNT and X_MSG_DATA. When DELETE_TAX_DISTS is used, downstream dependencies such as tax reporting and reconciliation extracts should be revalidated, since removal of distribution rows affects recoverable and non-recoverable tax accounting entries.