1 PACKAGE FII_EA_SOURCE_PKG AS
2 /* $Header: FIIEASOURCES.pls 120.1 2005/10/30 05:12:54 appldev noship $ */
3
4 -- the get_exp_source procedure is called by Expense Source report.
5 -- It is a wrapper for get_rev_exp_source function.
6 PROCEDURE get_exp_source (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
7 p_exp_source_sql out NOCOPY VARCHAR2,
8 p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
9
10 -- the get_rev_source procedure is called by Revenue Source report.
11 -- It is a wrapper for get_rev_exp_source function.
12 PROCEDURE get_rev_source (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
13 p_rev_source_sql out NOCOPY VARCHAR2,
14 p_rev_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
15
16 -- This is the main function which constructs the PMV sql.
17 FUNCTION get_rev_exp_source (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
18 p_multi_factor IN NUMBER) return VARCHAR2;
19
20
21 END FII_EA_SOURCE_PKG;