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.POA_DBI_APL_PKG dependencies on POA_DBI_SUTIL_PKG

Line 48: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);

44: begin
45: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
46: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
47:
48: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
49: if(l_sec_context = 'OU' or l_sec_context = 'OU/COM') then
50: poa_dbi_sutil_pkg.process_parameters(
51: p_param => p_param,
52: p_view_by => l_view_by,

Line 50: poa_dbi_sutil_pkg.process_parameters(

46: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
47:
48: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
49: if(l_sec_context = 'OU' or l_sec_context = 'OU/COM') then
50: poa_dbi_sutil_pkg.process_parameters(
51: p_param => p_param,
52: p_view_by => l_view_by,
53: p_view_by_col_name => l_view_by_col,
54: p_view_by_value => l_view_by_value,

Line 93: poa_dbi_sutil_pkg.process_parameters(

89: p_use_grpid => 'N',
90: p_filter_where => get_status_filter_where,
91: p_in_join_tables => l_in_join_tbl);
92: elsif(l_sec_context = 'COMP') then
93: poa_dbi_sutil_pkg.process_parameters(
94: p_param => p_param,
95: p_view_by => l_view_by,
96: p_view_by_col_name => l_view_by_col,
97: p_view_by_value => l_view_by_value,

Line 135: poa_dbi_sutil_pkg.process_parameters(

131: end if;
132: end loop;
133:
134: if(l_use_only_agg_mv = 'N') then
135: poa_dbi_sutil_pkg.process_parameters(
136: p_param => p_param,
137: p_view_by => l_view_by,
138: p_view_by_col_name => l_view_by_col,
139: p_view_by_value => l_view_by_value,

Line 229: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);

225: begin
226: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
227: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
228:
229: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
230: if(l_sec_context = 'OU' or l_sec_context = 'OU/COM') then
231: poa_dbi_sutil_pkg.process_parameters(
232: p_param => p_param,
233: p_view_by => l_view_by,

Line 231: poa_dbi_sutil_pkg.process_parameters(

227: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
228:
229: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
230: if(l_sec_context = 'OU' or l_sec_context = 'OU/COM') then
231: poa_dbi_sutil_pkg.process_parameters(
232: p_param => p_param,
233: p_view_by => l_view_by,
234: p_view_by_col_name => l_view_by_col,
235: p_view_by_value => l_view_by_value,

Line 267: poa_dbi_sutil_pkg.process_parameters(

263: p_col_name => l_col_tbl,
264: p_use_grpid => 'N',
265: p_in_join_tables => l_in_join_tbl);
266: elsif(l_sec_context = 'COMP')then
267: poa_dbi_sutil_pkg.process_parameters(
268: p_param => p_param,
269: p_view_by => l_view_by,
270: p_view_by_col_name => l_view_by_col,
271: p_view_by_value => l_view_by_value,

Line 304: poa_dbi_sutil_pkg.process_parameters(

300: end if;
301: end loop;
302:
303: if(l_use_only_agg_mv = 'N') then
304: poa_dbi_sutil_pkg.process_parameters(
305: p_param => p_param,
306: p_view_by => l_view_by,
307: p_view_by_col_name => l_view_by_col,
308: p_view_by_value => l_view_by_value,

Line 367: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

363:
364:
365: FUNCTION get_kpi_filter_where return VARCHAR2
366: IS
367: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
368: BEGIN
369: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
370: l_col_tbl.extend;
371: l_col_tbl(1) := 'POA_PERCENT2';

Line 369: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();

365: FUNCTION get_kpi_filter_where return VARCHAR2
366: IS
367: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
368: BEGIN
369: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
370: l_col_tbl.extend;
371: l_col_tbl(1) := 'POA_PERCENT2';
372: l_col_tbl.extend;
373: l_col_tbl(2) := 'POA_PERCENT1';

Line 376: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

372: l_col_tbl.extend;
373: l_col_tbl(2) := 'POA_PERCENT1';
374:
375:
376: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
377:
378: END;
379:
380: procedure kpi_sql(p_param in bis_pmv_page_parameter_tbl,

Line 407: poa_dbi_sutil_pkg.process_parameters(

403: begin
404: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
405: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
406:
407: poa_dbi_sutil_pkg.process_parameters(
408: p_param => p_param,
409: p_view_by => l_view_by,
410: p_view_by_col_name => l_view_by_col,
411: p_view_by_value => l_view_by_value,

Line 435: poa_dbi_sutil_pkg.get_table('ORGANIZATION+FII_OPERATING_UNITS', 'AP', '5.0');

431:
432: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
433:
434: l_join_rec.table_name :=
435: poa_dbi_sutil_pkg.get_table('ORGANIZATION+FII_OPERATING_UNITS', 'AP', '5.0');
436: l_join_rec.table_alias := 'v';
437: l_join_rec.fact_column :=
438: poa_dbi_sutil_pkg.get_col_name('ORGANIZATION+FII_OPERATING_UNITS', 'AP', '5.0', 'IDL');
439: l_join_rec.column_name := 'id';

Line 438: poa_dbi_sutil_pkg.get_col_name('ORGANIZATION+FII_OPERATING_UNITS', 'AP', '5.0', 'IDL');

434: l_join_rec.table_name :=
435: poa_dbi_sutil_pkg.get_table('ORGANIZATION+FII_OPERATING_UNITS', 'AP', '5.0');
436: l_join_rec.table_alias := 'v';
437: l_join_rec.fact_column :=
438: poa_dbi_sutil_pkg.get_col_name('ORGANIZATION+FII_OPERATING_UNITS', 'AP', '5.0', 'IDL');
439: l_join_rec.column_name := 'id';
440:
441: l_join_tbl.extend;
442: l_join_tbl(l_join_tbl.count) :=l_join_rec;

Line 473: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

469:
470:
471: FUNCTION get_status_filter_where return VARCHAR2
472: IS
473: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
474: BEGIN
475: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
476: l_col_tbl.extend;
477: l_col_tbl(1) := 'POA_MEASURE1';

Line 475: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();

471: FUNCTION get_status_filter_where return VARCHAR2
472: IS
473: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
474: BEGIN
475: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
476: l_col_tbl.extend;
477: l_col_tbl(1) := 'POA_MEASURE1';
478: l_col_tbl.extend;
479: l_col_tbl(2) := 'POA_PERCENT2';

Line 485: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

481: l_col_tbl(3) := 'POA_PERCENT1';
482: l_col_tbl.extend;
483: l_col_tbl(4) := 'POA_MEASURE3';
484:
485: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
486:
487: END;
488:
489: