Search Results ghr_ss_asg_eit

Overview

GHR_SS_ASG_EIT is an internal Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM taxonomy as OTHER. The name decomposes into its functional domain: GHR denotes the Oracle HRMS (Human Resources Management System) product family, SS denotes Self-Service, ASG denotes Assignment, and EIT denotes Extra Information Type. The package therefore serves the Oracle HR Self-Service assignment extra information infrastructure, providing the server-side logic that supports employee-facing maintenance of EIT (Extra Information Type) data attached to an assignment record.

Extra Information Types are the descriptive flexfield-based mechanism by which Oracle HRMS stores customer-defined, legislatively required, or installation-specific attributes against core HR entities. When an employee or manager edits such attributes through Oracle Self-Service Human Resources (SSHR), the underlying database changes must be accompanied by audit history and, in certain cases, business validation. GHR_SS_ASG_EIT encapsulates these responsibilities. The package header declares AUTHID CURRENT_USER, indicating that it executes with the privileges of the invoking user rather than the definer, a common pattern for shared HRMS utility code that must respect the caller's security context and row-level access.

The package is documented in the ETRM repository with three procedures and is referenced by two other packages, confirming its role as a shared internal utility rather than a top-level API intended for direct customer invocation. Its documented access status is explicitly Internal Table Handler Use Only, which restricts its supported use to Oracle-internal callers and the standard SSHR processing stack.

Key Procedures and Functions

The package exposes three documented procedures:

• INS_PA_HISTORY_PROC — Inserts a record into the GHR_PA_HISTORY table following an update to Assignment Extra Information originating from Self-Service. Its documented purpose is to capture the audit trail of EIT changes against an assignment.
• UPD_PA_HISTORY_PROC — Performs the corresponding update path against the personal action history, supporting modification and correction scenarios within the same self-service EIT workflow.
• VALIDATE_TELEWORK_DET — Validates Telework-related detail associated with an assignment extra information record. This reflects the inclusion of Telework (flexible working arrangement) EIT support within the SSHR assignment EIT framework.

Each procedure operates against a single assignment extra information record, identified in the documented signature by the assignment extra information identifier, the owning assignment identifier, and the information type. Parameter lists are intentionally not reproduced here; only the documented procedure identities and purposes are stated.

Tables Accessed

Two tables are documented as accessed through APPS synonyms:

• PER_ASSIGNMENT_EXTRA_INFO — The primary transactional table holding extra information type values for assignments. The package reads this table to resolve the EIT record being processed and to drive validation and history creation.
• HR_ORGANIZATION_INFORMATION — Holds organization-level extra information, consulted to support validation logic such as the Telework detail checks, which depend on organization-level configuration.

In addition, the documented description of INS_PA_HISTORY_PROC establishes that the package inserts into GHR_PA_HISTORY, the personal action history table used across HRMS to record a chronological audit of person and assignment changes.

Usage Notes

GHR_SS_ASG_EIT is invoked indirectly through the Oracle HR Self-Service application stack, specifically when an assignment extra information record is created, updated, or validated from an employee or manager self-service page. It is not a public API and, per its documented access status, is reserved for internal table handler use.

Because the package is referenced by two other packages, the standard call path is from a higher-level SSHR wrapper or table handler rather than from a form or concurrent program directly. Customers implementing extensions to assignment EIT behavior should not call GHR_SS_ASG_EIT directly; instead, they should use the supported HRMS extra information APIs and, where audit history is required, rely on this package through its normal SSHR invocation path. The AUTHID CURRENT_USER declaration means any caller must possess the appropriate underlying object privileges, reinforcing the internal-only designation.