Search Results pv_assignment_pub




Overview
Explore in AI Chat

Overview

The APPS.PV_ASSIGNMENT_PVT package is a private PL/SQL API that supports the assignment and routing engine within Oracle Partner Management and the Oracle Sales/TeleSales (formerly Oracle TeleSales) modules in Oracle E-Business Suite 12.1.1 and 12.2.2. Its primary business function is to manage the lifecycle of partner, lead, and opportunity assignments, including party notifications, response tracking, routing-stage management, and workflow orchestration. The "PVT" suffix designates it as a private package, meaning it is intended for internal consumption by the public API layer (notably PV_ASSIGNMENT_PUB) rather than for direct invocation by external customizations. It encapsulates the low-level logic that drives notification, validation, and assignment state transitions so that the public interface remains stable while this private layer handles implementation detail.

Key Procedures and Functions

The package exposes sixteen documented procedures. The notification-related procedures include BULK_CR_PARTY_NOTIFICATION, BULK_SET_PARTY_NOTIFY_ID, and SEND_NOTIFICATION, which create and dispatch notifications to assigned parties. CREATE_ASSIGNMENT_LOG_ROW, CREATE_OPPTY_ROUTING_LOG_ROW, and UPDATE_ROUTING_STAGE manage audit logging and the progression of assignments through routing stages. UPDATE_PARTY_RESPONSE and VALIDATERESPONSE capture and validate the responses returned by notified parties.

  • UPDATEASSIGNMENT and REMOVEREJECTEDFROMACCESS update assignment records and revoke access for rejected assignments.
  • SETPARTNERATTRIBUTES, SET_OFFERED_ATTRIBUTES, and SET_CURRENT_ROUTING_FLAG set partner and offer attributes and manage the current-routing indicator.
  • SETTIMEOUT establishes timeout parameters for assignment responses.
  • STARTWORKFLOW and ABANDONWORKFLOW initiate and terminate the associated workflow processes.

Tables Accessed

The package reads and writes through APPS synonyms to several core tables. Assignment and routing persistence is handled by PV_LEAD_ASSIGNMENTS, PV_ENTITY_ROUTINGS, PV_ASSIGNMENT_LOGS, PV_ASSIGNMENT_LOGS_S, PV_LEAD_WORKFLOWS, and PV_ENTY_ATTR_VALUES. Party and resource identity data is drawn from HZ_PARTIES, HZ_RELATIONSHIPS, HZ_ORGANIZATION_PROFILES, PER_ALL_PEOPLE_F, FND_USER, and JTF_RS_RESOURCE_EXTNS. Lead data is sourced from AS_LEADS_ALL and AS_SALES_LEADS, while FND_TABLES supports metadata lookups. These accesses allow the package to resolve the parties, resources, leads, and attributes required to execute an assignment and to log the outcome.

Usage Notes

Because PV_ASSIGNMENT_PVT is a private package, it is invoked indirectly. It is referenced by the public package PV_ASSIGNMENT_PUB as well as PV_ASSIGN_UTIL_PVT, PV_OPPORTUNITY_VHUK, and PV_WORKFLOW_PUB, and it depends on FND_API and STANDARD. Typical invocation occurs when a user or concurrent program triggers assignment processing from Oracle Sales or Partner Management forms, when a workflow event fires, or when the public API executes routing logic. Custom code should call the public API (PV_ASSIGNMENT_PUB) rather than this private package, since the private signatures are not part of the supported interface and may change between releases such as 12.1.1 and 12.2.2.