Search Results hr_template_tab_page_info




Overview
Explore in AI Chat

Overview

HR_TEMPLATE_TAB_PAGE_INFO is an APPS-owned PL/SQL package classified under the OTHER API category in Oracle E-Business Suite. It belongs to the Oracle HRMS (Human Resources Management System) product family and supports the framework that governs template-driven form layouts — specifically, the tab and page definitions associated with form templates used throughout the HRMS self-service and professional forms architecture. In EBS 12.1.1 and 12.2.2, this package functions as an internal metadata access layer that surfaces information about the tab pages configured for a given template. It is not exposed as a public, supported API; rather, it serves as supporting infrastructure consumed by the template-rendering and configuration components of the HRMS framework. The package holds a VALID status in the ETRM inventory, confirming it is compiled and operational in the reference environment.

Key Procedures and Functions

The ETRM metadata documents two procedures within this package:

  • TEMPLATE_TAB_PAGES — The primary procedure, which assembles and returns the tab page information for a form template. It queries the underlying template, tab page, and property tables to produce the tab page definitions that drive rendering and configuration of the template's layout.
  • TEMPLATE_TAB_PAGES_PST — A post-processing companion to the main procedure. The _PST suffix follows the EBS convention for a post-processing step, indicating it performs follow-on logic such as finalization, derived-value population, or output formatting after TEMPLATE_TAB_PAGES has executed.

No parameter lists are published in the available metadata; consumers should reference the actual package specification in the database for signature details. The package does not expose any documented functions outside these two procedures.

Tables Accessed

The package reads from a set of HRMS template and form-definition tables via APPS synonyms:

These accesses indicate the package is read-oriented, translating stored template configuration into collections used by the calling layer.

Usage Notes

HR_TEMPLATE_TAB_PAGE_INFO is invoked internally by the HRMS template framework rather than by end users or standard concurrent programs. It is referenced by only the package itself (recursive reference) and no other documented packages, confirming it is a leaf-level utility. Typical invocation occurs when HRMS forms or self-service pages render a template and must resolve the tab pages associated with it. Customizations should avoid calling this package directly, since it is unsupported internal code and its signature or behavior may change without notice; developers requiring template metadata should instead use supported HRMS configuration APIs or query the underlying _B/_TL tables directly where appropriate.