Search Results item_varray

Overview

AR_BPA_SHUTTLE_PKG is a PL/SQL package owned by the APPS schema that supports the Oracle Receivables Business Process Automation (BPA) framework. Business Process Automation provides a rule-driven engine for generating and routing customer-facing documents and interactions, and it depends on a metadata-driven model of "areas," "items," and "templates." Each template defines a presentation layout composed of areas, and each area is populated by items drawn from a library. The shuttle package exists to manage the mapping of items into those areas at runtime.

The package heading carries an internal revision marker of 120.1, last updated in 2004, which places it among the stable, long-lived utility packages that have persisted unchanged through EBS 12.1.1 and 12.2.2. It is classified as an OTHER API, meaning it is not a public, formally supported extension point, but rather an internal worker invoked by the BPA setup and configuration layers. The "shuttle" naming reflects its role in moving, reassigning, or re-parenting items between areas within a template — conceptually a shuttle between containers.

Key Procedures and Functions

The package exposes two documented procedures. Both share the same conceptual purpose — inserting, updating, or removing the association between an item and an area within a given template — but differ in how the item is specified.

• UPDATE_ITEM_MAP — Maintains a single item-to-area mapping. It accepts a template identifier, the area code, an optional new parent area code, an optional secondary application identifier, an optional display level, an optional item identifier, an optional display sequence, and a DML operation indicator that determines whether the mapping is inserted, updated, or deleted. It returns a status value to the caller.
• UPDATE_ITEM_MAP_ARRAY — Performs the same maintenance function for a collection of items in one call, accepting an item identifier list in place of a single item identifier. This bulk form is intended for multi-select operations in the setup user interface, where several items are shuttled at once.

Both procedures use defaulted parameters for the optional attributes, allowing callers to change only the parent area or display sequence without resupplying every attribute. Neither procedure is documented as returning a value other than the status out parameter.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• AR_BPA_AREA_ITEMS — The primary intersection table holding area-to-item assignments. This is the table the procedures maintain.
• AR_BPA_AREA_ITEMS_S — The shadow or sequence table associated with AR_BPA_AREA_ITEMS, used to generate or track primary key and ordering values for new mapping rows.
• AR_BPA_ITEMS_B — The base table of the BPA item library, referenced to validate that an item identifier exists before it is mapped into an area.
• PLITBLM — The PL/SQL internal table manager, used to process the item identifier list passed to the array variant of the procedure.

The metadata records no dependencies in the reverse direction: zero other packages reference AR_BPA_SHUTTLE_PKG, confirming it sits at the top of its call chain rather than in the middle of one.

Usage Notes

AR_BPA_SHUTTLE_PKG is invoked from the Receivables BPA template and area setup forms when a user moves items between areas, changes display sequencing, or re-parents an area. The DML operation parameter is populated by the form based on the user action, and the resulting status is used to raise or suppress form-level error messages. There is no documented concurrent program or public API entry point for this package.

Because the package is classified OTHER and is not a supported extension interface, custom code should not call it directly. Any direct invocation risks conflict with the form's own transaction handling and with the sequence generation performed against AR_BPA_AREA_ITEMS_S. Integrators needing to manipulate BPA area-item mappings should do so through the supported concurrent programs or by inserting into the underlying tables with the same sequencing logic. The package behavior is identical across 12.1.1 and 12.2.2; the 12.2 online patching architecture does not alter its runtime semantics, though editioning and the APPS synonym layer apply as they do to all EBS database objects. Note that references to "shuttering board distributors" are not related to this package — the term "shuttle" here denotes item movement within the BPA metadata model, not building products or trade distribution.