Search Results claim_chk

Overview

GHR_COMPLAINTS2_PKG is an Oracle EBS Human Resources (Oracle HRMS) package owned by the APPS schema and classified under the ETRM as "OTHER," indicating it is a supporting PL/SQL package rather than a formally published public API. It encapsulates the server-side logic required by the Oracle Grievance and Complaints functionality (the GHR schema prefix denotes the HR Grievance/Complaints product line). The package consolidates the data retrieval, code validation, and processing routines that the Complaints entry forms and associated concurrent programs invoke during the lifecycle of a complaint record. Its stored reference — $Header: ghrcomp2.pkh 115.4 2004/02/27 — confirms it has been part of the HR Grievance module since the 11i era, and it is deployed unchanged into Oracle EBS 12.1.1 and 12.2.2 environments. The package is declared AUTHID CURRENT_USER, so its SQL executes under the privilege set of the calling session, which requires that the caller has direct grants on the underlying GHR and PER tables.

Key Procedures and Functions

The ETRM metadata documents twenty procedures and functions. The package's data lookups center on the complainant: GET_FULLNAME_SSN returns the person's full name and Social Security Number as of an effective date, while GET_ASG_IDS returns the assignment, position, grade, and job identifiers associated with that person. These are consumed by the Complaints form to pre-populate the complainant block. The DESCRIPTIVE FLEXFIELD readers — FETCH_PEOPLEEI, FETCH_ASGEI, FETCH_POSITIONEI — each return the set of information segments (Information1 through Information30) from the respective descriptive flexfields. GET_POI_DESC retrieves the description of a point of interest; GET_GRADE_DETAILS returns grade definition attributes; and GET_CONSOLIDATED_COUNT returns a roll-up record count for display or processing. GET_DOCKET_NUMBER generates or retrieves the docket identifier assigned to a complaint or appeal. GET_WINDOW_TITLE (the procedure matching the user's search term) supplies the window caption used by the Complaints form when it opens. MIXED_COMPLAINT and REMAND_COMPLAINT perform complaint processing actions — filing a mixed complaint and remanding a complaint or appeal respectively. The validation routines GET_LOOKUP_CODE, GET_LOOKUP_MEANING, CA_REC_EXISTS, LTR_CLAIM_CHK, CLAIM_CHK, PCOM_INIT_CHK, BASIS_CHK, and CLAIM_EXISTS enforce that user-entered lookup codes, basis values, claim references, and corrective-action records exist and are valid before a complaint is committed.

Tables Accessed

The package reads and writes the core Grievance/Complaints and People Enterprise tables through APPS synonyms. GHR_COMPLAINTS2 is the primary complaint record; GHR_COMPL_APPEALS holds appeal records; GHR_COMPL_BASES stores complaint basis values; GHR_COMPL_CLAIMS, GHR_COMPL_CA_HEADERS, and GHR_COMPL_CA_DETAILS carry claim and corrective-action header and line data. GHR_POIS and PER_POSITION_EXTRA_INFO support point-of-interest and position flexfield lookups; PER_ASSIGNMENT_EXTRA_INFO and PER_PEOPLE_EXTRA_INFO supply assignment and person descriptive flexfield values; and PER_GRADES with PER_GRADE_DEFINITIONS provide grade attributes. These tables are accessed read-mostly, with insert/update activity concentrated in the complaint, claim, and corrective-action tables.

Usage Notes

GHR_COMPLAINTS2_PKG is invoked almost exclusively from the Oracle HRMS Complaints and Grievance forms (the GHR complaint windows) and from the concurrent programs that process complaint and appeal records. Because the ETRM reports zero other packages referencing it, integration is limited to direct calls from forms, Java/BC4J middle-tier code, or custom extension code, and Oracle does not publish it as a supported public API. Customizations should treat it as an internal package: validate behavior after applying 12.1.1 or 12.2.2 patches, since its procedures are subject to change without notice.