Search Results get_all_parameters

Overview

PAY_NL_PAYSLIP_ARCHIVE is an Oracle E-Business Suite payroll seed data package owned by the APPS schema. It supports the Dutch (NL) localization of Oracle Payroll by providing the archival logic required to move completed prepayment and QuickPay prepayment records for a payroll period into payslip archive storage. In the Netherlands, statutory and company-specific payslip retention requirements oblige employers to preserve a defensible snapshot of each payment run, and this package supplies the range-selection, locking, and data-extraction procedures that a payroll archival concurrent process calls during its execution phases.

The package is classified in ETRM under the generic API classification OTHER, indicating that it is not a public, supported business API but an internal component invoked by the payroll action framework. It is referenced by no other packages, confirming that its entry points are designed to be called from concurrent program definitions and the payroll action processing engine rather than from dependent PL/SQL units.

Key Procedures and Functions

The package exposes seven documented procedures and functions:

• RANGE_CODE — Returns a SQL string used by the payroll action framework to select the range of assignments eligible for archival. This is the range-code phase of the standard payroll action lifecycle.
• ASSIGNMENT_ACTION_CODE — Further restricts the assignment identifiers produced by the range code and locks all completed prepayments and QuickPay prepayments within the specified period, preventing modification while archival proceeds.
• ARCHIVE_INIT — Initializes package-level global tables, specifically g_statutory_balance_table, g_stat_element_table, g_user_balance_table, and g_element_table, which cache balance and element metadata for the duration of the archival run.
• ARCHIVE_CODE — The principal archival routine. It orchestrates the supporting procedures and writes the archived data for a given assignment action and effective date.
• GET_PARAMETER — Retrieves a single archival parameter value supplied to the payroll action.
• GET_ALL_PARAMETERS — Retrieves the complete set of parameters associated with the archival payroll action. This is the entry point most frequently referenced by users searching for parameter-initialization logic, since it populates the values consulted by the range code and archival procedures.
• GET_COUNTRY_NAME — Resolves the country name associated with the payroll action, supporting localization-specific formatting of archived output.

Tables Accessed

The package reads and writes a defined set of payroll and HR tables through APPS synonyms. Payroll action context and parameter data are drawn from PAY_ACTION_CONTEXTS, PAY_ACTION_INFORMATION, and PAY_ACTION_INTERLOCKS. Assignment and payroll definition data come from PAY_ASSIGNMENT_ACTIONS, PAY_ASSIGNMENT_ACTIONS_S, and PAY_ALL_PAYROLLS_F. Balance and element metadata are sourced from PAY_BALANCE_DIMENSIONS and PAY_BALANCE_FEEDS_F.

Organizational and legislative context is resolved through HR_ALL_ORGANIZATION_UNITS, HR_ALL_ORGANIZATION_UNITS_TL, HR_ORGANIZATION_INFORMATION, HR_LOCATIONS_ALL, HR_SOFT_CODING_KEYFLEX, FF_CONTEXTS, and FND_TERRITORIES_TL. Together these tables allow the package to associate each archived payslip with the correct legal employer, location, territory, and payroll statutory unit.

Usage Notes

PAY_NL_PAYSLIP_ARCHIVE is invoked by the Dutch payroll payslip archival concurrent program and by the payroll action framework during its range-code, assignment-action, and archive phases. GET_ALL_PARAMETERS is typically the first call made, supplying the parameter values that RANGE_CODE subsequently uses to build its selection SQL. ARCHIVE_INIT should always be executed before ARCHIVE_CODE so that the global balance and element tables are populated. Because the package is internal and unsupported as a public API, customizations should avoid direct invocation and instead call the delivered concurrent program; changes to the locking behaviour in ASSIGNMENT_ACTION_CODE can affect payroll run performance for the period being archived.