Search Results print_parameter

Overview

IBE_LEAD_IMPORT_PVT is a private PL/SQL package in the APPS schema that supports the Oracle E-Business Suite iStore and Sales Lead import process. Its purpose is to ingest externally sourced sales-lead data—whether originating as quotes (created in Oracle Advanced Pricing / Quoting from ASO tables) or as orders—and transform that data into usable sales-lead records. The package parses inbound import files, extracts header and line detail, creates corresponding leads, associated notes, sales teams, and account records, and records progress in a log for audit and error tracking. The package name is private ("_PVT"), meaning it is an internal implementation unit rather than a public API; external callers should invoke the associated public wrapper or the concurrent program that drives it. The package header declares several REF CURSOR and record types (G_Leads_Rec, G_Lead_Line_Rec, G_Lead_Line_Tbl) that model lead headers and lead lines, and two constants distinguishing lead modes ('ORDER' and 'QUOTE') and import modes ('COMPLETE' and 'INCREMENTAL'). These declarations reflect the package's core design: a single engine that branches on the lead type and import scope supplied at runtime.

Key Procedures and Functions

The documented API contains 22 procedures and functions grouped by function:

• Logging: WRITE_LOG, UPDATE_LOG, and INSERT_LOG_DETAILS maintain the import log, recording status, lead type, and run timestamps, and adding detail rows per processed record.
• Parsing: PARSEINPUT reads and interprets the incoming import interface records, producing the internal record structures used downstream.
• Record retrieval: GET_QUOTES_RECORDS, GET_QUOTE_LINE_RECORDS, GET_ORDER_RECORDS, and GET_ORDER_LINE_RECORDS extract quote and order headers and line detail from the interface tables. GET_DATE_PERIOD derives the effective date range for processing.
• Lead creation: CREATE_ORDER_LEADS and CREATE_QUOTE_LEADS build lead records by type; CREATE_SALES_LEAD constructs the base lead, CREATE_LEADANDNOTES adds descriptive notes, RANK_SALES_LEAD assigns ranking, and CREATE_SALES_TEAM with BUILD_SALES_TEAM assemble the sales team members.
• Orchestration: IMPORT_QUOTE_LEAD and IMPORT_ORDER_LEAD drive the full pipeline for each lead type, while PROCESS_SALES_LEAD_IMPORT acts as the top-level entry point.
• Utility: PRINT_PARAMETER outputs parameter values, typically for debugging or diagnostic logging. This is the object whose name matches the user search term "print_parameter"; it is not a standalone program but a diagnostic helper within the import pipeline.

Tables Accessed

The package references standard EBS synonyms. Source and transactional tables include ASO_QUOTE_HEADERS_ALL and ASO_QUOTE_LINES_ALL (quote header/line data), OE_ORDER_HEADERS (order header data), AMS_SOURCE_CODES (promotion codes), and the HZ tables HZ_PARTIES, HZ_PARTY_SITES, HZ_CONTACT_POINTS, and HZ_ORG_CONTACTS (party, site, and contact information used to build lead organizations and contacts). Import staging is handled through AS_IMPORT_INTERFACE, AS_IMPORT_INTERFACE_S, AS_IMP_LINES_INTERFACE, and AS_IMP_LINES_INTERFACE_S. Persistent results and audit trail are stored in IBE_LEAD_IMPORT_DETAILS, IBE_LEAD_IMPORT_DETAILS_S1, and IBE_LEAD_IMPORT_LOG. Two other packages reference IBE_LEAD_IMPORT_PVT, confirming it is a shared internal utility.

Usage Notes

Because IBE_LEAD_IMPORT_PVT is a private package, it is normally invoked indirectly through the iStore lead import concurrent request or the public API that wraps it, not called directly from forms or custom code. Customizations should avoid direct calls and instead use the supported public interface to preserve upgrade safety. The constant values G_ORDER_LEAD, G_QUOTE_LEAD, G_COMPLETE_IMPORT, and G_INCREMENTAL_IMPORT indicate the package supports full and incremental import runs. The presence of PRINT_PARAMETER and the log procedures suggests runtime diagnostics are available for troubleshooting import failures; these output parameter values for diagnostic review rather than driving business logic.