DBA Data[Home] [Help]

PACKAGE: APPS.FII_EA_DPRN_EXP_PKG

Source


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;