Search Results iza_upload

Overview

PAY_NL_IZA_UPLOAD is an Oracle E-Business Suite PL/SQL package owned by APPS that supports the Dutch statutory IZA (Inkomensverzekering Arbeidsongeschiktheid / disability income insurance) reporting process for the Netherlands localization of Oracle Payroll. The package implements the upload mechanism by which IZA data files generated externally are read and loaded into the Oracle Payroll batch tables, creating the header and line records required to represent IZA transactions for processing.

According to the ETRM metadata (12.2.2), the package is classified as OTHER and exposes six documented procedures: IZA_UPLOAD, IZA_VALIDATION, VAL_CREATE_BATCH_LINE, CREATE_BATCH_HEADER, CREATE_BATCH_LINE, and PURGE_IZA_PROCESS_STATUS. The header comment block confirms that the package was authored under the filename pynlizau.pkh and is declared with AUTHID CURRENT_USER.

Key Procedures and Functions

• IZA_UPLOAD — The main entry point. It initiates the IZA upload process, accepts parameters passed from the concurrent program definition (file name, batch name, effective date, business group, action-if-exists options, and effective-change date), and orchestrates the various procedures that insert data into PAY_BATCH_HEADERS and PAY_BATCH_LINES.
• IZA_VALIDATION — Validates an individual data record and determines whether the record should be processed or rejected. When a record is rejected, the procedure sets an OUT parameter p_reject_reason_code to a value from the NL_IZA_REJECT_REASON lookup; otherwise it returns '00'.
• VAL_CREATE_BATCH_LINE — Supports validation and creation of batch lines as part of the upload flow.
• CREATE_BATCH_HEADER — Creates the batch header row in PAY_BATCH_HEADERS for the IZA upload. This is the procedure the user searched for; it is invoked internally by the upload process rather than called standalone in normal operation.
• CREATE_BATCH_LINE — Creates individual batch line rows in PAY_BATCH_LINES corresponding to validated IZA records.
• PURGE_IZA_PROCESS_STATUS — Removes or resets IZA process status records, typically used to clear prior upload state before or after a run.

In addition to these procedures, the package declares a package-level variable level_cnt of type NUMBER and a constant c_default_action_if_exists set to 'R' (indicating a default action to reject or replace when a record already exists).

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• PAY_BATCH_LINES — The primary target table for created batch lines.
• PAY_NL_IZA_UPLD_STATUS — Tracks the status of IZA upload processing.
• HR_ORGANIZATION_INFORMATION, PER_ORG_STRUCTURE_ELEMENTS, PER_ORG_STRUCTURE_VERSIONS — Organizational hierarchy data used to resolve org context during validation.
• PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F, PER_ASSIGNMENT_EXTRA_INFO, PER_ASSIGNMENT_STATUS_TYPES — Assignment, person, and assignment-level data needed to validate employee records.
• PER_ABSENCE_ATTENDANCES — Absence records relevant to disability/IZA validation.
• PAY_ELEMENT_TYPES_F — Element definitions used during processing.
• DUAL and UTL_FILE — DUAL for trivial queries; UTL_FILE for reading the input IZA data file from the database server.

Usage Notes

PAY_NL_IZA_UPLOAD is not referenced by any other documented package (referenced by 0 packages in the metadata). It is intended to be invoked from the concurrent program definition that drives the Dutch IZA upload process; the parameters to iza_upload are supplied from the concurrent program's parameters. Direct invocation from custom code is possible but should follow the concurrent program parameter conventions. The procedures CREATE_BATCH_HEADER, CREATE_BATCH_LINE, and VAL_CREATE_BATCH_LINE are internal building blocks called during IZA_UPLOAD and are not intended as standalone public APIs. Because the package uses UTL_FILE, the Oracle database server must have directory/access privileges configured for the IZA file location.