Results for “check_cin”

10 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.HR_CN_API is a valid, documented PL/SQL package body in the Oracle E-Business Suite 12.1.1 / 12.2.2 environment, classified as an API within the Human Resources (HR) product family. The "CN" designator identifies it as a country-specific extension supporting legislative and business requirements for China (CN), one of the localizations delivered on top of the global Oracle HRMS data model. Its principal business function is to centralize the validation and retrieval logic that Chinese HR legislation demands — verifying that person, organization, address, assignment, payment, and tax-related data conform to statutory rules before records are committed to the core HR tables.

The package is a substantial, heavily reused artifact: ETRM documents 23 procedures and functions and records that HR_CN_API is referenced by 18 other database packages, making it a shared validation utility rather than a standalone transaction processor.

Key Procedures and Functions

The 23 documented routines fall into three functional groupings:

Tables Accessed

The ETRM dependency list shows the package reading from both core HRMS and flexfield metadata tables, all via APPS synonyms:

Usage Notes

HR_CN_API is a server-side validation utility rather than an end-user interface. It is typically invoked from Oracle Forms during Chinese HR data entry, from concurrent programs performing mass validation or payroll-adjacent processing, and from custom PL/SQL that must enforce Chinese statutory rules before inserting into PER_ or PAY_ tables. Because 18 packages depend on it, changes to its behavior carry wide blast radius and should be regression-tested across HRMS and payroll flows. It is not referenced by any database object outside the APPS schema dependency chain.