Search Results nowaitlock_p

Overview

ARP_APP_PKG is a PL/SQL package in the Oracle E-Business Suite Receivables (AR) module, owned by the APPS schema and declared with AUTHID CURRENT_USER. It provides the low-level data access layer for the AR_RECEIVABLE_APPLICATIONS entity, the central table that records the application of receipts, credit memos, on-account cash, and other transactions against customer transactions. The package encapsulates the insert, update, delete, fetch, and locking operations required to maintain rows in this table, insulating higher-level business logic and form code from direct Data Manipulation Language (DML) against the base table. In the context of a user searching for "ar_receivable_applications," this package is the primary programmatic interface through which application records are created and maintained. Its API classification is OTHER, reflecting that it is an internal infrastructure package rather than a user-facing business API such as AR_RECEIPT_API_PUB.

Key Procedures and Functions

The package exposes a compact set of documented programs, all operating on the AR_RECEIVABLE_APPLICATIONS record structure.

• REVISION — a function returning the package version string, used for diagnostic and support purposes to confirm the deployed code level.
• INSERT_P — inserts a new receivable application row. It accepts a row of AR_RECEIVABLE_APPLICATIONS and returns the generated RECEIVABLE_APPLICATION_ID through an IN OUT parameter. This is the principal entry point for creating an application.
• UPDATE_P — updates an existing application record using the supplied row image.
• DELETE_P — deletes an application identified by its RECEIVABLE_APPLICATION_ID.
• DELETE_F_CT_ID — introduced as a bugfix (2217253), deletes application records associated with a given CUSTOMER_TRX_ID, supporting cleanup when a transaction is removed.
• LOCK_P and NOWAITLOCK_P — acquire a row-level lock on an application record, with the latter using the non-blocking NOWAIT variant, allowing callers to detect concurrent modification rather than wait.
• FETCH_P — retrieves a single application row by RECEIVABLE_APPLICATION_ID into an OUT NOCOPY record.
• COMPARE_FOR_LLCA — a boolean function that compares a UI-supplied application row, used to detect changes relevant to last-level change auditing.

Tables Accessed

The package references several tables through APPS synonyms. AR_RECEIVABLE_APPLICATIONS is the primary table read and written for all application maintenance. AR_RECEIVABLE_APPLICATIONS_S is the corresponding audit/shadow table, populated in support of the audit trail. AR_DISTRIBUTIONS stores the accounting distributions generated when an application is created or updated, and is therefore updated when application amounts change. AR_SYSTEM_PARAMETERS supplies Receivables system option values that govern behavior such as audit-trail activation. XLA_EVENTS is referenced to signal Subledger Accounting events when applications are committed, and DUAL is used for scalar evaluations such as the REVISION function.

Usage Notes

ARP_APP_PKG is an internal package and is not intended for direct customer invocation. It is typically called by higher-level Receivables packages, forms, and concurrent programs — the metadata indicates it is referenced by fourteen other packages. The Oracle Receivables receipts and applications forms invoke these routines when users apply, unapply, or adjust receipt amounts. Concurrent processes such as automatic application and receipt remittance may also drive these procedures. Custom code should generally avoid calling this package directly, because it performs no validation of application business rules; developers requiring validated application processing should use the supported public APIs (for example, AR_RECEIPT_API_PUB) that in turn rely on this layer.