Search Results prosp_ident

Overview

APPS.PFT_PROFCAL_PROSP_IDENT_PUB is a public PL/SQL API package body belonging to the Profitability Manager (PFT) module of Oracle E-Business Suite. Its documented API classification is "PUB," indicating that it exposes callable entry points intended to be invoked by other application components, concurrent programs, or custom extensions rather than being restricted to internal use. The package name, combining "PROFCAL" (profit calculation) and "PROSP_IDENT" (prospect identification), identifies its business role: supporting the identification and profiling of prospective customers within the customer profitability calculation process. It handles the loading, matching, and enrichment of prospect data so that profitability analysis can be extended beyond existing customers to identified prospects and candidates.

The body defines a standard set of private constants and variables that characterize its internal behavior. Among these are the object version number (g_object_version_number set to 1), execution status codes (g_exec_status_error_rerun and g_exec_status_success), SQL statement type markers (g_insert and g_update), and target output table names (FEM_CUSTOMER_PROFIT and FEM_CUSTOMERS_ATTR) registered with the FEM_PL_PKG API. Logging severity levels are bound to FND_LOG constants, and a default fetch limit of 99999 governs bulk processing. Private exception state variables support error capture and callstack reporting.

Key Procedures and Functions

• PROCESS_SINGLE_RULE — The single documented public procedure of this package. It processes one prospect identification rule at a time, driving the logic that matches or derives prospect records for subsequent profitability calculation. As the only exposed entry point, it serves as the primary invocation surface for callers that iterate rules individually.

No parameter lists are documented for PROCESS_SINGLE_RULE; the procedure's exact signature should be confirmed against the package specification in the target environment before custom invocation.

Tables Accessed

• FEM_DIMENSIONS_B — The base table for Profitability Manager dimension definitions, used to resolve dimensions relevant to prospect identification rules.
• FEM_GLOBAL_VS_COMBO_DEFS — Stores global and combination value set definitions, referenced when interpreting or validating dimension combinations that drive prospect matching.
• FEM_MP_PROCESS_CTL_T — The multi-period process control table, used to track and manage the state of the profitability processing run associated with these rules.
• PLITBLM — A PL/SQL index-by table (array) used for bulk fetch and in-memory processing, supporting the package's set-based handling of prospect rows.

These are accessed through APPS synonyms, so the underlying physical objects reside in the FEM (Enterprise Performance Foundation / Profitability) schema.

Usage Notes

PFT_PROFCAL_PROSP_IDENT_PUB is not referenced by any other documented package, which means it is typically invoked higher up the call stack — commonly from Profitability Manager concurrent programs or from the FEM_PL_PKG rule execution framework that iterates over prospect identification rules. It may also be called from custom PL/SQL when extensions need to process prospect identification rules programmatically. The header comment indicates a 2006-era file (PFTPIDNTB.pls, version 120.1), so behavior is stable across 12.1.1 and 12.2.2 unless patched. Because the package writes to FEM_CUSTOMER_PROFIT and FEM_CUSTOMERS_ATTR output structures via the FEM_PL_PKG register_table API, callers should invoke it within a controlled processing context that manages transactions and monitors execution status (SUCCESS versus ERROR_RERUN) returned by the rule engine.