APPS.FII_EA_SUM_TREND_PKG dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 7: PROCEDURE get_exp_sum (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

3:
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);

Line 10: PROCEDURE get_rev_sum (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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

Line 13: PROCEDURE get_cgs_sum (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_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:
16: FUNCTION get_revexp_sum (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2;
17:

Line 16: FUNCTION get_revexp_sum (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2;

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,
19: exp_trend_sql out NOCOPY VARCHAR2, exp_trend_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
20:

Line 18: PROCEDURE get_exp_trend (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,
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);

Line 21: PROCEDURE get_rev_trend (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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

Line 24: PROCEDURE get_cogs_trend (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_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:
27: FUNCTION get_revexp_trend (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2;
28:

Line 27: FUNCTION get_revexp_trend (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2;

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:
30: END fii_ea_sum_trend_pkg;