Search Results hr_form_canvases_b_s

Overview

APPS.HR_FORM_CANVASES_PKG is a PL/SQL package body in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 releases that supports the maintenance of Oracle Forms canvas metadata within the Human Resources (HR) module. A "canvas" in Oracle Forms terminology refers to the drawing surface on which form items are arranged and displayed, and EBS stores this metadata in the HR_FORM_CANVASES_B, HR_FORM_CANVASES_B_S, and HR_FORM_CANVASES_TL tables so that forms, windows, and their associated canvases remain synchronized across the application.

The package functions as an internal data-management and loading utility rather than a public business API. The ETRM classification of "OTHER" and the presence of a companion _B_S synonym ("hr_form_canvases_b_s") indicate the package forms part of the infrastructure used by Oracle's Forms-related seed-data loading and the AOL (Application Object Library) form registration process. It provides a controlled set of DML and translation operations against the underlying base and translation tables.

Key Procedures and Functions

The package exposes eight documented procedures and functions, each serving a discrete maintenance role:

• OWNER_TO_WHO — Utility routine that maps or copies "owner"-style columns into the standard WHO audit columns (created_by, creation_date, last_updated_by, etc.), ensuring row-level audit information is populated consistently.
• INSERT_ROW — Inserts a new canvas definition into the base table HR_FORM_CANVASES_B, populating identifiers and descriptive attributes.
• LOCK_ROW — Acquires a row-level lock on an existing canvas record to support concurrency control before an update or delete.
• UPDATE_ROW — Modifies attributes of an existing canvas row, including the WHO audit columns and the last update date.
• DELETE_ROW — Removes a canvas definition and its dependent language rows.
• ADD_LANGUAGE — Inserts a new language translation row into HR_FORM_CANVASES_TL, enabling multilingual display of the canvas name or description.
• TRANSLATE_ROW — Updates the translated (user-facing) text for an existing canvas row in the TL table.
• LOAD_ROW — Seed-data loader that performs an insert-or-update against a canvas record, used during installation, patch application, and form-metadata synchronization.

These procedures are not documented as accepting particular parameter lists in ETRM; their usage is confined to the internal loading and maintenance workflow.

Tables Accessed

The package references the following tables (accessed via APPS synonyms):

• HR_FORM_CANVASES_B — Base table storing canvas metadata for HR forms; primary target of INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOAD_ROW.
• HR_FORM_CANVASES_TL — Translation table holding language-specific canvas text; primary target of ADD_LANGUAGE and TRANSLATE_ROW.
• HR_FORM_CANVASES_B_S — Supporting synonym/table that participates in the loading sequence for canvas definitions.
• FND_FORM — AOL form registry, used to validate that the canvas belongs to a registered form.
• FND_APPLICATION — AOL application registry, used to resolve and validate the owning application.
• FND_LANGUAGES — Installed/active language list, consulted when creating translation rows.
• HR_FORM_WINDOWS_B — Window metadata table, providing the parent window context for a canvas.
• DUAL — Used for single-row utility queries and sequence retrieval.

Referenced supporting packages include APP_EXCEPTION, FND_MESSAGE, and PER_RIC_PKG for error handling and message retrieval.

Usage Notes

HR_FORM_CANVASES_PKG is an internal infrastructure package; it is not referenced by any other database object according to ETRM, and it is not intended for direct invocation by customer code. Its LOAD_ROW procedure is typically driven by Oracle's seed-data loader (FNDLOAD-style) during patch and installation operations, while INSERT_ROW, UPDATE_ROW, DELETE_ROW, ADD_LANGUAGE, and TRANSLATE_ROW back the Forms registration and canvas maintenance screens in the HR Administrator and Application Developer responsibilities.

Because the package is classified as OTHER and depends on the _B, _B_S, and _TL table family, any custom script interacting with canvas metadata should follow the same insert/translate/delete sequence to preserve referential and linguistic integrity across HR_FORM_CANVASES_B and HR_FORM_CANVASES_TL. Direct DML against these tables without the accompanying WHO-column and language handling performed here risks inconsistent audit and translation data.