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

Line 63: poa_dbi_sutil_pkg.process_parameters(p_param

59: l_comparison_type := 'Y';
60: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
61: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
62:
63: poa_dbi_sutil_pkg.process_parameters(p_param
64: ,l_view_by
65: ,l_view_by_col
66: ,l_view_by_value
67: ,l_comparison_type

Line 146: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

142: ,p_view_by_col in varchar2)
143: return varchar2 is
144: l_sel_clause varchar2(6000);
145: begin
146: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
147: ,'PO'
148: ,'7.1');
149:
150: if(p_view_by_dim = 'ITEM+POA_ITEMS')

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 308: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

304: if(p_view_by = 'ITEM+POA_ITEMS') then
305: l_col_tbl.extend;
306: l_col_tbl(10) := 'POA_MEASURE10';
307: end if;
308: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
309: end;
310:
311:
312: procedure status_sum_sql(

Line 341: poa_dbi_sutil_pkg.process_parameters(

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

Line 421: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(

417: )
418: return varchar2 is
419: l_sel_clause varchar2(4000);
420: begin
421: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(
422: p_view_by_dim,
423: 'PO',
424: '7.1'
425: );

Line 517: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

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

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

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

Line 536: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

532: l_col_tbl.extend;
533: l_col_tbl(6) := 'POA_MEASURE10';
534: end if;
535:
536: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
537: end;
538:
539:
540: /* PROCESSED REQUISITIONS AMOUNT REPORT */

Line 570: poa_dbi_sutil_pkg.process_parameters(p_param

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

Line 654: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

650: )
651: return varchar2 is
652: l_sel_clause varchar2(4000);
653: begin
654: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
655: ,'PO'
656: ,'7.1');
657:
658: if(p_view_by_dim = 'ITEM+POA_ITEMS')

Line 792: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

788:
789:
790: function get_amt_filter_where(p_view_by in VARCHAR2) return varchar2
791: is
792: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
793: begin
794: l_col_tbl := poa_dbi_sutil_pkg.poa_dbi_filter_tbl();
795: l_col_tbl.extend;
796: l_col_tbl(1) := 'POA_MEASURE1';

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

790: function get_amt_filter_where(p_view_by in VARCHAR2) return varchar2
791: is
792: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
793: begin
794: l_col_tbl := poa_dbi_sutil_pkg.poa_dbi_filter_tbl();
795: l_col_tbl.extend;
796: l_col_tbl(1) := 'POA_MEASURE1';
797: l_col_tbl.extend;
798: l_col_tbl(2) := 'POA_PERCENT1';

Line 809: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

805: if(p_view_by = 'ITEM+POA_ITEMS') then
806: l_col_tbl.extend;
807: l_col_tbl(6) := 'POA_MEASURE10';
808: end if;
809: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
810: end;
811:
812: /* PROCESSED REQUISITIONS AGING REPORT */
813:

Line 842: poa_dbi_sutil_pkg.process_parameters(p_param

838: l_comparison_type := 'Y';
839: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
840: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
841:
842: poa_dbi_sutil_pkg.process_parameters(p_param
843: ,l_view_by
844: ,l_view_by_col
845: ,l_view_by_value
846: ,l_comparison_type

Line 931: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

927: , p_bucket_rec in BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE)
928: return varchar2 is
929: l_sel_clause varchar2(6000);
930: begin
931: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
932: ,'PO'
933: ,'7.1');
934:
935: if(p_view_by_dim = 'ITEM+POA_ITEMS') then

Line 1089: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

1085:
1086:
1087: function get_req_age_filter_where(p_view_by in VARCHAR2) return varchar2
1088: is
1089: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
1090: begin
1091: l_col_tbl := poa_dbi_sutil_pkg.poa_dbi_filter_tbl();
1092: l_col_tbl.extend;
1093: l_col_tbl(1) := 'POA_MEASURE1';

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

1087: function get_req_age_filter_where(p_view_by in VARCHAR2) return varchar2
1088: is
1089: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
1090: begin
1091: l_col_tbl := poa_dbi_sutil_pkg.poa_dbi_filter_tbl();
1092: l_col_tbl.extend;
1093: l_col_tbl(1) := 'POA_MEASURE1';
1094: l_col_tbl.extend;
1095: l_col_tbl(2) := 'POA_MEASURE2';

Line 1112: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

1108: l_col_tbl.extend;
1109: l_col_tbl(8) := 'POA_MEASURE10';
1110: end if;
1111:
1112: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
1113: end;
1114:
1115:
1116:

Line 1172: poa_dbi_sutil_pkg.process_parameters(p_param,

1168: l_comparison_type := 'Y';
1169: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
1170: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1171:
1172: poa_dbi_sutil_pkg.process_parameters(p_param,
1173: l_view_by,
1174: l_view_by_col_name,
1175: l_view_by_value,
1176: l_comparison_type,

Line 1299: poa_dbi_sutil_pkg.process_parameters(p_param,

1295: l_comparison_type := 'Y';
1296: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
1297: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1298:
1299: poa_dbi_sutil_pkg.process_parameters(p_param,
1300: l_view_by,
1301: l_view_by_col_name,
1302: l_view_by_value,
1303: l_comparison_type,

Line 1435: poa_dbi_sutil_pkg.process_parameters(p_param,

1431: l_comparison_type := 'Y';
1432: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
1433: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1434:
1435: poa_dbi_sutil_pkg.process_parameters(p_param,
1436: l_view_by,
1437: l_view_by_col_name,
1438: l_view_by_value,
1439: l_comparison_type,

Line 1519: poa_dbi_sutil_pkg.drill_process_parameters(

1515: err_msg varchar2(100);
1516: l_bucket varchar2(50);
1517: l_bucket_where varchar2(440);
1518: begin
1519: poa_dbi_sutil_pkg.drill_process_parameters(
1520: p_param,
1521: l_cur_suffix,
1522: l_where_clause,
1523: l_in_join_tbl,