Search Results archive_data

Overview

PAY_FR_DADS_ESTAB_COMP is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema that supports French statutory payroll reporting obligations, specifically the DADS (Déclaration Annuelle des Données Sociales) declaration framework. The package encapsulates the establishment-level ("établissement") data compilation logic required to build the French DADS archival and reporting structures used during year-end payroll processing.

The package is classified as "OTHER" in the ETRM API registry, meaning it is not a public integration API but an internal component invoked by the French payroll legislative reporting engine. Its primary responsibility is to archive the establishment and person-level data extracted for the DADS declaration into the PAY_ACTION_INFORMATION table so that the resulting dataset can be persisted, audited, and rendered into the statutory submission formats required by French authorities.

The excerpt above makes clear that the package's archive_data procedure is the central mechanism for this persistence. It accepts the payroll action identifier and a series of rubric, message, organization, lookup, and usage values, and writes them into the action information framework using pay_action_information_api.create_action_information. The action information category assigned is FR_DADS_FILE_DATA, clearly identifying these rows as French DADS file data.

Key Procedures and Functions

• S10_00_ISSUE_ESTAB — Drives the establishment-level section of the DADS declaration. This procedure gathers the headcount and establishment structure data for the reporting entity and routes it into the archiving framework. The S10 naming indicates it is part of the first stage of the DADS extraction sequence.
• S10_01_ISSUE_PERSON — Handles the individual (person) level extraction within the same S10 stage, producing the per-employee declaration records associated with each establishment.
• S20_COMP_INFO — Compiles complementary establishment information ("COMP" indicating complementary data) in the second sequence stage. This stage enriches the declaration with additional establishment details beyond the core S10 extract.
• S80_INSEE_ESTAB — Produces the INSEE-related establishment data, referencing French national statistics institute coding. The S80 sequence position suggests it is a later, consolidating stage of the DADS generation process.

The archive_data procedure, though not enumerated in the documented procedure list, is the shared archiving engine called by the S10 and S20 procedures to persist establishment and person data.

Tables Accessed

• PAY_ACTION_INFORMATION — The primary write target. Archived DADS establishment and person data rows are created here under the FR_DADS_FILE_DATA category.
• HR_ALL_ORGANIZATION_UNITS and HR_ALL_ORGANIZATION_UNITS_TL — Supply establishment/organization names and translated descriptions for the establishment identifiers.
• HR_ORGANIZATION_INFORMATION — Provides additional organization-level attributes such as SIRET and establishment classification data.
• HR_LOCATIONS_ALL and HR_LOCATIONS_ALL_TL — Supply address and location data required on the DADS declaration.
• FND_LOOKUP_VALUES — Used to decode lookup codes into user-readable meanings via hr_general.decode_lookup.
• FND_NEW_MESSAGES and FND_TERRITORIES — Provide message text and territory/INSEE-related reference data.
• PAY_ASSIGNMENT_ACTIONS and PER_ALL_ASSIGNMENTS_F — Provide the assignment and person records that form the employee-level declaration content.

Usage Notes

This package is invoked internally by the French DADS payroll reporting process, typically triggered through the associated French legislative reporting concurrent programs and their action-level processing. The archive_data procedure is designed to be called from the S10 and S20 procedures rather than directly, establishing a layered extraction-to-archive flow.

Because the package is classified as "OTHER" and references internal APIs such as pay_action_information_api and hr_general, it should not be called directly from custom code without understanding the payroll action context. It is referenced by one other package within the French payroll legislative framework, reflecting its role as a component of a larger reporting suite. The archived rows in PAY_ACTION_INFORMATION provide the durable audit trail and the source dataset from which the final DADS file is generated.