Results for “po_vendors_all”

14 results




Overview
Explore in AI Chat

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

Overview

PO_WFDS_PUB is a public PL/SQL package in the Oracle E-Business Suite APPS schema that supports Oracle Purchasing's integration with the Oracle Workflow Directory Service. Its documented purpose is to keep supplier (vendor) records synchronized with the Workflow Directory Service so that workflow notifications, approval routings, and related workflow activities can resolve the correct supplier and supplier-site information. The package is versioned in the source header as POXPWFDB.pls (Header 115.1), identifying it as a Purchasing workflow directory service component.

The package reads a debug flag from the profile option PO_SET_DEBUG_WORKFLOW_ON, cached in the global g_po_wf_debug, to control diagnostic logging. When enabled, this flag allows the routine to emit debug information to the standard Oracle Workflow debug log facilities, which is useful during implementation and troubleshooting of supplier synchronization flows. The package is classified as a public (PUB) API, meaning it is intended for use as a documented, externally callable interface rather than an internal-only helper.

Key Procedures and Functions

The package body exposes a single documented procedure, SYNCH_SUPP_WTH_WF_DIR_SRVCS. This procedure is designed to be invoked as an Oracle Workflow activity function. It synchronizes a supplier (and its associated supplier site) with the Workflow Directory Service in response to workflow item events.

Its documented logic includes:

  • Reading the workflow item attribute ECX_TP_MOD_TYPE to determine the event reason.
  • If the event reason equals 'DELETE', immediately returning without performing any synchronization, since deleted suppliers require no directory service update.
  • Reading supplier identifiers and related attributes from the workflow item, including ECX_PARTY_ID (vendor identifier), ECX_PARTY_SITE_ID (vendor site identifier), ECX_PARTY_TYPE, and ECX_COMPANY_ADMIN_EMAIL.
  • Gathering the remaining supplier and site data needed to update the directory service, sourced from the Purchasing supplier tables.

The procedure follows the standard Oracle Workflow activity function signature, accepting itemtype, itemkey, actid, and funcmode as inputs and returning a status through the resultout parameter. This signature allows the procedure to be wired directly into a workflow process definition as a function activity.

Tables Accessed

The metadata documents references to WF_PARAMETER_LIST_T and PLITBLM. WF_PARAMETER_LIST_T is the Workflow parameter-list type used to assemble name/value pairs passed to the Workflow Directory Service population routines; the procedure initializes a local variable of this type at the start of execution. PLITBLM is the standard Oracle index-by table of VARCHAR2 typically used for message or parameter handling within Workflow-related APIs.

In addition, the source excerpt shows that the procedure retrieves supplier details from PO_VENDORS_ALL and PO_VENDORS, the core Purchasing supplier entities that the user searched for. These tables supply the vendor name, vendor site, address, language, email, fax, and site code values needed to keep the Workflow Directory Service record consistent with Purchasing. The exact columns are not enumerated in the metadata, but the local variables declared in the procedure (vendor_id, vendor_site_id, vendor_name, site_address, site_code, email, fax, language, party_type) indicate the attributes being populated.

Usage Notes

PO_WFDS_PUB is normally invoked indirectly through Oracle Workflow rather than being called by end users or standard concurrent programs. It is embedded as a function activity in a supplier-related workflow process; when a supplier event occurs, Workflow raises the item and calls SYNCH_SUPP_WTH_WF_DIR_SRVCS with the relevant itemtype, itemkey, and activity identifiers. The procedure then resolves the party and site information from workflow item attributes and the Purchasing supplier tables and synchronizes the Workflow Directory Service accordingly.

Deletes are explicitly accommodated: because the procedure returns immediately when ECX_TP_MOD_TYPE is 'DELETE', no directory update is attempted for removed suppliers. Customizations that extend supplier approval or supplier lifecycle workflows should preserve this behavior. Debug output for this package is controlled by the PO_SET_DEBUG_WORKFLOW_ON profile option, which should be enabled only in non-production environments when diagnosing synchronization issues between Purchasing suppliers and the Workflow Directory Service.