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_FR_PKG dependencies on POA_DBI_SUTIL_PKG

Line 53: poa_dbi_sutil_pkg.process_parameters(p_param

49: l_comparison_type := 'Y';
50: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
51: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
52:
53: poa_dbi_sutil_pkg.process_parameters(p_param
54: ,l_view_by
55: ,l_view_by_col
56: ,l_view_by_value
57: ,l_comparison_type

Line 141: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

137: ,p_view_by_col in varchar2)
138: return varchar2 is
139: l_sel_clause varchar2(6000);
140: begin
141: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
142: ,'PO'
143: ,'7.1');
144: if(p_view_by_dim = 'ITEM+POA_ITEMS')
145: then

Line 282: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

278: end;
279:
280: function get_status_filter_where(p_view_by in varchar2) return varchar2
281: is
282: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
283: begin
284: l_col_tbl := poa_dbi_sutil_pkg.poa_dbi_filter_tbl();
285: l_col_tbl.extend;
286: l_col_tbl(1) := 'POA_MEASURE1';

Line 284: l_col_tbl := poa_dbi_sutil_pkg.poa_dbi_filter_tbl();

280: function get_status_filter_where(p_view_by in varchar2) return varchar2
281: is
282: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
283: begin
284: l_col_tbl := poa_dbi_sutil_pkg.poa_dbi_filter_tbl();
285: l_col_tbl.extend;
286: l_col_tbl(1) := 'POA_MEASURE1';
287: l_col_tbl.extend;
288: l_col_tbl(2) := 'POA_PERCENT1';

Line 309: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

