Search Results pay_cnu_bus




Overview
Explore in AI Chat

Overview

PAY_CNU_SHD is a shared utility package in the Oracle E-Business Suite Payroll (PAY) schema, owned by APPS and classified under the ETRM registry as an "OTHER" API object. Its name follows the Oracle convention for shadow or shared helper modules, and its position in the dependency graph confirms that role: it is referenced by five related packages — PAY_CNU_BUS, PAY_CNU_BUS1, PAY_CNU_DEL, PAY_CNU_INS, and PAY_CNU_UPD — which together form the insert, update, delete, and business-rule layer for a payroll contribution entity. Rather than storing business logic itself, PAY_CNU_SHD centralises cross-cutting services that those companion packages consume, most notably concurrency control, argument coercion, and constraint-error translation. Because the object is a valid APPS package in both 12.1.1 and 12.2.2, it is available to any payroll process executing in the APPS schema context.

Key Procedures and Functions

The documented interface exposes four callable units:

  • LCK — Provides locking semantics for the contribution records manipulated by the PAY_CNU family. It is the mechanism the companion DML packages invoke to serialise concurrent access and prevent lost updates on the underlying contribution rows.
  • CONVERT_ARGS — Performs data type and format conversion of incoming arguments. It allows the surrounding insert, update, and delete routines to accept values in multiple representations before committing them to the database.
  • CONSTRAINT_ERROR — Centralises handling of Oracle constraint violations. When an insert, update, or delete operation fails on a check, unique, or referential constraint, this routine translates the raw ORA error into a controlled, meaningful outcome for the calling package.
  • API_UPDATING — Indicates the state of an in-progress API transaction, allowing the family of packages to detect re-entrant or nested update activity and to guard against inconsistent writes during concurrent processing.

No parameter lists are asserted here; signatures should be verified against the deployed source using the ETRM "show dependent code" links.

Tables Accessed

The package references two documented tables through APPS synonyms:

  • PAY_FR_CONTRIBUTION_USAGES — The primary payroll contribution usage table. It stores the contribution data that the PAY_CNU_INS, PAY_CNU_UPD, and PAY_CNU_DEL packages write and maintain; PAY_CNU_SHD supports those operations through locking and error handling.
  • ALL_CONSTRAINTS — The data dictionary view used to inspect constraint definitions. This explains the role of CONSTRAINT_ERROR: the package resolves which constraint fired so the failure can be reported accurately.

The dependency listing also records PUBLIC.ALL_CONSTRAINTS and SYS.STANDARD, confirming that the package relies on standard PL/SQL built-ins and dictionary metadata.

Usage Notes

PAY_CNU_SHD is an internal support package, not an end-user entry point. It is invoked indirectly whenever the payroll contribution maintenance logic runs — typically through the PAY_CNU_BUS and PAY_CNU_BUS1 business-rule packages, which are themselves called by the standard Oracle Payroll forms and concurrent processes that manage French contribution usages. Custom code should follow the same pattern as Oracle's own: call PAY_CNU_BUS rather than PAY_CNU_SHD directly, and never alter the shared package. Because the companion objects are date-effective style DML wrappers, the locking and constraint routines in PAY_CNU_SHD are most active during multi-user payroll runs and batch loads of contribution data.