Search Results hr_template_item_tab_pages_pkg




Overview
Explore in AI Chat

Overview

APPS.HR_TEMPLATE_ITEM_TAB_PAGES_PKG is a VALID PL/SQL package in the Oracle E-Business Suite APPLSYS/APPS schema that supports the Oracle HRMS Forms Template configuration framework. It manages the association between individual form template items and the tab pages that are displayed within those items. In Oracle EBS 12.1.1 and 12.2.2, HRMS provides a metadata-driven architecture in which administrators define reusable template windows, canvases, tab pages, items, and item-level tab page assignments that govern how Oracle Forms-based, self-service, and professional-user interfaces are rendered. This package is the data-access and manipulation layer for the HR_TEMPLATE_ITEM_TAB_PAGES entity and its related setup tables.

Within the ETRM classification, the package is registered as an API of type OTHER, indicating that it is not a public business API but an internal technology component invoked by the HRMS forms and setup utilities that maintain template metadata. Its presence in the APPLSYS dependency chain and its reference to FND_APPLICATION, FND_FORM, and the broader HR_FORM_* and HR_TEMPLATE_* table families confirm its role in the configurable form template infrastructure.

Key Procedures and Functions

The documented package exposes six subprograms, each reflecting a standard table-handler pattern used throughout Oracle EBS:

  • OWNER_TO_WHO — Utility routine that populates the standard WHO (Who) audit columns, translating the owning schema context into the created-by, creation-date, last-updated-by, and last-update-date attributes required by the HRMS tables.
  • INSERT_ROW — Inserts a new template item-to-tab-page association record, applying the WHO audit defaults and validating the parent references.
  • LOCK_ROW — Acquires a row-level lock on an existing template item tab page record, providing concurrency protection before modification or deletion.
  • UPDATE_ROW — Updates the mutable attributes of an existing association and refreshes the WHO audit columns.
  • DELETE_ROW — Removes a template item tab page association, optionally enforcing referential integrity for dependent child metadata.
  • LOAD_ROW — Seeds or migrates a record from source metadata, typically called by the HRMS template loader during upgrade or template import processing.

Parameter lists are not published in the ETRM metadata and are therefore not reproduced here.

Tables Accessed

The package reads and writes HR_TEMPLATE_ITEM_TAB_PAGES and its sequence HR_TEMPLATE_ITEM_TAB_PAGES_S, which supplies primary keys. It also references the definition tables HR_TEMPLATE_ITEMS_B, HR_TEMPLATE_TAB_PAGES_B, HR_TEMPLATE_CANVASES_B, HR_TEMPLATE_WINDOWS_B, HR_FORM_ITEMS_B, HR_FORM_TAB_PAGES_B, HR_FORM_CANVASES_B, HR_FORM_WINDOWS_B, and HR_FORM_TEMPLATES_B, which provide the template and form metadata hierarchy. FND_APPLICATION and FND_FORM resolve application and form registration information, and DUAL supplies sequence and default lookups. All tables are accessed via APPS synonyms.

Usage Notes

This package is invoked by HRMS template configuration forms and by the template loader routines that populate and maintain template item tab page assignments. It is typically called during template definition, template upgrade, and template import, and via concurrent programs that seed or copy template metadata. It is not intended for direct invocation by custom code; any extension should use supported HRMS public APIs. The package is referenced by no other packages in the documented set, confirming its role as a leaf-level data handler within the HRMS template architecture.