Search Results lines_exists

Overview

ARP_RW_ICR_PKG is a PL/SQL package owned by the APPS schema that supports Oracle Receivables' interim cash receipt (ICR) processing. Interim cash receipts serve as the staging representation of receipt data captured through manual entry, lockbox, or other automated sources before the receipt is finalized and posted to the AR_CASH_RECEIPTS and AR_PAYMENT_SCHEDULES tables. The package encapsulates the row-level data manipulation, validation, and locking logic that forms use when maintaining interim receipt records and their associated application lines.

The package is classified in the ETRM repository as an "OTHER" API, meaning it is an internal helper package rather than a publicly documented Open Interface or public API. Its design centers on providing reusable row-handling primitives — insert, update, delete, and lock — together with validation checks and aggregate queries that Oracle Receivables forms and concurrent processes rely upon when working with interim cash receipt data.

Key Procedures and Functions

The ETRM documentation records eight procedures and functions in ARP_RW_ICR_PKG. Their documented names and purposes are:

• INSERT_ROW — Inserts a new interim cash receipt row, supporting receipt entry into the interim staging structure.
• UPDATE_ROW — Updates an existing interim cash receipt row with modified attribute values.
• DELETE_ROW — Removes an interim cash receipt row that is no longer required.
• LOCK_ROW — Acquires a row-level lock on an interim receipt record to ensure transactional consistency during concurrent access.
• CHECK_UNIQUE_RECEIPT — Validates that a receipt is unique, preventing duplicate receipt creation.
• CHECK_NO_LINES_EXISTS — Verifies that no application lines exist for a given interim receipt, typically used to guard deletion or reversal operations.
• LINES_EXISTS — Determines whether application lines are present for an interim receipt.
• GET_APPLIED_AMOUNT_TOTAL — Returns the total applied amount across lines for an interim receipt, supporting balance and remaining-amount calculations.

These routines collectively form the data-access layer for interim receipt maintenance. The metadata does not document parameter lists; the descriptions above reflect the documented functional intent of each procedure.

Tables Accessed

The package references the following tables through APPS synonyms:

• AR_INTERIM_CASH_RECEIPTS — The primary staging table for receipt header information; the central table for insert, update, delete, and lock operations.
• AR_INTERIM_CASH_RECEIPT_LINES — Stores the application lines associated with an interim receipt, used by LINES_EXISTS, CHECK_NO_LINES_EXISTS, and GET_APPLIED_AMOUNT_TOTAL.
• AR_PAYMENT_SCHEDULES — Holds payment schedule records used to validate and compute applied amounts.
• HZ_CUST_ACCOUNTS — Provides customer account information for validating receipt ownership.
• AR_BATCHES — Supplies batch context for grouped receipt entry.
• AR_CASH_RECEIPTS — The finalized receipt table, referenced when reconciling or promoting interim data.
• AR_SYSTEM_PARAMETERS — Provides system-level settings that govern receipt processing behavior.

Usage Notes

ARP_RW_ICR_PKG is an internal implementation package. The ETRM metadata indicates it is referenced by zero other packages, so it is not a shared dependency within the APPS schema. It is most commonly invoked indirectly by Oracle Receivables forms and receipt-processing concurrent programs that manipulate interim cash receipt data, rather than being called directly by external or customer-written code. Because it performs row-level DML and locking against interim receipt tables, any custom invocation should respect the same transactional and validation ordering the standard forms apply: uniqueness checks and line-existence checks before insert or delete, lock acquisition before update. Direct calls should be treated as unsupported customizations, as the package is not a published API and its signature may change across releases.