Search Results pay_ranges_f_s

Overview

PAY_SE_TAX_TABLE_UPLOAD is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema, classified under the generic API classification OTHER. It is a Swedish localization utility within Oracle Payroll (the PAY_ prefix denotes the Payroll product family, and the SE_ infix identifies the Sweden country extension). Its business function is to load externally supplied tax table data into the Swedish payroll tax range structures used by payroll processing. Swedish payroll tax withholding, and particularly the tax percentage tables issued by Skatteverket, are delivered as flat files that must be imported into the application tables before payroll runs can calculate withholding correctly. This package performs that bulk import: it reads a formatted input file, validates and stages the incoming rows into a temporary table, then migrates the validated rows into the permanent pay range tables that drive tax calculation.

The package is a batch-oriented data loading routine rather than a multitenant business API. It depends on FND_FILE and UTL_FILE for file handling and logging, FND_MESSAGE and FND_PROFILE for messaging and environment context, HR_API and HR_UTILITY for error handling, and the pay range APIs for the final persistence step.

Key Procedures and Functions

• MAIN — The driver procedure. It coordinates the overall upload process, establishing context (business group, file location), reading the input file, and invoking the staging and migration steps in sequence.
• PURGE — Cleanses the staging area, removing residual rows from prior runs so that an upload starts from a known, empty state and cannot double-post stale data.
• CHECK_DATE — Validates the date information associated with incoming tax table records, ensuring effective dates fall within acceptable bounds before data is written to persistent tables.
• UPLOAD_TAX_TO_TEMP_TABLE — Parses the external tax file and inserts each record into the temporary staging table, where rows can be validated and corrected without affecting live payroll data.
• UPLOAD_TAX_TO_MAIN_TABLE — Moves the validated rows from staging into the permanent pay range tables, using the pay range APIs so that the standard validation and audit logic is preserved.
• SPLIT_LINE — A parsing helper that decomposes a single delimited input line into its constituent fields for interpretation.
• END_DATE_CHILD — Derives or sets the end date on child range records, supporting the effective-dated parent/child structure of the pay range model.

Tables Accessed

• PAY_RANGES_F — The main effective-dated pay ranges table; the primary target for uploaded tax range header data.
• PAY_RANGES_F_S — The translated/secure descriptive column table for PAY_RANGES_F; the "_S" suffix table carries language-dependent text associated with each range definition and is written in step with the base table.
• PAY_RANGE_TABLES_F — Stores the individual range band/entry rows that define the tax brackets belonging to each range; this is where the numeric tax table content is persisted.
• PAY_RANGE_TEMP — The temporary staging table populated by UPLOAD_TAX_TO_TEMP_TABLE and read by UPLOAD_TAX_TO_MAIN_TABLE.

Final writes are routed through PAY_RANGE_API and PAY_RANGE_TABLE_API, which encapsulate the insert/update logic for these tables.

Usage Notes

PAY_SE_TAX_TABLE_UPLOAD is typically invoked as a concurrent program or run directly from the back end during Swedish payroll implementation and annual tax table maintenance, when updated Skatteverket tax tables must be loaded ahead of the first payroll run of the tax year. No other database object references this package, so it is a top-level entry point rather than a shared library. In EBS 12.1.1 and 12.2.2 the callable surface, dependencies, and table usage are identical; the 12.2.2 online patching architecture does not alter the package's file-based upload model. Because it writes directly to pay range definitions, it should be executed by a privileged payroll administrator, preferably into a test environment first, with a backup of the existing range data. The related query term pay_ranges_f_s refers to the translated descriptive table PAY_RANGES_F_S, which this package maintains alongside PAY_RANGES_F during the load.