Search Results get_product

Overview

JG_ZZ_SHARED_PKG is a global shared utility package owned by APPS in Oracle E-Business Suite. Its source header ($Header: jgzzssas.pls 120.6.12000000.1 2007/01/18) indicates it is part of the JG (Globalization / Localization) product family and has been stable since early releases. The package provides a lightweight, centralized mechanism for retrieving three globalization context values at runtime: the operating country code, the product code, and the application short name. These values are typically stored in user profile options, but the package intentionally abstracts direct profile access so that localization logic resolves the correct value based on organizational context rather than depending solely on the session-level profile setting.

This abstraction matters because multi-org environments can associate different countries, products, and legal entities with a single database session. Rather than embedding FND_PROFILE.VALUE or FND_PROFILE.GET calls throughout localization code, developers call JG_ZZ_SHARED_PKG. The package stores cached values in PL/SQL associative arrays (t_char_tbl, keyed by VARCHAR2) for country, product, and application, allowing efficient lookup and reuse across a session. With 52 other packages referencing it, JG_ZZ_SHARED_PKG acts as a de facto dependency for JG localization components.

Key Procedures and Functions

• GET_COUNTRY — Returns the country code applicable to the current context. It is documented with both a no-argument form and an overload accepting organization, ledger, and inventory organization identifiers, used when the country must be derived from a specific organizational hierarchy instead of the session default.
• GET_PRODUCT — Returns the product code. As with GET_COUNTRY, an overloaded version accepts organization, ledger, and inventory organization parameters so the product code can be resolved for a specific context. The user search term "get_product" corresponds directly to this function; it is the recommended replacement for reading the product profile option directly.
• GET_APPLICATION — Returns the application short name. One form takes no arguments and returns the current application; the overloaded form accepts the current form name, allowing the application short name to be derived from the form being executed.
• IS_GLOBALIZATION_ENABLED — Documented in ETRM metadata as a member of the package's API surface; it is used to determine whether globalization features are active, gating logic that depends on the JG product being installed and configured.

All functions return VARCHAR2 values. The package exposes no public procedures according to the documented specification; the four named members constitute the documented functional surface.

Tables Accessed

• FND_PROFILE_OPTION_VALUES — Read to resolve profile option values that back the country, product, and application codes, including organization-specific overrides where the overloaded functions are used.
• PLITBLM — The PL/SQL table memory utility used for the package's package-level associative arrays (p_country_tbl, p_product_tbl, p_appl_tbl), supporting caching of resolved values across calls.

Usage Notes

JG_ZZ_SHARED_PKG is typically invoked from localization forms, concurrent programs, and custom JG-related code that must determine country, product, or application context. Oracle's own source comments direct developers to call these functions in place of FND_PROFILE.VALUE/GET when retrieving country, product, or application codes, because the package applies globalization-aware resolution logic. In Oracle EBS 12.1.1 and 12.2.2, the package remains unchanged from the 12.0 code line and is a safe, read-only dependency. Custom code should use the overloaded variants when processing data for a non-session organization, ledger, or inventory organization.