Search Results hr_fr_mmo




Overview
Explore in AI Chat

Overview

APPS.HR_FR_MMO is a France-specific (FR localization) PL/SQL package within the Oracle E-Business Suite Human Resources module. Its name derives from the French Mouvement de Main d'Oeuvre (MMO), the mandatory workforce movement declaration that French establishments must periodically report to labor authorities. The package encapsulates the date and reason derivation logic required to produce this statutory report, isolating the French localization business rules from the core HR schema.

The package is classified under ETRM as OTHER, indicating it is not a public, supported API intended for third-party extension. Its header carries the comment "Internal Row Handler Use Only," confirming that it is an internal implementation component. The header revision string (hrfrmmo.pkh 120.0, dated 2005) indicates the specification has remained stable across the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

  • GET_FORMULA — Returns the formula_id of the Oracle Fast Formula to be used for resolving the starting and leaving reasons in the MMO report. Depending on configuration, this resolves either the USER_MMO_REASON formula or the TEMPLATE_MMO_REASON formula. The function accepts a business group identifier and a session date, and is declared with PRAGMA RESTRICT_REFERENCES(..., WNDS, WNPS), making it safe to call from SQL.
  • GET_START_DATE — Returns the start date for persons identified as having joined (or been present at) the establishment during the reporting period. Its documented inputs are the person identifier, the establishment identifier, and the end date bounding the reporting window.
  • GET_END_DATE — Returns the end date associated with a person's movement out of the establishment for the reporting period. This is the function most commonly located by developers searching for "get_end_date," and it is the counterpart to GET_START_DATE in constructing the MMO report rows.
  • GET_REASON — Derives the movement reason (for example, hire, termination, or transfer) that must be printed on the declaration, applying the formula resolved by GET_FORMULA.

These four functions operate as a cohesive set: the date pair frames the movement window, the formula controls configurability, and the reason function supplies the regulatory justification text.

Tables Accessed

  • FF_FORMULAS_F — The Fast Formula repository, queried to validate and resolve the formula identifier returned by GET_FORMULA.
  • PER_ALL_ASSIGNMENTS_F — The primary assignment datetrack table, read to determine effective assignment start and end dates for the person and establishment.
  • PER_ASSIGNMENT_STATUS_TYPES — Consulted to interpret assignment status (active, terminated, suspended) when classifying a movement as an entry or a departure.
  • PLITBLM — The PL/SQL table used for bulk row handling within the localization's reporting logic.

All references are made through APPS synonyms, consistent with standard EBS naming and the internal, non-API nature of the package.

Usage Notes

HR_FR_MMO is invoked by the French MMO report and its supporting concurrent program rather than called directly from application forms. The report driver supplies the business group and session date, then iterates over the establishment population, calling GET_START_DATE, GET_END_DATE, and GET_REASON for each person to assemble the declaration rows. GET_FORMULA is called once per run and its result cached to avoid repeated formula lookups.

Because the package is documented as internal row handler use only and is referenced by one other package, customizations should not call it directly; the supported extension point for MMO reason logic is the Fast Formula configuration (USER_MMO_REASON or TEMPLATE_MMO_REASON) that GET_FORMULA resolves. The single dependent package suggests the call graph is narrow and tightly coupled to the localization's report generation path.