Search Results pv_partner_util_pvt_w




Overview
Explore in AI Chat

Overview

PV_PARTNER_UTIL_PVT_W is a public PL/SQL package owned by the APPS schema in Oracle EBS 12.1.1 and 12.2.2. It belongs to the Partner Management / Channel Partner functional area and is classified as an OTHER API. The package encapsulates the internal business logic used to create and maintain partner records and the relationships between partners and related entities. Because it is a _PVT_W (private worker) package, it exposes the executable implementation behind the public APIs while keeping the underlying data manipulation logic hidden from direct caller use. ETRM documentation records the package as VALID with four documented procedures. Its naming and dependency profile indicate it operates on top of JTF collection types, which are used throughout EBS for bulk processing and value passing between the public and private layers.

Key Procedures and Functions

Four procedures are documented for this package:

  • CREATE_PARTNER — Creates a partner record, handling the validation and defaulting required before the partner is persisted.
  • CREATE_RELATIONSHIP — Establishes a relationship between a partner and another entity, applying the relationship rules defined for partner management.
  • DO_CREATE_RELATIONSHIP — The execution-level worker that performs the physical creation of the relationship once preliminary validation has succeeded. The DO_ prefix is consistent with EBS private-layer conventions.
  • INVITE_PARTNER — Initiates the partner invitation process, supporting the on-boarding of partners into the partner program.

Parameter lists are not enumerated in the ETRM metadata and should be inspected in the database before any custom invocation.

Tables Accessed

ETRM metadata does not list any base tables referenced directly through APPS synonyms. The documented dependencies are Oracle JTF collection types — JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100, JTF_VARCHAR2_TABLE_400, JTF_VARCHAR2_TABLE_500, JTF_VARCHAR2_TABLE_2000, and JTF_VARCHAR2_TABLE_4000 — together with the SYS STANDARD package. These collection types indicate that the package interfaces with the public partner APIs using bulk input and output parameters rather than row-by-row scalar arguments. Actual DML against partner tables occurs in dependent objects that are not enumerated in the source metadata.

Usage Notes

PV_PARTNER_UTIL_PVT_W is referenced by zero other packages in the documented dependency set and is not listed as referencing any other APPS package. It is intended to be invoked from the public partner API layer, partner management forms, or concurrent programs, not directly from custom code. Customizations that call the private worker directly bypass the validation and defaulting performed by the public API and risk corrupting partner and relationship data; such calls should be replaced with the corresponding public API. The package is valid in both 12.1.1 and 12.2.2. Because the documented dependency set is sparse, developers should query ALL_DEPENDENCIES and ALL_ARGUMENTS for the target instance to obtain the authoritative parameter signatures and downstream objects before designing any integration.