Search Results check_asg_terminate

Overview

APPS.PAY_NL_CBS_FILE is a Dutch (Netherlands) localized payroll archival package delivered with Oracle E-Business Suite 12.1.1 and 12.2.2. Its central business purpose is to produce the CBS (Centraal Bureau voor de Statistiek) statutory reporting extract required by Dutch law, while simultaneously archiving the assignment-level payroll run results that underlie that report. The package is classified as OTHER in ETRM and is owned by the APPS schema, indicating it is a localization routine rather than a published public API.

The package header declares two module-level objects: a global level_cnt counter and an hr_formula_error exception, which signal that the archival logic evaluates Oracle Fast Formula rules and records processing depth. The documented procedures collectively implement the standard Oracle payroll action parameters model: a range code to define the population, an assignment action code to further restrict that population, an initialization step to set up global balance and element tables, and a main archival driver.

Key Procedures and Functions

Twenty procedures and functions are documented for this package. RANGE_CODE returns a SQL string selecting the range of assignments eligible for archival. ASSIGNMENT_ACTION_CODE further restricts the assignment IDs returned by the range code. ARCHIVE_INIT initializes the global tables g_statutory_balance_table, g_stat_element_table, g_user_balance_table, and g_element_table. ARCHIVE_CODE is the main driver and calls the several procedures that archive the data.

The remaining documented units support parameter handling and Dutch-specific data retrieval. These include GET_ALL_PARAMETERS and MANDATORY_CHECK for action parameter validation; GET_LOC_EXTRA_INFO, GET_ER_SEQUENCE, GET_CAO_CODE, GET_EMPLOYMENT_CODE, GET_GRADE_SALARY_NUMBER, and GET_CBS_WORKING_HOURS for statutory and collective labour agreement attributes; GET_BALANCES1 and GET_BALANCES2 for balance retrieval; GET_HEALTH_INSURANCE and CHECK_ASG_SI_PROVIDER for social insurance data; GET_WORKING_SCHEDULE and GET_DEV_WORK_HOURS for time and schedule information; GET_TAX_DETAILS for tax reporting; and CHECK_ASG_TERMINATE, which evaluates whether an assignment has a termination status relevant to the CBS extract. This last procedure corresponds directly to the search term "check_asg_terminate" and is invoked during population building to exclude or flag terminated assignments.

Tables Accessed

The package reads and writes across the core Oracle HRMS and payroll schema. Assignment and person data come from PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F; organization context derives from PER_ORG_STRUCTURE_VERSIONS, HR_ORGANIZATION_INFORMATION, and HR_SOFT_CODING_KEYFLEX. Location data is drawn from HR_LOCATION_EXTRA_INFO. Payroll processing records are read from PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS (and its _S shadow table), PAY_ACTION_INFORMATION, PAY_ACTION_CONTEXTS, and PAY_RUN_RESULTS, which supplies the archival balance rows. Fast Formula evaluation metadata is read from FF_FORMULAS_F and FF_CONTEXTS, and error handling messages from FND_NEW_MESSAGES.

Usage Notes

PAY_NL_CBS_FILE is not an integration API and is referenced by zero other packages in ETRM. It is designed to be invoked through the Oracle Payroll action parameter framework, typically as part of a Dutch statutory reporting or payroll archival concurrent request in the Payroll Manager responsibility. The RANGE_CODE, ASSIGNMENT_ACTION_CODE, and ARCHIVE_CODE trio follows Oracle's standard payroll action chaining convention. Custom code should avoid direct invocation; instead, replicate the documented parameter contracts using supported public APIs such as PAY_PAYROLL_ACTION or HR_ASSIGNMENT_API. The 120.0.12000000.1 header version indicates the file has remained stable across the 12.1.1 and 12.2.2 releases, so behavior is consistent between those versions.