Search Results get_loc_extra_info

Overview

APPS.PAY_NL_CBS_FILE is a Dutch localizations payroll package within Oracle E-Business Suite, delivered under the PAY product schema. Its purpose is to support the CBS (Centraal Bureau voor de Statistiek) statutory reporting and archival process for the Netherlands, extracting assignment-level payroll data and formatting it for submission. The package implements the standard Oracle Payroll "range code / assignment action code / archive" interface pattern, allowing a payroll action to identify the population of assignments in scope, further restrict that population, initialize global working tables, and then archive the resulting data.

The package header carries the revision marker $Header: pynlcbsf.pkh 120.0.12000000.1 2007/01/17 22:54:40 appldev noship $, confirming it is a shipped, non-customized localization object. In Oracle EBS 12.1.1 and 12.2.2 the package remains classified as OTHER in the E-Business Tax and Reporting Management (ETRM) repository, with twenty documented procedures and functions. It is referenced by zero other packages, indicating it is a terminal consumer of payroll data rather than a shared utility.

Key Procedures and Functions

The documented procedures fall into three functional groups.

• Archival driver procedures: RANGE_CODE returns a SQL string selecting a range of assignments eligible for archival; ASSIGNMENT_ACTION_CODE further restricts the assignment IDs returned by the range code; ARCHIVE_INIT sets the global tables g_statutory_balance_table, g_stat_element_table, g_user_balance_table and g_element_table; and ARCHIVE_CODE is the main procedure that coordinates the several procedures used to archive data.
• Parameter and validation procedures: GET_ALL_PARAMETERS and MANDATORY_CHECK handle concurrent program parameter retrieval and validation.
• Data extraction procedures: 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, CHECK_ASG_SI_PROVIDER, GET_CAO_CODE, GET_GRADE_SALARY_NUMBER and CHECK_ASG_TERMINATE each return a specific statutory attribute required by the CBS file layout.

The user search term "get_loc_extra_info" maps directly to the GET_LOC_EXTRA_INFO procedure, which retrieves location-level descriptive information held in the HR_LOCATION_EXTRA_INFO table so that it can be included in the CBS output record for each assignment.

Tables Accessed

The package reads and writes the following APPS synonyms. Payroll action context is established through PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, PAY_ASSIGNMENT_ACTIONS_S, PAY_ACTION_INFORMATION and PAY_ACTION_CONTEXTS. Assignment and person attributes are drawn from PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F, with organizational structure from PER_ORG_STRUCTURE_VERSIONS, HR_ORGANIZATION_INFORMATION and HR_SOFT_CODING_KEYFLEX. Statutory and location detail comes from HR_LOCATION_EXTRA_INFO, while balances and results are read from PAY_RUN_RESULTS. Fast Formula configuration is resolved through FF_CONTEXTS and FF_FORMULAS_F, and FND_NEW_MESSAGES supplies runtime messages. The HR_LOCATION_EXTRA_INFO table is the principal source for GET_LOC_EXTRA_INFO.

Usage Notes

PAY_NL_CBS_FILE is invoked indirectly through the Oracle Payroll concurrent program framework: a payroll action is submitted, the range code and assignment action code procedures define the population, ARCHIVE_INIT prepares the global tables, and ARCHIVE_CODE executes the archival. It may also be called from custom PL/SQL where a specific statutory attribute, such as GET_LOC_EXTRA_INFO or GET_CAO_CODE, is required. Because the package relies on global PLS variables and NOCOPY OUT parameters, custom callers should invoke it in a well-defined session and expect errors to be raised through the hr_formula_error exception declared in the header.