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

Line 47: poa_dbi_sutil_pkg.process_parameters(p_param

43: BEGIN
44: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
45:
46: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
47: poa_dbi_sutil_pkg.process_parameters(p_param
48: ,l_view_by
49: ,l_view_by_col
50: ,l_view_by_value
51: ,l_comparison_type

Line 68: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);

64: ,'PO'
65: ,'6.0'
66: ,'COM'
67: ,'RTX');
68: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
69: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN
70: l_to_date_type := 'RLX';
71: ELSE
72: l_to_date_type := 'XTD';

Line 129: poa_dbi_sutil_pkg.process_parameters(p_param

125: l_to_date_type VARCHAR2(10);
126: BEGIN
127: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
128: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
129: poa_dbi_sutil_pkg.process_parameters(p_param
130: ,l_view_by
131: ,l_view_by_col
132: ,l_view_by_value
133: ,l_comparison_type

Line 144: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);

140: ,l_mv
141: ,l_join_tbl,l_in_join_tbl
142: ,x_custom_output,
143: 'Y','PO', '6.0', 'COM','RTX');
144: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
145: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN
146: l_to_date_type := 'RLX';
147: ELSE
148: l_to_date_type := 'XTD';

Line 218: poa_dbi_sutil_pkg.process_parameters(p_param

214: BEGIN
215: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
216:
217: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
218: poa_dbi_sutil_pkg.process_parameters(p_param
219: ,l_view_by
220: ,l_view_by_col
221: ,l_view_by_value
222: ,l_comparison_type

Line 239: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);

235: ,'PO'
236: ,'6.0'
237: ,'COM'
238: ,'RTX');
239: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
240: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN
241: l_to_date_type := 'RLX';
242: ELSE
243: l_to_date_type := 'XTD';

Line 308: poa_dbi_sutil_pkg.process_parameters(p_param

304: BEGIN
305: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
306:
307: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
308: poa_dbi_sutil_pkg.process_parameters(p_param
309: ,l_view_by
310: ,l_view_by_col
311: ,l_view_by_value
312: ,l_comparison_type

Line 329: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);

325: ,'PO'
326: ,'6.0'
327: ,'COM'
328: ,'RTX');
329: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
330: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN
331: l_to_date_type := 'RLX';
332: ELSE
333: l_to_date_type := 'XTD';

Line 393: poa_dbi_sutil_pkg.process_parameters(p_param

389: BEGIN
390: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
391: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
392:
393: poa_dbi_sutil_pkg.process_parameters(p_param
394: ,l_view_by
395: ,l_view_by_col
396: ,l_view_by_value
397: ,l_comparison_type

Line 413: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);

409: ,'PO'
410: ,'6.0'
411: ,'COM'
412: ,'RTX');
413: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
414: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN
415: l_to_date_type := 'RLX';
416: ELSE
417: l_to_date_type := 'XTD';

Line 447: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

443:
444: FUNCTION get_status_filter_where return VARCHAR2
445:
446: IS
447: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
448: BEGIN
449: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
450: l_col_tbl.extend;
451: l_col_tbl(1) := 'POA_MEASURE1';

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

445:
446: IS
447: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
448: BEGIN
449: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
450: l_col_tbl.extend;
451: l_col_tbl(1) := 'POA_MEASURE1';
452: l_col_tbl.extend;
453: l_col_tbl(2) := 'POA_PERCENT1';

Line 469: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

465: l_col_tbl(8) := 'POA_MEASURE15';
466: l_col_tbl.extend;
467: l_col_tbl(9) := 'POA_ATTRIBUTE3';
468:
469: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
470:
471: END;
472:
473: FUNCTION get_status_sel_clause(p_view_by_dim in VARCHAR2, p_url in VARCHAR2, p_view_by_col in VARCHAR2) return VARCHAR2

Line 478: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim, 'PO', '6.0');

474: IS
475: l_sel_clause varchar2(8000);
476: l_view_by_col_name varchar2(40);
477: BEGIN
478: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim, 'PO', '6.0');
479: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
480: l_sel_clause := l_sel_clause ||'
481: v.description POA_ATTRIBUTE1, --Description
482: ';

Line 606: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim, 'PO', '6.0');

602: IS
603: l_sel_clause varchar2(4000);
604: l_view_by_col_name varchar2(40);
605: BEGIN
606: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim, 'PO', '6.0');
607: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
608: l_sel_clause := l_sel_clause ||'
609: v.description POA_ATTRIBUTE1, --Description
610: ';

