Search Results fetch_asgei_prior_root_sf50

Overview

GHR_HISTORY_FETCH is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite (12.1.1 and 12.2.2) that provides date-effective history retrieval services for the Oracle Human Resources (HR) and Oracle Payroll product families. Each documented procedure reconstructs the state of a business object — a person, assignment, position, extra information record, element entry, or analysis — as of a specified effective date, using the GHR_PA_HISTORY tracking table and the corresponding date-tracked ("_F") tables. The package is classified as OTHER in the ETRM metadata, meaning it is not a supported public API in the sense of a full business object API, but it is a widely reused internal utility: 54 other packages reference it, which makes it one of the more pervasive HR history utilities in the EBS data model.

Key Procedures and Functions

The package exposes 22 documented procedures and functions. Each fetcher follows a common signature pattern: an identifier or a date-effective qualifier as input, an optional altered PA request identifier, an optional NOA-corrected identifier, an optional ROWID, an optional PA history identifier, an OUT NOCOPY record typed against the target table, and an OUT result code. The principal fetchers are:

• FETCH_PEOPLE — returns a PER_ALL_PEOPLE_F row as of the effective date.
• FETCH_ASGEI — returns a PER_ASSIGNMENT_EXTRA_INFO row. Two overloads exist: the first accepts an assignment extra information identifier, the second accepts an assignment identifier plus information type. The first overload also supports an OUT varchar2 flag p_get_ovn_flag (default 'N') and is the object most commonly associated with the term "fetch_asgei".
• FETCH_PEOPLEEI and FETCH_POSITIONEI — return person and position extra information rows respectively.
• FETCH_POSITION — returns an HR_ALL_POSITIONS_F row.
• FETCH_ASSIGNMENT — returns a PER_ALL_ASSIGNMENTS_F row.
• FETCH_ELEMENT_ENTRIES, FETCH_ELEMENT_ENTRY_VALUE, and GET_DATE_EFF_ELEEVL — return payroll element entry and element entry value records; GET_DATE_EFF_ELEEVL additionally returns a PA history identifier.
• FETCH_ELEMENT_INFO_COR — returns corrected element information.
• FETCH_PERSON_ANALYSES and FETCH_ADDRESS — return person analysis and address records.
• FETCH_ASGEI_PRIOR_ROOT_SF50 and FETCH_ASGN_PRIOR_ROOT_SF50 — retrieve prior root history rows using the SF50 (federal personnel action) history model.
• RETURN_SPECIAL_INFORMATION — a helper that returns special-case information needed by the fetch logic.

Tables Accessed

The package reads and writes the core date-tracked HR and Payroll tables through APPS synonyms. GHR_PA_HISTORY is the primary history/orchestration table that anchors effective-date reconstruction. Person and assignment fetchers read PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F. Address and analysis fetchers read PER_ADDRESSES and PER_PERSON_ANALYSES. Extra information procedures read PER_ASSIGNMENT_EXTRA_INFO, PER_PEOPLE_EXTRA_INFO, and PER_POSITION_EXTRA_INFO. Position procedures read HR_ALL_POSITIONS_F. Payroll procedures read PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_TYPES_F, and PAY_INPUT_VALUES_F. FND_ID_FLEX_STRUCTURES is referenced for key flexfield structure resolution.

Usage Notes

The package is invoked from HR and Payroll forms, from concurrent programs, and from custom PL/SQL that must display or compare records as they existed on a past effective date. Because it is classified OTHER rather than a public API, callers should treat its signatures as stable within a release but not covered by the same upgrade guarantees as a formal business object API. The overloads of FETCH_ASGEI mean callers must pass arguments that unambiguously resolve to the intended signature; mixing the assignment identifier and information type parameters with the assignment extra information identifier form will raise a compile-time ambiguity. All fetchers return a result code that the caller must check before consuming the OUT record.