1 PACKAGE FII_EA_ACCT_DETAIL_PKG AS
2 /* $Header: FIIEAACCDTLS.pls 120.3 2006/07/19 11:27:58 sajgeo noship $ */
3
4 -- the get_exp_trend_dtl procedure is called by Cost Of Goods Sold Trend by Account Detail report.
5 -- It is a wrapper for get_rev_exp_trend_dtl.
6 PROCEDURE get_cgs_trend_dtl (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
7 p_exp_trend_dtl_sql out NOCOPY VARCHAR2,
8 p_exp_trend_dtl_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
9
10 -- the get_exp_trend_dtl procedure is called by Expense Trend by Account Detail report.
11 -- It is a wrapper for get_rev_exp_trend_dtl.
12 PROCEDURE get_exp_trend_dtl (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
13 p_exp_trend_dtl_sql out NOCOPY VARCHAR2,
14 p_exp_trend_dtl_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
15
16 -- the get_rev_trend_dtl procedure is called by Revenue Trend by Account Detai report.
17 -- It is a wrapper for get_rev_exp_trend_dtl.
18 PROCEDURE get_rev_trend_dtl (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
19 p_rev_trend_dtl_sql out NOCOPY VARCHAR2,
20 p_rev_trend_dtl_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
21
22 -- This is the main function which constructs the PMV sql.
23 FUNCTION get_rev_exp_trend_dtl (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
24 p_fin_cat IN VARCHAR2) RETURN VARCHAR2;
25
26
27
28 END FII_EA_ACCT_DETAIL_PKG;
29