Line 699: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim, 'PO', '6.0');

695: IS
696: l_sel_clause varchar2(4000);
697: l_view_by_col_name varchar2(40);
698: BEGIN
699: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim, 'PO', '6.0');
700: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
701: l_sel_clause := l_sel_clause ||'
702: v.description POA_ATTRIBUTE1, --Description
703: ';

Line 788: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

784:
785:
786: FUNCTION get_it_rpt_filter_where return VARCHAR2
787: IS
788: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
789: BEGIN
790: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
791: l_col_tbl.extend;
792: l_col_tbl(1) := 'POA_MEASURE2';

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

786: FUNCTION get_it_rpt_filter_where return VARCHAR2
787: IS
788: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
789: BEGIN
790: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
791: l_col_tbl.extend;
792: l_col_tbl(1) := 'POA_MEASURE2';
793: l_col_tbl.extend;
794: l_col_tbl(2) := 'POA_MEASURE3';

Line 807: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

803: l_col_tbl.extend;
804: l_col_tbl(7) := 'POA_MEASURE8';
805: l_col_tbl.extend;
806: l_col_tbl(8) := 'POA_MEASURE9';
807: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
808:
809: END;
810:
811: FUNCTION get_amt_rpt_filter_where return VARCHAR2

Line 813: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

809: END;
810:
811: FUNCTION get_amt_rpt_filter_where return VARCHAR2
812: IS
813: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
814: BEGIN
815: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
816: l_col_tbl.extend;
817: l_col_tbl(1) := 'POA_MEASURE1';

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

811: FUNCTION get_amt_rpt_filter_where return VARCHAR2
812: IS
813: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
814: BEGIN
815: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
816: l_col_tbl.extend;
817: l_col_tbl(1) := 'POA_MEASURE1';
818: l_col_tbl.extend;
819: l_col_tbl(2) := 'POA_PERCENT1';

Line 832: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

828: l_col_tbl.extend;
829: l_col_tbl(7) := 'POA_MEASURE5';
830: l_col_tbl.extend;
831: l_col_tbl(8) := 'POA_MEASURE6';
832: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
833:
834: END;
835:
836: FUNCTION get_txn_rpt_filter_where return VARCHAR2

Line 838: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

834: END;
835:
836: FUNCTION get_txn_rpt_filter_where return VARCHAR2
837: IS
838: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
839: BEGIN
840: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
841: l_col_tbl.extend;
842: l_col_tbl(1) := 'POA_MEASURE1';

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

836: FUNCTION get_txn_rpt_filter_where return VARCHAR2
837: IS
838: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
839: BEGIN
840: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
841: l_col_tbl.extend;
842: l_col_tbl(1) := 'POA_MEASURE1';
843: l_col_tbl.extend;
844: l_col_tbl(2) := 'POA_PERCENT1';

Line 857: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

853: l_col_tbl.extend;
854: l_col_tbl(7) := 'POA_MEASURE5';
855: l_col_tbl.extend;
856: l_col_tbl(8) := 'POA_MEASURE6';
857: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
858:
859: END;
860:
861: FUNCTION get_status_it_sel_clause(p_view_by_dim IN VARCHAR2,p_view_by_col in VARCHAR2) return VARCHAR2 IS

Line 867: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim, 'PO', '6.0');

863: l_view_by_col_name varchar2(40);
864: BEGIN
865: --
866: --
867: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim, 'PO', '6.0');
868: --
869: l_sel_clause := l_sel_clause ||'
870: v.description POA_ATTRIBUTE1, --Description
871: v2.description POA_ATTRIBUTE2, --UOM

Line 940: poa_dbi_sutil_pkg.process_parameters(p_param

936: l_to_date_type VARCHAR2(10);
937: BEGIN
938: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
939: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
940: poa_dbi_sutil_pkg.process_parameters(p_param
941: ,l_view_by
942: ,l_view_by_col
943: ,l_view_by_value
944: ,l_comparison_type

Line 956: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);

952: ,l_join_tbl
953: ,l_in_join_tbl
954: , x_custom_output
955: ,'Y','PO', '6.0', 'COM','RTX');
956: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
957: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN
958: l_to_date_type := 'RLX';
959: ELSE
960: l_to_date_type := 'XTD';