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_PL_PAGE_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 6: pl_graph_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

2: /* $Header: FIIPLPGB.pls 120.5.12000000.2 2007/04/16 06:42:17 dhmehra ship $ */
3:
4: PROCEDURE get_pl_graph (
5: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, pl_graph_sql out NOCOPY VARCHAR2,
6: pl_graph_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
7:
8: sqlstmt VARCHAR2(30000);
9:
10:

Line 124: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

120:
121: PROCEDURE get_rev_trend (
122: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
123: expense_sum_sql out NOCOPY VARCHAR2,
124: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
125:
126: BEGIN
127: fii_ea_util_pkg.reset_globals;
128: fii_ea_util_pkg.g_fin_type := 'R';

Line 138: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

134:
135: PROCEDURE get_exp_trend (
136: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
137: expense_sum_sql out NOCOPY VARCHAR2,
138: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
139:
140: BEGIN
141: fii_ea_util_pkg.reset_globals;
142: fii_ea_util_pkg.g_fin_type := 'OE';

Line 152: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

148:
149: PROCEDURE get_cogs_trend (
150: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
151: expense_sum_sql out NOCOPY VARCHAR2,
152: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
153:
154: BEGIN
155: fii_ea_util_pkg.reset_globals;
156: fii_ea_util_pkg.g_fin_type := 'CGS';

Line 166: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

162:
163: PROCEDURE get_mar_trend (
164: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
165: expense_sum_sql out NOCOPY VARCHAR2,
166: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
167:
168: BEGIN
169: fii_ea_util_pkg.reset_globals;
170:

Line 177: expense_sum_sql out NOCOPY VARCHAR2, expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

173: expense_sum_output);
174: END get_mar_trend;
175:
176: PROCEDURE get_expense_sum (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
177: expense_sum_sql out NOCOPY VARCHAR2, expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
178: IS
179: sqlstmt VARCHAR2(32000);
180: l_pk VARCHAR2(30);
181: l_name VARCHAR2(100);

Line 497: expense_sum_sql out NOCOPY VARCHAR2, expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

493: END get_expense_sum;
494:
495:
496: PROCEDURE get_margin_sum (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
497: expense_sum_sql out NOCOPY VARCHAR2, expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
498: IS
499: sqlstmt VARCHAR2(32000);
500: l_pk VARCHAR2(30);
501: l_name VARCHAR2(100);

Line 862: ,p_gross_margin_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

858: -- for Gross Margin Table portlet and Gross Margin Summary report
859:
860: PROCEDURE get_gross_margin( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
861: ,p_gross_margin_sql OUT NOCOPY VARCHAR2
862: ,p_gross_margin_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
863: )
864:
865: IS
866: l_sqlstmt VARCHAR2(32767);

Line 1874: ,p_oper_margin_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

1870: -- for Operating Margin Table portlet and Operating Margin Summary report
1871:
1872: PROCEDURE get_oper_margin( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
1873: ,p_oper_margin_sql OUT NOCOPY VARCHAR2
1874: ,p_oper_margin_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
1875: )
1876:
1877: IS
1878: l_sqlstmt VARCHAR2(30000);