Search Results chk_lu_group_code

Overview

APPS.PAY_CNU_BUS1 is a PL/SQL package body belonging to the Oracle E-Business Suite Payroll (PAY) product family. Its internal header naming convention (pycnurhi.pkb) and the CNU component identifier associate it with the French payroll localization, specifically the maintenance and validation of contribution usage definitions held in the PAY_FR_CONTRIBUTION_USAGES table. The package is documented under the ETRM 12.2.2 repository with an API classification of OTHER, indicating that it supports the internal business logic layer rather than a public, versioned PL/SQL API. It exposes fifteen documented procedures and functions, most of which are defensive validation routines prefixed with CHK_. The package operates in both Oracle EBS 12.1.1 and 12.2.2, and its row handler generation comment (120.0) confirms it has been maintained across the 11i to R12 lineage.

Key Procedures and Functions

The documented routines fall into two functional groups: input validation and row loading.

• IS_NUMERIC — A utility function that tests whether a given value represents a valid number. It is the routine most frequently sought in this package and is typically used to guard downstream numeric conversions during contribution usage maintenance.
• CHK_ELEMENT_NAME — Validates the supplied element name, enforcing mandatory argument rules via HR_API.MANDATORY_ARG_ERROR.
• CHK_CONTRIBUTION_USAGE_TYPE — Verifies the effective date and contribution usage type combination.
• CHK_RATE_TYPE — Confirms the rate type supplied is acceptable for the contribution definition.
• CHK_PROCESS_TYPE — Checks the payroll process type associated with the usage record.
• CHK_LU_GROUP_CODE — Validates the logical unit group code.
• CHK_BUSINESS_GROUP_ID — Ensures a valid business group identifier is present.
• CHK_RATE_CATEGORY_TYPE — Validates the rate category classification.
• CHK_VALIDATE_CODE — Checks an associated validation code value.
• CHK_CONTRIBUTION_TYPE — Confirms the contribution type is defined and consistent.
• CHK_CONTRIBUTION_CODES — Validates the pairing or presence of contribution codes.
• CHK_GROUP_CODE — Verifies the contribution group code.
• CHK_DATES — Performs date range and effective-date consistency checks.
• CHK_CODE_RATE_ID — Validates the code/rate identifier used to link contribution definitions.
• LOAD_ROW — The row handler that inserts or updates a record in PAY_FR_CONTRIBUTION_USAGES after the validation procedures have succeeded.

Tables Accessed

The package references a single documented table through its APPS synonym: PAY_FR_CONTRIBUTION_USAGES. This table stores the French contribution usage definitions that drive element eligibility and rate assignment. The CHK_ procedures read from it to confirm that candidate values such as element name, contribution usage type, rate type, group code and rate identifier exist and are internally consistent, while LOAD_ROW writes the validated row to the table. No other application tables are documented as referenced, which reinforces the package's narrow, localization-specific scope.

Usage Notes

PAY_CNU_BUS1 is an internal business layer package, not a public API, so it is not intended for direct invocation from custom code. It is most commonly called from the French payroll contribution usage maintenance form, where each field-level validation triggers the corresponding CHK_ routine before the row handler persists the record. The presence of HR_UTILITY.SET_LOCATION tracing calls throughout the code makes it useful during debugging sessions enabled through HR diagnostics. Because the package is referenced by one other package, developers extending French contribution setups should treat it as a dependency and avoid modifying its logic directly; instead, oracle-provided patches should be applied through standard EBS patching. The IS_NUMERIC function is of particular interest because it is the sole generic utility in the package and is often reused by adjacent localization routines to validate numeric input before conversion, making it a frequent search target for developers diagnosing ORA-06502 value errors within French payroll configuration.