Results for “fnd_applications”

18 results




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

Overview

BIS_RELATED_LINKS_MLS is a private PL/SQL package in the APPS schema that supports the multilingual (MLS) maintenance of Oracle EBS related-links content, specifically the information surfaced in the Oracle Applications "Related Links" region of the personal home page and related dashboards. The package name suffix "MLS" identifies it as a translation-layer utility rather than a user-facing API. Its stated purpose in the package header is to populate the table BIS_RELATED_LINKS_TL (the translation table for BIS_RELATED_LINKS) and to manage the relationship of that content with the FND_APPLICATIONS table.

The package is classified as OTHER in the ETRM 12.1.1 metadata, indicating that it is not a published or supported public API and is intended for internal use by the BIS (Business Intelligence System) related-links subsystem. It is a lightweight package containing a single procedure, used internally when language rows must be synchronized or generated for related-links records.

Key Procedures and Functions

The documented package exposes one procedure:

  • ADD_LANGUAGE — Performs the language-population logic for related-links data. In the standard MLS pattern used throughout EBS, ADD_LANGUAGE inserts missing translated rows into the _TL table for each installed language that does not yet have a corresponding translation row, seeding the translatable columns. It leverages FND_LANGUAGES to determine which languages are installed and active, and it is dependent on the underlying related-links data being associated with an application in FND_APPLICATIONS. No parameter list is documented in the ETRM metadata, and none should be assumed; the procedure is invoked internally by the package or its callers rather than as a documented API signature.

No other procedures or functions are documented for this package.

Tables Accessed

The ETRM metadata documents three tables referenced through APPS synonyms:

  • BIS_RELATED_LINKS — The base (non-translatable) related-links definition table. It holds the link records themselves; the MLS procedure uses it as the source to determine which base rows require translation entries.
  • BIS_RELATED_LINKS_TL — The translation table that stores the language-specific text for each related link. ADD_LANGUAGE populates this table, creating rows for installed languages where translations are absent.
  • FND_LANGUAGES — The Oracle Application Object Library table of installed and active languages. It is read to enumerate the languages for which translation rows must be created or maintained.

The package header additionally notes the relationship with FND_APPLICATIONS, which is used to associate related links with the owning application; this association governs which links are surfaced within a given application context.

Usage Notes

BIS_RELATED_LINKS_MLS is a private package and is not intended to be called directly from custom forms, concurrent programs, or customer-written code. In practice it is invoked internally by the related-links subsystem—typically during installation or upgrade of the BIS product, or by the standard MLS maintenance routines whenever a new language is added to the instance. Because it follows the conventional _MLS ADD_LANGUAGE pattern, it is commonly called from within the related-links DML procedures rather than from an executable entry point.

Customers and integrators who need to maintain related-links translations should use the supported Oracle Applications administrative interfaces or the BIS related-links setup pages rather than invoking this package directly. The package carries Oracle proprietary and confidential markings, and its header confirms a 2005 vintage (BISPRLKS.pls), which is consistent with the R12 code line used in 12.1.1 and 12.2.2. Direct modification or reliance on this package is unsupported.