Search Results lock_misc_receipt




Overview
Explore in AI Chat

Overview

ARP_PROCESS_MISC_RECEIPTS2 is a public PL/SQL package body owned by APPS within the Oracle E-Business Suite Receivables (AR) module. Its sole purpose is to implement the server-side logic that supports the Miscellaneous Receipts form (ARREMT2B) and any related processing that manipulates miscellaneous cash receipts. The package encapsulates the database operations required to lock, validate, and delete miscellaneous receipt records in a multi-user environment, ensuring that what the end user views on the form is consistent with what is stored in the underlying tables at the moment of submission. The package header comment identifies the source file as ARREMT2B.pls and notes revision 120.12.12010000.2, providing version lineage for the deployment.

Key Procedures and Functions

The documented public procedures and functions are three in total:

  • REVISION — A standard informational function that returns the package revision string. It is used for diagnostic and version verification purposes, allowing support and administrators to confirm which source revision is active in the database.
  • LOCK_MISC_RECEIPT — The central procedure of the package. As described in the inline documentation, it locks a miscellaneous receipt for update and checks whether the values displayed on the form are still the ones stored in the database. This implements optimistic concurrency control: before a user is permitted to modify a receipt, the procedure compares the form's current field values against the persisted record and raises an error if a concurrent change has occurred. The procedure accepts a large set of parameters covering the cash receipt identifier, currency, amount, receivables transaction, payment source, receipt number, receipt date, GL date, comments, exchange rate type/rate/date, and the descriptive flexfield attribute columns (attribute category through attribute15). A modification note indicates that a receipt status parameter was added in February 2003 under Bug 2688648.
  • DELETE_MISC_RECEIPT — Removes a miscellaneous receipt and performs the associated cleanup of dependent records. It is invoked when a user deletes a receipt from the Miscellaneous Receipts form.

Tables Accessed

According to the documented package metadata, ARP_PROCESS_MISC_RECEIPTS2 references the following tables through APPS synonyms:

  • AR_CASH_RECEIPTS — The primary receipt header table; holds receipt number, date, amount, currency, and receipt attributes.
  • AR_CASH_RECEIPT_HISTORY — Tracks status and history changes for each cash receipt.
  • AR_DISTRIBUTIONS — Stores accounting distribution lines generated from the receipt.
  • AR_MISC_CASH_DISTRIBUTIONS — Holds the distribution detail specific to miscellaneous cash receipts.
  • AR_PAYMENT_SCHEDULES — Records the receivable payment schedule rows associated with the receipt.
  • AR_SYSTEM_PARAMETERS — Supplies system-level Receivables setup values used during validation and processing.
  • DUAL — Used for simple singleton queries and PL/SQL initialization.

Usage Notes

This package is invoked primarily by the Oracle Receivables Miscellaneous Receipts form to implement record locking prior to update and to handle deletion. In Oracle EBS 12.1.1 and 12.2.2 the form calls LOCK_MISC_RECEIPT whenever a user attempts to modify a displayed receipt, and calls DELETE_MISC_RECEIPT when a receipt is removed. Because the procedures are PUBLIC and classified as an API (OTHER), they may also be called from custom concurrent programs or third-party code that programmatically manipulates miscellaneous receipts, provided the caller supplies the complete parameter set expected by LOCK_MISC_RECEIPT. The package is not referenced by any other documented package in the ETRM inventory, so callers should treat it as a form-support utility rather than a general-purpose integration API.