Results for “values_f”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.HREMPTER package body is a core Oracle E-Business Suite (EBS) Human Resources (HR) database object that encapsulates the business logic required to terminate an employee and, where necessary, to cancel a previously recorded termination. The package is classified under the ETRM metadata as an API of type "OTHER" and is owned by the APPS schema, indicating that it forms part of the standalone HRMS termination engine delivered with Oracle HRMS rather than a pure validation or business-process API.

Its header comment, dated originally to 11-FEB-93 and last shipped in release 12.1.1 (file peempter.pkb 120.18.12010000.1), confirms the package's purpose: to declare the procedures required to terminate and cancel the termination of an employee. The package handles the full termination lifecycle, including the deletion of associated assignment records and element entries, the maintenance of absence and budget values, and the processing of payroll-related date-effective records. It is referenced by eight other packages, which reflects its role as a shared termination utility used by HR forms, payroll processes, and downstream EBS modules.

Key Procedures and Functions

The documented metadata exposes nine procedures and functions, of which the following are the principal public entry points:

• TERMINATE_EMPLOYEE — The primary procedure that performs the termination of an employee, driving the creation and validation of the termination record and orchestrating the dependent cleanup routines.
• EMPLOYEE_SHUTDOWN — Executes the shutdown sequence associated with termination, including checks relating to final processing dates (FPD) and actual termination dates (ATD).
• CANCEL_TERMINATION — Reverses a previously recorded termination, restoring the employee record and its associated entries.
• TERMINATE_ENTRIES_AND_ALUS — Terminates element entries and associated link usages, with logic that selects only recurring entries as corrected in change 80.2.
• DELETE_DE_ASSIGN — Removes date-effective assignment records linked to the termination.
• DELETE_ASSIGN_FPD — Deletes assignment records keyed to the final processing date.
• DELETE_ASSIGN_ATD — Deletes assignment records keyed to the actual termination date.

The remaining two documented procedures are supplementary internal routines supporting the above operations, including entry maintenance and benefit-related validation introduced in change 80.1.

Tables Accessed

The package reads from and writes to a broad set of HRMS and payroll synonyms, which reflects the cross-module impact of a termination:

• PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F — Core person and assignment date-tracked records updated during termination and reactivated during cancellation.
• PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_TYPES_F, and PAY_INPUT_VALUES_F — Element entry and link structures modified when recurring entries are terminated.
• PAY_PAYROLL_ACTIONS, PAY_RUN_RESULTS, PAY_ASSIGNMENT_ACTIONS, PAY_ASSIGNMENT_LINK_USAGES_F, PAY_COST_ALLOCATIONS_F, and PAY_PERSONAL_PAYMENT_METHODS_F — Payroll-facing records affected by assignment and element changes.
• PER_ABSENCE_ATTENDANCES — Absence records reconciled against the termination date.
• PER_ASSIGNMENT_BUDGET_VALUES_F — Budget values maintained as assignments are deleted.

Usage Notes

HREMPTER is typically invoked indirectly through the Oracle HRMS termination form and the associated termination concurrent processes, rather than being called directly by end users. In EBS 12.1.1 and 12.2.2 it remains a supported internal API; custom code that must reproduce termination behavior should call the documented public procedures rather than manipulating the underlying tables directly, because the package coordinates date-effective updates, element entry termination, and absence reconciliation in a single transactional unit. The notable search term associated with this object, while unrelated to its function, appears to correspond to third-party or community references and does not alter the package's documented role within Oracle HRMS.