Search Results qualifier_list

Overview

APPS.OE_INLINE_FLEX is a private PL/SQL package body used by Oracle Order Management to build, populate, and read the descriptive flexfield structures attached to order and location records. Its central purpose is to manage the runtime representation of an inline flexfield: the concatenated display of enabled key flexfield segments, the qualifier assigned to each segment, and the list of active segment numbers available for a given flexfield structure. Rather than exposing a public API, the package is invoked internally by Order Management forms and validation logic that must render flexfield segments inline and then break the resulting concatenated value back into its constituent parts.

The package declares several indexed collection types (numeric, date, varchar2, and char tables indexed by binary_integer) and corresponding package-level variables such as flex_name, flex_num, flex_column_name, flex_qualifier, flex_prompt, flex_pos, list_segs, and the scalar pointers flex_start, flex_end, flex_id, flex_short_name, flex_separator, and flex_segments. These globals hold the cached flexfield definition for the duration of a session call sequence. The package also declares a user-defined exception, no_qualifier, raised when a requested qualifier cannot be resolved from the flexfield definition.

Key Procedures and Functions

• INITIALIZE — Resets the package-level collections and scalar variables so that a fresh flexfield definition can be loaded without residual data from a previous structure.
• SETUP_FLEXFIELD — Loads the flexfield definition for a supplied flex code and structure identifier. It joins FND_FLEX_VALUE_SETS, FND_ID_FLEX_SEGMENTS_VL, FND_SEGMENT_ATTRIBUTE_VALUES, and FND_ID_FLEX_STRUCTURES to populate the segment number, column name, value set name, prompt, qualifier, delimiter, and position collections.
• TOKEN_EXPAND — Expands a tokenized flexfield expression into its resolved segment references, supporting the parsing of concatenated values.
• DELIMIT — Applies the concatenated segment delimiter retrieved from the flexfield structure to split or delimit a concatenated flexfield string.
• ADD_TO_LIST — Appends a segment number to the maintained list of active segments.
• QUALIFIER_LIST — The routine associated with the search term "qualifier_list". It returns the qualifier values associated with the currently loaded flexfield segments, drawn from the segment attribute values. It is used to identify segments carrying a particular qualifier attribute, such as those flagged with an attribute value of 'Y', so that downstream inline-flex processing can act on qualified segments only.
• EXPAND — Produces the expanded or concatenated form of the flexfield value using the resolved segment list, delimiter, and prompts.
• ACTIVE_SEGMENTS — Returns the set of enabled segments for the loaded structure, honouring the enabled_flag on the segment definition.

Tables Accessed

The package reads flexfield metadata from FND_FLEX_VALUE_SETS (value set names), FND_ID_FLEX_SEGMENTS_VL (segment number, application column name, form prompt, enabled flag), FND_SEGMENT_ATTRIBUTE_VALUES (segment attribute/qualifier values), and FND_ID_FLEX_STRUCTURES (the concatenated segment delimiter). Order Management and Receivables system parameters are read from AR_SYSTEM_PARAMETERS and AR_SYSTEM_PARAMETERS_ALL to obtain the operative flexfield structure and related setup values. All access is through APPS synonyms and is read-only.

Usage Notes

OE_INLINE_FLEX is an internal helper, not a public API. It is referenced by zero other documented packages at the ETRM level and is invoked by Order Management inline flexfield processing within the forms layer and by validation routines that must reconcile concatenated flexfield values against their segment definitions. Custom code should not call this package directly; developers needing equivalent behaviour should use the supported FND flexfield APIs. The package is identical in behaviour between 12.1.1 and 12.2.2, with the file header dating to 2006.