Search Results insert_rules

Overview

APPS.PAY_US_TAXABILITY_RULES_PKG is a PL/SQL package body in the Oracle E-Business Suite Payroll (PAY) application, classified in the ETRM under the generic API category OTHER. Its stated purpose is to hold the building blocks used in the maintenance of United States taxability rules held in the PAY_TAXABILITY_RULES table. Taxability rules determine how earnings, deductions, and other payroll element classifications are treated for federal, state, and local withholding and reporting purposes, so the package sits at the intersection of payroll element configuration and statutory tax processing.

The package has a long lineage, dating to November 1993, and the Header comment identifies it as paysuetw.pkb at version 120.1. The change list documents progressive refinements: renaming to the PAY_ and _PKG conventions, handling of classification identifiers, the shift from W_SIT/FIT to NW_SIT/FIT handling, filtering by classification id on query and delete, and the addition of a mutual-exclusivity check (chk_mutually_exclusive) ensuring only one overtime category at a time can be included in workers compensation. Support for CITY, COUNTY and SCHOOL jurisdictions was added in 1996, and a legislation_code check was introduced in 1999. The metadata notes that the package is referenced by two other packages, indicating it functions as a shared utility layer rather than a standalone entry point.

Key Procedures and Functions

• GET_OR_UPDATE — The principal routine, present since the original 1.0 release. It is the maintenance workhorse for taxability rule rows in PAY_TAXABILITY_RULES, covering both retrieval of existing rule definitions and insertion or modification of rule data. Historical change entries referencing query and delete behavior filtered by classification id, plus the overtime/workers compensation mutual-exclusivity check, are associated with the logic this routine orchestrates.
• GET_CLASSIFICATION_ID — Resolves the payroll element classification identifier associated with a balance type or element context. The April 1995 change list explicitly records modification "to handle populating classification id," and the April 19, 1995 entry records that the classification id is considered on query and delete.
• GET_BALANCE_TYPE — Returns the balance type corresponding to a given element classification or input value context, allowing taxability rules to be keyed to the correct balance type definition.

No parameter lists are documented in the ETRM metadata and none are asserted here. Callers should obtain signatures from the deployed package specification in the target instance.

Tables Accessed

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

• PAY_TAXABILITY_RULES and PAY_TAXABILITY_RULES_DATES — the primary rule and date-effective rule storage maintained by GET_OR_UPDATE.
• PAY_ELEMENT_CLASSIFICATIONS and PAY_ELEMENT_TYPES_F — source of classification and element context used to resolve the classification id.
• PAY_BALANCE_TYPES and PAY_BALANCE_FEEDS_F — balance type definitions and the feeds that connect balances to elements, consumed by GET_BALANCE_TYPE.
• PAY_INPUT_VALUES_F — element input value definitions referenced during rule resolution.
• FND_SESSIONS — used for session context, consistent with the HR/Payroll security model.
• DUAL — used for scalar lookups and validation.

Usage Notes

Because the package is classified OTHER rather than as a public API, it is intended primarily for internal use by Oracle Payroll forms and by the two packages documented as referencing it. The most common invocation path is the US taxability rule maintenance UI within the Payroll application, where GET_OR_UPDATE drives insert, update, and delete of rule rows as users configure element tax treatment. Custom code should prefer supported public APIs; where direct calls are required, the package specification should be inspected first, and all modifications to PAY_TAXABILITY_RULES should respect the date-effective and classification-id constraints the package enforces.