Search Results arp_misc_cash_dist_pkg




Overview
Explore in AI Chat

Overview

ARP_MISC_CASH_DIST_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its status is documented as VALID. The package encapsulates the core database operations for the AR_MISC_CASH_DISTRIBUTIONS entity, which stores the distribution lines that allocate miscellaneous cash receipts across general ledger accounts, accounting flexfields, and related receivable activities in Oracle Receivables. Miscellaneous cash receipts represent funds received that are not tied to a specific customer invoice or debit memo, such as interest income, refunds, or sundry collections. The distribution records created and maintained through this package determine how those receipts are posted to the general ledger.

The package provides a complete CRUD-style programming interface — insert, update, delete, lock, fetch, and a non-blocking fetch variant — allowing Oracle Forms, concurrent programs, and custom integrations to manipulate miscellaneous cash distributions without issuing direct DML against the underlying tables. Because it is not referenced by any other database object, it functions as a terminal application-layer package invoked by external callers rather than an internal dependency of other PL/SQL units. It is, however, referenced by three other packages, indicating reuse across Receivables processing flows. The package relies on ARP_STANDARD, a shared Receivables utility package, for common validation, currency, and accounting logic.

Key Procedures and Functions

Six documented procedures constitute the public interface of the package body:

  • INSERT_P — Creates a new miscellaneous cash distribution row, populating the AR_MISC_CASH_DISTRIBUTIONS records with the supplied receipt, account, and amount attributes.
  • UPDATE_P — Modifies an existing miscellaneous cash distribution row, typically when amounts or accounting flexfield assignments are corrected.
  • DELETE_P — Removes a distribution row, supporting rework and correction of erroneous distributions prior to posting.
  • LOCK_P — Obtains a row-level lock on a distribution record to guarantee exclusive access during a transaction, preventing concurrent modification.
  • FETCH_P — Retrieves a distribution record, issuing the standard locking select used by Oracle Forms blocks to populate fields and manage optimistic locking.
  • NOWAITLOCK_FETCH_P — Fetches a record while attempting to acquire the row lock without waiting; if the row is already locked, control returns immediately, allowing the caller to handle contention gracefully.

These procedures mirror the standard Oracle Application Object Library (AOL) table-handler conventions used throughout EBS, where FETCH_P, LOCK_P, INSERT_P, UPDATE_P, and DELETE_P are bound to Forms block events. The inclusion of NOWAITLOCK_FETCH_P provides a non-blocking alternative for interactive screens where waiting on a locked row would be undesirable.

Tables Accessed

The package references the following tables through APPS synonyms:

  • AR_MISC_CASH_DISTRIBUTIONS — the primary entity table storing miscellaneous cash receipt distribution lines; the target of INSERT_P, UPDATE_P, DELETE_P, and FETCH_P.
  • AR_MISC_CASH_DISTRIBUTIONS_S — the sequence used to generate primary key values for new distribution rows.
  • AR_CASH_RECEIPT_HISTORY — the receipt history table, consulted to track status and activity against the parent cash receipt.
  • AR_SYSTEM_PARAMETERS — the Receivables system options table, read for setup-driven defaults and validation behavior.
  • DUAL — the standard single-row utility table, used for scalar evaluations and sequence-based lookups.

The package also invokes FND_PROFILE for profile-option retrieval and ARP_STANDARD for shared Receivables processing logic and STANDARD for built-in PL/SQL functions.

Usage Notes

ARP_MISC_CASH_DIST_PKG is designed for invocation by Oracle Forms, concurrent programs, and custom PL/SQL code that needs to manage miscellaneous cash distributions in a controlled, validated manner. In a standard EBS configuration the Receivables Miscellaneous Receipts and related distribution forms call these table-handler procedures during block navigation, insertion, update, and deletion, relying on LOCK_P and NOWAITLOCK_FETCH_P to manage multi-user concurrency. Because the package body is documented as not referenced by any other database object, it should be treated as an application programming interface rather than a shared internal library. Custom development should call the documented procedures instead of issuing direct DML, thereby preserving validation and concurrency behavior. As with all APPS-schema package bodies, the compiled body resides in the database; source is maintained in the corresponding EBS product patch and file system, and any modification requires a valid compilation against its declared dependencies.