eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_GL_COST_CENTER_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 8: exp_by_cat_sql out NOCOPY VARCHAR2, exp_by_cat_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL );

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:

Line 11: rev_cc_sql out NOCOPY VARCHAR2, rev_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);

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:

Line 14: cogs_cc_sql out NOCOPY VARCHAR2, cogs_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);

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:

Line 17: exp_cc_sql out NOCOPY VARCHAR2, exp_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);

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;

Line 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);

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,

Line 24: exp_cc_by_cat1_sql out NOCOPY VARCHAR2, exp_cc_by_cat1_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL, fin_type VARCHAR2);

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);

Line 28: exp_cc_by_cat_output out NOCOPY BIS_QUERY_ATTRIBUTES_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);

Line 32: rev_cc_by_cat_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);

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);

Line 36: cogs_cc_by_cat_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL);

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:

Line 39: cont_marg_sql out NOCOPY VARCHAR2, cont_marg_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL, p_opera_marg IN Char DEFAULT 'N');

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);

Line 43: cont_marg_sql out NOCOPY VARCHAR2, cont_marg_output out NOCOPY BIS_QUERY_ATTRIBUTES_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);

Line 47: revexp_tr_sql out NOCOPY VARCHAR2, revexp_tr_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL, l_fin_type in VARCHAR2);

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);

Line 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);

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);

Line 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);

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);

Line 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);

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 (

Line 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);

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,

Line 60: exp_ccc_mgr_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;