Search Results hr_form_template_info




Overview
Explore in AI Chat

Overview

HR_FORM_TEMPLATE_INFO is an OTHER-classified PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Oracle HRMS (Human Resources Management System) family of template and form-personalization utilities, and it serves as a metadata resolution layer for the HR Forms and Template architecture. In EBS, HR forms such as the Employee Assignment, Personal Information, and related self-service and professional forms are not hard-coded; instead they are described declaratively through a repository of templates, canvas structures, item definitions, tab pages, windows, and stacks. HR_FORM_TEMPLATE_INFO exposes the information required to resolve a form definition to its underlying application, form identifier, and formatting rules so that downstream template-processing packages can generate, validate, or render the form correctly. The package is valid in the current ETRM snapshot and is documented with seven procedures/functions, five of which are explicitly catalogued: FORM_TEMPLATE, APPLICATION_ID, FORM_ID, DATE_FORMAT_MASK, and DATETIME_FORMAT_MASK.

Key Procedures and Functions

  • FORM_TEMPLATE — The primary entry point of the package. It resolves and returns template definition information for a given HR form, acting as the accessor through which callers obtain the form template record used by the surrounding HRMS template engine.
  • APPLICATION_ID — Returns the application identifier associated with a form or template context, allowing callers to key into FND_APPLICATION and related Application Object Library metadata.
  • FORM_ID — Returns the FND_FORM identifier for a form, enabling linkage between HR template metadata and the standard EBS form registry.
  • DATE_FORMAT_MASK — Supplies the date formatting mask used when rendering or interpreting date fields within the template, honoring the form's or user's configured display conventions.
  • DATETIME_FORMAT_MASK — Provides the corresponding date-and-time formatting mask for template fields that carry combined date/time values.

The remaining two documented units are internal helpers that support the resolution logic above; their documented names are not enumerated in the ETRM excerpt. Parameter lists are deliberately not reproduced here, as the metadata does not publish them and they should be confirmed against the deployed package specification.

Tables Accessed

The package reads from five documented tables, all resolved through APPS synonyms:

  • FND_APPLICATION — Provides application registration data used by APPLICATION_ID to validate and resolve the owning application of a form.
  • FND_FORM — The Application Object Library form registry, used by FORM_ID to map a form name to its internal form identifier.
  • FND_FORM_FUNCTIONS — Supplies form function metadata, connecting form definitions to the function-based navigation and security model.
  • HR_FORM_PROPERTIES — Stores HR-specific form properties that drive template behavior and rendering characteristics.
  • HR_FORM_TEMPLATES_B — The base table of HR form template definitions, the principal source of the metadata returned by FORM_TEMPLATE.

Usage Notes

HR_FORM_TEMPLATE_INFO is an internal rather than a public API. It is referenced by five other packages — HR_FORM_TEMPLATE_INFO itself (recursive internal calls), HR_TEMPLATE_CANVAS_INFO, HR_TEMPLATE_ITEM_INFO, HR_TEMPLATE_STACK_CANVAS_INFO, HR_TEMPLATE_TAB_PAGE_INFO, and HR_TEMPLATE_WINDOW_INFO — all of which form the HRMS template-inspection layer. It is therefore indirectly exercised whenever HR forms are rendered, personalized, or validated, and it should not normally be invoked directly by customers. Custom code requiring template metadata should prefer the documented HRMS template APIs. Because it depends on STANDARD and SYS facilities, it must execute in a standard APPS session. Oracle supports it only as part of the delivered HRMS template infrastructure; direct calls are unsupported and subject to change between patch levels.