4: ---------------------------------------------------------------------------------
5: -- the get_exp_source procedure is called by Expense Source report.
6: -- It is a wrapper for get_rev_exp_source function.
7:
8: PROCEDURE get_exp_source (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
9: p_exp_source_sql out NOCOPY VARCHAR2,
10: p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
11:
12: is
35: ---------------------------------------------------------------------------------
36: -- the get_rev_source procedure is called by Revenue Source report.
37: -- It is a wrapper for get_rev_exp_source function.
38:
39: PROCEDURE get_rev_source (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
40: p_rev_source_sql out NOCOPY VARCHAR2,
41: p_rev_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
42:
43: is
65:
66: ---------------------------------------------------------------------------------
67: -- This is the main function which constructs the PMV sql.
68:
69: FUNCTION get_rev_exp_source (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
70: p_multi_factor IN NUMBER) return VARCHAR2
71: IS
72:
73: get_rev_exp_source BIS_QUERY_ATTRIBUTES;