Search Results get_template_name

Overview

APPS.HR_TMPLT is a lookup and description utility package within the Oracle E-Business Suite HRMS (Human Resources Management System) schema. Its primary business function is to resolve internal numeric identifiers into human-readable names and descriptions for the various configuration objects that make up Oracle FastFormula and form-template structures. Rather than storing denormalized name columns, the HRMS data model stores foreign keys to definitions such as application, form, form template, tab page, formula, and balance category. HR_TMPLT provides a centralized API that translates those keys back into meaningful text, allowing forms, reports, and concurrent programs to present user-friendly labels without duplicating join logic. The package belongs to the APPS schema, is classified as OTHER in the ETRM catalog, and is referenced by no other documented packages, which indicates it is consumed primarily by Oracle Forms code and ad-hoc report logic rather than by other server-side PL/SQL modules. Its version history (header tag hrfcrlct.pkh 120.2, dated 2005) shows it has been a stable part of the HRMS form-template framework since at least the early 11i era and remains present in 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes ten public functions. All take a numeric identifier as input and return a VARCHAR2 description:

• GET_ITEM_NAME — returns the display name of a form item, identified by item, application, and form identifiers.
• GET_FORMULA_NAME — overloaded; one version resolves a formula ID, the second resolves a formula associated with an element type at a given effective date.
• GET_LEGISLATION_NAME — returns the legislation (country/regulatory) name associated with a formula.
• GET_BUS_GROUP_NAME — returns the business group name associated with a formula.
• GET_TAB_PAGE_NAME — resolves a form tab page and canvas combination into its page name.
• GET_TEMPLATE_NAME — returns the descriptive name of a form template.
• GET_APPLICATION_NAME — returns the name of the Oracle application owning a given form template. This is the function most frequently searched, as it is the standard shortcut for resolving an application ID from a template context.
• GET_FORM_NAME — returns the form name associated with a form template.
• GET_BALANCE_CATEGORY — returns the descriptive name of a payroll balance category.

Tables Accessed

Based on the documented dependencies, the package reads from the following APPS-synonymed tables. FND_APPLICATION supplies application names for GET_APPLICATION_NAME; FND_FORM supplies form names; HR_FORM_TEMPLATES_B provides the template definitions that link templates to applications and forms; HR_FORM_TAB_PAGES_B backs GET_TAB_PAGE_NAME; and HR_FORM_ITEMS_B backs GET_ITEM_NAME. Formula-related lookups draw on FF_FORMULAS_F, while PAY_BALANCE_CATEGORIES_F supports GET_BALANCE_CATEGORY and PAY_STATUS_PROCESSING_RULES_F supplies legislative and business-group context. Because these are definition (setup) tables rather than transactional tables, the package performs read-only lookups and does not commit or modify data.

Usage Notes

HR_TMPLT is typically invoked from Oracle Forms personalizations, custom form triggers, and report queries where a template or application ID must be rendered as text. It is also useful in custom concurrent programs and SQL*Plus scripts that audit form-template configuration. Because the functions perform single-row lookups against setup tables, performance is generally acceptable, but callers running set-based queries should consider joining the underlying tables directly to avoid row-by-row context switches. The package is not documented as an open extension point and should not be modified; Oracle-managed upgrades may replace it. When using GET_APPLICATION_NAME or its siblings, callers should handle a NULL return, which occurs when the supplied identifier does not match a current, effective row.