Search Results delete_dist_cover




Overview
Explore in AI Chat

Overview

The APPS.ARP_DELETE_DIST_COVER package body is a Receivables (AR) utility that provides a single documented programmatic entry point for removing a distribution line from the Oracle E-Business Suite accounting distribution model. Its name — "delete dist cover" — indicates that it acts as a wrapper or "cover" routine that centralizes the logic, validation, and error handling required to delete a row from the receivables distribution table, rather than allowing callers to issue a direct DELETE against the underlying data.

The package header carries the revision identifier $Header: ARTLGDDB.pls 115.4 2003/10/10 ..., confirming that it has been part of the AR product since the earliest releases and remained largely stable through 12.1.1 and 12.2.2. It is classified in the ETRM documentation as OTHER rather than as a public or private API, which reflects its role as an internal-support utility rather than a formally supported integration interface.

Key Procedures and Functions

  • DELETE_DIST_COVER — The sole documented procedure in the package. Its stated purpose is to convert column-level parameter values into a distribution record and to delete that distribution line. It accepts a large set of inbound (IN) parameters that mirror the columns of a receivables distribution row, including the distribution identifier, the parent transaction and transaction-line identifiers, the salesrep reference, the account class, monetary and percentage amounts (percent, amount, accounted amount), GL dating attributes (GL date, original GL date, GL posted date), the accounting flexfield reference (code combination ID and concatenated segments), deferred-tax collected-tax references, descriptive comments, the account set and latest-record flags, the USSGL transaction code and its context, a full attribute category with fifteen descriptive attributes, the posting control identifier, and contextual form name and form version values. No output parameters or return values are documented. The initial release was authored by Martin Johnson in October 1995; a January 1999 revision by Tasman Tang added the collected-tax code combination and concatenated segment parameters to support deferred tax processing. The procedure leverages arp_util.debug for diagnostics, gated by the AFLOG_ENABLED profile option, so that debug output is emitted only when logging is switched on.

Tables Accessed

  • RA_CUST_TRX_LINE_GL_DIST — The Receivables accounting distribution table for customer transactions. This is the only table documented as referenced by the package, accessed through its APPS synonym. It stores the GL distribution lines generated for each transaction line, and is the object against which the delete operation is applied.

Usage Notes

Because ETRM records no other packages referencing ARP_DELETE_DIST_COVER, and because the procedure tracks a form name and form version, its typical invocations are internal. It is most likely called from Receivables transaction and distribution maintenance forms — and from the supporting PL/SQL libraries those forms attach — when a user removes or adjusts a distribution line, and potentially from related concurrent or correction programs that regenerate distributions. In 12.1.1 and 12.2.2 the package remains a private implementation detail of the AR distribution UI layer.

Custom code should not call this package directly. Direct invocation bypasses the form-level validation sequence (account set flags, latest-record flags, posting control checks) on which the procedure depends. Customers requiring supported distribution manipulation should use the documented public AR APIs and the standard Receivables forms instead. Where troubleshooting is needed, the AFLOG_ENABLED profile can be set to enable the arp_util.debug output emitted by this package.