Search Results arp_cr_icr_pkg




Overview
Explore in AI Chat

Overview

ARP_CR_ICR_PKG is an internal Oracle Application Object Library package body owned by the APPS schema that encapsulates the persistence and locking logic shared between the AR_CASH_RECEIPTS and AR_INTERIM_CASH_RECEIPTS entities in Oracle Receivables. Its name reflects that dual responsibility: "CR" for cash receipts and "ICR" for interim cash receipts. Rather than exposing a single business API, the package provides a uniform, low-level DML and synchronization layer that other Receivables components call when they must insert, update, delete, or serialize access to cash receipt records. In Oracle EBS 12.1.1 and 12.2.2 the object is shipped VALID in the APPS schema and is classified as an OTHER API, meaning it is intended primarily for internal use by Oracle-developed forms, concurrent programs, and peer packages rather than as a publicly supported extension point. The presence of AR_CASH_RECEIPTS_S in its dependency list ties it directly to the cash receipts document sequence, and the package participates in receipt numbering, concurrency control, and population of base-table rows from interim data.

Key Procedures and Functions

Ten procedures are documented in the package body. SET_TO_DUMMY establishes the package session state, typically resetting internal global variables or reserving a dummy row context before bulk operations proceed. INSERT_P performs the insert of a cash receipt or interim receipt record. UPDATE_P applies modifications to an existing record, and DELETE_P removes a record. LOCK_P acquires a row-level lock on the target receipt in a wait mode, while NOWAITLOCK_P performs the same lock using a no-wait strategy so the caller can detect contention immediately. FETCH_P retrieves a record and returns its column values to the caller. The paired variants LOCK_FETCH_P and NOWAITLOCK_FETCH_P combine locking and retrieval in a single call, ensuring the fetched image is the locked image and eliminating a race window between the SELECT and the lock. SET_TO_DUMMY, together with the fetch family, supports the standard Oracle Forms-style server-side DML pattern in which a block queries, locks, and mutates receipt rows through this single package rather than issuing direct SQL.

Tables Accessed

The documented dependencies show access to AR_INTERIM_CASH_RECEIPTS, AR_CASH_RECEIPTS_S, AR_SYSTEM_PARAMETERS, DUAL, and DBMS_SQL. AR_INTERIM_CASH_RECEIPTS is the interim staging table where manually entered or imported receipts reside before validation and transfer into the final receipts tables. AR_CASH_RECEIPTS_S is the document sequence table that supplies and validates the receipt number for the cash receipts document category, explaining the package's involvement in numbering. AR_SYSTEM_PARAMETERS is consulted for Receivables system options that govern receipt behavior, such as numbering and defaulting rules. DUAL is used for single-row scalar lookups, and DBMS_SQL indicates that portions of the package build and execute dynamic SQL, likely to construct DML against the appropriate receipt table depending on the calling context. References to ARP_GLOBAL and ARP_STANDARD provide shared constants, error handling, and utility routines from the Receivables foundation layer.

Usage Notes

Because the package is documented as referenced by one other package and is not referenced by any database object outside that scope, it is best understood as an internal implementation package. It is typically invoked from Oracle Receivables forms and from higher-level Receivables APIs and concurrent programs that manipulate cash receipts and interim cash receipts. Practitioners who encounter ARP_CR_ICR_PKG while tracing errors around AR_CASH_RECEIPTS_S should recognize that the failure most often surfaces from the document sequence assignment or from a locking conflict produced by NOWAITLOCK_P or NOWAITLOCK_FETCH_P. Direct calls from custom code are not recommended; supported integration should use the documented Receivables APIs, while the package's procedures remain useful for diagnostics, dependency analysis, and understanding how Receivables serializes and numbers cash receipt records.