Search Results per_fr_termination_upg_pkg




Overview
Explore in AI Chat

Overview

PER_FR_TERMINATION_UPG_PKG is a localized Oracle HRMS upgrade package shipped under the APPS schema and classified in the ETRM repository as an "OTHER" API. It exists to migrate or normalize French (FR) termination data during an upgrade cycle, converting legacy termination records stored on the PER_PERIODS_OF_SERVICE entity into the structure expected by the current release. The package header is dated 2002, indicating it originated in an earlier release line and was retained through Oracle E-Business Suite 12.1.1 and 12.2.2 to support customers performing upgrades from legacy HRMS versions where French statutory termination handling was maintained differently. The AUTHID CURRENT_USER declaration means the package executes with the privileges of the invoking session rather than as a definer's-rights unit, so the calling user must already hold the necessary HRMS data privileges. In 12.2.2 the package is documented with a single entry point, consistent with a narrow, one-shot data-fix utility rather than a general-purpose business API.

Key Procedures and Functions

  • RUN_UPGRADE — The sole documented program unit, defined as a function returning a NUMBER. It accepts a business group identifier and performs the French termination upgrade processing scoped to that business group. The NUMBER return value conventionally signals success or failure, allowing a concurrent program or calling script to test the outcome without raising an exception. No parameter list beyond the business group identifier is documented, and no additional overloading is defined in the package specification.

Tables Accessed

The package operates against two documented base tables, both addressed through APPS synonyms:

  • PER_ALL_PEOPLE_F — The datetracked person record. The upgrade reads employee assignments and their effective dates so that termination processing is applied to the correct person rows within the specified business group.
  • PER_PERIODS_OF_SERVICE — The periods-of-service entity that holds hire, termination, and service-history rows. This is the primary target of the upgrade, as French termination details are carried on the period-of-service record and must be reconciled to the current column and date-track conventions.

Usage Notes

PER_FR_TERMINATION_UPG_PKG is an upgrade-time utility and is not intended for routine transactional use. It is typically invoked from a concurrent program or an upgrade driver script, once, with the target business group passed in, during the transition to the current release. Because the function returns a status NUMBER, callers should capture the return value and validate it rather than assuming silent success. The ETRM metadata records that the package is referenced by one other package, so dependency analysis should include that caller before any modification or removal. Customers running Oracle EBS 12.1.1 or 12.2.2 who are not upgrading French HRMS data will generally never execute this package; it remains in the APPS schema primarily as a compatibility artifact. No documented public API or form invokes it directly, and it should not be embedded in ongoing custom code.