Search Results update_asg

Overview

The APPS.HR_SUPERVISOR_SS package is a PL/SQL server-side component in Oracle E-Business Suite (documented for 12.1.1 and 12.2.2) that supports supervisor-related self-service transactions within Oracle Human Resources. The package is classified under ETRM as OTHER, indicating that it is an internal, non-public API rather than a formalized public interface. Its core business function is to resolve and validate reporting hierarchies during HR self-service workflows — most notably termination and assignment change transactions — so that workflow logic can branch correctly based on the affected employee's supervisory relationships.

In practical terms, the package answers questions such as whether an employee is a manager of a cost center, who that person's direct reports and supervisors are, and how a given transaction step should be recorded or advanced. It declares the AUTHID CURRENT_USER directive, meaning its procedures execute with the privileges of the invoking schema rather than the package owner, which is typical for APPS-owned self-service utility packages.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions:

• UPDATE_OBJECT_VERSION — Updates the object version number on a transaction step so that the object API does not raise an invalid object error, a behavior required for the "Save for Later" capability.
• BRANCH_ON_COST_CENTER_MGR — Reads the current person context and determines whether the employee being terminated is a cost center manager. When true, it sets the workflow item attribute HR_TERM_COST_CENTER_MGR_FLAG to 'Y' and sets the workflow result code accordingly, causing the workflow to transition to the Cost Center page.
• CREATE_TRANSACTION — Establishes the HR API transaction record that underlies the self-service operation.
• PROCESS_API — Drives the underlying HR API call that performs the actual business change against the employee or assignment record.
• WRITE_TRANSACTION — Persists transaction step information, including the surrogate collection gtt_transaction_steps declared using the HR_TRANSACTION_SS.transaction_table type.
• UPDATE_ASG — Handles the update of assignment records associated with the transaction.

The package also declares a record type lrt_direct_reports and a PL/SQL table type ltt_direct_reports, capturing attributes such as person_id, assignment_id, supervisor_id, supervisor_assignment_id, supervisor_name, and full_name — the structural basis for assignment security checks.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• HR_API_TRANSACTIONS, HR_API_TRANSACTION_STEPS, HR_API_TRANSACTION_VALUES — hold the header, step, and attribute values of each HR API transaction.
• PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_PERSON_TYPES — supply the person, assignment, and person type data used to determine reporting lines and supervisor relationships.
• HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION, HR_ORG_INFO_TYPES_BY_CLASS — provide organizational and cost center context used by the cost center manager branching logic.
• WF_ITEMS and WF_ACTIVITY_ATTR_VALUES — store and retrieve workflow item attributes driving the transaction's workflow transitions.
• PLITBLM — a standard PL/SQL table manipulation utility used for array handling.

Usage Notes

HR_SUPERVISOR_SS is not a public API and is referenced by zero other packages according to the ETRM metadata. It is invoked internally by Oracle HR self-service flows — principally the termination and assignment change processes in the Manager and Employee Self-Service responsibilities — to evaluate supervisory hierarchy and cost center management status before workflow routing decisions are made. Because it operates against workflow items and HR API transaction tables, custom code that attempts to simulate or extend self-service termination logic may call these procedures, but doing so requires awareness of the transaction step context and object version handling described in UPDATE_OBJECT_VERSION.