Search Results template_tab_pages




Overview
Explore in AI Chat

Overview

HR_TEMPLATE_TAB_PAGE_INFO is an Oracle E-Business Suite PL/SQL package owned by APPS and classified under the ETRM scheme as OTHER. It belongs to the Oracle Human Resources (HR) family of template configuration utilities used by the Forms-based template and tab page personalization framework. The package encapsulates the logic required to resolve which tab pages are associated with a given form template and form tab page, and to expose that resolved hierarchy in a form usable by calling forms and concurrent code.

The functionality centers on joining the template-side definitions (template tab pages, template canvases, template windows) with the form-side definitions (form tab pages, form canvases) and the descriptive text stored in the tab page properties tables. The result is a denormalized view of a tab page's label, canvas name, display order, navigation direction, visibility flag, information category, and its complete set of thirty information attributes (information1 through information30). This composition allows the Forms UI layer to render tab pages with the correct labels and behavioral properties without embedding the join logic in the form itself.

Key Procedures and Functions

The documented interface exposes two units, both named within the package body:

  • HR_TEMPLATE_TAB_PAGES — the primary program unit. It is responsible for populating the package's collection type t_template_tab_pages based on the global cursor csr_template_tab_pages, which is parameterized by form template and form tab page identifiers. This unit performs the resolution of template tab page records for consumption by the caller.
  • HR_TEMPLATE_TAB_PAGES_PST — the PST (persistent/state) variant of the same logical operation. It mirrors the behavior of the primary unit but exists to support the state-preserving invocation path used by the Forms framework. The user search term "template_tab_pages_pst" corresponds directly to this documented unit.

The package declares two global structures: the scalar g_form_template_id, typed against HR_FORM_TEMPLATES_B.FORM_TEMPLATE_ID, and the collection g_template_tab_pages, of type t_template_tab_pages. No parameter lists are documented in the available metadata, and none are inferred here.

Tables Accessed

The package reads from eight APPS synonyms. HR_FORM_TEMPLATES_B anchors the template definition. HR_TEMPLATE_WINDOWS_B, HR_TEMPLATE_CANVASES_B, and HR_TEMPLATE_TAB_PAGES_B describe the template-side window, canvas, and tab page hierarchy. HR_FORM_CANVASES_B and HR_FORM_TAB_PAGES_B supply the corresponding form-side window components. HR_TAB_PAGE_PROPERTIES_B and HR_TAB_PAGE_PROPERTIES_TL provide the base and translated descriptive properties, including labels, navigation direction, visibility, information category, and the thirty information columns. PLITBLM is referenced as the standard EBS table lookup utility. All joins in the cursor are outer joins, ensuring that missing template or form side rows do not suppress the returned record.

Usage Notes

HR_TEMPLATE_TAB_PAGE_INFO is invoked by the Oracle HR Forms application layer when rendering form templates and their tab pages. It is not a public API intended for direct customer invocation, and it is referenced by zero other documented packages within the ETRM inventory. Customizations that read template tab page layout information should treat the package as an internal utility, relying instead on the underlying tables or supported APIs. Because the resolution depends on userenv('LANG'), the translated label returned reflects the session language. The package carries a No Ship (noship) header marker, confirming it is internal Oracle code shipped as part of the HR product family.