Search Results ar_flag_dummy

Overview

ARP_CASH_RECEIPTS_PKG is a core Oracle Receivables package body responsible for the low-level data manipulation, concurrency control, and record retrieval logic applied to the AR_CASH_RECEIPTS entity. In an Oracle EBS 12.1.1 or 12.2.2 environment, this package underpins the persistence layer for cash receipt records — the rows describing payments received from customers, including amount, currency, receipt method, deposit information, and exchange details. The package exposes a family of procedures that isolate insert, update, delete, fetch, and locking operations so that higher-level Receivables APIs, forms, and concurrent programs do not manipulate the base table directly.

The header of the source identifies a central design device: a set of dummy constants declared at package scope. These include AR_TEXT_DUMMY, AR_FLAG_DUMMY, AR_NUMBER_DUMMY, and AR_DATE_DUMMY. They exist to supply placeholder values during update and lock operations, ensuring that columns are not inadvertently overwritten with NULLs and that WHERE clauses can be constructed uniformly. This is the "ar_text_dummy" element referenced in typical searches for the package.

Key Procedures and Functions

The documented package exposes fifteen procedures and functions organized around two concerns: record maintenance and concurrency control.

• SET_TO_DUMMY — Initializes every column of an ar_cash_receipts%ROWTYPE record with the appropriate dummy constant. This guarantees a fully populated, predictable working record before subsequent updates or lock checks. It is invoked internally by the other procedures in this package.
• INSERT_P — Inserts a new cash receipt row into AR_CASH_RECEIPTS.
• UPDATE_P — Updates an existing cash receipt row.
• DELETE_P — Deletes a cash receipt row.
• LOCK_P — Acquires a row lock on a cash receipt identified by primary key.
• LOCK_F_BATCH_ID — Locks the cash receipt associated with a given batch identifier.
• NOWAITLOCK_P — Attempts a row lock without waiting; returns immediately if the row is busy.
• NOWAITLOCK_VERSION_P — Performs a non-blocking lock qualified by the version number column.
• UPDATE_VERSION_NUMBER — Increments or refreshes the version column used for optimistic concurrency.
• NOWAITLOCK_F_BATCH_ID — Non-blocking lock keyed to batch identifier.
• FETCH_P — Retrieves a cash receipt record by primary key.
• LOCK_FETCH_P — Fetches a record while holding a blocking row lock.
• NOWAITLOCK_FETCH_P — Fetches with a non-blocking lock attempt.
• LOCK_COMPARE_P — Compares the current stored column values against a supplied record to detect changes before allowing an update.

Also present is a package-level initialization of WHO audit columns sourced from ARP_GLOBAL, and a debug switch driven by the AFLOG_ENABLED profile option.

Tables Accessed

The package references these APPS synonyms:

• AR_CASH_RECEIPTS — the primary entity table read and written by the fetch, insert, update, and delete procedures.
• AR_CASH_RECEIPTS_S — the sequence used to generate primary keys for new receipts.
• AR_CASH_RECEIPT_HISTORY — records the audit trail of changes applied to a cash receipt.
• AR_BATCHES — supports the batch-identifier lock and lookup variants.
• AR_SYSTEM_PARAMETERS — supplies Receivables configuration values, including default set of books context.
• DUAL — used for single-row select expressions.

Usage Notes

ARP_CASH_RECEIPTS_PKG is referenced by approximately twenty-two other packages in the Receivables schema, making it an internal dependency rather than a public extension point. It is typically invoked from Receivables forms and from higher-level APIs such as AR_RECEIPT_API_PUB when a receipt is created, applied, reversed, or updated. Because the procedures encapsulate locking — both blocking and non-blocking — and version comparison, custom code should call the public Receivables APIs instead of this package wherever possible. When direct use is unavoidable, callers must observe the package's dummy-value convention and the NOWAIT versus blocking variants to avoid unnecessary contention on the cash receipts table.