Search Results pay_cnu_bus1




Overview
Explore in AI Chat

Overview

The APPS.PAY_CNU_BUS1 package is a PL/SQL business-rules validation and row-loading utility within the Oracle E-Business Suite Payroll (PAY) application. Its name follows the convention associated with the French localizations of Oracle Payroll (CNU denoting a country-specific business component), positioning it as a supporting package for the payroll contributions and rates configuration used in France. The package is documented in ETRM as VALID in both Oracle EBS 12.1.1 and 12.2.2, with an API classification of OTHER, indicating it is not a published, supported public API but rather an internal component that supports the loading and validation of payroll setup data.

The primary role of PAY_CNU_BUS1 is to provide a set of discrete, single-purpose validation routines that check the correctness of data elements before they are committed to the underlying payroll tables. In this respect it functions as a gatekeeper: a companion package, PAY_CNU_BUS, which references PAY_CNU_BUS1, delegates the individual field-level and cross-field validation checks to these routines.

Key Procedures and Functions

Fifteen documented procedures and functions are recorded for this package. They fall into several functional groups:

Tables Accessed

The ETRM dependency listing shows PAY_CNU_BUS1 referencing a single application table through APPS synonyms: PAY_FR_CONTRIBUTION_USAGES. This table stores the contribution usage definitions for French payroll contributions, and the package reads from it to confirm that a supplied contribution usage type or code exists and is valid before any dependent rates or elements are created. No other application tables are documented as direct dependencies, indicating that the validation logic is deliberately narrow and focused on the contribution usage configuration path.

Usage Notes

Because PAY_CNU_BUS1 is classified as OTHER rather than a supported public API, it should be treated as an internal implementation component. It is invoked indirectly: PAY_CNU_BUS references PAY_CNU_BUS1, and PAY_CNU_BUS1 also references itself, confirming a layered structure in which higher-level loader logic calls these granular checks. Typical invocation paths include payroll configuration forms, country-specific concurrent programs for loading rates and contribution definitions, and upgrade or localization scripts that stage data before insertion. Custom development should avoid calling PAY_CNU_BUS1 directly; instead, use the documented public APIs or the parent PAY_CNU_BUS package, since the internal signatures of PAY_CNU_BUS1 are not guaranteed to remain stable across patches and upgrades.