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_PMV_PAGE_PARAMETER_TBL

Line 7: PROCEDURE get_exp_by_cat (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL, l_fin_category IN VARCHAR2,

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

Line 10: PROCEDURE get_rev_cc (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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

Line 13: PROCEDURE get_cogs_cc (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_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);

Line 16: PROCEDURE get_exp_cc (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_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:

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 21: FUNCTION get_revexp_cc (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2;

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:

Line 23: PROCEDURE get_exp_cc_by_cat1 (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 27: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, exp_cc_by_cat_sql out NOCOPY VARCHAR2,

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,

Line 31: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, rev_cc_by_cat_sql out NOCOPY VARCHAR2,

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,

Line 35: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, cogs_cc_by_cat_sql out NOCOPY VARCHAR2,

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

Line 38: PROCEDURE get_cont_marg (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 42: PROCEDURE get_opera_marg (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,

Line 46: PROCEDURE get_revexp_tr(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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:

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 58: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_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: