Search Results flm_routing




Overview
Explore in AI Chat

Overview

FLM_ROUTING is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the generic "OTHER" API category. Its purpose is to support the flow manufacturing and routing copy utilities by retrieving candidate assembly items that satisfy a set of filtering criteria, so that primary routings can be replicated onto them. The package header is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the package owner.

The package declares several public data types that shape its interface: item_tbl_type (an associative array of item IDs indexed by BINARY_INTEGER), item_rtg_type (a record pairing an item_id with a routing designator drawn from BOM_ALTERNATE_DESIGNATORS.ALTERNATE_DESIGNATOR_CODE), and item_rtg_tbl_type (a collection of those records). Two global variables, g_item_tbl and g_tbl_index, are also declared. These structures allow calling programs to receive sets of qualified items in bulk rather than one row at a time.

Key Procedures and Functions

The ETRM metadata documents three procedures:

  • RETRIEVE_ITEMS — Returns a list of items that fulfill the filtering criteria passed in. According to the embedded header comments, the inputs describe the organization, an item name range (lower and higher bounds between which the retrieved item must fall), a product family, a category set and category, a planner code, and an alternate routing designator. The last parameter ensures that a retrieved item does not already have a routing existing for the same item-alternate combination. Output consists of the item ID list and a return code (0 for success, 1 for failure). The procedure is designed to identify assembly items to which a primary routing can be copied, deliberately filtering out items that are not BOM enabled or that already possess a primary routing in order to protect performance.
  • RETRIEVE_OPTION_ITEMS — A companion retrieval procedure, invoked when a user searches for option items. It applies analogous filtering logic to return item sets suitable for routing operations, following the same output pattern as RETRIEVE_ITEMS.
  • RETRIEVE_MASS_CHANGE_ITEMS — Supports mass maintenance of routing data by returning the collection of items eligible for a bulk routing change operation.

Tables Accessed

The package references the following tables through APPS synonyms:

  • BOM_ALTERNATE_DESIGNATORS — Supplies the alternate designator codes used to validate the item-alternate routing combination.
  • BOM_OPERATIONAL_ROUTINGS — Checked to determine whether an item already has an existing routing, which excludes it from retrieval for copy purposes.
  • MTL_ITEM_CATEGORIES — Provides category assignments used when filtering by category set and category.
  • MTL_SYSTEM_ITEMS_KFV — The key flexfield view of item definitions; supplies item names, organization, planner code, and BOM-enablement status.
  • PLITBLM — A temporary/work table used to stage item ID lists during processing.

Usage Notes

FLM_ROUTING is typically invoked from Oracle Forms within the Flow Manufacturing and Bills of Material modules, and from concurrent programs that perform routing copy or mass change operations. Because the package is referenced by zero other packages per the ETRM metadata, it functions primarily as a top-level API called directly by application UI code or custom extensions. The return-code convention (0 for success, 1 for failure) means callers should always inspect the output code rather than relying on exceptions. Custom code invoking the package must run under a user with appropriate APPS-level privileges, since AUTHID CURRENT_USER does not grant definer rights. The header of the source dates to 2004, so the interface has been stable across the 12.1.1 and 12.2.2 releases.