Search Results hr_form_tab_pages_b_s

Overview

The APPS.HR_FORM_TAB_PAGES_PKG package body is a metadata maintenance utility within the Oracle E-Business Suite Human Resources (HR) module. Its purpose is to support the definition, registration, translation, and lifecycle management of "tab pages" — the supplemental tabbed regions that appear within Oracle Forms-based HR windows and canvases. In EBS 12.1.1 and 12.2.2, tab pages are stored as seeded or customer-defined metadata rows, and this package provides the programmatic interface used to create, modify, lock, delete, and localize those rows.

The package belongs to the broader HR Forms configuration framework, which links forms (FND_FORM), application registrations (FND_APPLICATION), windows (HR_FORM_WINDOWS_B), and canvases (HR_FORM_CANVASES_B) into a navigable structure. Because the rows are translatable, the package also handles language-specific maintenance and row loading routines common to EBS seed-data utilities.

Key Procedures and Functions

The ETRM metadata documents eight procedures/functions, all of which are standard data-manipulation and row-maintenance entry points:

• OWNER_TO_WHO — Resolves and standardizes the "WHO" audit columns (created_by, last_updated_by, etc.) for rows processed by the package. It typically maps an owner identifier to the standard audit context used by EBS WHO columns.
• INSERT_ROW — Inserts a new tab-page definition row into the base table, including associated descriptive attributes and audit information.
• LOCK_ROW — Acquires a row-level lock on an existing tab-page record, preventing concurrent modification during an update or delete operation.
• UPDATE_ROW — Modifies an existing tab-page definition row and refreshes the audit columns and timestamp.
• DELETE_ROW — Removes a tab-page definition row (or logically deactivates it), subject to dependency checks.
• ADD_LANGUAGE — Adds a new language row to the translatable (_TL) table, enabling localization of the tab-page description.
• TRANSLATE_ROW — Updates the language-specific descriptive text on an existing translation row.
• LOAD_ROW — Bulk-loads tab-page definitions from seed or upload data, invoking the appropriate insert/update logic based on the presence of an existing key.

The parameter lists are not documented in the ETRM excerpt and are intentionally omitted here.

Tables Accessed

The package reads and writes the following objects, all accessed through APPS synonyms:

• HR_FORM_TAB_PAGES_B — The base (non-translatable) table storing core tab-page attributes.
• HR_FORM_TAB_PAGES_B_S — The sequence used to generate primary keys for new base rows; this is the object referenced in the user's search term (hr_form_tab_pages_b_s).
• HR_FORM_TAB_PAGES_TL — The translation table holding language-specific descriptions, managed by ADD_LANGUAGE and TRANSLATE_ROW.
• HR_FORM_CANVASES_B and HR_FORM_WINDOWS_B — Parent forms-definition tables used for referential validation when inserting or updating tab pages.
• FND_FORM and FND_APPLICATION — Application/function registration tables used to validate the owning form and application.
• FND_LANGUAGES — Supplies the installed/active language list for translation operations.
• DUAL — Standard single-row utility table.

Usage Notes

The package is invoked by the HR Forms configuration forms and by the seed-data loading infrastructure that populates tab-page metadata during installation, upgrade, or patching. The LOAD_ROW procedure is the standard entry point for concurrent or scripted data loading, while INSERT_ROW, UPDATE_ROW, and DELETE_ROW support interactive form-based maintenance. The ETRM metadata confirms the package is not referenced by any other database object, so it is a top-level API called directly rather than through internal dependencies. Custom implementations should call the documented procedures rather than issuing direct DML against the underlying tables to ensure audit columns and translations are maintained consistently.