Search Results pos_supplier_notify_pkg




Overview
Explore in AI Chat

Overview

POS_SUPPLIER_NOTIFY_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports supplier notification and communication workflows within the Oracle Procurement and Supplier Management product family. The package is classified under the API classification "OTHER" in the ETRM metadata for release 12.2.2, and its status is reported as VALID. Its name and object references indicate that it serves as an internal utility package responsible for generating and dispatching notifications to suppliers, typically in response to sourcing, negotiation, or supplier registration events originating in Oracle Sourcing and related modules.

The package depends on the SYS.STANDARD package only, while it references and is referenced internally by APPS.POS_SUPPLIER_NOTIFY_PKG itself. The absence of external package dependencies indicates that it is invoked as a standalone notification utility rather than as a public integration API, and it is not referenced by any other documented package in the ETRM repository.

Key Procedures and Functions

The documented package exposes a single procedure:

  • SUPPLIER_NOTIFICATION — The sole public entry point in the package, responsible for constructing and dispatching supplier-facing notifications. In typical EBS sourcing and supplier management flows, this procedure assembles the notification content, resolves the recipient supplier contact, persists the message record, and initiates the associated workflow notification process.

No additional procedures or functions are documented in the ETRM metadata. Parameter lists are not published and should not be assumed; integrators invoking this procedure should inspect the package specification directly in the target environment.

Tables Accessed

The package accesses the following tables through APPS synonyms:

  • FND_NEW_MESSAGES — Stores notification message content for delivery through the Oracle Workflow notification mailer and the EBS notification framework.
  • FND_USER — Resolves internal EBS user accounts, typically the notification sender or workflow role owner.
  • HZ_CONTACT_POINTS — Supplies supplier contact information such as email addresses and other contact point records used to address outbound notifications.
  • HZ_PARTIES — Provides the party record for the supplier or supplier contact, linking the notification to the correct trading partner.
  • WF_ITEMS — Represents the Oracle Workflow item that the notification is associated with, enabling status tracking and response capture.
  • PLITBLM — Serves as the PL/SQL table used for message buffering during notification assembly.

Usage Notes

POS_SUPPLIER_NOTIFY_PKG is an internal product package and is not a documented public API. It is most commonly invoked indirectly by Oracle Sourcing functionality — such as negotiation invitations, supplier responses, and award notifications — and by other supplier-facing workflows where a notification must be delivered to an external supplier contact. Because the package references Workflow tables (WF_ITEMS) and the notification store (FND_NEW_MESSAGES), it will only function correctly when the Oracle Workflow mailer and notification infrastructure are configured in the environment.

Custom code should avoid calling this package directly, since it is not covered by Oracle's public API compatibility guarantee and may change between releases. Developers requiring supplier notification behavior in custom extensions should use Oracle Workflow APIs (WF_NOTIFICATION) or Oracle's documented notification PL/SQL interfaces instead. Both Oracle EBS 12.1.1 and 12.2.2 environments include this package under the APPS schema, and its presence should be verified at the site level before relying on it for any integration.