Search Results bis_pmf_definer_wrapper_pvt




Overview
Explore in AI Chat

Overview

APPS.BIS_PMF_DEFINER_WRAPPER_PVT is a private (PVT class) PL/SQL package within the Oracle E-Business Suite Balanced Scorecard and Performance Management Framework (BIS/PMF). It functions as the definition-side wrapper that encapsulates the create, update, and delete operations for performance measures, targets, target levels, and measure security assignments. Because the package is classified as private, it is not intended for direct invocation by external integrators; rather, it provides a controlled, reusable interface consumed by public packages and user interface components such as the BIS corrective action, indicator region UI, and PMF migration utilities. In Oracle EBS 12.1.1 and 12.2.2 the package resides in the APPS schema with a VALID status and depends on BIS_UTILITIES_PUB, FND_API, and STANDARD for error handling, message stack management, and utility routines.

Key Procedures and Functions

The documented 23 procedures and functions fall into several functional groups. Measure lifecycle routines include CREATE_PERFORMANCE_MEASURE, UPDATE_PERFORMANCE_MEASURE, DELETE_PERFORMANCE_MEASURE, and RETRIEVE_PERFORMANCE_MEASURE, which collectively manage the definition records for performance indicators. Target and target-level routines include CREATE_TARGET, DELETE_TARGET, GET_TARGET_DETAILS, CREATE_TARGET_LEVELS, UPDATE_TARGET_LEVELS, DELETE_TARGET_LEVELS, and GET_TARGET_LEVEL_NAMES, supporting the creation, maintenance, and retrieval of target hierarchies. Security-related routines include CREATE_MEASURE_SECURITY, UPDATE_MEASURE_SECURITY, DELETE_MEASURE_SECURITY, and HAS_TARGET_ACCESS, which govern responsibility-level access to measures and targets. Supporting lookups include GET_TIME_LEVEL_ID and GET_ORG_LEVEL_ID, which resolve dimension level identifiers, and messaging helpers ADD_TO_FND_MSG_STACK, BUILDALERTREGURLTL, and BUILDALERTREGURLTARGET, which build alert registration URLs and stack API error messages. No parameter lists are asserted here; only documented names and their evident purpose are described.

Tables Accessed

The package references five documented tables through APPS synonyms. BIS_DIMENSIONS and BIS_INDICATOR_DIMENSIONS store dimensional definitions and the association between indicators and their dimensions, supporting the measure and target-level logic. BIS_INDICATOR_RESPS holds responsibility assignments that drive the measure security and access routines. BIS_LEVELS stores the level definitions used by GET_TIME_LEVEL_ID and GET_ORG_LEVEL_ID when resolving time and organization level identifiers. PLITBLM is referenced for PL/SQL table or messaging support consistent with the FND message stack helpers. These tables are read and written as part of the measure, target, and security definition workflows.

Usage Notes

BIS_PMF_DEFINER_WRAPPER_PVT is referenced by six other packages: BIS_CORRECTIVE_ACTION_PVT, BIS_INDICATOR_REGION_UI_PVT, BIS_PMF_DEFINER_WRAPPER_PVT itself (recursive/internal reference), BIS_PMF_MIGRATION_PVT, BIS_PMF_PORTLET_UTIL, and BSC_BIS_WRAPPER_PVT, as well as BSC_JV_PMF. It is therefore invoked indirectly through the Balanced Scorecard UI, portlet rendering, migration utilities, and JV integration layers rather than through standalone concurrent programs. Because the package is a PVT wrapper, customizations and extensions should call the corresponding public wrapper packages instead. When troubleshooting definition errors, DBAs and developers should trace calls from the referencing public packages and inspect the FND message stack populated by ADD_TO_FND_MSG_STACK. The package is valid in both 12.1.1 and 12.2.2, and no online patching differences alter its documented dependencies.