1 PACKAGE FII_EA_DPRN_EXP_PKG AS
2 /* $Header: FIIEAMAJS.pls 120.1 2005/10/30 05:12:56 appldev noship $ */
3
4 -- ----------------------------------------------------------------------
5 --
6 -- GET_DPRN_EXP_MAJ: This procedure is called from Depreciation Expense
7 -- by Major Category report. It is the main procedure
8 -- that reads the report parameter values, builds the
9 -- PMV sql and passes back to the calling PMV report.
10 --
11 -- ----------------------------------------------------------------------
12
13 PROCEDURE GET_DPRN_EXP_MAJ( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
14 get_dprn_exp_maj_sql OUT NOCOPY VARCHAR2,
15 get_dprn_exp_maj_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
16
17
18 -- ----------------------------------------------------------------------
19 --
20 -- GET_DPRN_EXP_MIN: This procedure is called from Depreciation Expense
21 -- by Minor Category report. It is the main procedure
22 -- that reads the report parameter values, builds the
23 -- PMV sql and passes back to the calling PMV report.
24 --
25 -- ----------------------------------------------------------------------
26
27 PROCEDURE GET_DPRN_EXP_MIN( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
28 get_dprn_exp_min_sql OUT NOCOPY VARCHAR2,
29 get_dprn_exp_min_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
30
31 -- ----------------------------------------------------------------------
32 --
33 -- GET_DPRN_EXP_LIST: This procedure is called from Depreciation Expense
34 -- by Asset Listing report. It is the main procedure
35 -- that reads the report parameter values, builds the
36 -- PMV sql and passes back to the calling PMV report.
37 --
38 -- ----------------------------------------------------------------------
39
40 PROCEDURE GET_DPRN_EXP_LIST( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
41 get_dprn_exp_list_sql OUT NOCOPY VARCHAR2,
42 get_dprn_exp_list_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
43 END FII_EA_DPRN_EXP_PKG;