Search Results ghr_tsp_catchup_migrate

Overview

APPS.GHR_GENERAL is a shared PL/SQL utility package within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, residing in the APPS schema with a status of VALID. Its name and dependency profile identify it as a general-purpose support package for the Oracle HRMS/Advanced Benefits (GHR) product family, serving the United States federal and public-sector HRMS extensions. The package supplies common helper routines — number and date derivations, remark code lookups, notification flag resolution, and data migration routines — that other GHR components call rather than reimplementing identical logic. The ETRM-documented API classification is OTHER, indicating that this package is an internal support library rather than a published, end-user-facing API.

Key Procedures and Functions

The 12.2.2 ETRM metadata documents seven procedures and functions, each oriented toward shared GHR processing:

• RETURN_NUMBER — Returns a numeric value used by callers, typically as a derived or looked-up number.
• RETURN_RIF_DATE — Returns a date associated with RIF (Reduction in Force) processing, used in federal HRMS RIF workflows.
• GET_REMARK_CODE — Retrieves a remark code, drawing on the GHR_REMARKS table for standard code resolution.
• GET_POI_TO_SEND_NTFN — Determines the point of contact (POI) to be used when sending a notification.
• GHR_TSP_MIGRATE — Performs migration processing for Thrift Savings Plan (TSP) data.
• GHR_TSP_CATCHUP_MIGRATE — Handles migration of TSP catch-up contribution data, distinct from the standard TSP migration routine.
• GHR_FEHB_MIGRATE — Performs migration processing for Federal Employees Health Benefits (FEHB) data.

Each routine supports the federal benefits and HRMS extensions that GHR-prefixed objects deliver.

Tables Accessed

Via APPS synonyms, the package references both Oracle HRMS core and Benefits tables. Core HR objects include PER_ASSIGNMENTS_F (assignment records), PAY_ELEMENT_ENTRIES_F and PAY_ELEMENT_ENTRY_VALUES_F (payroll element entries and their values), and GHR_REMARKS (GHR-specific remarks). Benefits configuration and enrollment tables include BEN_OPT_F, BEN_PL_F, and the broader set BEN_ELIG_PER_ELCTBL_CHC, BEN_ENRT_RT, BEN_LER_F, BEN_OIPL_F, BEN_PER_IN_LER, BEN_PGM_F, BEN_PLIP_F, BEN_PL_TYP_F, BEN_PRTT_ENRT_RSLT_F, and BEN_PTIP_F. Read access supports eligibility, program, plan, and enrollment-rate resolution, while write access supports the migration routines that populate enrollment and element entry data.

Usage Notes

GHR_GENERAL is referenced by eighteen other packages and views, including GHR_PEOPLE_H_V, GHR_ASSIGNMENTS_H_V, GHR_POSITIONS_H_V, GHR_ELEMENT_ENTRIES_H_V, and related extra-info views; fellow packages such as GHR_RIF_PKG, GHR_FEHB_PLAN_DESIGN, GHR_TSP_PLAN_DESIGN, and GHR_TSP_CATCHUP_PLAN_DESIGN; and integration packages including PQP_FEDHR_USPAY_INTG_PKG and PQP_FEDHR_USPAY_INT_UTILS. This dependency pattern confirms the package is invoked indirectly through HRMS views, concurrent migration programs, RIF processing, and federal payroll integration, rather than being called directly by end users. Customers and implementers should treat GHR_GENERAL as an internal Oracle support library: it is safe to reference for dependency analysis, but direct custom invocation is not recommended because the interface is undocumented and Oracle may alter it in patches or upgrades.