Results for “lp_effective_date”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAY_NL_NSI_PROCESS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as an OTHER API within the ETRM repository. It forms part of the Dutch (NL) localization layer for Oracle Payroll, and its header identifies it as an NSI-related archival process (the "NSI" prefix correlates to the Dutch Sociale Verzekeringsbank / social insurance reporting conventions used in the Netherlands). The package declares AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the invoking schema rather than the definer, and its header comment dates from 2004 (pynlnsia.pkh 115.1), indicating a long-standing, stable interface.

The core business purpose of the package is to support archival of payroll assignment data. It does not perform its own driver logic; rather, it exposes procedures that Oracle Payroll's generic archival concurrent programs call during the standard payroll action lifecycle. The package determines which assignments qualify for archival, narrows that set, initializes the global balance and element tables used during the archival run, and then performs the archival itself.

Key Procedures and Functions

  • RANGE_CODE — Returns a SQL string used to select the range of assignments eligible for archival.
  • ASSIGNMENT_ACTION_CODE — Further restricts the assignment IDs returned by RANGE_CODE, operating on a payroll action ID, a person ID range, and a chunk value.
  • ARCHIVE_INIT — Initializes the global tables g_statutory_balance_table, g_stat_element_table, g_user_balance_table, and g_element_table for the payroll action being processed.
  • ARCHIVE_CODE — The main archival procedure; calls the supporting procedures to archive data for a given assignment action and effective date.
  • GET_PARAMETER — Retrieves a single parameter value supplied to the payroll action.
  • GET_ALL_PARAMETERS — Retrieves the full parameter set for the payroll action.

The package also declares a package-level variable, level_cnt (NUMBER), used for internal processing control.

Tables Accessed

The package reads and writes the principal Oracle Payroll action tables — PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS (and its _S shadow), and PAY_ACTION_INFORMATION — which hold the run definition and the assignments in scope. It references HR and PER tables to resolve assignment and person data: PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F, PER_ASSIGNMENT_EXTRA_INFO, PER_ASSIGNMENT_STATUS_TYPES, PER_ADDRESSES, PER_CONTACT_RELATIONSHIPS, and PER_ORGANIZATION_STRUCTURES. Legislative and organizational context is drawn from HR_ASSIGNMENT_SET_AMENDMENTS, HR_ORGANIZATION_INFORMATION, and HR_SOFT_CODING_KEYFLEX. FND_NEW_MESSAGES is referenced, indicating the package may emit or clear application messages during processing. All tables are accessed through APPS synonyms.

Usage Notes

PAY_NL_NSI_PROCESS is invoked indirectly rather than directly. It is referenced by zero other PL/SQL packages, confirming that it functions as a callout consumed by Oracle Payroll's archival framework (the "Archive" payroll action type) rather than as a shared library. It is also not the executable named in the user's search term — "OneNextGen Payment Processing Application.exe" is an unrelated Windows client artifact, and the search returns this package only as an incidental match. Administrators encountering this package in EBS 12.1.1 or 12.2.2 should treat it as Dutch localization infrastructure: it is exercised when Dutch payroll archival actions run, and its GET_PARAMETER / GET_ALL_PARAMETERS routines supply the action parameters that the archival processes consume.