Search Results reverse_row




Overview
Explore in AI Chat

Overview

APPS.ZX_TRL_DISTRIBUTIONS_PKG is the E-Business Tax (EBTax) maintenance package responsible for managing the rows of the tax recovery/non-recovery distribution table, ZX_REC_NREC_DIST. Within the Oracle EBS 12.1.1 and 12.2.2 architecture, the package functions as the transaction-level persistence API through which taxable transaction distributions are written, amended, audited with a row lock, or removed. It is classified in the ETRM repository under the API classification OTHER, indicating it is an internal maintenance package rather than a public, upward-compatible integration API.

The package owns the full lifecycle of a recovery/non-recovery distribution record: creation, update, locking, deletion, and reversal. Because it also encapsulates recovery override processing and reversal semantics, it is central to the tax calculation results that feed downstream recovery accounting, tax reporting, and reconciliation of recoverable versus non-recoverable tax amounts.

Key Procedures and Functions

  • INSERT_ROW — Creates a new recovery/non-recovery tax distribution record. It accepts the full attribute set needed to describe a distribution line, including transaction identifiers, tax and recovery rate details, recoverable flag, recoverable and non-recoverable amounts in both tax and functional currency, and project, task, award, and expenditure attributes. It returns the new ROWID.
  • UPDATE_ROW — Modifies an existing recovery/non-recovery distribution record identified by its primary key, applying the same attribute set as the insert operation.
  • LOCK_ROW — Obtains a row-level lock on a ZX_REC_NREC_DIST record, establishing serialized access before a subsequent update or delete.
  • DELETE_ROW — Removes a recovery/non-recovery distribution record by primary key.
  • OVERRIDE_RECOVERY — Applies an override to the recovery determination on a distribution, supporting manual or rule-driven changes to the recoverable portion of tax.
  • REVERSE_ROW — Reverses an existing recovery/non-recovery tax distribution. This is the procedure most closely associated with the search term "reverse_row": it is invoked to create the reversing entry that offsets a previously calculated distribution, preserving the audit trail through the reverse flag and the reversed tax distribution identifier carried on the distribution record.
  • LOCK_REC_NREC_DIST_FOR_DOC — Locks the recovery/non-recovery distributions associated with a document, providing document-level concurrency control for batch or document-wide processing.

Tables Accessed

  • ZX_REC_NREC_DIST — The primary table maintained by this package; it stores the recoverable and non-recoverable tax distribution rows created, updated, locked, deleted, and reversed by the above procedures.
  • ZX_LINES — The tax lines table, read to obtain the tax line context against which a distribution is created or reversed.
  • ZX_TAX_DIST_ID_GT — A global temporary table used to stage or collect tax distribution identifiers during bulk distribution processing.
  • PLITBLM — The standard Oracle Applications character-table structure used for passing or parsing tab-delimited character data into PL/SQL.

Usage Notes

ZX_TRL_DISTRIBUTIONS_PKG is an internal component of the E-Business Tax calculation and recovery flow. It is not intended for direct customer invocation; callers should use the supported EBTax APIs. In practice it is invoked programmatically by the tax engine and by other EBTax packages during tax calculation, adjustment, and reversal, and is referenced by three other packages in the ETRM repository. The presence of REVERSE_ROW and LOCK_REC_NREC_DIST_FOR_DOC indicates the package is used both for single-distribution maintenance and for document-level processing where multiple distributions must be secured before reversal or override. Custom code that needs to reverse or override recovery distributions should do so through the documented EBTax interfaces rather than calling these procedures directly, since the package signature is subject to change between patch levels, as evidenced by the header version stamped in the source.