1 PACKAGE FII_PSI_BUD_ENC_DETAIL_PKG AS
2 /* $Header: FIIPSIBEDTLS.pls 120.1 2005/10/30 05:06:13 appldev noship $ */
3
4 -- the get_bud_trend_dtl procedure is called by Budget Trend by Account Detail
5 -- It is a wrapper for get_bud_enc_trend_dtl.
6 PROCEDURE get_bud_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_enc_trend_dtl procedure is called by Encumbrance Trend by Account Detail
11 -- It is a wrapper for get_rev_exp_trend_dtl.
12 PROCEDURE get_enc_trend_dtl (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
13 p_rev_trend_dtl_sql out NOCOPY VARCHAR2,
14 p_rev_trend_dtl_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
15
16 -- This is the main function which constructs the PMV sql.
17 FUNCTION get_bud_enc_trend_dtl ( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
18 p_fin_cat IN VARCHAR2,
19 p_trend_type IN VARCHAR2) RETURN VARCHAR2;
20
21
22
23 END FII_PSI_BUD_ENC_DETAIL_PKG;
24