Search Results ghr_tsp_plan_design




Overview
Explore in AI Chat

Overview

GHR_TSP_PLAN_DESIGN is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the Oracle Advanced Benefits (BEN) and Human Resources (PER) product family. The "TSP" prefix denotes Total Compensation / Total Spend Plan functionality, which relates to the broader Oracle Compensation Workbench and Benefits plan design framework. The package serves as a technical utility that programmatically creates and maintains Total Spend Plan (TSP) structures — specifically the programs and associated plan records that form the foundation of a benefits offering. It is a design-time and migration-support package rather than a runtime enrollment engine, meaning it is invoked to establish or restructure plan configuration rather than to process participant elections.

In Oracle EBS 12.1.1 and 12.2.2, the package remains valid and is used where TSP functionality has been licensed. Its membership in the APPS schema and its dependencies on core BEN and PER kernel functions indicate it operates at the intersection of compensation plan setup and benefits eligibility configuration.

Key Procedures and Functions

The documented ETRM metadata identifies five procedures and functions. Parameter lists are intentionally omitted, as they are not specified in the source metadata.

  • CREATE_TSP_PROGRAM_AND_PLANS — Creates the program-level and plan-level records required to define a Total Spend Plan offering in the benefits schema. It establishes the parent program and its subordinate plan components.
  • POPULATE_TSP_PLAN_DESIGN — Populates the plan design data for an existing TSP structure, seeding the configuration attributes needed for eligibility and rate processing.
  • TSP_CONTINUE_COVERAGE — Supports the continuation-of-coverage logic associated with TSP plans, governing how coverage carries forward across enrollment periods or life events.
  • TSP_CONTINUE_COVERAGE_CP — The concurrent-program wrapper variant of the continuation-of-coverage routine, allowing the process to be invoked as a scheduled or batch concurrent request.
  • GET_RECS_FOR_TSP_MIGRATION — A retrieval function that extracts records required to migrate TSP data, returning the rows that a migration process must consume.

Tables Accessed

The package reads and writes through APPS synonyms referencing core Benefits and Payroll tables. The principal tables include:

Usage Notes

GHR_TSP_PLAN_DESIGN is referenced by no other documented packages in the ETRM repository, indicating it is a top-level entry point rather than a shared library routine. It is typically invoked through the Oracle Compensation Workbench or Benefits plan design forms, through concurrent programs (notably via the TSP_CONTINUE_COVERAGE_CP wrapper), or through custom migration scripts that call GET_RECS_FOR_TSP_MIGRATION during upgrade or data-conversion projects. Because it writes directly into enrollment and payroll element tables, it should be executed with standard EBS data-integrity controls, and concurrent runs should be scheduled outside active enrollment processing windows.