Search Results hr_form_stack_canvas_info




Overview
Explore in AI Chat

Overview

HR_FORM_STACK_CANVAS_INFO is a PL/SQL package body owned by the APPS schema and marked VALID in Oracle E-Business Suite releases 12.1.1 and 12.2.2. Its classification within the ETRM repository is "OTHER," indicating that it is a supporting internal utility rather than a published, customer-facing API. The package belongs to the Oracle Human Resources (HR) module and serves the metadata-driven architecture of the Oracle Forms-based HR forms, specifically the logic that resolves how stacked canvases and tabbed regions are presented within a given form window.

In the Oracle Forms technology stack, a single window may host multiple canvases, and tabbed regions may contain stacked canvases that must be shown or hidden dynamically as the user navigates. HR_FORM_STACK_CANVAS_INFO encapsulates the repository queries required to determine which canvases belong to which form, window, tab page, and stack, and feeds that information to the form at runtime. This allows Oracle HR forms such as the People, Assignment, and Position windows to render their tabbed interfaces consistently without hard-coding canvas relationships in each form module.

Key Procedures and Functions

The documented package body exposes one program unit:

  • FORM_STACK_CANVASES — The sole documented procedure/function in this package. Based on its name and the package's dependency set, it retrieves the set of canvases that participate in stacked-canvas (tabbed) navigation for a form. The ETRM metadata does not publish a parameter list, so the exact signature is not reproduced here. In practice, the routine queries the HR form repository tables and returns or exposes the canvas stack definitions that the calling form uses to drive WHEN-TAB-PAGE-CHANGED and related navigation triggers.

No other procedures or functions are documented for this package body. The single entry point reflects the package's narrow, single-purpose design: resolving stacked canvas information on demand rather than providing a broad API surface.

Tables Accessed

The package body references the following tables through APPS synonyms, as documented in the dependency information:

  • FND_APPLICATION — Oracle Applications registration table, used to resolve the application context in which the form and its canvases are defined.
  • FND_FORM — The Applications form registry, providing form-level identification and context for the canvas lookup.
  • HR_FORM_CANVASES_B — The base table storing canvas definitions for HR forms, including canvas names and their association to windows.
  • HR_FORM_WINDOWS_B — The base table storing window definitions for HR forms, establishing the window-to-canvas hierarchy.
  • HR_FORM_TAB_PAGES_B — Defines tab pages within HR forms, which determine how stacked canvases are grouped and displayed.
  • HR_FORM_TAB_STACKED_CANVASES — The intersection table that maps tab pages to their associated stacked canvases, and therefore the primary source for the procedure's output.
  • PLITBLM — The standard Oracle Forms PL/SQL table (associative array) type used to pass collections of values between the database and the form runtime.

The package also depends on HR_API and the SYS.STANDARD package. It does not write to any of these tables; the logic is read-only metadata resolution.

Usage Notes

HR_FORM_STACK_CANVAS_INFO is an internal implementation package. It is not referenced by any other database object, which confirms that its only consumers are Oracle Forms modules in the HR product family. Typical invocation occurs when an HR form initializes or when the user switches tab pages, at which point the form calls FORM_STACK_CANVASES to obtain the canvas stack definitions and then issues SET_CANVAS_PROPERTY or SHOW_VIEW/SHOW_WINDOW calls accordingly.

Because the package is not a public API and is not referenced by other database objects, customizations should not call it directly. Instead, customers extending Oracle HR forms should work through supported form personalization or the documented HR APIs. Direct invocation is unsupported and may be affected by patch upgrades between 12.1.1 and 12.2.2, since the underlying repository tables and the package body are subject to Oracle's internal maintenance.