Search Results split_line

Overview

PAY_NO_TAX_TABLE_UPLOAD is an Oracle E-Business Suite payroll-legislation utility package owned by the APPS schema. It supports the Norwegian payroll localization by loading tax table data into the Oracle Payroll range table structures from an external flat file. In Norwegian payroll processing, employer tax withholding is driven by government-published tax tables that map income bands to withholding amounts. Rather than requiring manual keying of these bands through the range table maintenance forms, this package provides a bulk upload mechanism that reads a delimited source file and populates the Payroll range and range table entities accordingly.

The package is classified as an OTHER API in the ETRM metadata, meaning it is not a supported public API and is intended for internal or administrative use by the localization. It is not referenced by any other package in the ETRM inventory, confirming its role as a top-level, standalone loader rather than a shared library routine. Its procedures follow the standard concurrent program interface signature, accepting errbuf and retcode output parameters for integration with the Oracle concurrent manager.

Key Procedures and Functions

• MAIN — The primary entry point. It orchestrates the upload by accepting a data file name, an effective start date, and a business group identifier, and drives the overall load and validation sequence.
• PURGE — Removes previously uploaded tax table data for a given business group across an effective date range, allowing a clean reload or cleanup of stale entries.
• CHECK_DATE — Validates the effective start and end dates supplied during the upload, returning a message name so callers can surface date-related errors.
• UPLOAD_TAX_TO_TEMP_TABLE — Reads the flat file and stages its contents into the temporary table PAY_RANGE_TEMP. This staging step isolates raw, unvalidated file data from the live payroll tables.
• UPLOAD_TAX_TO_MAIN_TABLE — Transfers validated records from staging into the production range tables (PAY_RANGE_TABLES_F and PAY_RANGES_F), applying the legislation code, effective start date, and business group.
• SPLIT_LINE — Parses a single delimited input line from the source file, decomposing it into its component fields: range table number, earnings type, period frequency, low band, and amount. Because range table rows are flat, the loader must extract individual band values from each line.
• END_DATE_CHILD — Applies an end date to child range records associated with a given range table ID, maintaining date-tracked consistency when a table version is superseded.

Tables Accessed

The package reads and writes several Payroll range table entities through APPS synonyms. PAY_RANGE_TABLES_F holds the range table header definitions, while PAY_RANGES_F stores the individual band/range rows. PAY_RANGES_F_S is the corresponding date-tracked audit table. PAY_RANGE_TEMP is the staging table populated by UPLOAD_TAX_TO_TEMP_TABLE before data is promoted by UPLOAD_TAX_TO_MAIN_TABLE. The package also uses UTL_FILE to read the external source file from an Oracle directory.

Usage Notes

PAY_NO_TAX_TABLE_UPLOAD is normally invoked as a concurrent program submitted through the Norwegian localization, supplying the data file name, effective start date, and business group. It may also be called from PL/SQL using the standard concurrent interface. Administrators should ensure the source file is present and readable on the database server, run PURGE before reloading a period to avoid duplicates, and restrict execution to authorized payroll administrators, as direct manipulation of range tables affects withholding calculations.