Search Results hr_template_window_info




Overview
Explore in AI Chat

Overview

HR_TEMPLATE_WINDOW_INFO is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, documented as VALID and classified under ETRM as an "OTHER" API (neither a public nor a private API in the formal sense). It belongs to the Oracle HRMS (Human Resources Management System) module and supports the configuration of form and window templates used to control how Oracle Forms-based HRMS windows are displayed, personalized, and rendered to end users. The package assembles metadata that describes the association between form templates, forms, windows, and window-level display properties, providing the application with a consolidated view of how a given window should be presented within a form template context. In effect, it functions as a supporting data-access and presentation layer for window and template definition records, rather than as a transactional business API. Its status and dependencies confirm it operates within the standard APPS synonym layer, reading from HRMS setup tables and a PL/SQL table type (PLITBLM).

Key Procedures and Functions

ETRM documents two program units within this package:

  • TEMPLATE_WINDOWS — the primary procedure responsible for retrieving and assembling window information associated with form templates. It resolves the linkage between a form template and the windows defined for its forms, returning the set of windows and their relevant attributes so callers can render or process them. It serves as the entry point for obtaining template-window data within the HRMS forms framework.
  • TEMPLATE_WINDOWS_PST — a companion procedure, conventionally named with a "_PST" suffix indicating a post-processing or secondary stage within the same logical operation. It complements TEMPLATE_WINDOWS, typically performing follow-up processing on the window data already gathered, such as populating or refining a PL/SQL table (PLITBLM) structure for downstream consumption.

The two procedures are intended to be used together as a retrieve-then-process sequence. Detailed parameter lists are not documented in the ETRM metadata and are therefore not reproduced here.

Tables Accessed

The package references the following APPS tables and structures, all standard HRMS form/template configuration tables:

  • HR_FORM_TEMPLATES_B — the base table defining form templates.
  • HR_FORM_WINDOWS_B — defines the windows belonging to HRMS forms.
  • HR_TEMPLATE_WINDOWS_B — associates templates with their applicable windows; the central table linking the two concepts.
  • HR_WINDOW_PROPERTIES_B and HR_WINDOW_PROPERTIES_TL — hold window display properties, with the _TL table supplying translatable (language-specific) property text.
  • PLITBLM — a PL/SQL index-by table type used to hold intermediate or returned data in memory.

These references are consistent with a package whose function is to resolve and return window-level metadata for rendering within form templates.

Usage Notes

HR_TEMPLATE_WINDOW_INFO exposes no incoming dependencies from other documented APPS packages (ETRM records zero referencing packages), indicating it is invoked directly rather than through a packaged chain. It is typically called during the runtime processing of Oracle Forms-based HRMS windows, where template and window definitions must be resolved before display. Administrators and developers encountering this package while investigating window personalization, template definition, or form rendering behavior should treat it as an internal HRMS support routine. Customizations should not modify it; modifications would be overwritten by patching. When diagnosing issues, verify that the underlying HR_TEMPLATE_WINDOWS_B and HR_WINDOW_PROPERTIES_B/_TL setup data is correctly configured, since the package simply surfaces that configuration.