APPS.FII_PL_PAGE_PKG dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 5: PROCEDURE get_pl_graph (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

1: PACKAGE fii_pl_page_pkg AS
2: /* $Header: FIIPLPGS.pls 120.2.12000000.1 2007/04/10 13:58:21 dhmehra ship $ */
3:
4:
5: PROCEDURE get_pl_graph (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
6: pl_graph_sql out NOCOPY VARCHAR2, pl_graph_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
7:
8:
9: FUNCTION get_pl_graph_val (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2;

Line 9: FUNCTION get_pl_graph_val (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2;

5: PROCEDURE get_pl_graph (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
6: pl_graph_sql out NOCOPY VARCHAR2, pl_graph_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
7:
8:
9: FUNCTION get_pl_graph_val (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2;
10:
11:
12: PROCEDURE get_rev_trend (
13: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

Line 13: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

9: FUNCTION get_pl_graph_val (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2;
10:
11:
12: PROCEDURE get_rev_trend (
13: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
14: expense_sum_sql out NOCOPY VARCHAR2,
15: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
16:
17: PROCEDURE get_exp_trend (

Line 18: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

14: expense_sum_sql out NOCOPY VARCHAR2,
15: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
16:
17: PROCEDURE get_exp_trend (
18: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
19: expense_sum_sql out NOCOPY VARCHAR2,
20: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
21:
22: PROCEDURE get_cogs_trend (

Line 23: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

19: expense_sum_sql out NOCOPY VARCHAR2,
20: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
21:
22: PROCEDURE get_cogs_trend (
23: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
24: expense_sum_sql out NOCOPY VARCHAR2,
25: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
26:
27: PROCEDURE get_mar_trend (

Line 28: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

24: expense_sum_sql out NOCOPY VARCHAR2,
25: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
26:
27: PROCEDURE get_mar_trend (
28: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
29: expense_sum_sql out NOCOPY VARCHAR2,
30: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
31:
32: PROCEDURE get_expense_sum(

Line 33: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

29: expense_sum_sql out NOCOPY VARCHAR2,
30: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
31:
32: PROCEDURE get_expense_sum(
33: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
34: expense_sum_sql out NOCOPY VARCHAR2,
35: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
36:
37: PROCEDURE get_margin_sum(

Line 38: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

34: expense_sum_sql out NOCOPY VARCHAR2,
35: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
36:
37: PROCEDURE get_margin_sum(
38: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
39: expense_sum_sql out NOCOPY VARCHAR2,
40: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
41:
42: -- Following procedure is used to form PMV SQL, which is used to retrieve data

Line 45: PROCEDURE get_gross_margin( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

41:
42: -- Following procedure is used to form PMV SQL, which is used to retrieve data
43: -- for Gross Margin Table portlet and Gross Margin Summary report
44:
45: PROCEDURE get_gross_margin( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
46: ,p_gross_margin_sql OUT NOCOPY VARCHAR2
47: ,p_gross_margin_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
48: );
49:

Line 53: PROCEDURE get_oper_margin( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

49:
50: -- Following procedure is used to form PMV SQL, which is used to retrieve data
51: -- for Operating Margin Table portlet and Operating Margin Summary report
52:
53: PROCEDURE get_oper_margin( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
54: ,p_oper_margin_sql OUT NOCOPY VARCHAR2
55: ,p_oper_margin_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
56: );
57: