Results for “check_org_type”
20 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:
- Generic validators: IS_NUMBER, IS_POSITIVE_INTEGER, IS_VALID_PERCENTAGE, IS_VALID_POSTAL_CODE, and CHECK_LOOKUP provide reusable low-level data checks — numeric conversion, integer positivity, percentage range, postal code format, and lookup-code existence.
- Entity validators: CHK_PERSON_TYPE, CHECK_PERSON, CHECK_ORGANIZATION, CHECK_ORG_CLASS, CHECK_ORG_TYPE, CHECK_BUS_GRP, CHECK_ADDRESS, CHECK_ASSIGNMENT, CHECK_PAYMENT_METHOD, CHECK_CIN, and CHECK_TAX_DEPENDENCE each validate a specific HRMS entity or Chinese legislative attribute (CIN being the statutory corporate identification number, and tax dependence relating to dependent declarations).
- Data retrieval helpers: SET_LOCATION, GET_PAY_MESSAGE, GET_USER_TABLE_VALUE, and GET_DFF_TL_VALUE resolve and return values for downstream processing, including translated descriptive flexfield content.
Tables Accessed
The ETRM dependency list shows the package reading from both core HRMS and flexfield metadata tables, all via APPS synonyms:
- Person and assignment data: PER_PEOPLE_F, PER_ASSIGNMENTS_F, PER_ADDRESSES, PER_PERSON_TYPES, PER_BUSINESS_GROUPS, and HR_PERSON_TYPE_USAGE_INFO support person, address, and assignment validation.
- Organization data: HR_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION support organization, classification, and type checks.
- Payroll data: PAY_ELEMENT_CLASSIFICATIONS and its _TL translation table, plus PAY_PERSONAL_PAYMENT_METHODS_F and PAY_USER_COLUMN_INSTANCES_F, underpin payment-method validation and pay-message retrieval.
- Flexfield and lookup metadata: FND_DESCR_FLEX_COLUMN_USAGES, FND_DESCR_FLEX_COL_USAGE_TL, FND_DESCR_FLEX_COL_USAGE_VL, and HR_LOOKUPS supply descriptive flexfield and lookup definitions.
- Infrastructure: HR_API, HR_UTILITY, HRUSERDT, PER_PER_BUS, PLITBLM, and STANDARD provide shared error handling, utility routines, and the PL/SQL table type used for bulk operations.
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.
-
PACKAGE: APPS.PA_ORG_UTILS 12.2.2
-
PACKAGE: APPS.PA_ORG_UTILS 12.1.1
-
PACKAGE: APPS.HR_CN_API 12.1.1
-
PACKAGE: APPS.HR_CN_API 12.2.2
-
PACKAGE: APPS.PA_ORG_UTILS 12.1.1
-
PACKAGE: APPS.PA_ORG_UTILS 12.2.2
-
PACKAGE BODY: APPS.HR_CN_API 12.2.2
-
PACKAGE BODY: APPS.HR_CN_API 12.1.1