Search Results per_hu_disability

Overview

PER_HU_DISABILITY is an Oracle EBS Human Resources package body owned by the APPS schema, classified under ETRM as an "OTHER" API object. It belongs to the Oracle Human Resources localization layer for Hungary (the "HU" suffix denotes the Hungarian country extension) and is designed to validate and manage disability-related data captured against a person record. The core business concern of this package is a legislative rule set that governs how a disability category relates to a declared disability degree (percentage). The Hungarian statutory framework recognizes discrete disability categories — for example a category representing a disability below fifty percent, a category fixed at exactly fifty percent, a category above sixty-seven percent, and a category fixed at exactly sixty-seven percent — and each category carries a permitted range for the associated degree value. The package header version string (pehudisp.pkb 120.1, dated 2006) confirms it is a legacy Hungarian localization object that has been carried forward into the 12.1.1 and 12.2.2 releases. This summary is written in the context of a search for the parameter p_category, which is the first formal argument accepted by all three documented procedures and the value against which every business rule in the package is keyed.

Key Procedures and Functions

• CHECK_HU_DISABILITY — Accepts the parameter p_category together with a second parameter, p_degree, and performs the category-versus-degree consistency validation. The procedure body in the source includes a commented-out block that, when active, applies the following rules: where the category is the below-fifty-percent value, a degree of fifty or greater is invalid; where the category is the exactly-fifty-percent value, any degree other than fifty is invalid; where the category is the above-sixty-seven-percent value, a degree of sixty-seven or lower is invalid; and where the category is the exactly-sixty-seven-percent value, any degree other than sixty-seven is invalid. On failure the procedure calls HR_UTILITY.SET_MESSAGE with message 800 and the token HR_HU_INVALID_DIS_DEGREE, then raises the error. In the shipped 120.1 source this logic is fully commented out and the executable body is simply NULL.
• CREATE_HU_DISABILITY — Accepts p_category and p_degree and is intended to run the disability check when a new disability record is created. Its body is guarded by HR_UTILITY.CHK_PRODUCT_INSTALL for the Oracle Human Resources product and the "HU" (Hungary) legislation, added to address GSI Bug 5472781. Inside the guard the call to CHECK_HU_DISABILITY is commented out and replaced with NULL.
• UPDATE_HU_DISABILITY — Accepts p_category and p_degree and is the counterpart invoked on modification of an existing disability record. It applies the identical product-install guard and, as shipped, performs no executable validation because the inner call is commented out.

Tables Accessed

The ETRM metadata records no directly referenced tables via APPS synonyms for this package. This is consistent with the source: all three procedures operate purely on their input parameters, and no DML, cursor, or query appears in the shipped body. The package therefore acts as a validation stub rather than a persistence layer; any table maintenance for Hungarian disability data is performed by the forms or APIs that call these procedures, not by PER_HU_DISABILITY itself.

Usage Notes

PER_HU_DISABILITY is referenced by two other packages according to the documented metadata, indicating it sits beneath a higher-level Hungarian HR API or validation layer rather than being invoked directly by end users. Its natural invocation point is the Hungarian person or disability maintenance form and associated business logic, where CREATE_HU_DISABILITY and UPDATE_HU_DISABILITY would be called on insert and update respectively, and CHECK_HU_DISABILITY used for standalone validation. Because the validation logic is commented out in the delivered 120.1 source — a state preserved through 12.1.1 and 12.2.2 — customizations should not assume that invalid category/degree combinations are rejected by the base product. Implementers extending this package must retain the CHK_PRODUCT_INSTALL guard so that the Hungarian rules are evaluated only when both Oracle Human Resources and the HU legislation are installed, and should re-enable the p_category-driven rules with care, since they encode statutory thresholds that may have been amended since the package was written.