Search Results pv_assignment_logs_s

Overview

PV_LEADLOG_PVT is a private PL/SQL package body in the APPS schema that supports the lead and assignment logging facility within Oracle E-Business Suite's Channel Management / Partner Management (PV) module. Its role is to encapsulate the low-level insert and audit logic used to persist lead assignment events and lead status transitions into the assignment log tables. As a "PVT" (private) package, it functions as an internal implementation layer rather than a public API; it is not referenced by any other database object, and it is designed to be called from within the PV module's own code stack. The package provides a controlled mechanism for writing audit rows that trace how leads are routed, reassigned, or progressed through their lifecycle, supporting downstream reporting and troubleshooting of the lead distribution process.

Key Procedures and Functions

The package exposes three documented procedures, all oriented toward record creation in the assignment logging tables:

• CREATEASSIGNLOG — The principal entry point for creating an assignment log entry. It orchestrates the creation of a log record for a lead assignment event, centralizing the logic required to generate a valid log row.
• INSERTASSIGNLOGROW — Performs the physical insertion of a single assignment log row into the assignment log schema objects, handling the persistence step for assignment events.
• INSERTLEADSTATUSLOGROW — Inserts a log row capturing a lead status change, preserving a historical trail of how a lead moved between statuses.

Consistent with standard EBS API conventions, these routines rely on the FND_API, FND_MESSAGE, FND_MSG_PUB, and FND_GLOBAL packages for error handling, message retrieval, and session context (such as user and login information). The presence of FND_MSG_PUB and FND_MESSAGE indicates that failures are surfaced through the standard EBS message stack rather than raw exceptions.

Tables Accessed

Through APPS synonyms, the package references two tables:

• PV_ASSIGNMENT_LOGS — The primary assignment log table, which stores the persisted audit records of lead assignment activity.
• PV_ASSIGNMENT_LOGS_S — The sequence associated with PV_ASSIGNMENT_LOGS, used to generate unique primary key values for new log rows. This is the object that corresponds directly to the user's search term, "pv_assignment_logs_s," and explains the association between that sequence and the PV_LEADLOG_PVT package.

Additional dependencies include DUAL and STANDARD, reflecting internal PL/SQL constructs rather than business tables.

Usage Notes

PV_LEADLOG_PVT is invoked internally by the PV lead management flows — typically from forms, business logic, or other PV packages — whenever a lead is assigned or its status changes and an audit record must be written. It is not intended for direct external invocation, and because no database object references it, its callers reside within the compiled PV application code rather than through declared dependency chains. Developers extending or debugging lead assignment logging in EBS 12.1.1 or 12.2.2 should treat this package as the authoritative write path for PV_ASSIGNMENT_LOGS and PV_ASSIGNMENT_LOGS_S, and should examine its callers within the PV module to trace how assignment events are captured.