APPS.FII_EA_SUM_TREND_PKG dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 10: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, exp_sum_sql out NOCOPY VARCHAR2,

6:
7: -- get_exp_sum procedure is called by Expense Summary report. It is a wrapper for get_revexp_sum.
8:
9: PROCEDURE get_exp_sum (
10: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, exp_sum_sql out NOCOPY VARCHAR2,
11: exp_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
12:
13: sqlstmt VARCHAR2(30000);
14:

Line 27: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, rev_sum_sql out NOCOPY VARCHAR2,

23:
24: -- get_rev_sum procedure is called by Revenue Summary report. It is a wrapper for get_revexp_sum.
25:
26: PROCEDURE get_rev_sum (
27: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, rev_sum_sql out NOCOPY VARCHAR2,
28: rev_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
29:
30: sqlstmt VARCHAR2(30000);
31:

Line 46: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, rev_sum_sql out NOCOPY VARCHAR2,

42: -- get_cgs_sum procedure is called by Cost of Goods Sold Summary report.
43: -- It is a wrapper for get_revexp_sum().
44: --
45: PROCEDURE get_cgs_sum (
46: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, rev_sum_sql out NOCOPY VARCHAR2,
47: rev_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
48:
49: sqlstmt VARCHAR2(30000);
50:

Line 64: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2 IS

60:
61: -- get_revexp_sum is a common procedure, used both by Expense and Revenue Summary reports
62:
63: FUNCTION get_revexp_sum (
64: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2 IS
65:
66: sqlstmt VARCHAR2(15000);
67: p_aggrt_viewby_id VARCHAR2(30);
68: p_snap_aggrt_viewby_id VARCHAR2(30);

Line 828: PROCEDURE get_cogs_trend ( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

824: END get_revexp_sum;
825:
826: -- Added for Cost of Goods Sold Rolling Trend
827: -- Profit and Loss Analysis, DBI 7.3
828: PROCEDURE get_cogs_trend ( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
829: ,p_cogs_trend_sql OUT NOCOPY VARCHAR2
830: ,p_cogs_trend_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
831: IS
832:

Line 852: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, exp_trend_sql out NOCOPY VARCHAR2,

848:
849: -- get_exp_trend procedure is called by Expense Rolling Trend report. It is a wrapper for get_revexp_trend.
850:
851: PROCEDURE get_exp_trend (
852: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, exp_trend_sql out NOCOPY VARCHAR2,
853: exp_trend_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
854:
855: sqlstmt VARCHAR2(30000);
856:

Line 869: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, rev_trend_sql out NOCOPY VARCHAR2,

865:
866: -- get_rev_trend procedure is called by Revenue Rolling Trend report. It is a wrapper for get_revexp_trend.
867:
868: PROCEDURE get_rev_trend (
869: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, rev_trend_sql out NOCOPY VARCHAR2,
870: rev_trend_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
871:
872: sqlstmt VARCHAR2(30000);
873:

Line 886: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2 IS

882:
883: -- get_revexp_trend is a common procedure, used both by Expense and Revenue Rolling Trend reports
884:
885: FUNCTION get_revexp_trend (
886: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2 IS
887:
888: sqlstmt VARCHAR2(15000);
889: l_agrt_snap_sql VARCHAR2(15000);
890: l_agrt_sql VARCHAR2(15000);