Search Results p_reporting_date

Overview

APPS.PAY_NL_CBS_FILE is a Dutch (NL) localization package body that supports the generation of the CBS (Centraal Bureau voor de Statistiek) statutory statistical file required from Dutch employers. The CBS file reports employment, wage, working-hours, and tax-related data to the Dutch statistical authority. The package operates within the Oracle Payroll archive and reporting framework and is driven by a payroll action context rather than by end-user forms. Its primary responsibility is to gather, transform, and format payroll and HR data for a specified reporting period and produce output suitable for the CBS submission.

The package relies on a small set of global state variables that persist across procedure calls within a single run. Notable among these is g_reporting_date, a DATE variable that holds the reference date of the report, and the associated global variables for payroll action identifier, assignment number, full name, error and warning flags, and a cached working-hours formula reference. The user search term p_reporting_date corresponds to the output parameter of GET_ALL_PARAMETERS, through which the reporting date is returned to the calling process.

Key Procedures and Functions

The package exposes twenty documented procedures and functions. GET_ALL_PARAMETERS is the parameter-retrieval entry point. It accepts the payroll action identifier and returns the business group, reporting date (p_reporting_date), effective date, employer, SI provider, organization structure, medium code, and density. The reporting date and related values are resolved by calling pay_core_utils.get_parameter against the legislative parameters of the payroll action and converting the canonical date via fnd_date.canonical_to_date.

ARCHIVE_INIT and ARCHIVE_CODE initialize and execute the archive transform that produces the CBS extract. MANDATORY_CHECK validates that required parameters and conditions are present. RANGE_CODE and ASSIGNMENT_ACTION_CODE provide the range and assignment-level formatting logic used by the archive process.

Data acquisition is handled by a group of getters: GET_LOC_EXTRA_INFO, GET_ER_SEQUENCE, GET_BALANCES1, GET_BALANCES2, GET_HEALTH_INSURANCE, GET_WORKING_SCHEDULE, GET_TAX_DETAILS, GET_DEV_WORK_HOURS, GET_EMPLOYMENT_CODE, GET_CBS_WORKING_HOURS, GET_CAO_CODE, and GET_GRADE_SALARY_NUMBER. These routines assemble balances, tax details, health insurance, CAO (collective labour agreement) codes, employment codes, grade/salary numbers, and working-hour figures. Validation helpers CHECK_ASG_SI_PROVIDER and CHECK_ASG_TERMINATE verify assignment-level SI provider and termination status.

Tables Accessed

The package reads core payroll and HR tables via APPS synonyms. PAY_PAYROLL_ACTIONS supplies the payroll action and legislative parameters from which the reporting date and other inputs are derived. PAY_ACTION_INFORMATION, PAY_ACTION_CONTEXTS, PAY_ASSIGNMENT_ACTIONS, and PAY_ASSIGNMENT_ACTIONS_S provide action-level and assignment-level context. PAY_RUN_RESULTS supplies calculated payroll run results and balances.

Person and assignment data come from PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F. Organization and location data are drawn from PER_ORG_STRUCTURE_VERSIONS, HR_ORGANIZATION_INFORMATION, HR_LOCATION_EXTRA_INFO, and HR_SOFT_CODING_KEYFLEX. Formula and context lookups use FF_FORMULAS_F and FF_CONTEXTS, consistent with the cached working-hours formula variables. Message retrieval uses FND_NEW_MESSAGES. The package is not referenced by any other package, indicating it is called directly by the payroll archive process.

Usage Notes

PAY_NL_CBS_FILE is invoked through the Oracle Payroll archive/generation framework, not from a data-entry form. It is associated with a payroll action whose legislative parameters include REPORTING_DATE, EMPLOYER_ID, ORG_STRUCT_ID, SI_PROVIDER_ID, MEDIUM_CODE, and DENSITY. The GET_ALL_PARAMETERS procedure, with its p_reporting_date output, is the standard mechanism by which the reporting date is passed into the CBS processing logic.

Custom code should invoke the package only through the supported archive hooks and should not modify global state directly. Any reporting requirement changes to the CBS file are typically implemented by wrapping or extending the archive process rather than altering PAY_NL_CBS_FILE.