Search Results get_target_for_level_id




Overview
Explore in AI Chat

Overview

APPS.BIS_PMF_UTILITIES_PUB is a public PL/SQL API package that exposes utility routines for the Oracle Enterprise Planning and Management (EPM) / Performance Management Framework (PMF) subsystem within Oracle E-Business Suite. The package header is defined with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the package owner, and is therefore intended to be called from application schemas or custom code operating in an APPS-authenticated session. Its documented purpose, as recorded in the source header, is simply "Public API for PMF utilities."

Functionally, the package provides a targeted lookup service: resolving the numeric target value that applies to a given combination of target level, organization level, time level, and dimension level, optionally scoped to a specific plan. This is a core requirement in balanced scorecard and performance management configurations, where a target may be stored at multiple levels of granularity and the correct figure must be inferred from the caller's context.

Key Procedures and Functions

The package exposes four documented routines. Forms, concurrent programs, and custom code should call only these entry points.

  • GET_TARGET_FOR_TARGET_LEVEL — Returns the target value for a named target level. It accepts the target level short name together with the organization, time, and up to five dimension level values, plus an optional plan name, and returns a number. This is the primary routine behind the user's search term.
  • GET_TARGET_FOR_LEVEL_ID — Returns the target value when the caller supplies level identifiers (measure short name and the numeric org, time, and dimension level IDs) alongside the corresponding level values, again with a plan name, returning a number.
  • GET_TARGET_FOR_LEVEL — A further variant that resolves a target from a level specification rather than a target-level name.
  • GET_TARGET_VALUE — Retrieves the underlying stored target value given the resolved context.

The header also declares the record type Target_Level_Rec_Type and the associative array l_target_level_Tbl_Type, which support internal handling of target level descriptions.

Tables Accessed

The package reads from four base tables through APPS synonyms:

  • BIS_LEVELS — the definition of levels (organization, time, and dimensions) used to interpret the level value arguments.
  • BIS_TARGET_LEVELS — the set of valid target levels, used to resolve a target level short name to its definition.
  • BIS_TARGET_VALUES — the actual stored target figures, from which the returned number is selected.
  • BIS_INDICATORS — indicator (measure) definitions that link levels and targets to a business measure.

These tables form the metadata and data foundation of the BIS/PMF schema, and the package performs read-only access against them when resolving targets.

Usage Notes

BIS_PMF_UTILITIES_PUB is a pure lookup API and is normally invoked from PL/SQL rather than directly by end users. Typical callers include custom scorecard or dashboard extensions, concurrent programs that populate or refresh performance data, and Forms-based maintenance screens that need to display the effective target for the context a user has navigated to. Because the routines are functions returning NUMBER, they are conveniently usable inside SQL statements and PL/SQL assignments.

No other documented package references this API, so it is a leaf dependency; callers must supply all level values consistently with the definitions held in BIS_LEVELS. When a target is not defined at the requested level, callers should expect the resolution logic to fall back or return null according to the stored hierarchy. Because the package runs AUTHID CURRENT_USER, the invoking schema must have direct or synonym-based access to the four BIS tables. The header history shows creation in August 1999, and the object remains available in both 12.1.1 and 12.2.2.