Search Results pay_se_tax_table_upload




Overview
Explore in AI Chat

Overview

The APPS.PAY_SE_TAX_TABLE_UPLOAD package is a server-side PL/SQL component within the Oracle E-Business Suite Payroll (PAY) application, schema APPS. It supports the maintenance of legislated tax tables for Sweden (SE), providing the mechanism by which externally sourced tax range data is loaded into the Oracle Payroll tax table structures. Its principal business purpose is to manage the upload, validation, and lifecycle of tax ranges held in the PAY_RANGES_F and PAY_RANGE_TABLES_F entities, which store the effective-dated range definitions used by Oracle Payroll to determine the correct tax rate or amount applicable to an employee's taxable pay.

The package is classified as an OTHER API, indicating it is not part of the standard public payroll API set but is nonetheless a valid, deployable database object. Its metadata records seven packaged subprograms, covering upload, purge, date validation, and record splitting logic. The package is self-contained in its dependency graph: the ETRM documentation records that no other packages reference it, although it does depend on a small set of payroll range tables and on the database STANDARD and SYS packages.

Key Procedures and Functions

The package exposes the following documented subprograms:

  • MAIN — The principal entry point and orchestrator of the upload process. It coordinates the sequence of validation, staging, and final load operations performed by the other procedures.
  • UPLOAD_TAX_TO_TEMP_TABLE — Loads incoming tax range records into a staging area, represented by the PAY_RANGE_TEMP table, prior to validation and promotion into the permanent tax table structures.
  • UPLOAD_TAX_TO_MAIN_TABLE — Transfers validated records from the staging area into the main PAY_RANGES_F and PAY_RANGE_TABLES_F tax table structures.
  • CHECK_DATE — Performs date validation on the uploaded rows, confirming that effective dates are consistent and suitable for insertion into the effective-dated range tables.
  • SPLIT_LINE — Handles the partitioning of a single source line across multiple effective-dated range records, supporting the way PAY_RANGES_F stores dated definitions.
  • END_DATE_CHILD — Manages the end-dating of dependent or child range records when new tax definitions supersede prior ones, preserving the effective-date continuity of the ranges.
  • PURGE — Removes obsolete or superseded tax range data, clearing stale entries from the relevant tables.

Tables Accessed

The package reads and writes the following documented objects, accessed through APPS synonyms:

  • PAY_RANGES_F — The core effective-dated table holding tax range definitions.
  • PAY_RANGE_TABLES_F — Stores the parent range table header information to which individual ranges belong.
  • PAY_RANGES_F_S — The corresponding date-tracked (shadow) table maintained for PAY_RANGES_F.
  • PAY_RANGE_TEMP — A temporary staging table used during the upload before records are committed to the main tables.
  • UTL_FILE — The Oracle-supplied file I/O package, used to read externally supplied tax table source files.

Usage Notes

This package is typically invoked as part of the Swedish payroll tax table maintenance cycle, when updated statutory tax ranges must be loaded into Oracle Payroll. Because it relies on UTL_FILE, invocation generally occurs in a server-side context where the relevant database directory object is configured and the source file is accessible to the database tier.

The documented absence of downstream dependents indicates the package is intended as a terminal implementation utility rather than a reusable service. It would normally be triggered either through a dedicated concurrent program wrapper, a PL/SQL script executed by a payroll administrator, or custom code during implementation and legislative update projects. Direct invocation against a production instance should be preceded by validation of the source data and an assessment of the impact on PAY_RANGES_F and its date-tracked counterpart, since the upload and purge procedures modify effective-dated payroll configuration data.