Search Results delete_hier_version
Overview
APPS.FEM_HIER_UTILS_PVT is a private (PVT) PL/SQL utility package belonging to the Oracle Enterprise Performance Management / Enterprise Resource Planning (EPM/ERP) "FEM" Application component, which supports the definition, maintenance, and manipulation of enterprise hierarchies within Oracle E-Business Suite 12.1.1 and 12.2.2. The package encapsulates the core internal logic used to build, expand, duplicate, and restructure hierarchy trees stored in the FEM hierarchy tables. It is classified as a Private API, meaning its interfaces are intended for internal consumption by other FEM packages rather than for direct invocation by external callers. The header comment ($Header: FEMVDHUS.pls 120.4) confirms it originated as part of the FEM hierarchy utility module and was last shipped in the 12.x code line.
Key Procedures and Functions
The package exposes 39 documented procedures and functions. The central ones include:
- FLATTEN_FOCUS_NODE, FLATTEN_FOCUS_NODE_TREE, FLATTEN_WHOLE_HIER_VERSION, FLATTEN_WHOLE_HIER_VERSION_CP, FLATTEN_FOCUS_NODE_CP — expand (flatten) a focus node or an entire hierarchy version into its constituent member rows, with the "_CP" variants being concurrent-program wrappers.
- UNFLATTEN_FOCUS_NODE_TREE — reverses a flatten operation by restoring the parent/child relationships of a focus node tree, accepting parent and immediate-child identifiers along with an operation code.
- INSERT_ROOT_NODE, ADD_NODES, ADD_ROOT_NODES — add members to a hierarchy, either beneath an existing node or as new root-level entries.
- REMOVE_NODES, MOVE_NODES — delete members or re-parent members within a hierarchy.
- DUPLICATE_HIERARCHY, DUPLICATE_HIER_VERSION — copy an entire hierarchy definition or a single hierarchy version, supported by LAUNCH_DUP_HIER_PROCESS and LAUNCH_DUP_HIER_VER_PROCESS.
- DELETE_HIERARCHY, DELETE_HIER_VERSION — remove hierarchy definitions or versions, supported by LAUNCH_DEL_HIER_PROCESS and LAUNCH_DEL_HIER_VER_PROCESS.
- HIER_MEMBER_SEQUENCE_UPDATE — re-sequence display order of members within a hierarchy.
Following Oracle's API conventions, the public procedures consistently accept p_api_version, p_init_msg_list, p_commit, and p_validation_level as inputs and return x_return_status, x_msg_count, and x_msg_data as standard outputs.
Tables Accessed
The package reads and writes the FEM hierarchy schema via APPS synonyms, including FEM_HIERARCHIES, FEM_HIER_DEFINITIONS, FEM_HIER_DIMENSION_GRPS, and FEM_HIER_VALUE_SETS, which store hierarchy metadata; FEM_COST_OBJECTS, FEM_COST_OBJECTS_HIER, FEM_COST_OBJECTS_HIER_S, and FEM_COST_OBJ_HIER_QTY, which store cost-object hierarchy members and quantities; and the per-dimension hierarchy tables FEM_ACTIVITIES_HIER, FEM_CAL_PERIODS_HIER, FEM_CCTR_ORGS_HIER, FEM_CHANNELS_HIER, FEM_CUSTOMERS_HIER, FEM_ENTITIES_HIER, and FEM_GEOGRAPHY_HIER, which hold the actual flattened member rows for each hierarchy dimension.
Usage Notes
Because FEM_HIER_UTILS_PVT is a private package, it is not intended for direct customer invocation. It is referenced by three other FEM packages (including the public hierarchy APIs and concurrent-program drivers) and is invoked from hierarchy maintenance forms, hierarchy-related concurrent programs (through the _CP wrappers), and internal business logic during hierarchy duplication, deletion, and re-sequencing operations. Customizations should call the corresponding public FEM hierarchy API rather than this package; direct calls bypass the supported interface contract and are not upgrade-safe across 12.1.1 and 12.2.2.