Search Results jtf_menu_pub




Overview
Explore in AI Chat

Overview

APPS.JTF_MENU_PUB is a public PL/SQL package in the Oracle E-Business Suite Applications Technology layer that exposes the FND menu hierarchy to programmatic consumers. In both EBS 12.1.1 and 12.2.2, this package serves the business function of resolving menu definitions, their entries, and the underlying form functions into a navigable, language-aware structure. It is the natural integration point for any custom component that must reconstruct, traverse, or render the same navigational topology that the EBS user interface presents through the Navigator and the menu-based responsibility framework.

The package is classified as a PUB API, meaning it is intended for supported external invocation rather than internal-only use, and is therefore referenced by other application packages in the environment.

Key Procedures and Functions

The documented API surface consists of fourteen procedures and functions, generally grouped as language-neutral accessors and their translated (_TL) counterparts. Users searching on "get_menu_name" are typically seeking GET_MENU_NAME, which returns the display name of a given menu, along with GET_MENU_NAME_TL, its translation-aware form.

Tables Accessed

The package reads the foundational FND menu and function tables through APPS synonyms. FND_MENUS and FND_MENUS_TL supply menu headers and their translated prompts; FND_MENU_ENTRIES and FND_MENU_ENTRIES_TL supply the parent-child composition of menus into submenus and functions. FND_FORM_FUNCTIONS, FND_FORM_FUNCTIONS_TL, and the related function-view definitions provide the function metadata that menu leaves ultimately resolve to, including web host, agent, HTML call, and security attributes. FND_RESPONSIBILITY, FND_RESPONSIBILITY_TL, and FND_RESP_FUNCTIONS are consulted to honor responsibility-level grants and menu exclusions when the exclusion APIs are used. DUAL supports singleton selection, and PLITBLM is the standard FND table-based index-by table type used for array handling.

Usage Notes

JTF_MENU_PUB is typically invoked from custom Forms, OAF pages, JSP-based regions, or concurrent programs that need to render or inspect the menu hierarchy outside of the standard Navigator. Because the package offers both neutral and _TL variants, consumers building multilingual user experiences should call the _TL versions to obtain localized prompts, while internal processing can use the language-neutral forms. Callers working within a responsibility context should prefer the excluded-tree and excluded-entries variants so that menu exclusions are respected. As a PUB API referenced by two other packages, it is safe to depend on across 12.1.1 and 12.2.2; however, custom code should not assume a stable output ordering and should not modify package internals. Direct DML against the underlying FND tables is not supported and should be replaced by the corresponding public APIs.