Results for “set_windows_client_info”

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

Overview

APPS.CZMLS is a multilingual (MLS) support package within the Oracle E-Business Suite environment. Its name derives from "Character Set / Multilingual Support," and its function is to bridge the client-side environment (typically a Windows desktop running Oracle Forms) and the database session with respect to language and character set configuration. The package specification carries the AUTHID CURRENT_USER directive, meaning that its executable code runs under the privileges of the invoking schema rather than the defining schema, which is consistent with its role as a shared utility exposed to a broad set of callers across the EBS technology stack.

The package is classified as OTHER in the ETRM API classification, indicating it is an internal technology-layer utility rather than a formal, documented business API. It is not referenced by any other documented package, confirming its position as a leaf-level dependency consumed directly by forms or by runtime infrastructure rather than by the application's business logic packages. The header date (2002) reflects a long-stable interface carried forward into EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

• SET_WINDOWS_CLIENT_INFO — Records information about the Windows client, receiving a code page and a language identifier as inputs, and returning the Oracle character set name along with the derived database client language and database base language, plus a status indicator. This procedure is central to establishing how the Forms client's locale maps to the database's NLS configuration.
• SET_ORACLE_CHARSET — Accepts a target character set name and applies it to the session context, allowing the runtime character set used for conversions to be adjusted programmatically.
• CLIENT_CHARSET — A function returning the character set currently associated with the client. This is used by callers to discover the active client encoding without needing to query NLS views directly.
• CHECK_LANGUAGE — A function validating a supplied language identifier. It accepts a language code and returns the corresponding database client language and database base language through output parameters, along with a numeric return value indicating the outcome. This is the object a user searches for under the term "check_language," and it is the primary entry point for determining whether a requested language is valid and installed.

Tables Accessed

• FND_LANGUAGES — The EBS language repository. CHECK_LANGUAGE consults it to confirm that a language is installed and to derive the client and base language values returned to the caller.
• V$NLS_PARAMETERS — Used to read the session's current NLS settings, particularly the character set in effect.
• V$NLS_VALID_VALUES — Used to validate language and territory values against the set of character sets the database recognizes as legitimate.

These are accessed through APPS synonyms, so the package operates against the standard EBS data dictionary without requiring direct object grants.

Usage Notes

CZMLS is typically invoked during Forms session startup and by multilingual infrastructure code to reconcile the desktop client's code page and language with the database character set. It is not exposed as a concurrent program and has no menu or responsibility of its own. Custom code that needs to validate a language code before performing multilingual lookups may call CHECK_LANGUAGE directly, but developers should treat the package as an internal utility: parameter signatures and behavior are governed by the technology stack rather than by a published business API contract, and reliance on it should be limited to scenarios where the standard NLS and FND_LANGUAGES interfaces are insufficient.