APPS.POA_DBI_INV_PKG dependencies on POA_DBI_SUTIL_PKG

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

55: l_join_tbl := POA_DBI_UTIL_PKG.POA_DBI_JOIN_TBL();
56: l_col_tbl := POA_DBI_UTIL_PKG.POA_DBI_COL_TBL();
57: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
58: --
59: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
60: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM' or l_sec_context = 'SUPPLIER')then
61: poa_dbi_sutil_pkg.process_parameters(
62: p_param => p_param,
63: p_view_by => l_view_by,

Line 61: poa_dbi_sutil_pkg.process_parameters(

57: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
58: --
59: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
60: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM' or l_sec_context = 'SUPPLIER')then
61: poa_dbi_sutil_pkg.process_parameters(
62: p_param => p_param,
63: p_view_by => l_view_by,
64: p_view_by_col_name => l_view_by_col,
65: p_view_by_value => l_view_by_value,

Line 109: poa_dbi_sutil_pkg.process_parameters(

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

Line 142: poa_dbi_sutil_pkg.process_parameters(

138: end if;
139: end loop;
140:
141: if(l_use_only_agg_mv = 'N') then
142: poa_dbi_sutil_pkg.process_parameters(
143: p_param => p_param,
144: p_view_by => l_view_by,
145: p_view_by_col_name => l_view_by_col,
146: p_view_by_value => l_view_by_value,

Line 232: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

228:
229:
230: FUNCTION get_status_filter_where return VARCHAR2
231: IS
232: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
233: BEGIN
234: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
235: l_col_tbl.extend;
236: l_col_tbl(1) := 'POA_MEASURE1';

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

230: FUNCTION get_status_filter_where return VARCHAR2
231: IS
232: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
233: BEGIN
234: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
235: l_col_tbl.extend;
236: l_col_tbl(1) := 'POA_MEASURE1';
237: l_col_tbl.extend;
238: l_col_tbl(2) := 'POA_PERCENT1';

Line 244: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

240: l_col_tbl(3) := 'POA_MEASURE2';
241: l_col_tbl.extend;
242: l_col_tbl(4) := 'POA_PERCENT2';
243:
244: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
245:
246: END;
247:
248:

Line 260: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

256: ,p_to_date_type IN VARCHAR2
257: ,p_sec_context IN VARCHAR2) RETURN VARCHAR2 IS
258: l_sel_clause VARCHAR2(10000);
259: BEGIN
260: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
261: ,'PO'
262: ,'6.0');
263: IF(p_view_by_dim = 'ITEM+POA_ITEMS') THEN
264: l_sel_clause := l_sel_clause || ' v.description POA_ATTRIBUTE1, --Description

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

388: BEGIN
389: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
390: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
391:
392: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
393: if(l_sec_context = 'OU' or l_sec_context = 'OU/COM' or l_sec_context = 'SUPPLIER' ) then
394: poa_dbi_sutil_pkg.process_parameters(
395: p_param => p_param,
396: p_view_by => l_view_by,

Line 394: poa_dbi_sutil_pkg.process_parameters(

390: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
391:
392: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
393: if(l_sec_context = 'OU' or l_sec_context = 'OU/COM' or l_sec_context = 'SUPPLIER' ) then
394: poa_dbi_sutil_pkg.process_parameters(
395: p_param => p_param,
396: p_view_by => l_view_by,
397: p_view_by_col_name => l_view_by_col_name,
398: p_view_by_value => l_view_by_value,

Line 436: poa_dbi_sutil_pkg.process_parameters(

432: ,p_use_grpid => 'N'
433: ,p_in_join_tables => l_in_join_tbl);
434:
435: elsif(l_sec_context = 'COMP') then
436: poa_dbi_sutil_pkg.process_parameters(
437: p_param => p_param,
438: p_view_by => l_view_by,
439: p_view_by_col_name => l_view_by_col_name,
440: p_view_by_value => l_view_by_value,

Line 468: poa_dbi_sutil_pkg.process_parameters(

464: end if;
465: end loop;
466:
467: if(l_use_only_agg_mv = 'N') then
468: poa_dbi_sutil_pkg.process_parameters(
469: p_param => p_param,
470: p_view_by => l_view_by,
471: p_view_by_col_name => l_view_by_col_name,
472: p_view_by_value => l_view_by_value,