Results for “form_dim_level_value_tbl”

9 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BIS_PMF_DATA_SOURCE_PVT is a private PL/SQL package body in the APPS schema that implements the Data Source Connector layer of the Oracle E-Business Suite Business Intelligence System (BIS) / Performance Management Framework (PMF). Its source file, BISVDSCB.pls, is described in the header as the "Private API for the Data Source Connector," with an original creation date of April 2000 and a subsequent revision dated 30-JAN-2003 (bug#2774644) that removed FND_API.G_MISS_xxx usage from initialization and declaration sections.

The package provides the internal plumbing that transforms measure and dimension data structures into the record formats expected by the BIS public APIs. It operates primarily on the following public types:

  • BIS_MEASURE_PUB.Measure_Instance_type — carries a measure instance and its associated target level identifiers.
  • BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type — a collection of dimension level values.
  • BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type — the target level record structure populated by Form_Target_Level_rec.

Method names use the Form_* prefix, indicating that the package constructs and returns records rather than performing persistent DML. Because it is classified as PVT, only other members of the BIS package family are expected to call it directly.

Key Procedures and Functions

The ETRM metadata documents seven procedures/functions in this package:

  • FORM_TARGET_LEVEL_REC — Populates a BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type record from a supplied measure instance. The documented body copies Measure_ID, Measure_short_name, Measure_name, Target_Level_ID, Target_Level_short_name, and Target_Level_name from the measure instance into the target level record, then returns it via a NOCOPY OUT parameter. A local record variable is used, and exceptions FND_API.G_EXC_ERROR and FND_API.G_EXC_UNEXPECTED_ERROR are handled within the block.
  • FORM_TARGET_REC — Builds a target record structure from inbound measure or dimension data, analogous in style to FORM_TARGET_LEVEL_REC.
  • FORM_ACTUAL_REC — Constructs an actual (fact/actual value) record from source data, supplying the actuals side of the measure instance.
  • FORM_MEASURE_INSTANCE — Assembles a BIS_MEASURE_PUB.Measure_Instance_type structure from its component attributes, the inverse direction of the Form_* record builders.
  • FORM_DIM_LEVEL_VALUE_TBL — Builds the BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type collection used to describe dimensional level members.
  • FORM_NOTIFIER_REC — Populates a notifier record, used to convey status, error, or workflow notification information to callers.
  • SYNC_TARGET_MEASURE_OWNERS — Synchronizes target-to-measure ownership relationships, aligning target level definitions with their owning measures within the PMF metadata model.

Tables Accessed

The ETRM metadata does not list any tables referenced via APPS synonyms for this package body. This is consistent with its role as a record-transformation private API: the Form_* procedures operate on PL/SQL record types and collections passed in and out, and the package contains no evident DML against BIS base tables. Any persistence of the populated records is performed by the corresponding public BIS packages and their dependencies. SYNC_TARGET_MEASURE_OWNERS is the only procedure whose name implies interaction with the metadata model, but the documented metadata does not attribute a specific base table to it.

Usage Notes

As a PVT package, BIS_PMF_DATA_SOURCE_PVT is invoked internally by other members of the BIS package family rather than by customer code. ETRM records that it is referenced by three other packages, which supply the measure instances and dimension level value collections that the Form_* routines convert into target level, target, actual, and notifier records. Typical invocation contexts are PMF concurrent programs and OAF/Forms-based data source connector pages that gather measure and dimension selections and then pass them into the public BIS APIs. Because FORM_TARGET_LEVEL_REC and its peers return records through OUT NOCOPY parameters and swallow FND_API error exceptions, callers should check the returned record for validity rather than relying on forwarded exceptions. The form_target_level_rec search term corresponds directly to the first documented procedure, which is the recommended entry point for callers that already hold a measure instance and require the matching target level record.