PACKAGE: APPS.FII_GL_COST_CENTER_PKG

Source

1 PACKAGE fii_gl_cost_center_pkg AUTHID CURRENT_USER AS
2 /* $Header: FIIGLC1S.pls 115.20 2004/07/08 07:39:00 hpoddar noship $ */
3 
4 --   This package will provide sql statements to retrieve data for the portlets
5 --   on the Expenses page.
6 
7 PROCEDURE get_exp_by_cat (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL, l_fin_category IN VARCHAR2,
8 exp_by_cat_sql out NOCOPY VARCHAR2, exp_by_cat_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL );
9 
10 PROCEDURE get_rev_cc (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
11 rev_cc_sql out NOCOPY VARCHAR2, rev_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
12 
13 PROCEDURE get_cogs_cc (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
14 cogs_cc_sql out NOCOPY VARCHAR2, cogs_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
15 
16 PROCEDURE get_exp_cc (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
17 exp_cc_sql out NOCOPY VARCHAR2, exp_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
18 
19 PROCEDURE get_te_cc (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, te_cc_sql out NOCOPY VARCHAR2, te_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
20 
21 FUNCTION get_revexp_cc (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2;
22 
23 PROCEDURE get_exp_cc_by_cat1 (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
24 exp_cc_by_cat1_sql out NOCOPY VARCHAR2, exp_cc_by_cat1_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL, fin_type VARCHAR2);
25 
26 PROCEDURE get_exp_cc_by_cat (
27   p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, exp_cc_by_cat_sql out NOCOPY VARCHAR2,
28   exp_cc_by_cat_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
29 
30 PROCEDURE get_rev_cc_by_cat (
31   p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, rev_cc_by_cat_sql out NOCOPY VARCHAR2,
32   rev_cc_by_cat_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
33 
34 PROCEDURE get_cogs_cc_by_cat (
35   p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, cogs_cc_by_cat_sql out NOCOPY VARCHAR2,
36   cogs_cc_by_cat_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
37 
38 PROCEDURE get_cont_marg (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
39 cont_marg_sql out NOCOPY VARCHAR2, cont_marg_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL, p_opera_marg IN Char DEFAULT 'N');
40 
41 /* procedure added by ilavenil */
42 PROCEDURE get_opera_marg (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
43 cont_marg_sql out NOCOPY VARCHAR2, cont_marg_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
44 
45 
46 PROCEDURE get_revexp_tr(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
47 revexp_tr_sql out NOCOPY VARCHAR2, revexp_tr_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL, l_fin_type in VARCHAR2);
48 
49 PROCEDURE get_rev_tr (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, rev_tr_sql out NOCOPY VARCHAR2,rev_tr_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
50 
51 PROCEDURE get_exp_tr (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, exp_tr_sql out NOCOPY VARCHAR2,exp_tr_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
52 
53 PROCEDURE get_cogs_tr (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, cogs_tr_sql out NOCOPY VARCHAR2,cogs_tr_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
54 
55 PROCEDURE get_te_tr (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, te_tr_sql out NOCOPY VARCHAR2,te_tr_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
56 
57 PROCEDURE get_exp_ccc_mgr (
58   p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
59 	exp_ccc_mgr_sql out NOCOPY VARCHAR2,
60   exp_ccc_mgr_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
61 
62 
63 END fii_gl_cost_center_pkg;