Search Results add_to_list

Overview

APPS.OE_INLINE_FLEX is an Oracle E-Business Suite PL/SQL package that supports inline flexfield handling within Order Management and related flows. Inline flexfields allow users to enter and validate key flexfield combinations directly inside a descriptive or key flexfield field, rather than navigating to a separate flexfield window. This package provides the runtime plumbing that tokenizes free-form flexfield input, resolves qualifier segments, expands the entered values into a fully qualified concatenated flexfield structure, and validates the active segment configuration against the underlying flexfield definitions.

The package header was last revised under version 120.0 (2005/06/01) and remains shipped under the APPS schema. Its API classification is OTHER, meaning it is not published as a public, supported interface for customer extension; it is an internal utility used by Oracle Order Management and its dependent forms and programs. Because it is referenced by zero other packages in the ETRM metadata, its callers are typically Forms-based UI code and inline flexfield validation paths rather than other PL/SQL APIs.

Key Procedures and Functions

• INITIALIZE — Performs package-level startup work, caching or resetting the session state required before flexfield expansion and qualifier handling can occur.
• SETUP_FLEXFIELD — Configures the package for a specific flexfield, accepting a flexfield code and the flexfield structure identifier. This establishes which key flexfield definition and segment structure subsequent operations will use.
• TOKEN_EXPAND — Expands a single word token into its resolved flexfield value, using the token position index to determine which segment or qualifier the token maps to.
• DELIMIT — Identifies and applies the delimiter character that separates qualifier segments from the core segment value within free-form flexfield input.
• ADD_TO_LIST — Appends a value to a delimited string list, supporting accumulation of parsed tokens during expansion.
• QUALIFIER_LIST — Converts a raw qualifier string into a normalized qualifier list suitable for segment resolution.
• EXPAND — Parses a qualifier string using a supplied separator and expands a word into a fully qualified flexfield structure, producing the concatenated segment string used for validation and storage.
• ACTIVE_SEGMENTS — Returns the number of currently active segments in the configured flexfield structure, allowing callers to bound parsing and validation loops.

Tables Accessed

• FND_ID_FLEX_STRUCTURES — Provides the key flexfield structure definition, including the structure identifier configured by SETUP_FLEXFIELD.
• FND_FLEX_VALUE_SETS — Supplies value set definitions that govern validation and value lookup for flexfield segments.
• FND_SEGMENT_ATTRIBUTE_VALUES — Retrieves segment-level attribute settings that control display, validation, and qualifier behavior.
• AR_SYSTEM_PARAMETERS / AR_SYSTEM_PARAMETERS_ALL — Read to obtain Receivables system option settings, particularly flexfield-related configuration shared with Order Management.

Usage Notes

OE_INLINE_FLEX is invoked during entry and validation of inline flexfields in Order Management forms and in the pricing and qualifier resolution paths that depend on flexfield combinations. The typical sequence is to call INITIALIZE, then SETUP_FLEXFIELD with the appropriate flexfield code and structure identifier, followed by DELIMIT, QUALIFIER_LIST, TOKEN_EXPAND, and EXPAND as each entered token is processed. ACTIVE_SEGMENTS and ADD_TO_LIST are helper utilities used while iterating over segments and building the token list.

Because the package is classified OTHER and is not a documented public API, customizations should avoid direct dependency where possible; if direct calls are required, they should be treated as version-sensitive and retested during upgrades between 12.1.1 and 12.2.2, since internal Oracle code may change independently of the public interface set.