Search Results included_items_dml

Overview

APPS.OE_CONFIG_PVT is a private (PVT-classified) PL/SQL package within the Oracle Order Management (OM) module of Oracle E-Business Suite. It encapsulates the internal configuration logic that governs how configured items — that is, items assembled through Oracle Configurator and its associated model/BOM structures — are processed as they flow through the order lifecycle. Configuration processing is a specialized area of Order Management because a configured item is not a single inventory entity but a parent item whose child components, options, and included items must be expanded, validated, priced, and reserved as a coherent group.

The package operates behind the public Order Management APIs and is not intended as a directly callable interface for external consumers. The "PVT" suffix signals that its procedures are internal APIs invoked by sibling and calling packages rather than by customers or integrations. It sits near the center of the order-processing dependency graph, referenced by fifteen other packages in the APPS schema, and itself depending on the public order API OE_ORDER_PUB, the global constants package OE_GLOBALS, the FND_API error-handling framework, and CSI_DATASTRUCTURES_PUB for install-base configuration data structures.

Key Procedures and Functions

The documented package exposes eleven procedures and functions. PROCESS_CONFIG is the principal driver; it coordinates configuration processing for an order line, orchestrating the sub-steps below. DELETE_CONFIG removes configuration data associated with a line, while COPY_CONFIG and COPY_CONFIG1 duplicate configuration detail — for example when a line is copied into a new order. PUT_HOLD_AND_RELEASE_HOLD manages hold application and release behavior specific to configured lines. EXPLODE_BILL expands the configuration bill structure to materialize configurator output into order lines. INCLUDED_ITEMS_DML and MODIFY_INCLUDED_ITEMS perform the insert, update, and delete operations against included-item records within a configuration. CALL_PROCESS_ORDER invokes downstream order processing after configuration changes. CHANGE_COLUMNS handles the selective mutation of configuration columns on the order line. IS_CANCEL_OR_DELETE determines whether a configuration is in a cancelled or deleted state, a prerequisite check before many operations. The private procedure list reflects a tightly scoped internal API rather than a broad functional surface.

Tables Accessed

Through APPS synonyms the package reads and writes the core order line tables OE_ORDER_LINES, OE_ORDER_LINES_ALL, and OE_ORDER_LINES_S, which hold configuration headers and their component lines. MTL_SYSTEM_ITEMS and its key-flex variant MTL_SYSTEM_ITEMS_KFV are queried to resolve item attributes and descriptions for configured items and their components. DUAL supports scalar lookups, and PLITBLM is the standard PL/SQL index-by table used for bulk DML in EBS. These accesses confirm that the package bridges order-line persistence with inventory item definition.

Usage Notes

OE_CONFIG_PVT is invoked internally rather than directly. Calling packages include OE_ORDER_PVT, OE_ORDER_PURGE_PVT, OE_SPLIT_UTIL, OE_MASS_CHANGE_PVT, OE_VALIDATE_LINE, OE_LINE_UTIL, and OE_CONFIG_UTIL, meaning configuration processing is triggered during line validation, order copying, splitting, mass change, purge, and scheduled configuration runs. It is consequently exercised whenever an order containing configured items is entered, changed, copied, split, or purged in the Order Management forms and via the public Order Management APIs. Custom code should use OE_ORDER_PUB rather than this private package, whose signatures are not part of Oracle's supported public interface and may change between releases.