Search Results ghr_us_org_information

Overview

GHR_SS_ASG_EIT is a PL/SQL package body owned by APPS that supports Oracle EBS Human Resources self-service processing for assignment extra information. It is classified in the ETRM repository as an OTHER API, meaning it is not a formally published public API but rather an internal component used by the self-service layer. The package is predominantly concerned with detecting changes to an assignment's Extra Information Type (EIT) records made through employee self-service and persisting those changes to the GHR_PA_HISTORY table so that a historical audit trail is maintained.

The package is referenced by two other packages within the EBS schema, confirming that it operates as a shared utility rather than an isolated module. The primary business driver is legislative and organizational compliance: certain assignment data — notably Federal telework information — must be tracked through its full change history, not merely stored in its current state. The package header revision (120.0.12020000.3) indicates it is a 12.1.1-level file that is applied unchanged to 12.2.2, where it continues to use the GHR (Global HR) table history mechanism.

Key Procedures and Functions

• INS_PA_HISTORY_PROC — Inserts a new row into GHR_PA_HISTORY following an update to assignment extra information originating from self-service. It accepts identifiers for the assignment extra information record, the assignment, and the information type, resolves the corresponding row identifier from PER_ASSIGNMENT_EXTRA_INFO, and records the change. Prior to inserting, it evaluates whether Global HR setup is available by counting qualifying rows in HR_ORGANIZATION_INFORMATION and raises an application error if the history insert cannot be completed.
• UPD_PA_HISTORY_PROC — Handles the update path for the same history-tracking mechanism, ensuring that modifications to assignment extra information are reflected in the history table rather than only in the live record.
• VALIDATE_TELEWORK_DET — Performs validation of telework detail data. This procedure underpins the Federal telework setup checks that the package performs, verifying that the required organizational information exists before telework-related assignment changes are accepted.

Tables Accessed

• HR_ORGANIZATION_INFORMATION — Read via the cursor c_fed_setup_avl, which counts rows where the organization information context equals GHR_US_ORG_INFORMATION and where organization information segments 1 through 5 are all non-null. This establishes whether the US Federal Global HR setup is fully configured before history processing proceeds. Note the proximity to the search term: the package queries the context value GHR_US_ORG_INFORMATION, while the object of interest is the synonym ghr_us_org_information.
• PER_ASSIGNMENT_EXTRA_INFO — Read via the cursor get_row_id to retrieve the ROWID for a given ASSIGNMENT_EXTRA_INFO_ID, which is then used by the history insertion logic. The procedure is documented as inserting into GHR_PA_HISTORY, which is the write target that the metadata excerpt truncates.

Usage Notes

This package is designated "Internal Table Handler Use Only," indicating it is not intended for direct invocation by customer extensions or public integrations. It is invoked by the assignment self-service flow and by the two dependent packages recorded in ETRM. Typical execution paths include the employee self-service assignment pages and related concurrent or OAF-based update processes that modify EIT data. Customers maintaining Federal telework configuration should note the dependency on GHR_US_ORG_INFORMATION context rows being fully populated; if any of the first five information segments are null, setup availability resolves to FALSE and history processing is bypassed. Custom code should avoid calling these procedures directly and instead rely on the supported self-service interfaces.