Search Results hr_termination_ss




Overview
Explore in AI Chat

Overview

APPS.HR_TERMINATION_SS is a server-side PL/SQL package within Oracle E-Business Suite 12.1.1 and 12.2.2 that supports the employee termination workflow. It is an integral component of the HR Termination self-service (SS) flow, which allows managers, HR professionals, and employees to initiate, review, and process the end of an employee's period of service. The package encapsulates the business rules required to validate, stage, and commit termination data to the underlying HR tables, and it orchestrates the Workflow activity HR_TERMINATION_SS through the WF_ITEM_ACTIVITY_STATUSES_V view.

Its 2005 header file reference (hrtrmwrs.pkh) places the package within the long-standing termination framework of Oracle HRMS. The package maintains a global temporary transaction step table (gtt_transaction_steps based on HR_TRANSACTION_SS.Transaction_Table), indicating it participates in the generic transaction framework used for "Save for Later" behavior in Oracle Self-Service HR.

Key Procedures and Functions

The ETRM metadata documents eight procedures and functions. Their roles are as follows:

  • PROCESS_SAVE — Persists partially entered termination data. This is the procedure most relevant to the user's search; it supports the "Save for Later" action by staging data and updating the object version number to avoid invalid object API errors.
  • UPDATE_OBJECT_VERSION — Explicitly updates the object version number on a transaction step. The in-line comment in the source states its purpose is to "pass the invalid object api error for Save for Later," confirming it works in tandem with PROCESS_SAVE.
  • PROCESS_API — Invokes the underlying HR termination APIs to commit validated termination details to the PER tables once the user finalizes the transaction.
  • ACTUAL_TERMINATION_EMP — Handles processing for an actual (as opposed to projected) employee termination, applying the effective termination date and related attributes.
  • UPDATE_PDS_DETAILS — Updates the Periods of Service (PDS) record with termination-specific details such as leaving reason, comments, and dates.
  • GET_TERM_TRANSACTION — Retrieves an existing termination transaction, likely populating the record type rt_termination and the DFF table t_flex_table defined in the package header.
  • BRANCH_ON_SUBORDINATE_PRESENCE — Determines whether the terminating person has direct reports, enabling conditional workflow branching.
  • MOVEALLDIRECTREPORTS — Reassigns direct reports to another manager (or leaves them unassigned) when the terminating manager leaves, preserving organizational structure.

Tables Accessed

The package reads from and writes to standard HRMS tables through APPS synonyms. PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F supply person and assignment data together with rehire recommendation and reason fields. PER_PERIODS_OF_SERVICE and PER_PERIODS_OF_PLACEMENT hold the termination dates, leaving reasons, and process dates central to the transaction. PER_PERSON_TYPES and PER_ASSIGNMENT_STATUS_TYPES provide the status classification applied on termination. Workflow integration uses WF_ITEMS, WF_ACTIVITY_ATTR_VALUES, and WF_ITEM_ATTRIBUTE_VALUES, while HR_API_TRANSACTION_STEPS manages transaction staging. Descriptive flexfields and organizational context are resolved through HR_ALL_ORGANIZATION_UNITS_TL, HR_ALL_POSITIONS_F_TL, and HR_LOCATIONS_ALL.

Usage Notes

HR_TERMINATION_SS is invoked primarily from the Oracle Self-Service HR termination pages, where it is called during both the interim "Save for Later" action and the final submission. It is also referenced by one other package in the ETRM inventory. Customizations that extend the termination flow — for example, adding DFF handling or altering workflow branching — should route through the documented procedures rather than updating PER tables directly. Developers should note that PROCESS_SAVE and UPDATE_OBJECT_VERSION are tightly coupled and that bypassing the object version update may reintroduce the invalid object API error the package was designed to prevent.