Search Results translate_ca_ele_dev_df

Overview

HR_LEGISLATION_LOCAL is a server-side PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It operates as a supporting utility for the Oracle HRMS localization and legislation framework, which governs how payroll and human-resources rules vary by legislative jurisdiction (for example, United States, Canada, or other localizations). The package carries an ETRM API classification of OTHER, indicating that it is not a public, documented business API intended for direct customer invocation but rather an internal component used to install, seed, and translate legislative data during setup, cloning, and localization maintenance operations.

Its primary role centres on the installation of legislation-specific configuration — particularly United States and Canadian element and balance definitions — and on resolving derived payroll information such as element balance context. Because it writes to legislative, tax, report, and balance metadata tables, the package is central to ensuring that a newly provisioned or upgraded EBS instance receives the correct statutory configuration.

Key Procedures and Functions

The ETRM metadata documents five procedures and functions within this package:

• INSTALL — The principal installation driver, responsible for populating legislation-level configuration records for the applicable localization during setup or upgrade.
• INSTALL_US_NEW — A specialized variant that installs United States-specific legislative and element definitions, reflecting the periodic additions Oracle delivers for US payroll and tax structures.
• DECODE_ELMNT_BAL_INFORMATION — Resolves or decodes balance-related information for a payroll element, supporting the mapping between element definitions and the balance types they feed.
• TRANSLATE_US_ELE_DEV_DF — Translates United States element developer descriptive flexfield (DF) content, enabling localized or language-specific rendering of element metadata.
• TRANSLATE_CA_ELE_DEV_DF — Performs the equivalent translation function for Canadian element developer descriptive flexfield content.

Only the procedure and function names are documented; parameter lists are not exposed in the metadata and should not be assumed.

Tables Accessed

The package reads and writes through APPS synonyms across several functional areas:

• Legislative and rule metadata: HR_S_LEGISLATION_RULES, HR_S_STATE_RULES, HR_S_TAXABILITY_RULES — the core rule tables that define how elements are taxed and processed within a jurisdiction.
• Element and balance definitions: HR_S_ELEMENT_TYPES_F and HR_S_BALANCE_TYPES — the dated, translated element and balance repositories that the install routines seed.
• US and Canada tax configuration: HR_S_US_FEDERAL_TAX_INFO_F, HR_S_US_CITY_TAX_INFO_F, HR_S_US_COUNTY_TAX_INFO_F — federal, city, and county tax information used to build US statutory tax structures.
• Lookups and history: HR_S_REPORT_LOOKUPS, HR_REPORT_LOOKUPS, HR_S_HISTORY, HR_STU_EXCEPTIONS, and HR_ORG_INFO_TYPES_BY_CLASS — supporting reference and exception data.
• Installed-solution context: FND_PRODUCT_INSTALLATIONS and FND_ID_FLEX_STRUCTURES — used to confirm what is installed and to locate the key flexfield structures relevant to element definitions.

Usage Notes

HR_LEGISLATION_LOCAL is referenced by the APPS.HR_LEGISLATION package, which is the more commonly encountered legislation-handling component, and by one other tracked package. It is therefore normally invoked indirectly — during HRMS legislation installation, patching, or upgrade processing — rather than from end-user forms or concurrent programs. Custom code should not call this package directly unless replicating an Oracle-supported installation path, since its routines assume a controlled setup sequence and write to seeded legislative tables. Any diagnostic or troubleshooting activity should treat it as an internal dependency and consult Oracle support documentation before direct execution.