Search Results flm_seq_id2name




Overview
Explore in AI Chat

Overview

FLM_SEQ_ID2NAME is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM metadata as an "OTHER" API type. It is associated with Oracle Flow Manufacturing (FLM) functionality, a module within Oracle Manufacturing that supports mixed-model, demand-driven production lines. The package name — "SEQ_ID2NAME" — indicates its primary purpose: translating internal numeric sequence identifiers into their corresponding human-readable sequence names. Flow Manufacturing internally identifies production sequences, attribute sets, and related configuration entities by surrogate numeric IDs. The FLM_SEQ_ID2NAME package resolves those IDs to display names, supporting both programmatic lookups and user-facing list-of-values (LOV) queries within the EBS forms layer.

The package is reported as VALID in the ETRM repository for both 12.1.1 and 12.2.2, and depends only on the SYS.STANDARD package, meaning it relies on core PL/SQL built-ins rather than on other EBS packages at compile time.

Key Procedures and Functions

The ETRM metadata documents six procedures and functions, four of which are publicly named:

  • ID2NAMEINIT — Initialization routine. It prepares internal state (such as cached lookup structures) that the subsequent ID-to-name resolution calls depend upon. It is typically invoked once at the start of a session or a batch of lookups.
  • ID2NAME — The core conversion function. Given a numeric sequence identifier, it returns the corresponding display name. This is the principal entry point for callers needing to resolve an FLM sequence ID to its name.
  • ID2NAMELOVQUERY — Supports the Oracle Forms LOV mechanism. It returns the query result set used to populate a list of values, enabling users to select a sequence by name while the form retains the underlying ID.
  • ID2NAMEATTRIBUTEVALUE — Resolves an ID to a name within the context of a specific sequence attribute, returning the attribute's display value rather than a generic sequence name.

The remaining two documented routines are not separately named in the ETRM excerpt; they follow the same ID-to-name resolution pattern and complete the package's public surface.

Tables Accessed

The package references the following objects through APPS synonyms:

  • FLM_SEQ_ATTRIBUTES — The primary data source. This table stores attribute definitions and values associated with Flow Manufacturing sequences. ID2NAMEATTRIBUTEVALUE in particular reads from this table to map attribute IDs to their descriptive values.
  • DBMS_SQL — The Oracle-supplied dynamic SQL package, used to construct and execute queries at runtime, which allows ID2NAMELOVQUERY to build flexible LOV queries.
  • PLITBLM — A PL/SQL table utility package used for in-memory collection handling, supporting the buffering and iteration over lookup results.

Usage Notes

FLM_SEQ_ID2NAME is an internal utility package rather than a public integration API. It is most commonly invoked from Oracle Forms in the Flow Manufacturing module, where LOV popups and field validations require translating stored sequence IDs into readable names. ID2NAMELOVQUERY is the entry point called by the forms LOV infrastructure; ID2NAME and ID2NAMEATTRIBUTEVALUE are called from form triggers, block-level PL/SQL, or concurrent program logic to render descriptive values.

Custom code should use this package cautiously: it is not documented as a supported public API, it is referenced by no other EBS packages (as confirmed by the ETRM dependency data), and its interface may change between releases. Where a supported alternative exists, it should be preferred. When direct use is required, callers should invoke ID2NAMEINIT first to ensure the lookup structures are initialized, and should avoid caching resolved names across long-lived sessions, since sequence configuration may change. There are no known inbound dependencies within the APPS schema, confirming its role as a leaf-level utility serving the presentation layer.