Search Results pos_spm_wf_pkg1




Overview
Explore in AI Chat

Overview

POS_SPM_WF_PKG1 is an Oracle Application Object Library package owned by the APPS schema that supports the Oracle Supplier Lifecycle Management (SPM) module within Oracle E-Business Suite. Its primary business function is to generate and dispatch Oracle Workflow notifications associated with supplier registration, supplier profile maintenance, and buyer-driven approval activities. The package acts as a centralized notification layer: rather than embedding Workflow API calls directly within each supplier-facing package, the SPM application delegates notification logic to POS_SPM_WF_PKG1, which resolves recipients, constructs notification payloads, and initiates the appropriate Workflow processes.

The package is classified as OTHER in the documented API classification, indicating that it is an internal implementation component rather than a published integration API. It is not intended for direct customer invocation. The package name contains the "WF" token, confirming its role as the Workflow-facing utility for supplier profile management.

Key Procedures and Functions

ETRM documents 43 procedures and functions, of which the following are representative. The naming convention splits cleanly into "NOTIFY_" routines that raise Workflow notifications and note-related routines that record buyer input.

Tables Accessed

The package reads and writes a mix of Oracle Supplier Management, Trading Community Architecture (TCA), and Oracle Application Framework foundation tables.

Usage Notes

POS_SPM_WF_PKG1 is invoked indirectly rather than by end users. It is referenced by four other APPS packages — POS_REQUEST_UTILS_PKG, POS_SBD_PKG, POS_SUPPLIER_NOTIFY_PKG, and POS_VENDOR_REG_PKG — and by itself, forming the notification backbone for supplier registration and profile change flows. Typical invocation occurs when an Oracle Application Framework (OAF) supplier registration or profile management page commits a change; the calling package then invokes the appropriate NOTIFY_ routine to place a notification in the recipient's Workflow worklist or to deliver an outbound message.

Because the object is classified OTHER and is undocumented as a public API, customizations should not call these procedures directly. Any extension that requires supplier notifications should be implemented by wrapping or subscribing to the surrounding Workflow process rather than by invoking POS_SPM_WF_PKG1 members. The package relies only on SYS.STANDARD for compilation dependencies and presents no external database links, keeping it portable across both 12.1.1 and 12.2.2 releases where the SPM module is licensed.