Results for “po_wfds_pub”

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

Overview

PO_WFDS_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its name encodes its role: Purchasing (PO) integration with the Workflow Directory Services (WFDS) subsystem. The package provides a programmatic interface for synchronizing Oracle Purchasing supplier records with the Workflow Directory Service, the repository that workflow notification and routing components use to resolve roles, users, and ad hoc recipients. In this sense PO_WFDS_PUB acts as a bridge between the supplier master held in Purchasing and the directory structures consumed by Oracle Workflow.

The package is classified as PUB, indicating that it exposes a supported public API surface intended for controlled external invocation rather than purely internal use. The ETRM record shows the package and package body both in VALID status, confirming it is compiled and available in the database at the documented release level.

Key Procedures and Functions

The documented API surface of PO_WFDS_PUB consists of a single procedure:

• SYNCH_SUPP_WTH_WF_DIR_SRVCS — Synchronizes supplier information with Workflow Directory Services. The procedure reconciles supplier-related directory entries so that workflow routing, notification, and address resolution reflect the current state of the Purchasing supplier records. It is the sole documented entry point in this package per the ETRM metadata.

No additional procedures or functions are documented for this package in the 12.2.2 ETRM extract. Parameter lists are not reproduced in the available metadata and are therefore not stated here.

Tables Accessed

The metadata identifies the following tables referenced through APPS synonyms:

• WF_PARAMETER_LIST_T — A Workflow parameter list type used to pass structured parameter collections to Workflow APIs. Its presence confirms that PO_WFDS_PUB drives Workflow engine calls that require parameter-list arguments.
• PLITBLM — The standard Oracle Forms PL/SQL table of VARCHAR2 used for list handling. This reference is consistent with a package that passes arrays or lists of values into Workflow directory operations.

The package is also documented as referencing SYS.STANDARD, the default PL/SQL package, which is a normal compilation dependency. No base application tables are listed as directly referenced, suggesting the supplier-side data retrieval is performed through other Purchasing objects or through the Workflow directory schema itself.

Usage Notes

PO_WFDS_PUB is typically invoked indirectly rather than through direct user action. In a standard EBS deployment it is called from Purchasing supplier maintenance flows, from concurrent programs associated with supplier and workflow synchronization, or from workflow-enabled transactions that must refresh directory entries when supplier data changes.

The ETRM record states that PO_WFDS_PUB is referenced by zero other packages, which indicates it is an entry point rather than a shared internal utility. Customizations that need to force synchronization of supplier data with Workflow Directory Services should call SYNCH_SUPP_WTH_WF_DIR_SRVCS through the APPS schema, observing standard EBS API conventions: initialize the session with FND_GLOBAL.APPS_INITIALIZE, commit explicitly as required by the Workflow interfaces invoked, and test in a non-production environment before deployment. Because the package is classified PUB, it is the appropriate object to reference in custom code rather than any private helper.