Search Results ghr_tsp_catchup_plan_design




Overview
Explore in AI Chat

Overview

APPS.GHR_TSP_CATCHUP_PLAN_DESIGN is a PL/SQL package in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the APPS schema and classified under the ETRM as an OTHER-type API. The package supports the Oracle Advanced Benefits and Oracle Payroll "Total Compensation" model by enabling the design and generation of catch-up contribution plan structures for Tax Sheltered Plans (TSP) and similar benefit programs. In practical terms, it provides the logic needed to migrate participants into a new or updated contribution plan, populate the corresponding plan design records, and adjust alternate check dates that drive payroll processing. The functionality centers on catch-up contributions, which allow eligible employees to make additional pre-tax deferrals once normal statutory limits are reached, a common requirement in US public-sector and benefit-rich organizations running Oracle Payroll alongside Oracle Advanced Benefits.

Key Procedures and Functions

ETRM documents four procedures and functions within the package body:

  • CREATE_TSPC_PROGRAM_AND_PLANS — Creates the benefit program and associated plan records required for the TSP catch-up design. This is the primary setup routine used when a new catch-up program must be established before participant-level processing can occur.
  • POPULATE_TSPC_PLAN_DESIGN — Populates the plan design configuration and related element structures. It establishes the relationship between benefit plans and the payroll elements that drive contribution calculation and deduction processing.
  • GET_RECS_FOR_TSPC_MIGRATION — Retrieves the set of records eligible for catch-up migration. This function identifies existing participant or enrolment records that must be transitioned into the new catch-up plan design.
  • UPDATE_ALTERNATE_CHECK_DATE — Updates the alternate check date associated with catch-up processing. This supports payroll timing scenarios in which catch-up amounts are applied to a specific pay period or off-cycle check.

No parameter lists are documented in the ETRM, so signatures should be confirmed directly against the package specification before invoking these routines from custom code.

Tables Accessed

The package operates primarily on Oracle Advanced Benefits and Oracle Payroll configuration tables accessed via APPS synonyms. BEN_PGM_F holds benefit program definitions, supporting program creation. The PAY family — PAY_ELEMENT_TYPES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_INPUT_VALUES_F, and PAY_LINK_INPUT_VALUES_F — provides the element definitions, links, entry values, and input values required to drive catch-up deductions. PER_TIME_PERIODS supplies payroll period information used in date calculations. PQH_COPY_ENTITY_TXNS and PQH_TRANSACTION_CATEGORIES are used to record the create and migration operations as HR transactions, preserving auditability and integration with Oracle HRMS transaction processing.

Usage Notes

Because the package is classified as an OTHER API and is referenced by no other packages, it is not part of a standard automated processing chain. It is typically invoked during implementation or data migration projects when an organization introduces or restructures a TSP catch-up program, or when retroactively aligning existing enrolments with a new plan design. Invocation is most likely through one-off SQL*Plus scripts, concurrent program wrappers, or custom PL/SQL migration routines executed under an APPLSYSPUB- or APPS-authorized session. The documented dependency on SYS.STANDARD and the STANDARD package confirms only standard PL/SQL dependencies, with no dependency on other APPS packages. Administrators should treat this as a setup and migration utility rather than a routine called by standard Oracle forms, and should validate and back up benefit and payroll element configuration before execution in production.