Search Results no_method




Overview
Explore in AI Chat

Overview

APPS.PAY_US_TAX_UDFS_PKG is a PL/SQL package body in Oracle E-Business Suite that supplies user-defined functions (UDFs) supporting United States payroll tax processing. Its central role is to determine and persist the calculation method applied to a given assignment action for a specific state, with particular emphasis on alternate flat rate calculation methods. The package caches this information in a PL/SQL in-memory structure rather than repeatedly querying base tables, providing an efficient lookup path during payroll run processing.

The package is classified as API classification OTHER, indicating it is not a formally published, externally supported interface but rather an internal utility used by the US payroll tax engine. It operates against assignment-action and element-type level data, reflecting the granularity at which US state tax rules can vary — per assignment and per state jurisdiction.

Key Procedures and Functions

  • GET_ALTRNT_FLAT_RATE_CALC_METH — Returns the alternate flat rate calculation method for a given assignment action and state. It examines the cached collection and returns the first calculation method whose state code matches the supplied state, returning a default value of 'NO_METHOD' when the cache is empty or no match is found. An explicit loop with an early exit ensures only the first qualifying entry is returned.
  • SET_ALTRNT_FLAT_RATE_CALC_METH — Populates (sets) the cached alternate flat rate calculation method, typically invoked during setup or data-gathering phases so that subsequent calls to the getter function can retrieve the value without additional database access. The actual source excerpt also documents a related store_data function that loads element-type-level state and calculation method information into the in-memory collection and flushes it when the assignment action changes.

Tables Accessed

  • PAY_ASSIGNMENT_ACTIONS — The assignment action context (assignment action ID) against which state tax calculation methods are scoped.
  • PAY_ELEMENT_TYPES_F — Provides element type identifiers and their definitions used when storing and correlating calculation method data.
  • PAY_US_STATES — Supplies valid US state codes used in validation and matching.
  • PAY_ELEMENT_TYPE_EXTRA_INFO — Holds element-type-specific extra information relevant to state tax processing.
  • FND_LOOKUP_VALUES — Supplies lookup meanings and lookup codes, notably for calculation method and level values.
  • PLITBLM — The standard Oracle Applications PL/SQL table that backs in-memory collections used to cache the retrieved data.

Usage Notes

This package is normally invoked from the US payroll tax calculation flow rather than directly by end users. User-defined functions of this type are registered with Oracle Payroll so that the tax engine can call them during payroll run processing to resolve jurisdiction-specific calculation rules, including alternate flat rate methods. The setter is called first to load the relevant state/element-type combination into memory for the active assignment action; the getter is then called repeatedly, benefiting from the cached collection. Because it is an internal utility rather than an officially published API, customizations should avoid direct dependency where possible; instead, configuration should be managed through supported payroll setup and user-defined function registration. When the cache is empty the getter returns 'NO_METHOD', so callers should treat that value as a signal that no override exists and that standard tax calculation logic should apply.