Search Results per_conversions_type

Overview

GHR_UPD_HR_VALIDATION is a server-side PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. Its classification in the ETRM registry is OTHER, indicating it is not part of a formal public API surface but rather an internal validation engine used by the Oracle HRMS/Advanced Benefits "Update HR" family of processes. The package supplies reusable validation logic that verifies Human Resources data before it is committed, most notably in the context of performance management and performance-type classifications. It is referenced by four other packages, confirming its role as a shared utility rather than a standalone entry point.

The package body declares private PL/SQL collection types — structure_type, structure_table, column_type, and column_table — along with package-level state variables such as structures, column_defs, structure_rows, column_rows, structures_loaded, and cur_structure. These collections cache validation structures and column definitions in memory so that repeated lookups during a validation run avoid redundant queries against the underlying request tables.

Key Procedures and Functions

• GET_FORM_ITEM_NAME — Retrieves the form item name associated with a given validation context, allowing the package to map a database validation rule back to the corresponding Oracle Forms field.
• SET_FORM_ITEM_NAME — Stores or registers the form item name for a validation context, complementing the getter above.
• MAIN_VALIDATION — The principal driver routine that executes the validation rules against the extracted HR data and returns or raises errors when records fail.
• GET_EXEMP_AWARD_DATE — Returns the exemption or award date used to determine whether a person qualifies for a given action or performance-type outcome.
• GET_RPA_INFO — Retrieves information related to the RPA (redundancy/reassignment or similar HR process) for use in downstream validation decisions.
• TO_POSN_NOT_ACTIVE — Handles the transition of a position to an inactive state, applied when validation determines a position should no longer be active.

The private helper functions get_structure_index and get_column_index, together with the set_structure procedure, support the internal structure/column caching used by these validation routines.

Tables Accessed

The package reads and writes through APPS synonyms, including:

• GHR_PA_REQUESTS, GHR_PA_REQUEST_EXTRA_INFO, and GHR_PA_DATA_FIELDS — store the HR "PA" (person action) request header, extra attributes, and the descriptive data fields being validated.
• GHR_FAMILIES, GHR_NOA_FAMILIES, and GHR_NOA_FAM_PROC_METHODS — define the performance-type / notice-of-action families and their associated processing methods.
• HR_ALL_POSITIONS_F — the position definition view, accessed to determine whether a position is active.
• PER_PERSON_TYPES and PER_SHARED_TYPES — supply person type and shared-type lookups that gate which validations apply to a given assignment.

Usage Notes

GHR_UPD_HR_VALIDATION is invoked indirectly, typically from the "Update HR" concurrent process and the associated Oracle Forms flow that submits it. Because it is not designated as a public API, custom code should call the higher-level listed procedures rather than manipulating the package's private collections. The conduct_performance_type identifier found in the source reflects the package's role in validating performance-type-driven HR actions, and any extension work should preserve the package's reliance on the GHR request tables to avoid inconsistent validation results.