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

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

61: BEGIN
62: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
63: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
64:
65: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
66: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
67: poa_dbi_sutil_pkg.process_parameters(
68: p_param => p_param,
69: p_view_by => l_view_by,

Line 67: poa_dbi_sutil_pkg.process_parameters(

63: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
64:
65: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
66: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
67: poa_dbi_sutil_pkg.process_parameters(
68: p_param => p_param,
69: p_view_by => l_view_by,
70: p_view_by_col_name => l_view_by_col,
71: p_view_by_value => l_view_by_value,

Line 110: poa_dbi_sutil_pkg.process_parameters(

106: p_filter_where => get_status_filter_where(l_view_by),
107: p_in_join_tables => l_in_join_tbl);
108:
109: elsif (l_sec_context = 'COMP') then
110: poa_dbi_sutil_pkg.process_parameters(
111: p_param => p_param,
112: p_view_by => l_view_by,
113: p_view_by_col_name => l_view_by_col,
114: p_view_by_value => l_view_by_value,

Line 152: poa_dbi_sutil_pkg.process_parameters(

148: end if;
149: end loop;
150:
151: if(l_use_only_agg_mv = 'N') then
152: poa_dbi_sutil_pkg.process_parameters(
153: p_param => p_param,
154: p_view_by => l_view_by,
155: p_view_by_col_name => l_view_by_col,
156: p_view_by_value => l_view_by_value,

Line 217: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

213:
214:
215: FUNCTION get_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
216: IS
217: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
218: BEGIN
219: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
220: l_col_tbl.extend;
221: l_col_tbl(1) := 'POA_MEASURE1';

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

215: FUNCTION get_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
216: IS
217: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
218: BEGIN
219: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
220: l_col_tbl.extend;
221: l_col_tbl(1) := 'POA_MEASURE1';
222: l_col_tbl.extend;
223: l_col_tbl(2) := 'POA_PERCENT1';

Line 236: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

232: l_col_tbl.extend;
233: l_col_tbl(6) := 'POA_MEASURE12';
234: end if;
235:
236: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
237:
238: END;
239:
240:

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

244: p_sec_context in VARCHAR2) return VARCHAR2
245: IS
246: l_sel_clause varchar2(8000);
247: BEGIN
248: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim, 'PO', '6.0');
249:
250: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
251: l_sel_clause := l_sel_clause || ' v.description POA_ATTRIBUTE1,
252: v2.description POA_ATTRIBUTE2, oset.POA_MEASURE12 POA_MEASURE12, ';

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

406: BEGIN
407: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
408: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
409:
410: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
411: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
412: poa_dbi_sutil_pkg.process_parameters(
413: p_param => p_param,
414: p_view_by => l_view_by,

Line 412: poa_dbi_sutil_pkg.process_parameters(

408: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
409:
410: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
411: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
412: poa_dbi_sutil_pkg.process_parameters(
413: p_param => p_param,
414: p_view_by => l_view_by,
415: p_view_by_col_name => l_view_by_col,
416: p_view_by_value => l_view_by_value,

Line 453: poa_dbi_sutil_pkg.process_parameters(

449: p_filter_where => get_con_rpt_filter_where(l_view_by),
450: p_in_join_tables => l_in_join_tbl);
451:
452: elsif (l_sec_context = 'COMP') then
453: poa_dbi_sutil_pkg.process_parameters(
454: p_param => p_param,
455: p_view_by => l_view_by,
456: p_view_by_col_name => l_view_by_col,
457: p_view_by_value => l_view_by_value,

Line 493: poa_dbi_sutil_pkg.process_parameters(

489: end if;
490: end loop;
491:
492: if(l_use_only_agg_mv = 'N') then
493: poa_dbi_sutil_pkg.process_parameters(
494: p_param => p_param,
495: p_view_by => l_view_by,
496: p_view_by_col_name => l_view_by_col,
497: p_view_by_value => l_view_by_value,

Line 560: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

556:
557:
558: FUNCTION get_con_rpt_filter_where(p_view_by in VARCHAR2) return VARCHAR2
559: IS
560: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
561: BEGIN
562: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
563: l_col_tbl.extend;
564: l_col_tbl(1) := 'POA_MEASURE1';

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

558: FUNCTION get_con_rpt_filter_where(p_view_by in VARCHAR2) return VARCHAR2
559: IS
560: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
561: BEGIN
562: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
563: l_col_tbl.extend;
564: l_col_tbl(1) := 'POA_MEASURE1';
565: l_col_tbl.extend;
566: l_col_tbl(2) := 'POA_PERCENT1';

Line 576: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

572: l_col_tbl.extend;
573: l_col_tbl(5) := 'POA_MEASURE12';
574: end if;
575:
576: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
577:
578: END;
579:
580:

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

584: p_sec_context in VARCHAR2) return VARCHAR2
585: IS
586: l_sel_clause varchar2(8000);
587: BEGIN
588: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim, 'PO', '6.0');
589:
590: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
591: l_sel_clause := l_sel_clause || ' v.description POA_ATTRIBUTE1,
592: v2.description POA_ATTRIBUTE2, oset.POA_MEASURE12 POA_MEASURE12, ';

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

701: BEGIN
702: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
703: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
704:
705: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
706: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
707: poa_dbi_sutil_pkg.process_parameters(
708: p_param => p_param,
709: p_view_by => l_view_by,

Line 707: poa_dbi_sutil_pkg.process_parameters(

703: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
704:
705: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
706: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
707: poa_dbi_sutil_pkg.process_parameters(
708: p_param => p_param,
709: p_view_by => l_view_by,
710: p_view_by_col_name => l_view_by_col,
711: p_view_by_value => l_view_by_value,

Line 747: poa_dbi_sutil_pkg.process_parameters(

743: p_use_grpid => 'N',
744: p_filter_where => get_ncp_rpt_filter_where(l_view_by),
745: p_in_join_tables => l_in_join_tbl);
746: elsif(l_sec_context = 'COMP')then
747: poa_dbi_sutil_pkg.process_parameters(
748: p_param => p_param,
749: p_view_by => l_view_by,
750: p_view_by_col_name => l_view_by_col,
751: p_view_by_value => l_view_by_value,

Line 787: poa_dbi_sutil_pkg.process_parameters(

783: end if;
784: end loop;
785:
786: if(l_use_only_agg_mv = 'N') then
787: poa_dbi_sutil_pkg.process_parameters(
788: p_param => p_param,
789: p_view_by => l_view_by,
790: p_view_by_col_name => l_view_by_col,
791: p_view_by_value => l_view_by_value,

Line 854: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

850:
851:
852: FUNCTION get_ncp_rpt_filter_where(p_view_by in VARCHAR2) return VARCHAR2
853: IS
854: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
855: BEGIN
856: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
857: l_col_tbl.extend;
858: l_col_tbl(1) := 'POA_MEASURE1';

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

852: FUNCTION get_ncp_rpt_filter_where(p_view_by in VARCHAR2) return VARCHAR2
853: IS
854: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
855: BEGIN
856: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
857: l_col_tbl.extend;
858: l_col_tbl(1) := 'POA_MEASURE1';
859: l_col_tbl.extend;
860: l_col_tbl(2) := 'POA_MEASURE2';

Line 871: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

867: l_col_tbl.extend;
868: l_col_tbl(5) := 'POA_MEASURE12';
869: end if;
870:
871: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
872:
873: END;
874:
875:

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

882: l_sel_clause varchar2(8000);
883:
884:
885: BEGIN
886: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim, 'PO', '6.0');
887:
888: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
889: l_sel_clause := l_sel_clause || ' v.description POA_ATTRIBUTE1,
890: v2.description POA_ATTRIBUTE2, oset.POA_MEASURE12 POA_MEASURE12, ';

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

1010: BEGIN
1011: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
1012: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1013:
1014: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
1015: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
1016: poa_dbi_sutil_pkg.process_parameters(
1017: p_param => p_param,
1018: p_view_by => l_view_by,

Line 1016: poa_dbi_sutil_pkg.process_parameters(

1012: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1013:
1014: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
1015: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
1016: poa_dbi_sutil_pkg.process_parameters(
1017: p_param => p_param,
1018: p_view_by => l_view_by,
1019: p_view_by_col_name => l_view_by_col,
1020: p_view_by_value => l_view_by_value,

Line 1060: poa_dbi_sutil_pkg.process_parameters(

1056: p_filter_where => get_pcl_rpt_filter_where(l_view_by),
1057: p_in_join_tables => l_in_join_tbl);
1058:
1059: elsif(l_sec_context = 'COMP')then
1060: poa_dbi_sutil_pkg.process_parameters(
1061: p_param => p_param,
1062: p_view_by => l_view_by,
1063: p_view_by_col_name => l_view_by_col,
1064: p_view_by_value => l_view_by_value,

Line 1103: poa_dbi_sutil_pkg.process_parameters(

1099: end if;
1100: end loop;
1101:
1102: if(l_use_only_agg_mv = 'N') then
1103: poa_dbi_sutil_pkg.process_parameters(
1104: p_param => p_param,
1105: p_view_by => l_view_by,
1106: p_view_by_col_name => l_view_by_col,
1107: p_view_by_value => l_view_by_value,

Line 1168: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

1164:
1165:
1166: FUNCTION get_pcl_rpt_filter_where(p_view_by in VARCHAR2) return VARCHAR2
1167: IS
1168: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
1169: BEGIN
1170: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
1171: l_col_tbl.extend;
1172: l_col_tbl(1) := 'POA_MEASURE1';

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

1166: FUNCTION get_pcl_rpt_filter_where(p_view_by in VARCHAR2) return VARCHAR2
1167: IS
1168: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
1169: BEGIN
1170: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
1171: l_col_tbl.extend;
1172: l_col_tbl(1) := 'POA_MEASURE1';
1173: l_col_tbl.extend;
1174: l_col_tbl(2) := 'POA_MEASURE2';

Line 1190: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

1186: if(p_view_by= 'ITEM+POA_ITEMS') then
1187: l_col_tbl.extend;
1188: l_col_tbl(8) := 'POA_MEASURE12';
1189: end if;
1190: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
1191:
1192: END;
1193:
1194:

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

1198: p_sec_context in VARCHAR2) return VARCHAR2
1199: IS
1200: l_sel_clause varchar2(8000);
1201: BEGIN
1202: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim, 'PO', '6.0');
1203:
1204: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
1205: l_sel_clause := l_sel_clause || ' v.description POA_ATTRIBUTE1,
1206: v2.description POA_ATTRIBUTE2, oset.POA_MEASURE12 POA_MEASURE12, ';

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

1327: BEGIN
1328: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
1329: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1330:
1331: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
1332: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
1333: poa_dbi_sutil_pkg.process_parameters(
1334: p_param => p_param,
1335: p_view_by => l_view_by,

Line 1333: poa_dbi_sutil_pkg.process_parameters(

1329: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1330:
1331: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
1332: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
1333: poa_dbi_sutil_pkg.process_parameters(
1334: p_param => p_param,
1335: p_view_by => l_view_by,
1336: p_view_by_col_name => l_view_by_col,
1337: p_view_by_value => l_view_by_value,

Line 1368: poa_dbi_sutil_pkg.process_parameters(

1364: p_use_grpid => 'N',
1365: p_in_join_tables => l_in_join_tbl);
1366:
1367: elsif(l_sec_context = 'COMP')then
1368: poa_dbi_sutil_pkg.process_parameters(
1369: p_param => p_param,
1370: p_view_by => l_view_by,
1371: p_view_by_col_name => l_view_by_col,
1372: p_view_by_value => l_view_by_value,

Line 1403: poa_dbi_sutil_pkg.process_parameters(

1399: end if;
1400: end loop;
1401:
1402: if(l_use_only_agg_mv = 'N') then
1403: poa_dbi_sutil_pkg.process_parameters(
1404: p_param => p_param,
1405: p_view_by => l_view_by,
1406: p_view_by_col_name => l_view_by_col,
1407: p_view_by_value => l_view_by_value,

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

1507: BEGIN
1508: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
1509: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1510:
1511: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
1512: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
1513: poa_dbi_sutil_pkg.process_parameters(
1514: p_param => p_param,
1515: p_view_by => l_view_by,

Line 1513: poa_dbi_sutil_pkg.process_parameters(

1509: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1510:
1511: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
1512: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
1513: poa_dbi_sutil_pkg.process_parameters(
1514: p_param => p_param,
1515: p_view_by => l_view_by,
1516: p_view_by_col_name => l_view_by_col,
1517: p_view_by_value => l_view_by_value,

Line 1550: poa_dbi_sutil_pkg.process_parameters(

1546: p_use_grpid => 'N',
1547: p_in_join_tables => l_in_join_tbl);
1548:
1549: elsif(l_sec_context = 'COMP')then
1550: poa_dbi_sutil_pkg.process_parameters(
1551: p_param => p_param,
1552: p_view_by => l_view_by,
1553: p_view_by_col_name => l_view_by_col,
1554: p_view_by_value => l_view_by_value,

Line 1588: poa_dbi_sutil_pkg.process_parameters(

1584: end if;
1585: end loop;
1586:
1587: if(l_use_only_agg_mv = 'N') then
1588: poa_dbi_sutil_pkg.process_parameters(
1589: p_param => p_param,
1590: p_view_by => l_view_by,
1591: p_view_by_col_name => l_view_by_col,
1592: p_view_by_value => l_view_by_value,

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

1699: BEGIN
1700: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
1701: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1702:
1703: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
1704: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
1705: poa_dbi_sutil_pkg.process_parameters(
1706: p_param => p_param,
1707: p_view_by => l_view_by,

Line 1705: poa_dbi_sutil_pkg.process_parameters(

1701: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1702:
1703: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
1704: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
1705: poa_dbi_sutil_pkg.process_parameters(
1706: p_param => p_param,
1707: p_view_by => l_view_by,
1708: p_view_by_col_name => l_view_by_col,
1709: p_view_by_value => l_view_by_value,

Line 1732: l_query := poa_dbi_sutil_pkg.get_viewby_select_clause(l_view_by, 'PO','6.0');

1728: poa_dbi_util_pkg.add_column(l_col_tbl, 'contract_amt_' || l_cur_suffix, 'contract_amt');
1729: poa_dbi_util_pkg.add_column(l_col_tbl, 'p_contract_amt_' || l_cur_suffix, 'p_contract_amt');
1730: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'purchase_amt');
1731:
1732: l_query := poa_dbi_sutil_pkg.get_viewby_select_clause(l_view_by, 'PO','6.0');
1733:
1734: l_query := l_query || '
1735: oset.POA_PERCENT1 POA_PERCENT1,
1736: oset.POA_PERCENT2 POA_PERCENT2,

Line 1772: poa_dbi_sutil_pkg.process_parameters(

1768: p_use_grpid => 'N',
1769: p_in_join_tables => l_in_join_tbl);
1770:
1771: elsif(l_sec_context = 'COMP')then
1772: poa_dbi_sutil_pkg.process_parameters(
1773: p_param => p_param,
1774: p_view_by => l_view_by,
1775: p_view_by_col_name => l_view_by_col,
1776: p_view_by_value => l_view_by_value,

Line 1810: poa_dbi_sutil_pkg.process_parameters(

1806: end if;
1807: end loop;
1808:
1809: if(l_use_only_agg_mv = 'N') then
1810: poa_dbi_sutil_pkg.process_parameters(
1811: p_param => p_param,
1812: p_view_by => l_view_by,
1813: p_view_by_col_name => l_view_by_col,
1814: p_view_by_value => l_view_by_value,

Line 1847: l_query := poa_dbi_sutil_pkg.get_viewby_select_clause(l_view_by, 'PO','6.0');

1843: l_mv_tbl(2).mv_where := l_where_clause2;
1844: l_mv_tbl(2).in_join_tbls := l_in_join_tbl2;
1845: l_mv_tbl(2).use_grp_id := 'N';
1846:
1847: l_query := poa_dbi_sutil_pkg.get_viewby_select_clause(l_view_by, 'PO','6.0');
1848:
1849: l_query := l_query || '
1850: oset.POA_PERCENT1 POA_PERCENT1,
1851: oset.POA_PERCENT2 POA_PERCENT2,

Line 1885: l_query := poa_dbi_sutil_pkg.get_viewby_select_clause(l_view_by, 'PO','6.0');

1881: p_paren_count => 3,
1882: p_generate_viewby => 'Y',
1883: p_diff_measures => 'N');
1884: else
1885: l_query := poa_dbi_sutil_pkg.get_viewby_select_clause(l_view_by, 'PO','6.0');
1886:
1887: l_query := l_query || '
1888: oset.POA_PERCENT1 POA_PERCENT1,
1889: oset.POA_PERCENT2 POA_PERCENT2,

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

1958: BEGIN
1959: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
1960: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1961:
1962: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
1963: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
1964: poa_dbi_sutil_pkg.process_parameters(
1965: p_param => p_param,
1966: p_view_by => l_view_by,

Line 1964: poa_dbi_sutil_pkg.process_parameters(

1960: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1961:
1962: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
1963: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
1964: poa_dbi_sutil_pkg.process_parameters(
1965: p_param => p_param,
1966: p_view_by => l_view_by,
1967: p_view_by_col_name => l_view_by_col,
1968: p_view_by_value => l_view_by_value,

Line 2035: poa_dbi_sutil_pkg.process_parameters(

2031: and fl.enabled_flag = ''Y''
2032: )
2033: )';
2034: elsif(l_sec_context = 'COMP')then
2035: poa_dbi_sutil_pkg.process_parameters(
2036: p_param => p_param,
2037: p_view_by => l_view_by,
2038: p_view_by_col_name => l_view_by_col,
2039: p_view_by_value => l_view_by_value,

Line 2074: poa_dbi_sutil_pkg.process_parameters(

2070: end if;
2071: end loop;
2072:
2073: if(l_use_only_agg_mv = 'N') then
2074: poa_dbi_sutil_pkg.process_parameters(
2075: p_param => p_param,
2076: p_view_by => l_view_by,
2077: p_view_by_col_name => l_view_by_col,
2078: p_view_by_value => l_view_by_value,

Line 2225: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

2221:
2222:
2223: FUNCTION get_doctype_filter_where return VARCHAR2
2224: IS
2225: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
2226: BEGIN
2227: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
2228: l_col_tbl.extend;
2229: l_col_tbl(1) := 'c_purchase_amt_total';

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

2223: FUNCTION get_doctype_filter_where return VARCHAR2
2224: IS
2225: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
2226: BEGIN
2227: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
2228: l_col_tbl.extend;
2229: l_col_tbl(1) := 'c_purchase_amt_total';
2230: l_col_tbl.extend;
2231: l_col_tbl(2) := 'c_purchase_amt';

Line 2234: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

2230: l_col_tbl.extend;
2231: l_col_tbl(2) := 'c_purchase_amt';
2232:
2233:
2234: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
2235:
2236: END;
2237:
2238:

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

2265: BEGIN
2266: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
2267: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
2268:
2269: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
2270: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
2271: poa_dbi_sutil_pkg.process_parameters(
2272: p_param => p_param,
2273: p_view_by => l_view_by,

Line 2271: poa_dbi_sutil_pkg.process_parameters(

2267: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
2268:
2269: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
2270: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
2271: poa_dbi_sutil_pkg.process_parameters(
2272: p_param => p_param,
2273: p_view_by => l_view_by,
2274: p_view_by_col_name => l_view_by_col,
2275: p_view_by_value => l_view_by_value,

Line 2308: poa_dbi_sutil_pkg.process_parameters(

2304: p_filter_where => get_doctype_filter_where,
2305: p_in_join_tables => l_in_join_tbl);
2306:
2307: elsif(l_sec_context = 'COMP')then
2308: poa_dbi_sutil_pkg.process_parameters(
2309: p_param => p_param,
2310: p_view_by => l_view_by,
2311: p_view_by_col_name => l_view_by_col,
2312: p_view_by_value => l_view_by_value,

Line 2343: poa_dbi_sutil_pkg.process_parameters(

2339: end if;
2340: end loop;
2341:
2342: if(l_use_only_agg_mv = 'N') then
2343: poa_dbi_sutil_pkg.process_parameters(
2344: p_param => p_param,
2345: p_view_by => l_view_by,
2346: p_view_by_col_name => l_view_by_col,
2347: p_view_by_value => l_view_by_value,