Search Results pqp_fedhr_uspay_intg_pkg




Overview
Explore in AI Chat

Overview

PQP_FEDHR_USPAY_INTG_PKG is an Oracle Applications (APPS) PL/SQL package that forms part of the Oracle Payroll legislative and configuration infrastructure supporting United States federal human resources and payroll processing. Its primary business purpose is to automate the provisioning of payroll elements and to manage configuration values required by the US payroll integration between Oracle HRMS/Payroll and federal processing requirements. In Oracle EBS 12.1.1 and 12.2.2, the package is registered in the APPS schema with a VALID status and is classified as an "OTHER" API, indicating it is an internal utility rather than a public, supported integration interface. The package depends only on the SYS.STANDARD package at the object level, and no other application packages reference it, which confirms that it functions as a self-contained setup or seeding utility rather than a runtime service consumed by other modules.

Key Procedures and Functions

The documented metadata identifies two procedures or functions within the package:

  • PQP_FEDHR_ELEMENT_CREATION — Creates the payroll element definitions that the federal US payroll integration depends upon. This routine is responsible for installing element types and their associated input values into the payroll element tables so that subsequent payroll runs and calculations can reference them. It effectively seeds the element structures required for US federal processing.
  • UPDATE_OR_INS_PQP_CONFIG_VALS — Maintains the configuration values held by the payroll product. As the name indicates, the routine performs an update or insert (upsert) against the configuration values store, allowing setup data to be created when absent and refreshed when already present.

No parameter lists are documented, and none should be assumed. The two routines are invoked as a coordinated pair, with element provisioning and configuration maintenance representing the two halves of the same setup activity.

Tables Accessed

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

  • FF_FORMULAS_F — the base table of FastFormula definitions, referenced when element creation requires an associated formula.
  • FND_APPLICATION and FND_APPLICATION_TL — the application registry and its translated names, used to resolve the owning application for seeded data and for language-specific descriptions.
  • PAY_ELEMENT_CLASSIFICATIONS — defines the classification under which created elements are grouped.
  • PAY_ELEMENT_TYPES_F — the base element type definitions that PQP_FEDHR_ELEMENT_CREATION populates.
  • PAY_INPUT_VALUES_F — the input value definitions belonging to each element type.
  • PQP_CONFIGURATION_VALUES — the configuration store maintained by UPDATE_OR_INS_PQP_CONFIG_VALS.
  • PLITBLM — an Oracle Applications internal PL/SQL table used for bulk operations and identifier handling.

Collectively, these tables span both the FastFormula/element metadata model and the payroll configuration model, consistent with a package whose role is to establish payroll setup objects.

Usage Notes

Because the package is classified as OTHER and is referenced by no other packages, it is not intended as a general-purpose API for customer code. It is typically invoked during the setup, installation, or upgrade of the US federal payroll integration, most plausibly from a concurrent program or a patch driver script that seeds element types and configuration values. Administrators and technical consultants generally encounter it when troubleshooting missing payroll elements or stale configuration entries following an upgrade or a legislative patch. Direct invocation should be reserved for controlled, Oracle-directed scenarios, since the routines write to core payroll and FastFormula tables and could produce duplicate or inconsistent element definitions if executed outside the supported setup flow. In Oracle EBS 12.1.1 and 12.2.2, the object remains valid and unchanged in its documented dependency footprint, with references limited to standard SYS objects and no downstream dependents.