Search Results ar_interim_cash_receipt_lines




Overview
Explore in AI Chat

Overview

ARP_CR_ICR_LINES_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that encapsulates insert, update, delete, fetch, and locking logic for the AR_INTERIM_CASH_RECEIPT_LINES table. This table stores the individual detail lines belonging to interim (unposted) cash receipts held in the AR_INTERIM_CASH_RECEIPTS header table. Together these interim tables represent receipt data captured in Oracle Receivables before it is validated and transferred into the permanent AR_CASH_RECEIPTS and AR_CASH_RECEIPT_HISTORY tables. The package declared with AUTHID CURRENT_USER therefore provides the canonical low-level access API for maintaining interim receipt lines while enforcing concurrency control and row-level locking discipline. It is an internal "OTHER" classified package rather than a formal public API, and its two overloaded insert procedures allow a line to be created either through a fully populated record or with an explicit parent receipt identifier.

Key Procedures and Functions

  • SET_TO_DUMMY — Initializes an interim cash receipt line record with dummy/default values, typically used to seed a %ROWTYPE variable before population.
  • INSERT_P — Inserts a new interim cash receipt line. Two overloads exist: one returns the generated row ID and cash receipt line ID, and one accepts the parent cash receipt ID explicitly and returns the new line ID.
  • UPDATE_P — Updates an existing interim receipt line identified by its receipt line ID, batch ID, and cash receipt ID, using the supplied record as the source of new column values.
  • DELETE_P — Deletes a single interim cash receipt line, identified by parent interim receipt ID and line ID.
  • DELETE_FK — Performs a foreign-key style delete of all lines belonging to a given parent interim cash receipt ID, used when cascading removal from the header.
  • LOCK_P — Acquires a row-level lock on a specified interim cash receipt line, blocking until the lock is available.
  • NOWAITLOCK_P — Attempts to lock a line without waiting, allowing the caller to proceed or fail immediately if the row is busy.
  • FETCH_P — Retrieves a single interim cash receipt line record into an output %ROWTYPE variable by line ID.
  • LOCK_FETCH_P — Combines locking and retrieval, returning the locked line record.
  • NOWAITLOCK_FETCH_P — Combines non-blocking locking with retrieval of the line record.

Tables Accessed

The package operates primarily on AR_INTERIM_CASH_RECEIPT_LINES, which holds the line detail and is the target of all insert, update, delete, and fetch operations. It references AR_INTERIM_CASH_RECEIPTS as the parent header, used for parent-key validation and cascade deletes. AR_SYSTEM_PARAMETERS supplies Receivables system configuration and default settings applied during record initialization, and DBMS_SQL is referenced to support dynamic SQL requirements within the package's processing.

Usage Notes

ARP_CR_ICR_LINES_PKG is an internal Receivables package invoked primarily by Oracle's own Receivables forms and concurrent programs that manage interim cash receipts, particularly the receipt entry and QuickCash flows and the posting process that migrates interim data into the permanent receipt tables. Custom integrations should generally avoid direct calls and instead use supported Receivables APIs, since the package enforces locking semantics that legitimate callers must respect. When custom code must manipulate interim receipt lines, callers should use the appropriate INSERT_P, UPDATE_P, or DELETE_P overload and observe the LOCK/ NOWAITLOCK conventions to prevent concurrency conflicts on the same interim receipt line.