Search Results bis_indicator_resps_s

Overview

The APPS.BIS_MEASURE_SECURITY_PVT package body is the private implementation layer of the Oracle EBS Balanced Scorecard measure security framework. In Oracle EBS 12.1.1 and 12.2.2, it supports the Business Intelligence System (BIS) module by enforcing which responsibilities, users, and target-level assignments may view or maintain specific performance measures (indicators). The package is classified as a PVT (private) API, meaning it is not intended for direct invocation by external consumers; the public counterpart is BIS_MEASURE_SECURITY_PUB, which delegates to this body. Its core business purpose is to create, retrieve, update, delete, and validate measure security records that bind scorecard indicators to responsibilities through the BIS_INDICATOR_RESPS and BIS_INDICATOR_RESPS_S tables — the latter being the subject of the user's search term "bis_indicator_resps_s."

Key Procedures and Functions

The package body exposes twelve documented procedures and functions:

• CREATE_MEASURE_SECURITY — Inserts a new measure security assignment linking an indicator to a responsibility.
• RETRIEVE_MEASURE_SECURITIES — Returns a collection of measure security records matching specified criteria.
• RETRIEVE_MEASURE_SEC_SORTED — Returns measure security records in a defined sort order, typically by indicator or responsibility.
• RETRIEVE_MEASURE_SECURITY — Retrieves a single measure security record by unique key.
• UPDATE_MEASURE_SECURITY — Modifies an existing measure security assignment.
• DELETE_MEASURE_SECURITY — Removes a measure security row.
• VALIDATE_MEASURE_SECURITY — Verifies the integrity and admissibility of a security record before DML, calling into BIS_MEASURE_SEC_VALIDATE_PVT.
• VALUE_ID_CONVERSION — Converts between internal numeric IDs and display values for measure security attributes.
• RETRIEVE_TAR_LEVEL_USER_RESPS — Returns target-level user and responsibility mappings used in security resolution.
• DELETE_TARGETLEVEL_RESP — Removes a target-level responsibility association.

Tables Accessed

The package reads and writes via APPS synonyms:

• BIS_INDICATORS — The indicator (measure) definition table, used to validate measure existence.
• BIS_INDICATOR_RESPS — The primary measure-to-responsibility assignment table; the target of CREATE, UPDATE, and DELETE operations.
• BIS_INDICATOR_RESPS_S — The underlying database table/synonym for indicator-responsibility security rows, referenced directly in the user's search.
• BIS_TARGET_LEVELS — Defines target-level granularity used in security resolution.
• DUAL and PLITBLM — Utility objects used for PL/SQL table and scalar operations.

Additional dependencies include BIS_COMMON_UTILS, BIS_RESPONSIBILITY_PVT, BIS_TARGET_LEVEL_PUB/PVT, BIS_UTILITIES_PUB/PVT, FND_API, FND_GLOBAL, FND_MSG_PUB, FND_RESPONSIBILITY_VL, and FND_USER_RESP_GROUPS.

Usage Notes

Because this is a PVT package body, applications and forms invoke it indirectly through BIS_MEASURE_SECURITY_PUB. It is commonly exercised from the Balanced Scorecard administration forms when a user assigns responsibilities to a measure, and from concurrent programs that seed or migrate measure security. Custom code should never call the PVT package directly; use the PUB API to preserve validation, message handling, and the FND_API savepoint conventions. The package is referenced by three other packages and references BIS_MEASURE_SECURITY_PUB, BIS_MEASURE_SEC_VALIDATE_PVT, and BIS_TARGET_LEVEL_PVT in turn, confirming its role as the internal engine beneath the public measure security interface.