PACKAGE: APPS.FII_GL_COST_CENTER_PKG2

Source

1 PACKAGE fii_gl_cost_center_pkg2 AUTHID CURRENT_USER AS
2 /* $Header: FIIGLC2S.pls 115.8 2003/12/26 22:01:48 juding noship $ */
3 --   This package will provide sql statements to retrieve data for the portlets
4 --   on the Expenses page.
5 
6 BUDGET_TIME_UNIT   VARCHAR2(1);
7 FORECAST_TIME_UNIT VARCHAR2(1);
8 
9 PROCEDURE get_exp_by_cat (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
10                          exp_by_cat_sql out NOCOPY VARCHAR2,
11                          exp_by_cat_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL );
12 FUNCTION get_revexp_cc ( p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, l_fin_type IN VARCHAR2) return VARCHAR2;
13 
14 PROCEDURE get_cont_marg (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
15 cont_marg_sql out NOCOPY VARCHAR2, cont_marg_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL, p_opera_marg IN Char DEFAULT 'N');
16 
17 PROCEDURE get_opera_marg (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,cont_marg_sql out NOCOPY VARCHAR2, cont_marg_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
18 
19 PROCEDURE get_cogs_cc (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, cgs_cc_sql out NOCOPY VARCHAR2, cgs_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
20 
21 PROCEDURE get_exp_cc (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, exp_cc_sql out NOCOPY VARCHAR2, exp_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
22 
23 PROCEDURE get_rev_cc (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, rev_cc_sql out NOCOPY VARCHAR2, rev_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
24 
25 
26 
27 END fii_gl_cost_center_pkg2;