Results for “insert_tl_rec”

10 results




Overview
Explore in AI Chat

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

Overview

FPA_SCORECARDS_PVT is a private PL/SQL package within the Oracle E-Business Suite Applications (APPS) schema, belonging to the Enterprise Performance Foundation / Enterprise Planning and Budgeting product family. The package encapsulates the server-side scoring logic used by Oracle's Balanced Scorecard functionality, which allows organizations to define strategic objectives, assign weighted scores, and track performance across planning cycles, projects, and scenarios. Because it is classified as a Private (PVT) API, FPA_SCORECARDS_PVT is not intended for direct invocation by external or customer-written code; it is designed to be called exclusively by other packages within the same product layer. The package header carries a header string reflecting a ship date of 2005 and a version of 120.2, indicating it has been a stable, low-change component across the 12.1.1 and 12.2.2 release lines.

Key Procedures and Functions

The package exposes seven documented program units, all of which follow the standard Oracle API parameter convention for message handling and return status.

  • UPDATE_CALC_PJT_SCORECARD_AW — Recalculates and updates scorecard values at the project level, accepting a planning cycle identifier, project identifier, and a PL/SQL table of scorecard records.
  • UPDATE_CALC_SCEN_SCORECARD_AW — Performs the analogous recalculation at the scenario level, taking planning cycle, scenario, and project identifiers along with the scorecard table.
  • CALC_SCENARIO_WSCORES_AW — Computes weighted scores for an entire scenario, processing the scoring hierarchy defined for the scenario.
  • UPDATE_SCENARIO_APP_SCORES — Writes approved or application-level scores back to the scenario records.
  • INSERT_TL_REC — Inserts a translated (TL) scorecard record, supporting multilingual deployments.
  • HANDLE_COMMENTS — Manages the capture and persistence of textual commentary attached to scorecard entries.
  • READ_ONLY — A utility routine that enforces read-only behavior, preventing unintended modification of scorecard data.

The package declares custom record and table types (FPA_SCORECARD_REC_TYPE and FPA_SCORECARD_TBL_TYPE) used to pass arrays of strategic-object scores and comments between the API surface and its callers.

Tables Accessed

The package operates against a small, focused set of objects accessed through APPS synonyms:

  • FPA_SCORECARDS_TL — The translated scorecard table that stores scorecard definitions and descriptive text by language.
  • FND_LANGUAGES — Oracle's language registry, consulted to determine valid installed languages for translation inserts.
  • DBMS_AW — The Oracle OLAP Analytic Workspace PL/SQL package, used to drive multidimensional score aggregation and calculation.
  • PLITBLM — A PL/SQL index-by table manipulation utility package used for in-memory table processing.

Usage Notes

FPA_SCORECARDS_PVT is referenced by six other packages, confirming that it serves as a shared internal service layer rather than a standalone entry point. It is typically invoked from Oracle Balanced Scorecard forms and concurrent programs, and from higher-level planning packages that orchestrate score calculation across planning cycles. Because the package relies on DBMS_AW for its computational core, an OLAP-capable database configuration is required. Custom code should never call this package directly; developers seeking scorecard integration should use the public FPA APIs instead.