305: if( p_view_by = 'ITEM+POA_ITEMS' ) then
306: l_col_tbl.extend;
307: l_col_tbl(11) := 'POA_ATTRIBUTE5';
308: end if;
309: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
310: end;
311:
312: /*Fulfilled Requisition Lines Summary*/
313: procedure status_summary_sql(p_param in bis_pmv_page_parameter_tbl

Line 340: poa_dbi_sutil_pkg.process_parameters(p_param

336: l_comparison_type := 'Y';
337: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
338: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
339:
340: poa_dbi_sutil_pkg.process_parameters(p_param
341: ,l_view_by
342: ,l_view_by_col
343: ,l_view_by_value
344: ,l_comparison_type

Line 415: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

411: ,p_view_by_col in varchar2)
412: return varchar2 is
413: l_sel_clause varchar2(5000);
414: begin
415: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
416: ,'PO'
417: ,'7.1');
418: if(p_view_by_dim = 'ITEM+POA_ITEMS')
419: then

Line 519: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

515: end;
516:
517: function get_summary_filter_where(p_view_by in varchar2) return varchar2
518: is
519: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
520: begin
521: l_col_tbl := poa_dbi_sutil_pkg.poa_dbi_filter_tbl();
522: l_col_tbl.extend;
523: l_col_tbl(1) := 'POA_MEASURE1';

Line 521: l_col_tbl := poa_dbi_sutil_pkg.poa_dbi_filter_tbl();

517: function get_summary_filter_where(p_view_by in varchar2) return varchar2
518: is
519: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
520: begin
521: l_col_tbl := poa_dbi_sutil_pkg.poa_dbi_filter_tbl();
522: l_col_tbl.extend;
523: l_col_tbl(1) := 'POA_MEASURE1';
524: l_col_tbl.extend;
525: l_col_tbl(2) := 'POA_PERCENT1';

Line 540: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

536: if( p_view_by = 'ITEM+POA_ITEMS' ) then
537: l_col_tbl.extend;
538: l_col_tbl(8) := 'POA_ATTRIBUTE5';
539: end if;
540: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
541: end;
542:
543: /*Fulfilled Requisitions Amount report*/
544: procedure amt_sql(p_param in bis_pmv_page_parameter_tbl

Line 572: poa_dbi_sutil_pkg.process_parameters(p_param

568: l_comparison_type := 'Y';
569: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
570: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
571:
572: poa_dbi_sutil_pkg.process_parameters(p_param
573: ,l_view_by
574: ,l_view_by_col
575: ,l_view_by_value
576: ,l_comparison_type

Line 650: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

646: , p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE)
647: return varchar2 is
648: l_sel_clause varchar2(5000);
649: begin
650: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
651: ,'PO'
652: ,'7.1');
653: if(p_view_by_dim = 'ITEM+POA_ITEMS')
654: then

Line 785: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

781: end;
782:
783: function get_amt_sql_filter_where(p_view_by in varchar2) return varchar2
784: is
785: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
786: begin
787: l_col_tbl := poa_dbi_sutil_pkg.poa_dbi_filter_tbl();
788: l_col_tbl.extend;
789: l_col_tbl(1) := 'POA_MEASURE1';

Line 787: l_col_tbl := poa_dbi_sutil_pkg.poa_dbi_filter_tbl();

783: function get_amt_sql_filter_where(p_view_by in varchar2) return varchar2
784: is
785: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
786: begin
787: l_col_tbl := poa_dbi_sutil_pkg.poa_dbi_filter_tbl();
788: l_col_tbl.extend;
789: l_col_tbl(1) := 'POA_MEASURE1';
790: l_col_tbl.extend;
791: l_col_tbl(2) := 'POA_PERCENT1';

Line 802: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

798: if( p_view_by = 'ITEM+POA_ITEMS' ) then
799: l_col_tbl.extend;
800: l_col_tbl(6) := 'POA_ATTRIBUTE5';
801: end if;
802: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
803: end;
804:
805: /*fulfilled Requisition Lines report*/
806: procedure req_lines_sql(p_param in bis_pmv_page_parameter_tbl

Line 821: poa_dbi_sutil_pkg.drill_process_parameters(p_param, l_cur_suffix, l_where_clause, l_in_join_tbl, 'PO', '7.1', 'VPP','REQMF');

817: err_msg varchar2(100);
818: l_bucket varchar2(50);
819: l_bucket_where varchar2(440);
820: begin
821: poa_dbi_sutil_pkg.drill_process_parameters(p_param, l_cur_suffix, l_where_clause, l_in_join_tbl, 'PO', '7.1', 'VPP','REQMF');
822:
823: for i in 1..p_param.count
824: loop
825: if (p_param(i).parameter_name = 'POA_ATTRIBUTE10') then

Line 993: poa_dbi_sutil_pkg.process_parameters(p_param

989: l_comparison_type := 'Y';
990: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
991: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
992:
993: poa_dbi_sutil_pkg.process_parameters(p_param
994: ,l_view_by
995: ,l_view_by_col
996: ,l_view_by_value
997: ,l_comparison_type

Line 1080: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

1076: , p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE)
1077: return varchar2 is
1078: l_sel_clause varchar2(5000);
1079: begin
1080: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
1081: ,'PO'
1082: ,'7.1');
1083: if(p_view_by_dim = 'ITEM+POA_ITEMS')
1084: then

Line 1237: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

1233: end;
1234:
1235: function get_req_age_filter_where(p_view_by in varchar2) return varchar2
1236: is
1237: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
1238: begin
1239: l_col_tbl := poa_dbi_sutil_pkg.poa_dbi_filter_tbl();
1240: l_col_tbl.extend;
1241: l_col_tbl(1) := 'POA_MEASURE1';

Line 1239: l_col_tbl := poa_dbi_sutil_pkg.poa_dbi_filter_tbl();

1235: function get_req_age_filter_where(p_view_by in varchar2) return varchar2
1236: is
1237: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
1238: begin
1239: l_col_tbl := poa_dbi_sutil_pkg.poa_dbi_filter_tbl();
1240: l_col_tbl.extend;
1241: l_col_tbl(1) := 'POA_MEASURE1';
1242: l_col_tbl.extend;
1243: l_col_tbl(2) := 'POA_PERCENT1';

Line 1258: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

1254: if( p_view_by = 'ITEM+POA_ITEMS' ) then
1255: l_col_tbl.extend;
1256: l_col_tbl(8) := 'POA_ATTRIBUTE5';
1257: end if;
1258: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
1259: end;
1260:
1261: /*Fulfilled Lines Automation Trend report*/
1262: procedure trend_sql(p_param in bis_pmv_page_parameter_tbl

Line 1288: poa_dbi_sutil_pkg.process_parameters(p_param,

1284: l_comparison_type := 'Y';
1285: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
1286: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
1287:
1288: poa_dbi_sutil_pkg.process_parameters(p_param,
1289: l_view_by,
1290: l_view_by_col_name,
1291: l_view_by_value,
1292: l_comparison_type,

Line 1382: poa_dbi_sutil_pkg.process_parameters(p_param,

1378: l_comparison_type := 'Y';
1379: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
1380: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
1381:
1382: poa_dbi_sutil_pkg.process_parameters(p_param,
1383: l_view_by,
1384: l_view_by_col_name,
1385: l_view_by_value,
1386: l_comparison_type,

Line 1481: poa_dbi_sutil_pkg.process_parameters(p_param,

1477: l_comparison_type := 'Y';
1478: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
1479: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
1480:
1481: poa_dbi_sutil_pkg.process_parameters(p_param,
1482: l_view_by,
1483: l_view_by_col_name,
1484: l_view_by_value,
1485: l_comparison_type,