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 22: PROCEDURE get_exp_by_cat (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

18: END IF;
19:
20: END is_mgr_topnode;
21:
22: PROCEDURE get_exp_by_cat (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
23: l_fin_category IN VARCHAR2,
24: exp_by_cat_sql out NOCOPY VARCHAR2,
25: exp_by_cat_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
26: IS

Line 98: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, te_cc_sql out NOCOPY VARCHAR2,

94:
95: END get_exp_by_cat;
96:
97: PROCEDURE get_te_cc (
98: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, te_cc_sql out NOCOPY VARCHAR2,
99: te_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
100:
101: sqlstmt VARCHAR2(32000);
102: BEGIN

Line 111: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, cogs_cc_sql out NOCOPY VARCHAR2,

107: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, te_cc_sql, te_cc_output);
108: END get_te_cc;
109:
110: PROCEDURE get_cogs_cc (
111: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, cogs_cc_sql out NOCOPY VARCHAR2,
112: cogs_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
113:
114: sqlstmt VARCHAR2(32000);
115: BEGIN

Line 124: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, exp_cc_sql out NOCOPY VARCHAR2,

120: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, cogs_cc_sql, cogs_cc_output);
121: END get_cogs_cc;
122:
123: PROCEDURE get_exp_cc (
124: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, exp_cc_sql out NOCOPY VARCHAR2,
125: exp_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
126: sqlstmt VARCHAR2(32000);
127: BEGIN
128: fii_gl_util_pkg.reset_globals;

Line 136: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, rev_cc_sql out NOCOPY VARCHAR2,

132: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, exp_cc_sql, exp_cc_output);
133: END get_exp_cc;
134:
135: PROCEDURE get_rev_cc (
136: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, rev_cc_sql out NOCOPY VARCHAR2,
137: rev_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
138: sqlstmt VARCHAR2(32000);
139: BEGIN
140: fii_gl_util_pkg.reset_globals;

Line 149: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2 IS

145:
146: END get_rev_cc;
147:
148: FUNCTION get_revexp_cc (
149: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2 IS
150:
151: sqlstmt VARCHAR2(32000);
152: l_prior_or_budget VARCHAR2(3000) := NULL;
153: gt_cy_act VARCHAR2(20);

Line 389: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, exp_ccc_mgr_sql out NOCOPY VARCHAR2,

385: END get_revexp_cc;
386:
387:
388: PROCEDURE get_exp_ccc_mgr (
389: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, exp_ccc_mgr_sql out NOCOPY VARCHAR2,
390: exp_ccc_mgr_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
391:
392: sqlstmt VARCHAR2(32000);
393: l_prior_or_budget VARCHAR2(3000) := NULL;

Line 509: PROCEDURE get_exp_cc_by_cat1 (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

505:
506:
507:
508:
509: PROCEDURE get_exp_cc_by_cat1 (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
510: exp_cc_by_cat1_sql out NOCOPY VARCHAR2, exp_cc_by_cat1_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL, fin_type VARCHAR2)
511: IS
512:
513: exp_cc_by_cat1_rec BIS_QUERY_ATTRIBUTES;

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

627: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, exp_cc_by_cat1_sql, exp_cc_by_cat1_output);
628:
629: END get_exp_cc_by_cat1;
630: PROCEDURE get_rev_cc_by_cat (
631: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, rev_cc_by_cat_sql out NOCOPY VARCHAR2,
632: rev_cc_by_cat_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
633: l_fin_type VARCHAR2(1);
634: BEGIN
635: fii_gl_util_pkg.reset_globals;

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

639:
640: END get_rev_cc_by_cat;
641:
642: PROCEDURE get_exp_cc_by_cat (
643: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, exp_cc_by_cat_sql out NOCOPY VARCHAR2,
644: exp_cc_by_cat_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
645: l_fin_type VARCHAR2(2);
646: BEGIN
647: fii_gl_util_pkg.reset_globals;

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

651:
652: END get_exp_cc_by_cat;
653:
654: PROCEDURE get_cogs_cc_by_cat (
655: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, cogs_cc_by_cat_sql out NOCOPY VARCHAR2,
656: cogs_cc_by_cat_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
657: l_fin_type VARCHAR2(3);
658: BEGIN
659: fii_gl_util_pkg.reset_globals;

Line 668: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

664: END get_cogs_cc_by_cat;
665:
666:
667: PROCEDURE get_revexp_tr(
668: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
669: revexp_tr_sql out NOCOPY VARCHAR2, revexp_tr_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL, l_fin_type in VARCHAR2) IS
670:
671: revexp_tr_rec BIS_QUERY_ATTRIBUTES;
672: sqlstmt VARCHAR2(32000);

Line 786: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, rev_tr_sql out NOCOPY VARCHAR2,

782:
783: END get_revexp_tr;
784:
785: PROCEDURE get_rev_tr (
786: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, rev_tr_sql out NOCOPY VARCHAR2,
787: rev_tr_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
788: l_fin_type VARCHAR2(1);
789: BEGIN
790: l_fin_type := 'R';

Line 797: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, cogs_tr_sql out NOCOPY VARCHAR2,

793:
794: END get_rev_tr;
795:
796: PROCEDURE get_cogs_tr (
797: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, cogs_tr_sql out NOCOPY VARCHAR2,
798: cogs_tr_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
799: l_fin_type VARCHAR2(3);
800: BEGIN
801: l_fin_type := 'CGS';

Line 808: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, exp_tr_sql out NOCOPY VARCHAR2,

804:
805: END get_cogs_tr;
806:
807: PROCEDURE get_exp_tr (
808: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, exp_tr_sql out NOCOPY VARCHAR2,
809: exp_tr_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
810: l_fin_type VARCHAR2(2);
811: BEGIN
812: l_fin_type := 'OE';

Line 817: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, te_tr_sql out NOCOPY VARCHAR2,

813: fii_gl_cost_center_pkg.get_revexp_tr(p_page_parameter_tbl, exp_tr_sql, exp_tr_output, l_fin_type );
814: END get_exp_tr;
815:
816: PROCEDURE get_te_tr (
817: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, te_tr_sql out NOCOPY VARCHAR2,
818: te_tr_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
819: l_fin_type VARCHAR2(2);
820: BEGIN
821: l_fin_type := 'TE';

Line 827: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

823:
824: END get_te_tr;
825:
826: PROCEDURE get_cont_marg(
827: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
828: cont_marg_sql out NOCOPY VARCHAR2, cont_marg_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL, p_opera_marg IN Char DEFAULT 'N') IS
829:
830: cont_marg_rec BIS_QUERY_ATTRIBUTES;
831: sqlstmt VARCHAR2(32000);

Line 1082: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

1078: END get_cont_marg;
1079:
1080: --* Procedure added by Ilavenil. This procedure is called by OPERATING MARGIN.
1081: PROCEDURE get_opera_marg(
1082: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
1083: cont_marg_sql out NOCOPY VARCHAR2, cont_marg_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
1084: Begin
1085: get_cont_marg(p_page_parameter_tbl, cont_marg_sql, cont_marg_output, 'Y');
1086: End;