Search Results top_customer_tbl_type




Overview
Explore in AI Chat

Overview

CN_WEBSERVICE_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Oracle Incentive Compensation (CN) product family. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking user rather than the defining schema. Its stated purpose is webservice generation for the Commission Gadget, a front-end component used by sales representatives to view compensation-related data without navigating the full E-Business Suite forms interface. The package is registered in ETRM with the display name "Gadget Web Service," a lifecycle status of active, and a compatibility rating of S (supported), and it is categorized against the business entity CN_COMP_PLANS.

The source header (cnwebsrs.pls 120.1, dated 18-June-2009) and the presence of Multi-Org Access Control (MOAC) validation variables (l_org_id, l_status) indicate the package is designed to be operating-unit aware, allowing the same webservice endpoints to be called across different organizations while filtering results to the operating unit of the logged-in user.

Key Procedures and Functions

The package exposes five documented public procedures. Each returns data through strongly typed PL/SQL collection types declared in the package specification, notably RECENT_TRANSACTION_TBL_TYPE and TOP_CUSTOMER_TBL_TYPE.

  • RECENT_TRANS_FOR_SALESREP — Returns a table of recently processed commission transactions for a given sales representative, identifying the salesrep by login username. Each record carries the processed date, customer name, product name, transaction amount, credit, earnings, and currency symbol.
  • TOP_CUSTOMER_FOR_SALESREP — Returns the highest-performing customers for a sales representative, again keyed on login username. The output structure includes customer name, earnings, rate, credit, transaction amount, and currency symbol.
  • TOP_PRODUCT_FOR_SALESREP — Returns the top-selling or top-crediting products attributable to a sales representative, following the same username-based lookup pattern.
  • TOP_ESCALTED_TASK_SALESREP — Returns escalated task information for a sales representative, sourced from the JTF task tables, supporting the salesrep's visibility of outstanding or escalated activities.
  • TEST_WEBSERVICE — A diagnostic procedure used to validate that the webservice is correctly deployed and callable, typically invoked during setup or troubleshooting.

Parameter lists are intentionally summarized here; the specification does not publish invented parameters beyond the documented record and collection types.

Tables Accessed

The package reads and writes through APPS synonyms across four functional areas:

Usage Notes

CN_WEBSERVICE_PUB is not referenced by any other documented package; it is a leaf-level API invoked directly by external callers. Typical invocation channels include:

  • Oracle Integration / SOA Suite webservice endpoints — The procedures are exposed as SOAP or REST operations consumed by the Commission Gadget, mobile applications, or custom portals.
  • Custom PL/SQL — Developer-written programs may call the procedures directly to populate dashboards or reporting layers.
  • Diagnostic testing — TEST_WEBSERVICE is used to confirm connectivity and grants after patching or cloning.

Because the package is AUTHID CURRENT_USER, the invoking user must hold the necessary privileges on the underlying CN, HZ, JTF, and FND objects. Multi-Org filtering depends on the caller's session operating unit. The package is compatible with both EBS 12.1.1 and 12.2.2.

Note: the originating search term "ping ww.baidu.com -t" is unrelated to this EBS object and appears to be a network diagnostic command entered in error.