DBA Data[Home] [Help]

APPS.FII_PL_PAGE_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 6: pl_graph_sql out NOCOPY VARCHAR2, pl_graph_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);

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;
10:

Line 15: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);

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 (
18: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
19: expense_sum_sql out NOCOPY VARCHAR2,

Line 20: 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 (
23: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
24: expense_sum_sql out NOCOPY VARCHAR2,

Line 25: 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 (
28: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
29: expense_sum_sql out NOCOPY VARCHAR2,

Line 30: 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(
33: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
34: expense_sum_sql out NOCOPY VARCHAR2,

Line 35: 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(
38: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
39: expense_sum_sql out NOCOPY VARCHAR2,

Line 40: 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
43: -- for Gross Margin Table portlet and Gross Margin Summary report
44:

Line 47: ,p_gross_margin_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

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:
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

Line 55: ,p_oper_margin_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

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:
58: END fii_pl_page_pkg;