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

Line 25: exp_by_cat_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

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
27:
28: exp_by_cat_rec BIS_QUERY_ATTRIBUTES;
29: sqlstmt VARCHAR2(32000);

Line 28: exp_by_cat_rec BIS_QUERY_ATTRIBUTES;

24: exp_by_cat_sql out NOCOPY VARCHAR2,
25: exp_by_cat_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
26: IS
27:
28: exp_by_cat_rec BIS_QUERY_ATTRIBUTES;
29: sqlstmt VARCHAR2(32000);
30: l_mgr_viewby_value VARCHAR2(30);
31: l_cat_viewby_value VARCHAR2(30);
32: l_mgr_viewby_id VARCHAR2(30);

Line 99: te_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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
103: fii_gl_util_pkg.reset_globals;

Line 112: cogs_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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
116: fii_gl_util_pkg.reset_globals;

Line 125: exp_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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;
129: fii_gl_util_pkg.g_fin_type := 'OE';

Line 137: rev_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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;
141: fii_gl_util_pkg.g_fin_type := 'R';

Line 390: exp_ccc_mgr_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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;
394:

Line 510: exp_cc_by_cat1_sql out NOCOPY VARCHAR2, exp_cc_by_cat1_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL, fin_type VARCHAR2)

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;
514: sqlstmt VARCHAR2(32000);

Line 513: exp_cc_by_cat1_rec BIS_QUERY_ATTRIBUTES;

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;
514: sqlstmt VARCHAR2(32000);
515: l_time_parameter VARCHAR2(100);
516: l_bitmask NUMBER;
517: l_cat_detail_url VARCHAR2(300);

Line 632: rev_cc_by_cat_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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;
636: l_fin_type := 'R';

Line 644: exp_cc_by_cat_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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;
648: l_fin_type := 'OE';

Line 656: cogs_cc_by_cat_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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;
660: l_fin_type := 'CGS';

Line 669: revexp_tr_sql out NOCOPY VARCHAR2, revexp_tr_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL, l_fin_type in VARCHAR2) IS

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);
673: l_hint1 VARCHAR2(200) := NULL;

Line 671: revexp_tr_rec BIS_QUERY_ATTRIBUTES;

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);
673: l_hint1 VARCHAR2(200) := NULL;
674: l_hint2 VARCHAR2(200) := NULL;
675: l_join1 VARCHAR2(100):= NULL;

Line 787: rev_tr_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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';
791: fii_gl_cost_center_pkg.get_revexp_tr(p_page_parameter_tbl, rev_tr_sql, rev_tr_output, l_fin_type );

Line 798: cogs_tr_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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';
802: fii_gl_cost_center_pkg.get_revexp_tr(p_page_parameter_tbl, cogs_tr_sql, cogs_tr_output, l_fin_type );

Line 809: exp_tr_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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';
813: fii_gl_cost_center_pkg.get_revexp_tr(p_page_parameter_tbl, exp_tr_sql, exp_tr_output, l_fin_type );

Line 818: te_tr_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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';
822: fii_gl_cost_center_pkg.get_revexp_tr(p_page_parameter_tbl, te_tr_sql, te_tr_output, l_fin_type );

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

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);
832: sqlstmt1 VARCHAR2(5000);

Line 830: cont_marg_rec BIS_QUERY_ATTRIBUTES;

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);
832: sqlstmt1 VARCHAR2(5000);
833: cy_act_exp_select VARCHAR2(100) := NULL;
834: l_prior VARCHAR2(20) := NULL;

Line 1083: cont_marg_sql out NOCOPY VARCHAR2, cont_marg_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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;
1087: