Search Results fr_dads_sort_order

Overview

PAY_FR_DADS_F_PKG is a French localization package within the Oracle E-Business Suite Payroll (PAY) module. Its name reflects its purpose: DADS (Déclaration Annuelle des Données Sociales) is the French annual social data declaration that employers must file with the tax and social security authorities. The "_F" suffix denotes a French legislative/localization object, and the package body serves as the functional engine that generates DADS reporting output for a given business group and issuing establishment.

The package accepts a rich set of filing parameters — issuing establishment, DADS reference, report type, declaration nature and type, report inclusions, sort orders, and submission type — and produces formatted output written through the FND_FILE concurrent-program file APIs. It therefore functions primarily as a report generator invoked by a French payroll concurrent program rather than as a general-purpose business API. The ETRM classification of OTHER is consistent with a report-driver package that is not part of a published open interface.

Key Procedures and Functions

• PROCESS — The main entry point and driver procedure. It receives the full set of DADS filing parameters and coordinates the generation of the declaration output. The documented body shows it writing each incoming parameter to the concurrent program output file for traceability, including decoding the sort-order code values through HR_GENERAL.DECODE_LOOKUP against the FR_DADS_SORT_ORDER lookup type so that the log records the human-readable meaning rather than the internal code. PROCESS governs the overall execution flow of the declaration run.
• WRITE_USER_FILE_REPORT — Writes the user-facing report file for the DADS declaration. This procedure is responsible for producing the formatted report content delivered to the user as the concurrent request output.
• CONTROL_PROC — A control procedure that manages process-level validation or orchestration for the DADS run, separating control logic from the main processing and file-writing routines.

Tables Accessed

• FND_NEW_MESSAGES — The Oracle Application Object Library messages table, used to retrieve and raise standardized error or informational messages during DADS processing. Access is via the APPS synonym.
• HR_ALL_ORGANIZATION_UNITS_TL — The translated organizations table, used to resolve the issuing establishment and related organization details into the language-appropriate description required on the French declaration.
• PAY_ACTION_INFORMATION — The payroll action information table, which stores action-level details (such as payroll action parameters and statuses) needed to identify and describe the payroll data being declared.

Usage Notes

This package is not a public API. The ETRM metadata records zero other packages referencing it, indicating it is invoked directly by its associated French DADS concurrent program rather than being called from other PL/SQL units. It is executed at the time the French DADS declaration is run, typically on an annual basis, with the concurrent program supplying the business group, issuing establishment, declaration nature and type, report inclusions, sort orders, and submission type.

Because output is emitted through FND_FILE, the results are consumed as the concurrent request's output file. In Oracle EBS 12.1.1 and 12.2.2 the package resides in the APPS schema and references its underlying objects through APPS synonyms. Customers should treat PAY_FR_DADS_F_PKG as a localized, report-oriented component: it should typically be invoked only through its delivered concurrent program, and direct calls should be avoided unless supporting a documented extension point.