DBA Data[Home] [Help]

APPS.FII_EA_SUM_TREND_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 8: exp_sum_sql out NOCOPY VARCHAR2, exp_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);

4: -- This package will provide sql statements to retrieve data for Expense Summary, Revenue Summary,
5: -- Expense Rolling Trend and Revenue Rolling Trend reports
6:
7: PROCEDURE get_exp_sum (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
8: exp_sum_sql out NOCOPY VARCHAR2, exp_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
9:
10: PROCEDURE get_rev_sum (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
11: rev_sum_sql out NOCOPY VARCHAR2, rev_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
12:

Line 11: rev_sum_sql out NOCOPY VARCHAR2, rev_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);

7: PROCEDURE get_exp_sum (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
8: exp_sum_sql out NOCOPY VARCHAR2, exp_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
9:
10: PROCEDURE get_rev_sum (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
11: rev_sum_sql out NOCOPY VARCHAR2, rev_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
12:
13: PROCEDURE get_cgs_sum (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
14: rev_sum_sql out NOCOPY VARCHAR2, rev_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
15:

Line 14: rev_sum_sql out NOCOPY VARCHAR2, rev_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);

10: PROCEDURE get_rev_sum (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
11: rev_sum_sql out NOCOPY VARCHAR2, rev_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
12:
13: PROCEDURE get_cgs_sum (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
14: rev_sum_sql out NOCOPY VARCHAR2, rev_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
15:
16: FUNCTION get_revexp_sum (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2;
17:
18: PROCEDURE get_exp_trend (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

Line 19: exp_trend_sql out NOCOPY VARCHAR2, exp_trend_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);

15:
16: FUNCTION get_revexp_sum (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2;
17:
18: PROCEDURE get_exp_trend (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
19: exp_trend_sql out NOCOPY VARCHAR2, exp_trend_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
20:
21: PROCEDURE get_rev_trend (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
22: rev_trend_sql out NOCOPY VARCHAR2, rev_trend_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
23:

Line 22: rev_trend_sql out NOCOPY VARCHAR2, rev_trend_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);

18: PROCEDURE get_exp_trend (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
19: exp_trend_sql out NOCOPY VARCHAR2, exp_trend_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
20:
21: PROCEDURE get_rev_trend (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
22: rev_trend_sql out NOCOPY VARCHAR2, rev_trend_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
23:
24: PROCEDURE get_cogs_trend (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
25: p_cogs_trend_sql out NOCOPY VARCHAR2, p_cogs_trend_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
26:

Line 25: p_cogs_trend_sql out NOCOPY VARCHAR2, p_cogs_trend_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);

21: PROCEDURE get_rev_trend (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
22: rev_trend_sql out NOCOPY VARCHAR2, rev_trend_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
23:
24: PROCEDURE get_cogs_trend (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
25: p_cogs_trend_sql out NOCOPY VARCHAR2, p_cogs_trend_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
26:
27: FUNCTION get_revexp_trend (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2;
28:
29: