Search Results per_fr_election




Overview
Explore in AI Chat

Overview

PER_FR_ELECTION is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM documentation as an "OTHER" API type rather than as a public, supported business API. Its name associates it with French (FR) legislative and regulatory requirements, specifically the "election" of employee representative bodies such as the Délégué du Personnel, the Comité d'Entreprise, and related French statutory representation structures. In the Oracle EBS HRMS (Human Resources Management System) localization layer, packages with this naming pattern encapsulate the data derivation and validation logic required to support French legal reporting and statutory processes tied to workforce representation.

The package is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2 and depends only on SYS.STANDARD, indicating that it is a self-contained PL/SQL unit that does not reference other APPS packages. The metadata also records that it is referenced by no other packages, confirming that PER_FR_ELECTION operates as a terminal or leaf-level component rather than a shared utility. It exposes a single documented procedure, PROCESS, and references a stable set of HRMS base tables via APPS synonyms.

Key Procedures and Functions

The ETRM metadata documents exactly one callable unit within PER_FR_ELECTION:

  • PROCESS — The primary (and only documented) entry point of the package. Based on the French-election context and the referenced tables, PROCESS is intended to evaluate employee representation data and populate or validate the derived information required for French statutory election reporting. As the metadata provides no parameter signature, no argument list should be assumed; callers must consult the live package specification in the target instance before invocation. PROCESS is the sole documented public interface, and all supporting logic is encapsulated within the package body.

Tables Accessed

The package reads and, where applicable, writes the following HRMS tables through APPS synonyms, as documented in the ETRM metadata:

  • HR_ALL_ORGANIZATION_UNITS — Provides organization unit definitions used to identify the legal entity or establishment for which representative elections apply.
  • HR_ORGANIZATION_INFORMATION — Supplies additional organization-level attributes that qualify the election scope.
  • HR_SOFT_CODING_KEYFLEX — Resolves the Descriptive Flexfield / Key Flexfield combinations used to categorize representation data.
  • PER_ALL_PEOPLE_F — The core person record, supplying names, dates, and person identifiers for the elector and candidate population.
  • PER_ADDRESSES — Address and location data used to determine establishment-level eligibility.
  • PER_ALL_ASSIGNMENTS_F — Assignment records used to determine employment status and the relevant assignment context for each worker.
  • PER_ASSIGNMENT_STATUS_TYPES — Status classification used to filter active versus inactive assignments for eligibility determination.
  • PER_CONTRACTS_F — Contract details, including contract type and dates, relevant to statutory eligibility.
  • PER_PEOPLE_EXTRA_INFO — The repository for person-level DFF/extra information where election-related attributes are stored.

Usage Notes

PER_FR_ELECTION is an internal localization package rather than a supported public API. It is typically invoked from French HRMS localization logic — either from a concurrent program, an Oracle Forms customization, or a wrapper package that drives the statutory election calculation and generates the supporting data set. Because the package is referenced by no other APPS packages, direct calls originate from application or customization code rather than from the standard dependency chain.

Given the sparse ETRM metadata, integrators and support analysts should treat PER_FR_ELECTION as a version-sensitive object. Before extending or calling it, verify the actual package specification in the target instance, confirm the PROCESS signature, and validate behavior identically in both 12.1.1 and 12.2.2, since French legal requirements and the underlying HRMS table structures may differ between these releases.