Search Results pv_partner_util_pvt




Overview
Explore in AI Chat

Overview

PV_TERR_ASSIGN_PUB is a public PL/SQL package in the APPS schema that belongs to the Oracle Partner Management and Channel Management functionality within Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2. Its primary business purpose is the creation and maintenance of channel teams and the assignment of trading partners to territories. In the Oracle EBS partner model, a "channel team" is the collection of partner resources (sales representatives, account managers, and supporting roles) associated with a partner organization or a partner relationship. PV_TERR_ASSIGN_PUB provides the programmatic entry point for building those teams, resolving resource and partner detail information, and applying territory assignment rules to sub-territories. As a PUB-classified package, it is intended for external invocation by forms, concurrent programs, and other dependent packages rather than being restricted as an internal helper. It is a foundational dependency for several surrounding partner utilities and wrappers, including PV_PARTNER_UTIL_PVT, PV_PARTNER_UTIL_PVT_W, PV_PARTNER_ATTR_LOAD_PUB, and PV_TAP_BES_PKG.

Key Procedures and Functions

The documented interface exposes eleven procedures and functions. Their purposes are as follows:

  • CHK_PRTNR_QFLR_ENABLED — verifies whether the partner qualifier mechanism is enabled before qualification-dependent logic proceeds.
  • GET_RES_FROM_TEAM_GROUP — retrieves resource identifiers belonging to a specified team group.
  • GET_PARTNER_DETAILS — returns partner-specific attribute and organization detail used during team construction.
  • CREATE_CHANNEL_TEAM — the public entry point that initiates creation of a channel team, delegating the heavy processing to the internal creational routine.
  • DO_CREATE_CHANNEL_TEAM — the worker procedure that performs the actual channel team creation work.
  • CREATE_ONLINE_CHANNEL_TEAM — public entry point for building a channel team for online-channel scenarios, delegating to an internal routine.
  • DO_CR_ONLINE_CHNL_TEAM — internal worker that performs the online channel team creation processing.
  • CREATE_VAD_CHANNEL_TEAM — creates a channel team for value-added distributor (VAD) partner relationships.
  • UPDATE_CHANNEL_TEAM — modifies an existing channel team, including its members or role associations.
  • ASSIGN_CHANNEL_TEAM — applies or links a channel team to the relevant partner or territory context.
  • PROCESS_SUB_TERRITORIES — handles territory assignment cascading to sub-territories, ensuring child territories inherit the correct channel team coverage.

Tables Accessed

The package reads and writes against the Oracle Trading Community Architecture (TCA) and Oracle Resource Manager (JTF_RS) tables, accessed through APPS synonyms:

Usage Notes

PV_TERR_ASSIGN_PUB is not typically invoked directly by end users. It is called by higher-level partner management code, notably PV_PARTNER_UTIL_PVT and its wrapper PV_PARTNER_UTIL_PVT_W, which drive the user-facing partner and channel team forms. The _W wrapper packages supply the Web/forms-layer bindings around the public API, and because the user's search term was "pv_partner_util_pvt," it is worth noting that PV_PARTNER_UTIL_PVT is among the most direct callers of PV_TERR_ASSIGN_PUB and is likely the layer that surfaces this functionality to the form. The package delegates to FND_API for standard API error and message handling and relies on SYS.STANDARD package machinery, indicating it follows Oracle's published API conventions returning status and message out-parameters. Typical invocation points include the partner and channel team maintenance forms, concurrent programs that build or refresh channel teams, and custom partner-management extensions. Because the CREATE procedures are paired with DO_ helper routines, callers should invoke the public entry points and avoid calling the internal workers directly. All operations should run as the APPS schema or a schema with appropriate grants to the APPS synonyms listed above.