Results for “nls_language_code”

18 results




Overview
Explore in AI Chat

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

Overview

BIS_HTML_UTILITIES_PVT is a private PL/SQL package body owned by APPS in Oracle E-Business Suite, shipped in source file BISVHTMB.pls and attributed in its header to Oracle Corporation. Its documented purpose is to generate HTML banners within PMF (Process Manufacturing) forms. The package internally assembles markup and either writes it directly to the web server output stream via the PLS cartridge htp.p procedure or returns the constructed HTML as an OUT parameter to the calling program. Additional functionality covers the insertion of iHelp JavaScript into the generated banner, resolution of image and icon locations, and translation of icon text according to the active NLS environment. First created in January 1999 and maintained through 2001, the package is classified in ETRM as a PVT (private) API, meaning it is intended for internal use by Oracle EBS components rather than as a supported public interface for customer extensions.

The header history and embedded commentary are notable: the source explicitly acknowledges ten overloaded versions of the banner-building routine, described in the file header by their argument signatures and call chains (versions one through ten, with one calling another, and several variants accepting BOOLEAN flags to control behavior). The commentary further notes that duplicate routines already exist in BIS_REPORT_UTIL_PVT and were updated in parallel, and that it removes a quotation mark from the iHelp call and adjusts the location of the style file. This file predates modern NLS conventions; it was written before the centralized ICX OA_HTML and OA_MEDIA profile options, which were introduced in a May 2001 revision.

Key Procedures and Functions

  • BUILD_HTML_BANNER — The central routine of the package. It constructs the HTML banner markup used by PMF forms, and in its various overloaded forms emits the result either to the web server through htp.p or into an OUT parameter. Certain overloads additionally insert the iHelp JavaScript block and delegate to other overloads.
  • GET_TRANSLATED_ICON_TEXT — Returns translated display text for banner icons, allowing the banner to render in the language of the current session.
  • GET_IMAGES_SERVER — Determines the appropriate images server location used to build fully qualified image URLs embedded in the banner.
  • GET_NLS_LANGUAGE — Retrieves the current NLS language setting so the generated HTML and icon text can be localized.
  • GET_IMAGE_FILE_STRUCTURE — Resolves the file and directory structure for banner images, producing the correct path fragments for the markup.

Tables Accessed

  • FND_LANGUAGES — Read to enumerate and validate the languages installed in the EBS instance, supporting translation of icon text and language-sensitive banner output.
  • NLS_SESSION_PARAMETERS — Read to obtain the session language and related NLS settings that drive localization decisions in GET_NLS_LANGUAGE and GET_TRANSLATED_ICON_TEXT.
  • HTP — The PL/SQL Web Toolkit package referenced for HTML generation primitives such as htp.p, through which banner markup is written to the web server output stream.

Access is achieved through APPS synonyms, consistent with standard EBS data dictionary conventions.

Usage Notes

BIS_HTML_UTILITIES_PVT is a PVT package and is referenced by two other packages in the ETRM repository, reflecting its role as a shared internal utility rather than a standalone entry point. It is typically invoked in the context of PMF (Process Manufacturing) form sessions that render HTML content through the Oracle Applications framework or the PL/SQL Web Toolkit. The banner it produces includes iHelp JavaScript and image references, so the package is called early in page or form assembly, before the main HTML body is emitted. The presence of ten overloaded versions of the banner routine means callers must select the overload matching their desired alternates: output to the web server versus an OUT variable, and behavior controlled by BOOLEAN flags. Because the source is dated 1999–2001 and predates the ICX OA_HTML and OA_MEDIA profile consolidation, developers maintaining customizations around this package should be aware of the duplicated logic in BIS_REPORT_UTIL_PVT and of the potential for divergent image and style file paths.

Note on the search context: the querystring parameters (msgid, width, height, dnd, dsptype=popup) are unrelated to this database object. They belong to an Oracle Applications Framework (OAF) popup page request or a similar HTML framework URL, and are incidental to the package documentation.