Search Results pay_leg_field_info

Overview

APPS.PAY_GB_RETRO_UPGRADE is a United Kingdom localizations utility package whose stated purpose, per its own header comments, is to upgrade elements for Enhanced Retropay. It is a one-time or re-runnable data migration helper that converts legacy element definitions into the structures required by the Enhanced Retropay feature set. The package is owned by APPS and is classified in the ETRM repository as OTHER rather than as a public API, confirming that it is intended for internal upgrade and patch execution rather than for general application integration.

The header change list documents a lineage that originated in the US equivalent, payusretroupg.pkb, and a series of corrective iterations between 2005 and 2006. Seeded elements were excluded in version 115.1, and version 115.2 added a NOT EXISTS clause to the insert_retro_comp_usages procedure so that the upgrade could be re-run without generating duplicate rows. Version 115.3 corrected a DELETE statement against PAY_LEG_FIELD_INFO, the entity associated with the user search term pay_leg_field_info. Bug 5609218 subsequently introduced and then reverted ADV_RETRO_COMPONENT_USAGE legislative field information, because that field information is not required to enable the button; the ADVANCED_RETRO leg rule performs that function instead.

Key Procedures and Functions

The documented interface exposes two procedures. Only their purposes are recorded in the ETRM metadata.

• UPGRADE_ELEMENT — Drives the upgrade of an individual element so that it participates correctly in Enhanced Retropay. It evaluates whether the element qualifies for conversion and performs the associated data transformation.
• QUALIFY_ELEMENT — Applies the eligibility test that determines whether a given element should be upgraded. It is the decision point that prevents seeded and otherwise ineligible elements from being processed.

An additional internal procedure, INSERT_RETRO_COMP_USAGES, is visible in the source excerpt and is responsible for populating retro component usage records; its NOT EXISTS guard makes repeated executions safe.

Tables Accessed

The package reads and writes a focused set of payroll and HR tables through APPS synonyms. The core of the upgrade is the retro component model, touched via PAY_RETRO_COMPONENTS, PAY_RETRO_COMPONENT_USAGES and PAY_RETRO_COMPONENT_USAGES_S. Element definition and eligibility logic draws on PAY_ELEMENT_TYPES_F, PAY_ELEMENT_CLASSIFICATIONS, PAY_ELE_CLASSIFICATION_RULES, PAY_ELEMENT_SETS, PAY_ELEMENT_TYPE_RULES, PAY_LEGISLATION_RULES, PAY_LEGISLATIVE_FIELD_INFO, PAY_ELEMENT_SPAN_USAGES and PAY_ELEMENT_SPAN_USAGES_S, together with PAY_TIME_SPANS for span resolution. PAY_PAYROLL_ACTIONS and HR_ORGANIZATION_INFORMATION supply supporting context, and PAY_LEG_FIELD_INFO is manipulated to control legislative field behaviour on the element entry form.

Usage Notes

PAY_GB_RETRO_UPGRADE is invoked during the upgrade path to Enhanced Retropay, typically from patch drivers or a one-off upgrade concurrent program supplied by Oracle Support, and it is not referenced by any other package in the ETRM repository. Because the procedures are guarded for re-runnability, execution may be repeated safely after a failed run. It should not be called directly from custom code; upgrades to element retro configuration in a live 12.1.1 or 12.2.2 environment should be performed through the supported upgrade mechanism or by way of the standard retropay configuration forms.