Search Results translate_dim_by_given_lang

Overview

APPS.BSC_DIMENSION_GROUPS_PVT is a private PL/SQL package belonging to the Oracle Balanced Scorecard (BSC) product family within Oracle E-Business Suite. Its core responsibility is to create, maintain, and translate Dimension Groups in the BSC dimensional model. A Dimension Group is the logical container that organizes the dimensions and dimension levels used to structure scorecard data, such as a hierarchy of organizational units or reporting categories. The package header dates from October 2001, authored by Mario-Jair Campos, and includes a June 2003 enhancement adding dimension group translation logic. As a PVT classification object, it is the private implementation layer that supports the public specification package BSC_DIMENSION_GROUPS_PUB; the public APIs delegate their processing to this package. It is referenced by two other packages and is not intended for direct invocation by external customers.

Key Procedures and Functions

The package exposes eleven documented procedures and functions organized into three functional groups.

• Dimension Group CRUD: CREATE_DIMENSION_GROUP, RETRIEVE_DIMENSION_GROUP, UPDATE_DIMENSION_GROUP, and DELETE_DIMENSION_GROUP perform the full lifecycle of create, read, update, and delete operations against a dimension group record. Each accepts a commit indicator, a dimension group record based on the BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type structure, and standard API return status, message count, and message data outputs.
• Dimension Levels in Group: CREATE_DIM_LEVELS_IN_GROUP, RETRIEVE_DIM_LEVELS_IN_GROUP, UPDATE_DIM_LEVELS_IN_GROUP, and DELETE_DIM_LEVELS_IN_GROUP manage the association of individual dimension levels that belong to a given group, preserving the ordered hierarchy that defines the group's structure.
• Utility and Translation: GET_DIM_GROUP_ID returns the surrogate identifier for a dimension group; TRANSLATE_DIMENSION_GROUP and TRANSLATE_DIM_BY_GIVEN_LANG handle multilingual support. TRANSLATE_DIM_BY_GIVEN_LANG is the procedure relevant to the common search term "translate_dim_by_given_lang"; it translates dimension group and level metadata into a specified language, writing the translated (or blended) values back to the translation layer.

Tables Accessed

Data is accessed through APPS synonyms. BSC_SYS_DIM_GROUPS_TL is the translatable (TL) table that stores dimension group names and descriptions per language and is the primary target of the translation procedures. BSC_SYS_DIM_LEVELS_BY_GROUP stores the mapping of dimension levels to their parent dimension group and is managed by the level-in-group routines. FND_LANGUAGES provides the installable language definitions used by TRANSLATE_DIMENSION_GROUP and TRANSLATE_DIM_BY_GIVEN_LANG to validate language codes and populate translations where a language-specific row does not yet exist.

Usage Notes

BSC_DIMENSION_GROUPS_PVT is invoked indirectly. Standard application flows—such as the Balanced Scorecard administrator setup and dimension maintenance forms—call the public wrapper BSC_DIMENSION_GROUPS_PUB, which in turn invokes this private package. Custom development or concurrent programs should call the PUBLIC package rather than this PVT layer to remain supported across releases. The translation procedures are typically reached when a user changes the session language or when a multilingual deployment requires population of translated dimension group metadata. Because the package uses FND_API conventions for return status and messages, callers must always check x_return_status and inspect x_msg_count/x_msg_data on failure. The behavior is consistent across EBS 12.1.1 and 12.2.2; the underlying BSC dimensional schema and FND language infrastructure are unchanged between these releases.