Results for “pay_defined_balances_s”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.HR_LEGISLATION is the principal driver package for the delivery and maintenance of legislation-specific startup data within Oracle E-Business Suite Human Resources. Its role is to orchestrate the loading of legislative seed data during installation and, subsequently, to execute the same procedures as part of legislative refreshes whenever an HRMS legislative patch or upgrade is applied. The package body source (pelegins.pkb) is one of the oldest continuously maintained components of the HRMS schema, with a revision history extending back to 1993, reflecting its central position in the localization framework.

As an OTHER-classified API rather than a public business API, HR_LEGISLATION is not intended for direct customer invocation in ordinary business flows. It is a delivery engine whose procedures sequence the creation of lookup values, formula definitions, balance definitions, organization information types, and other legislatively mandated configuration records. Within Oracle EBS 12.1.1 and 12.2.2, the same code path supports both first-time installation and repeatable refresh operations, which is why the package begins from the documented line PACKAGE body hr_legislation AS and contains extensive internal versioning notes describing fixes to the ordering of balance routines, duplicate detection, and sequence checking.

Key Procedures and Functions

The ETRM metadata documents eight procedures and functions in this package. No parameter lists are published; the following describes purpose only.

• INSTALL — The primary entry point. It sequences the calls to the remaining legislative startup packages and procedures, driving the full delivery or refresh of legislative data for the installed jurisdictions.
• HRRUNPRC_TRACE_ON and HRRUNPRC_TRACE_OFF — A paired diagnostic facility that enables and disables tracing for the package's execution, used by support and development to capture detailed runtime information during delivery failures or refreshes.
• INSERT_HR_STU_EXCEPTIONS — Records exception rows encountered during the startup data delivery, providing an audit trail of legislative records that could not be inserted or that clashed with existing data.
• MUNGE_SEQUENCE — Resequences data elements, including the internal check_next_sequence logic corrected in the early 70.x revisions, so that generated identifiers and ordering remain consistent across repeated refresh runs.
• PSEUDO_SEED_DATA_CLASH and GET_PSEUDO_ENABLED — A pair of routines supporting detection and querying of clashes between pseudo seed data and existing customer configuration. PSEUDO_SEED_DATA_CLASH reports a conflict, while GET_PSEUDO_ENABLED returns whether pseudo seed processing is active for the current context.

Tables Accessed

The package operates across the HRMS and FND schema surfaces via APPS synonyms. Formula infrastructure is manipulated through FF_FORMULAS_F, FF_COMPILED_INFO_F, FF_DATABASE_ITEMS, FF_FDI_USAGES_F, FF_USER_ENTITIES, and FF_ROUTES. Oracle Applications and localization configuration is read from FND_APPLICATION, FND_LANGUAGES, FND_LOOKUP_VALUES, and FND_PRODUCT_INSTALLATIONS, the latter used to determine which products and legislative sets are installed. HR-specific structures include HR_APPLICATION_OWNERSHIPS, HR_DM_DATABASES, HR_LEGISLATION_SUBGROUPS, HR_ORG_INFORMATION_TYPES, and HR_ORG_INFO_TYPES_BY_CLASS, which together define legislative grouping and the organization information types delivered per legislation.

Usage Notes

HR_LEGISLATION is invoked indirectly rather than from HRMS forms or standard concurrent programs. It is called during HRMS installation and by legislative refresh processes when localized seed data is applied. The reference by five other packages confirms that downstream delivery routines and higher-level installers depend on it. Because it is classified as an OTHER/Maintenance API, custom code should not call it directly; doing so risks corrupting seed data or producing pseudo-seed clashes. Sites in the United Kingdom and other jurisdictions subject to Section 63BA (shared parental leave and pay) encounter this package mainly through underlying legislative delivery; Section 63BA content is supplied by localization patches and the associated legislative data set rather than by any developer-callable entry point in this package.