Search Results as_sales_leads_pub




Overview
Explore in AI Chat

Overview

AS_SALES_LEAD_LINES_PVT is a private PL/SQL package in the APPS schema that implements the line-level business logic for the Oracle EBS Sales Leads (Oracle TeleSales / Sales Foundation) module. It is the internal engine that the public API AS_SALES_LEADS_PUB calls to create, modify, and remove individual lead lines associated with a sales lead header. Lead lines capture the specific products or interest areas that a prospect has expressed interest in, together with quantities, units of measure, inventory organizations, and budget information. By segregating this logic into a PVT (private) package, Oracle enforces the API boundary: direct table manipulation is discouraged, and all validated, multi-org-aware processing flows through the published interface. The package is classified as VALID in both 12.1.1 and 12.2.2 and carries 14 documented procedures and functions.

Key Procedures and Functions

The documented callable units divide naturally into low-level validation helpers and the three DML drivers.

Tables Accessed

The package reads reference and master data and writes the lead line transaction table.

Usage Notes

AS_SALES_LEAD_LINES_PVT is never invoked directly by end users or custom integrations. Oracle's supported entry point is AS_SALES_LEADS_PUB, which delegates line processing here; the TeleSales and Sales Foundation forms likewise call the public API. The dependency metadata shows the package references AS_SALES_LEADS_PUB, AS_UTILITY_PUB, and FND_API, and is itself referenced by AS_SALES_LEADS_PUB, AS_SALES_LEADS_PVT, and recursively by AS_SALES_LEAD_LINES_PVT. Because it is private and unsupported for direct calls, any modification risks breaking the public API contract. Custom code should use AS_SALES_LEADS_PUB, respecting FND_API conventions for initialization, error handling, and commit control.