Search Results ar_adjustments_s




Overview
Explore in AI Chat

Overview

The PL/SQL package body APPS.ARP_ADJ_PKG implements the core data-access layer for Oracle Receivables adjustments within Oracle E-Business Suite 12.1.1 and 12.2.2. An adjustment represents a modification to the balance of an invoice, debit memo, chargeback, or deposit, and is a fundamental component of the Receivables transaction model. The package encapsulates the low-level insert, update, delete, locking, and fetch operations required to persist and retrieve adjustment records, shielding callers from direct manipulation of the underlying base tables. Because the package body is owned by the APPS schema and holds a VALID status in the ETRM repository, it is a supported, compiled component of the Receivables application object library rather than user-modified code. The API classification is recorded as OTHER, indicating that it is an internal utility package rather than a public, externally documented API, and it is invoked primarily by Oracle's own forms and concurrent programs rather than by customer extensions.

Key Procedures and Functions

The package body exposes five documented procedures, each providing a discrete database operation against the adjustment entity:

  • INSERT_P — Performs the insertion of a new adjustment record into the Receivables adjustment tables, populating the surrogate and sequence-based identifiers required for the record.
  • UPDATE_P — Applies modifications to an existing adjustment record, enabling changes to the attributes of a previously created adjustment.
  • DELETE_P — Removes an adjustment record from the base tables, supporting the removal or reversal of adjustment data.
  • LOCK_P — Acquires a row-level lock on the target adjustment record, ensuring serialized access and preventing concurrent modification conflicts during multi-step transactions.
  • FETCH_P — Retrieves an adjustment record into the caller's PL/SQL variables, providing the read path used by screens and validation logic.

The consistent _P naming suffix confirms these are procedure-based (not function-based) entry points. Parameter lists are not documented in the available metadata and are therefore not reproduced here.

Tables Accessed

The package body references the following objects, resolved through APPS synonyms:

  • AR_ADJUSTMENTS — The primary base table storing adjustment records; the target of the insert, update, delete, lock, and fetch operations.
  • AR_ADJUSTMENTS_S — The DDL-free sequence/surrogate table that supplies the internal primary key identifier for new adjustment rows.
  • AR_ADJUSTMENT_NUMBER_S — The sequence object that generates the user-facing adjustment number, which is the identifier most commonly surfaced to end users and searched within the application.
  • AR_SYSTEM_PARAMETERS — Supplies Receivables system-level setup values that govern adjustment behavior and defaults during record processing.
  • DUAL — The standard Oracle single-row utility table, used for sequence value selection and similar scalar queries.

Usage Notes

ARP_ADJ_PKG is an internal utility package that is not referenced by any other database object directly, according to the dependency metadata; instead, it is consumed by Oracle Receivables application code, principally the Adjustments form and associated concurrent programs. It is also reported as being referenced by two other packages, indicating reuse within the Receivables PL/SQL layer. Administrators and developers should treat ARP_ADJ_PKG as a private implementation detail: direct invocation from custom code is not recommended, because the supported extension path for adjustments is the public Receivables Adjustments API. The frequent search association with AR_ADJUSTMENT_NUMBER_S reflects the package's role in generating adjustment numbers, making this package relevant when diagnosing numbering gaps, sequence-related errors, or adjustment creation failures in both 12.1.1 and 12.2.2 environments.