Search Results hr_template_stack_canvas_info




Overview
Explore in AI Chat

Overview

APPS.HR_TEMPLATE_STACK_CANVAS_INFO is a PL/SQL package in the Oracle E-Business Suite Human Resources (HR) schema. Its documented status is VALID, and it is classified under the ETRM "OTHER" API classification category, indicating that it is a component of the Oracle HRMS form-template and canvas rendering infrastructure rather than a public, supported business API. The package supports the definition and management of "stacked canvases" within Oracle HRMS form templates — that is, the layout metadata that governs how multiple canvas regions are layered or ordered within a given tab page of an HR form.

The package operates against HR Forms configuration tables, which store the structure of the configurable HRMS forms used to display and capture person, assignment, and related information. Its role is tied to the template configuration stack that determines which canvases appear on which tab pages and in what order.

Key Procedures and Functions

The documented metadata lists two procedures or functions in this package:

  • TEMPLATE_STACK_CANVASES — The primary routine, which handles the processing of stacked canvas information for HR form templates. Based on the package name and its dependency on HR_FORM_TAB_STACKED_CANVASES, this procedure processes or retrieves the set of canvases stacked on a form tab page, reading the form canvases and tab page definitions and assembling the canvas stack for the template.
  • TEMPLATE_STACK_CANVASES_PST — A companion routine, identifiable by the "_PST" suffix convention typical in Oracle EBS for a post-processing or post-save variant. It likely performs the write/persist phase for the stacked canvas configuration after the main retrieval or processing logic has executed.

Only these two procedures are documented; no parameter lists are disclosed in the available metadata, and parameter details should be obtained from the package specification via ALL_ARGUMENTS or the package source if required.

Tables Accessed

The package references the following APPS-owned base tables through synonyms:

  • HR_FORM_TEMPLATES_B — Stores HR form template definitions; the package uses this to associate stacked canvas metadata with a specific template.
  • HR_FORM_TAB_PAGES_B — Defines tab pages within HR form templates; the package relates each stacked canvas set to a tab page.
  • HR_FORM_TAB_STACKED_CANVASES — The principal table holding the stacked canvas definitions, linking tab pages to the canvases that appear in each stack.
  • HR_FORM_CANVASES_B — Defines the individual canvases available within HR form templates; the package resolves stack members to their canvas definitions.
  • PLITBLM — An Oracle-supplied PL/SQL table type reference used internally for in-memory collection handling.

Together these tables form the configuration model for the dynamic, template-driven HRMS forms, and the package reads and (via the PST routine) writes the stacked canvas relationships that drive form layout behavior.

Usage Notes

HR_TEMPLATE_STACK_CANVAS_INFO is an internal component of the HRMS form-template configuration framework. It is not a published, supported API and is referenced by zero other packages per the ETRM metadata, meaning no other documented PL/SQL package depends on it. Its meaning is limited to the HR forms configuration layer and the Oracle Forms-based runtime that interprets stacked canvas information.

Typical invocation occurs indirectly during HRMS form template setup and rendering, through the underlying framework that reads and writes HR_FORM_TAB_STACKED_CANVASES. Custom code should not call this package directly; developers seeking to manipulate stacked canvas configuration should prefer supported Oracle HRMS APIs or the relevant setup forms. Because the "_PST" routine performs persistence, standard transactional and validation rules for the HR form configuration tables apply when it executes.