Search Results ar_bpa_area_items_s

Overview

AR_BPA_SHUTTLE_PKG is an Oracle Applications (APPS) PL/SQL package body that supports the Oracle Receivables Business Process Automation (BPA) subsystem. In Oracle EBS 12.1.1 and 12.2.2, the AR_BPA_* schema objects underpin the configurable "shuttle" and area-item setup used by Receivables process automation and related HTML-based administrative components. The package's specific responsibility is to maintain the mapping between business process automation shuttle items and their corresponding area item definitions — the join that allows the user interface to move selected items between the available and selected lists while persisting each item's configuration attributes to the underlying tables.

The object is a VALID package body owned by APPS. It is a low-level utility package rather than a public API; ETRM classifies it as API classification OTHER. The metadata confirms that AR_BPA_SHUTTLE_PKG is not referenced by any other database object, indicating it is a terminal dependency invoked directly by forms or application code rather than an internal building block used by other packages.

Key Procedures and Functions

The documented package exposes two procedures:

• UPDATE_ITEM_MAP — Handles the update of a single item-mapping record. It is the scalar entry point used when one area item must be inserted, modified, or re-associated within the shuttle configuration.
• UPDATE_ITEM_MAP_ARRAY — Performs the same mapping maintenance for a collection of items in a single call. It accepts a PL/SQL array type (the package depends on ITEM_VARRAY and PUBLIC.PLITBLM, the standard PL/SQL table-of-varchar2 type), enabling bulk processing of user selections submitted from a multi-select shuttle control.

The two procedures are complementary: the array form is used when a user commits a batch of moved items, while the scalar form services individual row-level operations. No parameter lists are documented in the ETRM metadata, and therefore none are asserted here.

Tables Accessed

The package's dependency list identifies the following underlying objects, all reached through APPS synonyms:

• AR_BPA_AREA_ITEMS and AR_BPA_AREA_ITEMS_S — the base table and its _S companion. The _S suffix in EBS designates the table that stores translated or descriptive (TL-style) columns for the entity, so the package reads/writes both the transactional mapping rows and the associated descriptive text.
• AR_BPA_ITEMS_B — the base (non-translated) item definition table that supplies the item identifiers being mapped into each area.
• PLITBLM — the standard Oracle PL/SQL table type used to pass arrays of item identifiers and values between the calling form and the package.

No other application tables are referenced. Because the object is not referenced by any other database object, it does not participate in a wider server-side call graph.

Usage Notes

AR_BPA_SHUTTLE_PKG is invoked from the client or middle-tier form that presents the Business Process Automation shuttle interface, most likely a Receivables setup or administration form that renders available and selected item lists. The typical flow is: the form builds a PL/SQL table of item identifiers, and on save calls UPDATE_ITEM_MAP_ARRAY to persist the entire selection set; discrete row edits are committed through UPDATE_ITEM_MAP.

Because the package logs through FND_LOG (as shown by the dependency on the FND logging package), diagnostic information is written to the standard EBS logging framework, and concurrent or form-level debug can be enabled through the standard FND: Debug Log profile options.

The object is not a supported public API. Customizations should not call AR_BPA_SHUTTLE_PKG directly; any extension of Receivables business process automation should be implemented against the documented AR_BPA_* base tables. Note that the search term ar_bpa_area_items_s corresponds to the translated companion table this package maintains, confirming that AR_BPA_AREA_ITEMS_S is the primary target of the mapping update logic.