Search Results update_employee

Overview

APPS.AP_EMPLOYEE_UPDATE_PKG is a Payables-side utility package whose documented purpose is to synchronize employee-related records when supplier and supplier site assignments change between a source and a target supplier. In Oracle EBS Payables, an employee can be associated with a supplier record (for example, a payee or an employee-type supplier representing reimbursement flows or payroll-related disbursements). When a supplier relationship is reorganized or an employee is reassigned to a different supplier or supplier site, the corresponding assignment and period-of-service records must be kept consistent. This package encapsulates that synchronization logic behind a single callable interface, allowing Oracle Payables to update employee assignments without requiring external callers to manipulate HR tables directly.

The package is classified as an "OTHER" API in the ETRM 12.2.2 metadata, reflecting that it is an internal, non-public API rather than a formally supported public interface. Its header comment (version 120.1) indicates it originates from the Payables product family and has been stable for many releases, applying to both 12.1.1 and 12.2.2 with equivalent behavior.

Key Procedures and Functions

• UPDATE_EMPLOYEE — The only documented program unit. It is a function returning BOOLEAN, signifying success or failure of the update operation. Its parameters (based on the package specification) cover a processing date, a source supplier, a target supplier, a debug-mode indicator, and a calling-sequence string for diagnostic logging. The function's core purpose is to move or re-point employee assignment information from one supplier context to another while preserving HR data integrity.

No other procedures or functions are documented. The package exposes a narrow, single-entry interface, characteristic of a batch or internal maintenance routine invoked by higher-level Payables processes.

Tables Accessed

The ETRM metadata lists five tables accessed through APPS synonyms, spanning both Payables and HR schemas:

• AP_SUPPLIERS and AP_SUPPLIER_SITES_ALL — Payables supplier and supplier site masters; read (and potentially updated) to identify the supplier contexts involved in the update.
• PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F — Oracle HRMS date-tracked person and assignment tables; these hold the employee records whose assignments are synchronized.
• PER_PERIODS_OF_SERVICE — Records periods of service for employees, ensuring service history remains aligned with the changed supplier association.

Writing to HRMS tables via a Payables package underscores the cross-product nature of the operation, which is why the package centralizes these updates rather than leaving them to callers.

Usage Notes

Because the API classification is OTHER and it is referenced by only one other package, AP_EMPLOYEE_UPDATE_PKG is not intended as a general-purpose integration point. It is typically invoked internally by Payables supplier-maintenance logic—such as a concurrent program, a supplier merge/update flow, or a forms-based action triggered when an employee's supplier linkage is changed—rather than called directly from customer-written code.

Custom developers should treat it as a private helper: the BOOLEAN return and debug_mode/calling_sequence parameters indicate it is designed for internal orchestration and troubleshooting. Any custom invocation should occur within the same session context (APPS) that owns the HRMS data, and error handling should check the BOOLEAN return value consistently. Because it touches date-tracked HR tables, callers are advised to invoke it only as part of a controlled transaction and to avoid concurrent direct edits to the same person or assignment records.