Search Results flm_ekb_pref_level_seq

Overview

FLM_KANBAN_CONFIG_PARAMS is the configuration access layer for Oracle E-Business Suite's eKanban (electronic Kanban) functionality within the Flow Manufacturing module. The package body, owned by the APPS schema and documented as VALID, provides a centralized mechanism for retrieving Kanban configuration parameters and preference values that drive replenishment, tolerance, and inventory health calculations across the eKanban feature set. Rather than embedding configuration literals directly in Kanban processing logic, the module externalizes these settings into a hierarchical preference framework stored in the FLM_EKB_* tables, and FLM_KANBAN_CONFIG_PARAMS serves as the programmatic interface to that framework.

The package is substantial, exposing thirty-three documented procedures and functions. It is classified as OTHER in the ETRM metadata, indicating it is an internal supporting package rather than a formally published public API. This distinction matters: it is designed for consumption by other eKanban packages and Oracle forms, not as a customer-facing extension point, although the metadata confirms it is referenced by six other packages.

Key Procedures and Functions

The documented routines cluster into several functional groups. The preference retrieval routines form the core: GET_PREFERENCE_LEVEL_ID resolves the active preference level applicable to a given context, while GET_PREFERENCE_VALUE_CODE and GET_PREFERENCE_VALUE return the configured value in coded and decoded form respectively. GET_RESULT_VALUE_CODE supports conversion of results into lookup-coded representations.

Tolerance and range routines govern Kanban sizing and signal sensitivity. GET_KANBAN_TOL_FS_PROD, GET_KANBAN_TOL_FS_INTER, GET_KANBAN_TOL_FS_INTRA, and GET_KANBAN_TOL_FS_SUPPLIER return tolerance factors segmented by production, inter-org, intra-org, and supplier replenishment sources. GET_TOL_KANBAN_TRANSFER returns the tolerance applied to transfer Kanbans. GET_DEMAND_RANGE_DAYS and GET_DEMAND_TOLERANCE, together with GET_LT_RANGE_DAYS and GET_LT_TOLERANCE, define the historical windows and variance thresholds used in demand and lead-time analysis.

Inventory and replenishment health routines include GET_GOOD_INV_HEALTH_PER and GET_BAD_INV_HEALTH_PER, which define the percentage boundaries classifying inventory health, and GET_DIST_DEPLOYMENT, which returns distribution deployment configuration. GET_DJ_STATUS_REPLENISH and GET_SOURCE_STAGING_SUBINV return replenishment status and staging subinventory settings. Finally, GET_UNMOVEDCARD_LEADTIME and GET_UNMOVEDCARD_ENB_STATUS control the unmoved-card detection feature, specifying the lead-time basis and whether the check is enabled.

Tables Accessed

The package reads configuration data from FLM_EKB_PREFERENCE_DEFINITIONS, which catalogs the available preference parameters; FLM_EKB_PREFERENCE_LEVELS, which defines the hierarchy of levels at which preferences may be set; and FLM_EKB_PREFERENCE_VALUES, which stores the actual configured values at each level. The sequences FLM_EKB_PREF_LEVEL_SEQ and FLM_EKB_PREF_VAL_SEQ supply primary keys for level and value rows respectively. DUAL is used for single-row expression evaluation, and PLITBLM is the standard PL/SQL integer table type used for array handling within PL/SQL constructs. The dependency listing confirms references to MFG_LOOKUPS for lookup validation, FND_MESSAGE for message resolution, FND_LOG and FLM_EKANBAN_LOGGER for diagnostic logging, and FND_FUNCTION for function security checks.

Usage Notes

FLM_KANBAN_CONFIG_PARAMS is invoked internally by other eKanban packages, including the Kanban calculation and processing modules, and is not referenced by any database object outside the APPS schema. Custom code should treat the package as a stable read interface: calling the GET_* routines to obtain configured values is appropriate, but direct dependence on internal logic risks breakage across patches. Because the package resolves preferences through a level hierarchy referencing the FLM_EKB_PREF_LEVEL_SEQ identifier, administrators configure values through the eKanban setup forms, and the package transparently returns the effective value for the requested context.