Results for “per_pds_wf”

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

Overview

APPS.PER_HRWF_SYNCH_COVER is a PL/SQL cover package belonging to the Oracle Human Resources (PER) product family. Its role is to expose a controlled, stable interface to the underlying worker synchronization package, PER_HRWF_SYNCH, which performs the actual propagation of person and person-assignment data to Oracle Workflow. Rather than allowing callers to invoke PER_HRWF_SYNCH directly, the E-Business Suite delivers this thin wrapper so that dependent product code, forms, and public APIs bind to PER_HRWF_SYNCH_COVER. This insulation layer allows Oracle to refactor or replace the internal synchronization logic without breaking the many upstream consumers that reference the cover's signatures.

The package body header indicates a maintenance level consistent with Release 12.1.1 and 12.2.2, and the source is deliberately minimal: each procedure logs an entry with HR_UTILITY.SET_LOCATION, delegates to the equivalent PER_HRWF_SYNCH entry point by name, and logs its exit. No business logic, data manipulation, or validation is performed within the cover itself.

Key Procedures and Functions

Two procedures are documented:

• PER_PER_WF — Accepts a person record type defined in PER_PER_SHD (the shadow/datatype package for the PER_PER schema) along with an action indicator, and forwards both unchanged to PER_HRWF_SYNCH.PER_PER_WF. This entry point is used when synchronization is driven from a complete person record, typically during datetracked or process-driven person changes.
• PER_PDS_WF — Accepts a person identifier, an optional effective date, a start date, and an action indicator, and forwards them to PER_HRWF_SYNCH.PER_PDS_WF. The PDS (Person Data Store/Person Delivery Service) variant is invoked when synchronization is triggered by way of a person ID rather than a full record, such as during assignment-level refreshes or workflow-initiated person updates.

Both procedures emit HR_UTILITY location markers at the entering and leaving points, which assists with diagnostic tracing in a multi-package call chain. No cursor, exception handler, or DML statement appears in the body, confirming that the cover is purely a delegation shim.

Tables Accessed

No tables are accessed directly by PER_HRWF_SYNCH_COVER. All row-level reads and writes against PER tables and Workflow tables occur inside PER_HRWF_SYNCH, which the cover calls by fully qualified name. The only runtime dependency of note is HR_UTILITY, used for tracing rather than data access. Because the package references no APPS synonyms for table operations, it can be analyzed and compiled with minimal object dependencies, reducing the risk of invalidations cascading from table DDL.

Usage Notes

PER_HRWF_SYNCH_COVER is typically invoked from HR forms and from Oracle Workflow background processes when person or assignment information must be synchronized with the Workflow directory. It may also be called from custom code, but Oracle's guidance is to reference this cover package rather than PER_HRWF_SYNCH directly, since the internal package is subject to change without notice. The metadata shows the package is referenced by one other package within APPS, indicating a narrow but well-defined call surface. When troubleshooting, DBMS_OUTPUT or session tracing at HR_UTILITY locations will reveal whether the failure lies in the cover (rare, since it contains no logic) or in the underlying PER_HRWF_SYNCH implementation. Implementers seeking the actual synchronization behavior for the search term "per_pds_wf" should follow the delegation path into PER_HRWF_SYNCH.PER_PDS_WF, where the substantive person data synchronization logic resides.