Search Results retrieve_computed_targets




Overview
Explore in AI Chat

Overview

The APPS.BIS_COMPUTED_TARGET_PVT package body is a private (PVT-classified) PL/SQL API within the Oracle E-Business Suite Business Intelligence System (BIS) product family. Its role is to support the discovery, validation, and identifier translation of computed targets registered in the EBS Forms function repository. A computed target in this context corresponds to a system function whose parameters carry the pFunctionType=BISTAR clause — that is, a form function mapped to a BIS/BISTAR-enabled transaction. Unlike public APIs that expose stable interfaces to external callers, this package is intended for internal consumption by other BIS modules and the two packages documented as referencing it. It provides the plumbing that allows higher-level BIS components to enumerate available BISTAR targets, verify that a supplied target identifier is legitimate, and convert an internal value identifier into its corresponding definition.

Key Procedures and Functions

  • RETRIEVE_COMPUTED_TARGETS — Opens a cursor against the form functions view, selecting function_id, function_name, and user_function_name for every row whose parameters column matches the BISTAR pattern. It populates an out-parameter table of computed target records, each carrying the target identifier (derived from function_id), the short name, and the user-facing name. It follows the standard EBS API error-handling contract, setting the return status and raising the appropriate FND_API exception on error, and logging unexpected failures through BIS_UTILITIES_PVT.Add_Error_Message.
  • VALIDATE_COMPUTED_TARGET_ID — Confirms that a supplied Computed_Target_ID is a valid, known computed target. It accepts a validation level defaulting to full validation and returns a status plus an error table, consistent with the EBS validation API convention. It is used to guard downstream processing against stale or unauthorized target identifiers.
  • VALUE_ID_CONVERSION — Performs the identifier translation that the user query referenced. It maps an incoming value identifier to its associated computed target representation, serving as the conversion bridge between the internal BIS value model and the function-based target identifiers returned by RETRIEVE_COMPUTED_TARGETS.

Tables Accessed

The package reads from FND_FORM_FUNCTIONS (via the FND_FORM_FUNCTIONS_VL view), the Applications Object Library table that stores form function definitions, including the parameters column inspected by the BISTAR clause filter. No insert, update, or delete operations are documented; the package is strictly a read-side utility. The conversion logic in VALUE_ID_CONVERSION operates against the in-memory record structures populated from this source rather than persisting any data.

Usage Notes

BIS_COMPUTED_TARGET_PVT is documented as referenced by two other packages, indicating it is invoked programmatically rather than directly by end users. Typical invocation patterns include: BIS forms or setup pages that need to present the list of available BISTAR computed targets for selection, concurrent programs that seed or refresh BIS target configuration, and custom extensions performing value_id_conversion lookups before calling public BIS APIs. Because the package is PVT-classified, Oracle does not guarantee signature stability across patch levels, and the $Header version marker (115.11, dated 2003) indicates a long-standing, largely unchanged implementation retained through EBS 12.1.1 and 12.2.2. Callers should always check x_return_status and inspect the returned error table before proceeding.