Results for “pon_sourcing_user_manager_pkg”

21 results




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

Overview

PON_SOURCING_USER_MANAGER_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite involving Sourcing, the Oracle Advanced Procurement module within the Purchasing family. In ETRM it is classified as a VALID package with an API classification of OTHER, meaning it serves internal processing rather than a published, externally supported interface, but it is a documented object with a specific security or user-validation responsibility.

The package acts as the user-side management and validation layer for the Sourcing application. Its central documented procedure, VALIDATE_USER_DATA, is intended to confirm that the identity and association data for a Sourcing user is complete, consistent, and permissible before the Sourcing application commits that user relationship.

Sourcing connects buyers, sourcing professionals, suppliers, and internal collaborators to negotiation events, qualification areas, and supplier lists, so validation of the user record is an essential prerequisite. The package therefore provides a reusable validation service consumed by other Sourcing components rather than by external callers.

Key Procedures and Functions

VALIDATE_USER_DATA is the sole documented procedure or function in this package. As its name indicates, it performs validation of user data submitted to the Sourcing user manager. It checks the integrity and admissibility of the user record before it is accepted by the owning Sourcing process and returns control to the caller with the result of that validation.

Because the procedure is documented without a parameter list, its call signature should be read directly from the deployed package specification. Its purpose is data validation rather than data mutation of unrelated entities. No other public procedures or functions are documented for this package, and no parameter lists are asserted here.

Tables Accessed

The ETRM metadata does not enumerate underlying base tables for PON_SOURCING_USER_MANAGER_PKG, and no tables are listed among its documented dependencies. The only dependency shown is on the SYS.STANDARD package, the PL/SQL built-in library, which indicates that the package relies on standard PL/SQL functionality rather than explicit object-level table dependencies visible in the metadata.

Consistent with its role, the package logically operates against the Sourcing user and user-association data structures used throughout PON modules. Because the documented table list is empty, no specific tables or columns are asserted here; validation targets should be determined from the installed package body and from the calling components.

Usage Notes

PON_SOURCING_USER_MANAGER_PKG is referenced by one other package, PON_OPEN_INTERFACE_PVT, as well as by itself. This indicates that the Open Interface processing package is the primary documented consumer: when Sourcing data is loaded or processed through the open interface, user data is passed to VALIDATE_USER_DATA before it is accepted. The package is intended for internal Sourcing and Open Interface processing on Oracle EBS 12.1.1 and 12.2.2.

The documented API classification of OTHER confirms this is not a self-service or externally supported public API. Customizations should avoid calling it directly. Instead, use the supported Sourcing Open Interface flows that invoke it. Any direct use should be limited to diagnostics and must respect the package body's current signature on the target release.