Search Results pay_cnu_upd




Overview
Explore in AI Chat

Overview

PAY_CNU_UPD is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It forms part of the payroll legislative/regulatory infrastructure used by Oracle Payroll, appearing under the PAY_CNU naming prefix that identifies a group of packages handling contribution and usage processing logic (notably for the United States payroll context). Its classification within the ETRM repository is "OTHER," indicating it is an internal implementation package rather than a publicly documented business API.

The package is a dependent of PAY_CNU_SHD, a shared-code object, and of HR_API, the Oracle HRMS public API layer. In turn, PAY_CNU_UPD is referenced by PAY_CNU_API and by itself. This dependency pattern is typical of a low-level update routine that performs the actual data manipulation on behalf of a higher-level API facade (PAY_CNU_API) while relying on shared definitions (PAY_CNU_SHD) and HRMS API services (HR_API). In Oracle EBS 12.1.1 and 12.2.2 the package remains VALID, confirming it is compiled and available in the APPS schema.

Key Procedures and Functions

  • UPD — The single documented program unit exposed by the package. Consistent with the "UPD" naming convention used throughout Oracle Payroll (an abbreviation of "update"), this procedure performs the maintenance or update of contribution usage data. The ETRM metadata records two documented entries (UPD) — one in the package specification and its corresponding implementation in the package body. As the metadata does not enumerate a parameter list, no argument signature is asserted here; the procedure is characterized solely by its purpose of applying updates to the underlying contribution usage records.

No other procedures or functions are documented for this package. Any invocation must therefore be directed at UPD through the public specification, with the expectation that callers (principally PAY_CNU_API) supply the appropriate context.

Tables Accessed

  • PAY_FR_CONTRIBUTION_USAGES — The table referenced by this package via an APPS synonym. This is the contribution usages table that records how payroll contributions are consumed or applied within the contribution-processing framework. PAY_CNU_UPD is presumed to write to (and possibly validate against) this table as part of its update operation, since the package's sole documented procedure is an update routine.

The table is reached through the APPS synonym layer, which is standard practice for Oracle Payroll packages and ensures schema-independent access. No other application tables are documented among the direct dependencies, though the HR_API dependency suggests indirect interaction with HRMS business logic during validation or processing.

Usage Notes

PAY_CNU_UPD is an internal implementation package and is not intended to be called directly by customer extensions. Its documented referencing packages — PAY_CNU_API and itself — indicate that the supported entry point for contribution usage processing is the API layer, which in turn delegates the physical update to PAY_CNU_UPD.UPD. Developers extending or diagnosing contribution functionality should therefore invoke the public API surface (PAY_CNU_API) rather than the update package directly.

The package is most commonly executed in the context of payroll run processing and contribution maintenance, where usages records must be updated in response to payroll calculation and post-processing events. In an Oracle EBS 12.1.1 or 12.2.2 instance, it may be surfaced through payroll concurrent programs, forms-based contribution maintenance, or internal run-time calls. Custom code that must touch contribution usages should route through the API to preserve validation, security, and consistency guarantees. Invalidating or recompiling this package should be treated as an integrated part of the PAY_CNU_* group, given its bidirectional relationship with PAY_CNU_API and its dependency on PAY_CNU_SHD and HR_API.