Search Results name_value

Overview

The APPS.FLM_SEQ_ID2NAME package body is a utility component within the Oracle E-Business Suite Flow Manufacturing (FLM) module. Its principal business function is to determine whether a given sequencing attribute requires ID-to-Name (ID2Name) translation and, where applicable, to resolve stored internal identifier values into their human-readable display names. This capability supports the Flow Manufacturing sequencing engine, where attributes captured against production lines, schedules, and recommendations must be presented meaningfully to users rather than as opaque numeric keys.

The package implements a dispatch pattern: the outer ID2Name procedure inspects the attribute definition, derives the appropriate base table and column, and delegates the actual translation work to overloaded ID2Name variants. This indirection allows the same public entry point to serve multiple attribute sources without requiring callers to know the underlying table mapping.

Key Procedures and Functions

• ID2NAME — The primary public procedure. It accepts an attribute identifier, initializes the FND message stack when requested, queries FLM_SEQ_ATTRIBUTES to retrieve the attribute type and source column, maps the type to a target table, and returns a single-character flag indicating whether translation applies. It standardizes return status, message count, and message data through the FND_API conventions.
• ID2NAMEINIT — Initialization routine associated with the package's translation logic, establishing any required setup before translation processing begins.
• ID2NAMELOVQUERY — Query routine supporting list-of-values resolution, enabling translated name values to be surfaced in LOV-style selections.
• ID2NAMEATTRIBUTEVALUE — Retrieves and translates the attribute value itself, performing the actual ID-to-name conversion for a specific attribute instance.

Tables Accessed

• FLM_SEQ_ATTRIBUTES — The principal reference table. It supplies attribute_type and attribute_source for a given attribute_id. The attribute type drives the table mapping: type 4 resolves to MTL_SYSTEM_ITEMS, type 5 to OE_ORDER_LINES_ALL, type 6 to MRP_RECOMMENDATIONS, and type 14 to WIP_FLOW_SCHEDULES. The source value identifies the column used in translation.
• DBMS_SQL — The Oracle dynamic SQL package, employed to build and execute translation queries where the target table or column is determined at runtime.
• PLITBLM — The PL/SQL integer table type used for handling collections within the package's internal processing.

Usage Notes

FLM_SEQ_ID2NAME is classified as an OTHER API and is not referenced by any other documented package, indicating it is invoked directly by Flow Manufacturing forms, concurrent programs, or custom extensions rather than through a layered API stack. The user search term "name_value" corresponds closely to the package's output parameter x_id2name, which returns a name value or the literal 'N' when no translation is required.

Callers should note that the procedure follows standard FND_API error handling: on any unexpected exception it returns FND_API.G_RET_STS_UNEXP_ERROR, sets the translation flag to 'N', and logs the exception through FND_MSG_PUB. The message stack is initialized only when p_init_msg_list is passed as a true Boolean value. The NOCOPY hints on the OUT parameters improve performance for larger message payloads.