Search Results py_fr_additional_element_rules




Overview
Explore in AI Chat

Overview

The APPS.PY_FR_ADDITIONAL_ELEMENT_RULES package is a payroll configuration utility within Oracle E-Business Suite, positioned in the Oracle Payroll (PY) module under the French (FR) localization layer. Its business purpose is to automate the generation of payroll element rules that arise when an accrual plan requires one or more additional (secondary) element types beyond its primary accrual element. In absence of this package, a payroll administrator would need to manually define input values, element types, element links, and formula result rules through the Element Design forms. The package formalizes and accelerates that work by encapsulating the creation steps in a single callable API.

The package body is a lightweight, focused construct; the header identifies the source file as pyfreliv.pkh, last revised in 2005, which indicates the interface has remained stable across the 11i through 12.1.1 and 12.2.2 releases. It is classified by ETRM as an OTHER API rather than a public or private standard API, meaning it is intended for internal/localization use and is not documented as a supported integration point.

Key Procedures and Functions

  • CREATE_INPUT_VALUE (FUNCTION) — Creates a payroll input value definition. It accepts the element name, input value name, unit of measure, business group, element type identifier, primary classification, legislation code, classification type, sequence, and an optional base name. The function returns a numeric identifier, presumably the generated input value identifier (e.g., input_value_id), allowing the caller to key subsequent configuration steps. It is the lower-level building block used when an element requires a distinct input value to be defined.
  • CREATE_EXTRA_ELEMENTS (PROCEDURE) — The operative routine that a user invoking the search term "create_extra_elements" is looking for. It creates the additional element types and their associated rules for a given accrual plan. Its parameters identify the effective date, the accrual plan (by ID and name), the accrual plan's element type, the business group, the PTO input value, and the accrual category. The effective date governs the datetracked (date-effective) rows written to the element and link tables.

Tables Accessed

Usage Notes

The package is referenced by two other packages and is not exposed through a standard concurrent program or public API. It is customarily invoked indirectly. Expect it to be called from French-localization payroll setup flows, from an element-generation concurrent request, or from custom PL/SQL that loops over accrual plans for a business group. Any caller must pass a business group that has been properly configured for French payroll legislation and must account for datetrack mode, since the effective date parameter drives row versioning in the element tables.