Search Results get_cont_marg




Overview
Explore in AI Chat

Overview

APPS.FII_GL_COST_CENTER_PKG2 is a PL/SQL package declared with AUTHID CURRENT_USER that supplies SQL statements to Oracle EBS HTML-based portlets on the Expenses page, part of the Financial Intelligence (FII) reporting layer. It is not a transactional or validation API; it is a presentation-support utility whose procedures assemble dynamic SQL and query attributes consumed by the Business Intelligence (BIS) PMV portlet framework. The package body translates page-level user parameters into runnable queries against the General Ledger cost center view.

The header comment dates the source at 115.8 (2003/12/26) and states plainly that the package "will provide sql statements to retrieve data for the portlets on the Expenses page." Two package-level variables, BUDGET_TIME_UNIT and FORECAST_TIME_UNIT, are declared as VARCHAR2(1) and carry time-unit context for the budget and forecast comparisons made by the portlets.

Key Procedures and Functions

The package exposes seven documented program units:

  • GET_EXP_BY_CAT — produces the SQL and BIS query attributes for the expenses-by-category portlet.
  • GET_REVEXP_CC — a function returning a VARCHAR2, used to derive revenue and expense values for a cost center; it accepts a financial type indicator to distinguish the two.
  • GET_CONT_MARG — generates the contribution margin SQL and output attributes. It carries a parameter p_opera_marg defaulting to 'N', allowing the caller to switch between contribution margin and operating margin definitions.
  • GET_OPERA_MARG — the operating margin portlet procedure. It shares the same signature shape as GET_CONT_MARG, taking page parameters and returning the SQL text plus the query attribute collection; it is invoked when operating margin, rather than contribution margin, is required.
  • GET_COGS_CC — supplies the cost-of-goods-sold query for a cost center.
  • GET_EXP_CC — supplies the expense-by-cost-center query.
  • GET_REV_CC — supplies the revenue-by-cost-center query.

Tables Accessed

No table references are documented in the ETRM metadata for this package, and no APPS synonyms are recorded. This is consistent with a package whose purpose is to emit SQL rather than execute it: the actual table access is deferred to the portlet runtime, which parses and executes the returned SQL text. In practice the generated statements target the Financial Intelligence cost center reporting view and the underlying GL balances, but no direct INSERT, UPDATE, DELETE, or SELECT against a named table is attributable to this package from the documented evidence.

Usage Notes

FII_GL_COST_CENTER_PKG2 is referenced by zero other packages, confirming that it sits at the edge of the dependency graph and is called from outside the PL/SQL stack. Its invocations originate from the FII Expenses page portlets, which pass a BIS_PMV_PAGE_PARAMETER_TBL and receive the SQL and attribute collections back for execution. Customizations should avoid modifying the package directly, as it is a seeded, non-ship object whose signature contract is consumed by the portlet framework. The AUTHID CURRENT_USER clause means privileges are evaluated as the invoking schema, so any custom caller must resolve the same underlying objects the APPS synonyms expose.