Search Results s10_01_issue_person

Overview

PAY_FR_DADS_ESTAB_COMP is a French localization payroll package within Oracle E-Business Suite (EBS) that supports the generation and validation of establishment-level data required for the French DADS (Déclaration Annuelle des Données Sociales) regulatory reporting process. The DADS declaration is a mandatory annual social data filing that French employers must submit to the tax and social security authorities, reporting remuneration, contributions, and employment details for every employee. The package is owned by APPS and classified as OTHER under the ETRM documentation model, meaning it is a localization-specific component rather than a public API. Its primary responsibility is to resolve the identifying information of an issuing establishment — including name, SIREN, NIC, and media details — and to compile that information into the structure required by the DADS reporting stream. The package declares a PL/SQL record type, cre_info_issue_rec, which encapsulates the establishment identity fields used throughout the declaration logic.

Key Procedures and Functions

The package exposes four documented procedures:

S10_00_ISSUE_ESTAB — Retrieves establishment-level information for the issuing establishment, returning a populated cre_info_issue_rec record through an OUT parameter. This establishes the legal and administrative identity of the reporting entity for downstream DADS processing.
S10_01_ISSUE_PERSON — Processes person-level (employee) reporting data associated with a given issuing establishment and payroll action. It is the counterpart to S10_00_ISSUE_ESTAB at the individual declaration level.
S20_COMP_INFO — The procedure referenced by the search term "s20_comp_info." It compiles company-level information for the DADS declaration across a defined start and end date range, using the establishment record resolved by S10_00_ISSUE_ESTAB. This procedure is central to aggregating the employer-side declaration content within the reporting period.
S80_INSEE_ESTAB — Handles INSEE (Institut National de la Statistique et des Études Économiques) establishment coding, aligning the reported establishment with official French statistical identifiers required for the declaration.

Tables Accessed

The package reads and writes through APPS synonyms across several Oracle HRMS and Payroll tables:

HR_ORGANIZATION_INFORMATION — Supplies establishment attributes such as SIREN, NIC, and address-selection flags that populate the CRE record.
HR_ALL_ORGANIZATION_UNITS and HR_ALL_ORGANIZATION_UNITS_TL — Provide the establishment name and organization definitions, including translated names.
HR_LOCATIONS_ALL and HR_LOCATIONS_ALL_TL — Provide address details for the issuing establishment.
FND_LOOKUP_VALUES, FND_NEW_MESSAGES, and FND_TERRITORIES — Supply validation values, user-facing messages, and territory/address-formatting metadata.
PAY_ACTION_INFORMATION and PAY_ASSIGNMENT_ACTIONS — Link the declaration logic to specific payroll actions and assignment-level processing runs.
PER_ALL_ASSIGNMENTS_F — Provides assignment records for person-level reporting.

Usage Notes

PAY_FR_DADS_ESTAB_COMP is invoked as part of the French DADS declaration generation workflow, typically driven by Oracle Payroll concurrent programs configured for French legislative reporting. It is referenced by one other package in the ETRM inventory, indicating it is a supporting module rather than a top-level entry point. Because procedures such as S20_COMP_INFO accept a p_payroll_action_id, the package is designed to execute within the context of an active payroll action, where declaration data is assembled per reporting period bounded by start and end dates. Customizations or extensions that call this package directly should respect the AUTHID CURRENT_USER declaration and ensure that the calling schema has appropriate privileges on the underlying HRMS and FND tables. As a localization component, it must only be invoked against French business groups configured with the relevant DADS reporting parameters.