Search Results pay_taxability_rules_aru




Overview
Explore in AI Chat

Overview

PAY_US_TAXABILITY_RULES_PKG is an Oracle EBS Payroll (PAY) package owned by the APPS schema and classified as a valid, OTHER-type API in the ETRM repository for release 12.2.2. It encapsulates the business logic that determines how earnings, deductions, and other payroll elements are treated for U.S. taxability purposes. In the Oracle Payroll model, taxability rules associate element classifications and balance feeds with the tax treatment applied during payroll run processing. This package provides the runtime and maintenance services that resolve those associations, translate them into classification identifiers, and derive the balance types against which taxable wages are accumulated. Because U.S. statutory payroll requires that each element be mapped to the correct taxing authority treatment (federal, state, and local), this package sits at the point where payroll element configuration meets tax reporting configuration. It is a supporting utility rather than a full public API; the ETRM dependency list shows it is referenced by PAY_TAXABILITY_RULES_ARI and PAY_TAXABILITY_RULES_ARU, the date-tracked table handlers for the PAY_TAXABILITY_RULES entity, and by itself, indicating internal recursion or helper-to-helper calls rather than broad external exposure.

Key Procedures and Functions

The ETRM metadata documents three callable units. No parameter lists are published in the available metadata, and none are inferred here.

  • GET_OR_UPDATE — Resolves the existing taxability rule record for a given context or creates/updates it when none is present. This is the primary maintenance entry point used by the ARI/ARU table handlers when taxability rule rows are inserted or maintained.
  • GET_CLASSIFICATION_ID — Returns the element classification identifier associated with an element type or its taxability context. Classification IDs are drawn from PAY_ELEMENT_CLASSIFICATIONS and drive which tax rules apply to an element.
  • GET_BALANCE_TYPE — Returns the balance type that a taxability rule maps to, drawn from PAY_BALANCE_TYPES. This determines the accumulator against which taxable amounts are stored and later reported.

Tables Accessed

The package reads and maintains data across the core payroll configuration and date-tracked tables, accessed through APPS synonyms:

  • PAY_TAXABILITY_RULES and PAY_TAXABILITY_RULES_DATES — the primary entity and its date-tracked (datetrack) companion, holding the rule definitions and their effective-dated versions.
  • PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, PAY_ELEMENT_CLASSIFICATIONS — element definition, input value, and classification data used to resolve the element context and classification ID.
  • PAY_BALANCE_TYPES and PAY_BALANCE_FEEDS_F — balance definition and feed configuration used by GET_BALANCE_TYPE to identify the target balance.
  • FND_SESSIONS — Oracle Forms session context, used to establish the effective date and session identity for datetracked operations.
  • DUAL — used for single-row lookups and validation queries.

Usage Notes

PAY_US_TAXABILITY_RULES_PKG is normally invoked indirectly. The ARI and ARU handlers for the PAY_TAXABILITY_RULES entity call it during insert and update processing, which means it executes whenever taxability rules are created or modified through the Taxability Rules maintenance form or equivalent setup path. It also runs during payroll processing whenever element taxability must be evaluated. Because the package is internal and not documented as a public API, customizations should not call it directly; extensions should instead use the supported ARI/ARU entry points. Any direct reference from custom code risks breakage across patches, since the documented interface exposes only GET_OR_UPDATE, GET_CLASSIFICATION_ID, and GET_BALANCE_TYPE, and Oracle may change the remaining internals without notice.