Search Results p_proc_lf_evts_from_benauthe

Overview

APPS.GHR_TSP_PLAN_DESIGN is a seed-data generation utility within the Oracle E-Business Suite Advanced Benefits (OCM/OLM) module. Its principal business function is to programmatically construct the Federal Thrift Savings Plan (TSP) program along with its associated plan designs for a designated target business group. Rather than requiring an administrator to manually configure TSP program structures through the Benefits forms, this package leverages Oracle's existing copy-entity transaction framework to replicate a predefined seed design and populate the resulting plan components.

The package is oriented toward deployment and migration scenarios for United States federal customers who adopt the TSP offering. It combines transaction category lookup (using the short name BEN_PDCPWZ) with a copy-entity definition stored under the display name GHR_TSP_SEED_PROGRAM_DESIGN, ensuring that the TSP program is created consistently across environments.

Key Procedures and Functions

• CREATE_TSP_PROGRAM_AND_PLANS — The entry point for seeding. It resolves the relevant transaction category and copy-entity transaction identifiers, then drives creation of the TSP program and its subordinate plans for the supplied target business group. The header comments identify a 120.2 revision dated 2006, confirming long-standing use across releases.
• POPULATE_TSP_PLAN_DESIGN — Populates the plan design records that underpin the generated TSP program, establishing the eligibility and enrollment structures the program requires.
• TSP_CONTINUE_COVERAGE — Supports continuation-of-coverage processing for TSP participants, typically applied during leave or separation events administered through Benefits.
• TSP_CONTINUE_COVERAGE_CP — The concurrent-program wrapper variant of continuation-of-coverage processing, allowing the logic to be scheduled as a batch job rather than invoked interactively.
• GET_RECS_FOR_TSP_MIGRATION — Returns the set of records required when migrating TSP participants and their election data between configurations or environments.

All procedures are declared within a single package body whose private variable g_package prefixes HR_UTILITY tracing calls, supporting diagnostic tracing during execution.

Tables Accessed

The package reads and writes a broad slice of the Benefits and Payroll schema through APPS synonyms. Benefits tables include BEN_PGM_F (the program definition checked for the Federal TSP program name), BEN_LER_F, BEN_ELIG_PER_ELCTBL_CHC, BEN_ENRT_RT, BEN_PER_IN_LER, BEN_PRTT_ENRT_RSLT_F, BEN_PRTT_RT_VAL, and BEN_PTNL_LER_FOR_PER, supporting plan design, eligibility, enrollment, and rate processing. PER_ALL_PEOPLE_F supplies person records for participant identification. Payroll tables — 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 — are used to create and maintain the payroll elements and input values that fund TSP contributions and matching.

Usage Notes

Because the package is classified as OTHER with no referenced dependents, it is invoked directly rather than called by other application packages. Typical invocation paths include Benefits setup or migration tasks, one-off SQL*Plus or concurrent program executions during implementation for federal agencies, and custom code that needs to seed or validate TSP program structures. The concurrent wrapper TSP_CONTINUE_COVERAGE_CP indicates that continuation-of-coverage runs are expected to be submitted as scheduled jobs. The p_proc_lf_evts_from_benauthe parameter referenced in search queries aligns with BEN_AUTHE (authorized event) processing used when lifecycle events trigger TSP enrollment changes, so the package should be run in conjunction with standard Benefits event processing. Implementers should execute it only against a target business group whose TSP seed copy-entity transaction exists, since the procedure raises Nothing_To_Do when the copy-entity lookup fails.