Search Results insert_adjust_cover

Overview

ARP_INSERT_ADJ_COVER is an Oracle Receivables (AR) package body owned by the APPS schema. Its documented purpose is to provide the insertion logic for adjustments created through Oracle EBS form-based or programmatic workflows, specifically the operations that build and persist rows in the AR_ADJUSTMENTS table. The package name, containing the token "COVER," indicates that the procedure acts as a covering wrapper around the core adjustment insertion logic, accepting the full set of adjustment column values as input parameters and delegating the physical insert to the underlying Receivables adjustment APIs. As documented in ETRM 12.2.2, the object is classified as OTHER rather than a published public API, and it is not referenced by any other package within the documented metadata. The package header comment reflects a version of 120.2 last shipped in 2008, identifying it as a long-standing component of the Receivables adjustment infrastructure carried forward into 12.1.1 and 12.2.2.

Key Procedures and Functions

The package body exposes a single documented procedure:

• INSERT_ADJUST_COVER — Accepts a comprehensive set of adjustment attributes as input parameters and performs the insertion of an adjustment record. The parameter set includes the form context (form name and form version), the adjustment identity and type (adjustment_id, adjustment_number, adjustment_type), and the monetary values in both entered and accounted form (amount and acctd_amount). It further accepts application and receipt linkage fields (apply_date, associated_application_id, associated_cash_receipt_id), approval and batch context (approved_by, batch_id), chargeback linkage (chargeback_customer_trx_id), the general ledger account reference (code_combination_id), the automatically_generated flag, and the complete set of descriptive flexfield columns (attribute_category and attribute1 through attribute15). Because each parameter is declared using the %TYPE anchor against the corresponding AR_ADJUSTMENTS column, the procedure remains resilient to datatype changes in the base table. The procedure serves as the single insertion entry point for adjustment records in this package.

Tables Accessed

The documented table reference for this package is AR_ADJUSTMENTS, accessed through the APPS synonym. AR_ADJUSTMENTS is the Receivables base table that stores all adjustments applied to invoices, debit memos, chargebacks, and receipts, including manual adjustments, tax adjustments, freight adjustments, and write-offs. The INSERT_ADJ_COVER procedure performs an insert into this table, populating the columns that correspond to its input parameters. No other tables are documented as referenced. The procedure's direct dependency on AR_ADJUSTMENTS means that any insertion performed here bypasses higher-level business validation typically enforced elsewhere; callers are expected to have validated amounts, dates, and accounting combinations before invoking the procedure.

Usage Notes

The parameter naming — notably p_form_name and p_form_version — indicates that INSERT_ADJ_COVER is designed for invocation from Oracle Forms, most plausibly the Receivables Adjustments form, where the form passes its own name and version to the stored program unit. This pattern is characteristic of form trigger code that calls a server-side PL/SQL wrapper to standardize insertion behavior across multiple form entry points. In Oracle EBS 12.1.1 and 12.2.2 environments, the package remains available in the APPS schema, but it is not a supported public API and is not referenced by any other documented package. Consequently, customizations should not rely on it directly; the supported path for creating adjustments programmatically is the AR_ADJUSTMENTS_API or equivalent public interfaces. The procedure should be treated as internal implementation detail of the standard Receivables forms, and any custom code that invokes it must supply a fully populated attribute set, including flexfield columns, to avoid incomplete or non-conforming adjustment records.