Search Results sales_lead_lines_handler

Overview

AS_SALES_LEAD_ASSIGN_PVT is a private PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that implements the core assignment logic for Oracle Sales (AS) sales leads. It operates as the engine behind the public sales lead assignment API, resolving which sales resources, sales teams, and territories should own a given lead and persisting the resulting assignment records. The package is declared with AUTHID CURRENT_USER, a convention typical of private (PVT) API layers that are invoked by a public wrapper rather than directly by external consumers.

The header history indicates the package originated in April 2001 and has been extended across multiple releases, notably Release 11.5.8 and 11.5.9, to support real-time assignment, sales lead sales teams, owner decline processing, and channel-based lead triggers. Although classified as a private package, ETRM lists nine documented procedures and functions, and it is referenced by five other packages, confirming its role as a shared internal component of the Sales Lead assignment architecture.

Key Procedures and Functions

• ASSIGN_SALES_LEAD — The principal entry point. It performs the full lead assignment workflow, evaluating assignment criteria and returning status, message count, message data, and assignment identifier information to the caller.
• CALL_WF_TO_ASSIGN — Invokes the Oracle Workflow engine to carry out lead assignment asynchronously. This is the object most commonly searched for in the context of deferred or background assignment processing.
• BUILD_LEAD_SALES_TEAM — Constructs the sales team associated with a lead, including the sales group identifier for the current user, based on the enhancement introduced for sales lead sales teams.
• REBUILD_LEAD_SALES_TEAM — Regenerates an existing lead sales team when assignment inputs change, applying the same current-user sales group logic as the initial build.
• SALES_LEADS_TRIGGER_HANDLER — Handles trigger logic for the sales leads entity, including the channel code added for bug 2921105.
• SALES_LEAD_LINES_HANDLER — Manages processing of sales lead line records in conjunction with assignment.
• SET_DEFAULT_LEAD_OWNER — Establishes the default owner for a lead when no explicit assignment outcome applies.
• FIND_LEAD_OWNER — Resolves and returns the owner of a lead based on the applicable assignment and access rules.
• PROCESS_ACCESS_RECORD — Evaluates and processes access records that govern which resources may be assigned or may access the lead.

Tables Accessed

• AS_SALES_LEADS, AS_SALES_LEADS_LOG, AS_SALES_LEAD_RANKS_B — Lead headers, audit log, and rank definitions driving assignment priority.
• AS_ACCESSES_S, AS_TERRITORY_ACCESSES — Access and territory rules used to determine eligible owners.
• AS_CHANGED_ACCOUNTS_ALL, AS_STATUSES_B — Account change tracking and lead status lookup.
• HZ_PARTIES, HZ_PARTY_SITES, HZ_LOCATIONS, HZ_CONTACT_POINTS, HZ_ORGANIZATION_PROFILES — Trading community data resolving the customer and its contact, address, and organizational context.
• JTF_RS_GROUPS_B, JTF_QUAL_USGS_ALL — Resource group definitions and qualification usage data supporting team and resource selection.
• FND_CONCURRENT_REQUESTS_S — Concurrent request context, consistent with asynchronous invocation via Workflow or concurrent processing.

Usage Notes

Because AS_SALES_LEAD_ASSIGN_PVT is a PVT-classified package, it is not intended for direct invocation by customers. Assignment is ordinarily initiated from the Oracle Sales forms, from concurrent programs that bulk-assign leads, or through Oracle Workflow when the CALL_WF_TO_ASSIGN procedure defers processing. The package's dependencies on JTF resource groups, HZ trading community tables, and FND concurrent request data indicate that it runs within the standard APPS runtime context with FND_API messaging conventions. Customizations that require lead assignment behavior should reference the supported public API layer rather than calling this private package directly, since its signature and internal logic are subject to change across releases.