Search Results pay_fr_dads_estab_comp




Overview
Explore in AI Chat

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

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.