Search Results p_submission_type

Overview

APPS.PAY_FR_DADS_F_PKG is a French statutory reporting package within the Oracle E-Business Suite Payroll (PAY) module. The acronym "DADS" refers to the Déclaration Annuelle des Données Sociales, the mandatory annual social data declaration that French employers must submit to the tax and social security authorities. The suffix "F" denotes the French localization variant of the DADS declaration processing logic.

The package encapsulates the procedural logic required to gather, format, and emit DADS declaration data extracted from Oracle Payroll and Oracle HRMS records. It is classified as "OTHER" under the ETRM API classification scheme, meaning it is not a public, supported integration API but rather an internal implementation component. The package is declared with AUTHID CURRENT_USER, so its SQL executes under the privileges of the invoking schema (typically APPS), and it relies on APPS synonyms for all referenced database objects. The header identifies the source file as pyfrdadf.pkh, with a version reference dating from December 2003, indicating the package has been stable across multiple EBS releases, including 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes three documented procedures:

• PROCESS — The principal entry point. It accepts the standard concurrent program error buffer and return code parameters, followed by business group, issuing establishment, DADS reference, report type, declaration nature, declaration type, report inclusions, two sort order parameters, and a submission type. The P_DUMMY parameter is explicitly annotated in the source as being present solely to enable P_SUBMISSION_TYPE, a legacy positional-parameter workaround. PROCESS coordinates the overall declaration run.
• WRITE_USER_FILE_REPORT — This is the procedure the user searched for. It mirrors the input signature of PROCESS, minus the error buffer, return code, and dummy parameters. Its documented role is to produce the user-facing output file for the declaration run, applying the requested declaration nature and type, report inclusions, sort orders, and submission type.
• CONTROL_PROC — A control routine that validates and drives processing. Notably, it omits the submission type parameter found in the other two procedures, which suggests it operates on the core declaration selection and layout logic rather than submission-channel-specific behavior.

Tables Accessed

Three tables are documented as referenced through APPS synonyms:

• FND_NEW_MESSAGES — The Oracle Application Object Library message table, used to resolve translatable message text for errors and informational output during processing.
• HR_ALL_ORGANIZATION_UNITS_TL — The translated organization units table, supplying issuing establishment names and related descriptive attributes required on the declaration.
• PAY_ACTION_INFORMATION — The payroll action information table, providing the payroll run and action context from which declaration figures are derived.

Usage Notes

Because PAY_FR_DADS_F_PKG is not classified as a public API and is referenced by zero other packages per the ETRM metadata, it is best understood as a tightly scoped implementation package invoked by a concurrent program (typically submitted from the French Payroll responsibility) or by a thin wrapper. The presence of errbuf and retcode on PROCESS confirms this concurrent-program invocation pattern.

Customizations should not call WRITE_USER_FILE_REPORT directly unless the calling code replicates the full parameter contract, including P_SUBMISSION_TYPE, since behavior changes with that value. Given the package's age and internal classification, functional testing after any French payroll legislative patch is advisable, as DADS reporting formats are periodically revised by French authorities.