Results for “retrieve_mult_targ_levels”
4 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
BIS_TARGET_LEVEL_PVT is the private implementation package body for the Oracle EBS Business Intelligence System (BIS) target level subsystem, residing in the APPS schema. In the Oracle EBS layered API architecture, the _PVT suffix denotes an internal, implementation-level package whose procedures are typically invoked only by its public counterpart, BIS_TARGET_LEVEL_PUB. The package manages the definition, maintenance, and retrieval of target levels — the hierarchical entities against which business performance targets are assigned and measured across dimensions, indicators, and organizational structures within Oracle Balanced Scorecard and related BIS modules.
The package is documented as VALID and exposes 24 procedures and functions, encompassing the full lifecycle of target level records: creation, query, update, deletion, translation, and validation. It therefore acts as the persistence and business-rule engine behind the public target level API.
Key Procedures and Functions
The documented procedures fall into several functional clusters:
- Creation and maintenance: CREATE_TARGET_LEVEL, UPDATE_TARGET_LEVEL, DELETE_TARGET_LEVEL, and UPDT_TL_ATTRIBUTES handle the core write operations, including targeted attribute modification.
- Retrieval: RETRIEVE_TARGET_LEVEL, RETRIEVE_TARGET_LEVELS, RETRIEVE_MULT_TARG_LEVELS, RETRIEVE_USER_TARGET_LEVELS, RETRIEVE_TIME_LEVEL, RETRIEVE_ORG_LEVEL, RETRIEVE_TL_FROM_DIMLVLSHNMS, RETRIEVE_LAST_UPDATE_DATE, and COUNT_TARGET_LEVELS provide single-row, multi-row, user-scoped, and context-specific query capability.
- Translation and language support: TRANSLATE_TARGET_LEVEL manages translated (TL) attribute content across installed languages.
- Validation: VALIDATE_TARGET_LEVEL and VALIDATE_DIMENSIONS enforce referential and dimensional integrity before persistence.
- Key and identifier resolution: GET_LEVEL_ID_FROM_DIMLEVELS, GET_ID_FROM_DIMLEVELSHORTNAMES, and VALUE_ID_CONVERSION resolve internal identifiers from dimension-level combinations and short names.
- Concurrency control: LOCK_RECORD provides row-level locking to support optimistic and pessimistic update patterns.
No parameter signatures are documented in the ETRM record; callers must consult the package specification for exact arguments.
Tables Accessed
The package reads and writes the following documented tables, primarily via APPS synonyms:
- BIS_TARGET_LEVELS and its _S (sequence/primary key) and _TL (translation) companions — the core target level definition tables.
- BIS_DIMENSIONS, BIS_LEVELS, BIS_LEVELS_VL — dimension and hierarchy level metadata that define valid target level contexts.
- BIS_INDICATORS, BIS_INDICATOR_DIMENSIONS, BIS_INDICATOR_RESPS — indicator configuration and responsibility mappings that govern target applicability.
- FND_LANGUAGES — for translation-aware processing; FND_GLOBAL and FND_USER_RESP_GROUPS supply session and security context.
Usage Notes
BIS_TARGET_LEVEL_PVT is an internal layer and is not intended for direct customer invocation; the documented dependency list shows it is referenced by 14 other packages, including BIS_TARGET_LEVEL_PUB, BIS_TARGET_LEVEL_VALIDATE_PVT, BIS_TARGET_PUB, and BIS_COMPUTED_TARGET_PVT. It draws on shared utilities such as FND_API for API error handling, BIS_UTILITIES_PUB/PVT, and BIS_MEASURE_PVT, and FND_MSG_PUB for message stack management. In practice it is invoked indirectly from Oracle Balanced Scorecard forms and concurrent programs that maintain target levels, and from custom code that calls the public wrapper. Customizations should always target BIS_TARGET_LEVEL_PUB rather than this private body to remain upgrade-safe.