3:
4:
5: PROCEDURE get_te_sum (
6: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, expense_sum_sql out NOCOPY VARCHAR2,
7: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
8:
9: BEGIN
10: fii_gl_util_pkg.reset_globals;
11: fii_gl_util_pkg.g_fin_type := 'TE';
14: END get_te_sum;
15:
16: PROCEDURE get_exp_sum (
17: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, expense_sum_sql out NOCOPY VARCHAR2,
18: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
19:
20: BEGIN
21: fii_gl_util_pkg.reset_globals;
22: fii_gl_util_pkg.g_fin_type := 'OE';
24: fii_gl_exp_trend.get_expense_sum(p_page_parameter_tbl, expense_sum_sql, expense_sum_output);
25: END get_exp_sum;
26:
27: PROCEDURE get_expense_sum (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
28: expense_sum_sql out NOCOPY VARCHAR2, expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
29: IS
30: sqlstmt VARCHAR2(32000);
31: l_pk VARCHAR2(30);
32: l_name VARCHAR2(100);