APPS.POA_DBI_PC_PKG dependencies on POA_DBI_SUTIL_PKG

Line 40: poa_dbi_sutil_pkg.process_parameters(p_param

36: l_to_date_type VARCHAR2(10);
37: BEGIN
38: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
39: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
40: poa_dbi_sutil_pkg.process_parameters(p_param
41: ,l_view_by
42: ,l_view_by_col
43: ,l_view_by_value
44: ,l_comparison_type

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

56: ,'PO'
57: ,'6.0'
58: ,'COM'
59: ,'PQC');
60: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
61: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN
62: l_to_date_type := 'RLX';
63: ELSE
64: l_to_date_type := 'XTD';

Line 107: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

103: END;
104:
105: FUNCTION get_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
106: IS
107: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
108: BEGIN
109: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
110: l_col_tbl.extend;
111: l_col_tbl(1) := 'POA_MEASURE1';

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

105: FUNCTION get_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
106: IS
107: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
108: BEGIN
109: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
110: l_col_tbl.extend;
111: l_col_tbl(1) := 'POA_MEASURE1';
112: l_col_tbl.extend;
113: l_col_tbl(2) := 'POA_PERCENT2';

Line 125: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

121: l_col_tbl(5) := 'POA_MEASURE12';
122: end if;
123:
124:
125: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
126:
127: END;
128:
129:

Line 137: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim,

133: IS
134: l_sel_clause VARCHAR2(8000);
135: l_view_by_col_name VARCHAR2(40);
136: BEGIN
137: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim,
138: 'PO', '6.0');
139:
140: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
141: l_sel_clause := l_sel_clause ||' v.description POA_ATTRIBUTE1,

Line 216: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

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

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

214: FUNCTION get_dtl_filter_where return VARCHAR2
215: IS
216: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
217: BEGIN
218: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
219: l_col_tbl.extend;
220: l_col_tbl(1) := 'POA_MEASURE1';
221: l_col_tbl.extend;
222: l_col_tbl(2) := 'POA_MEASURE3';

Line 230: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

226: l_col_tbl(4) := 'POA_MEASURE5';
227: l_col_tbl.extend;
228: l_col_tbl(5) := 'POA_MEASURE6';
229:
230: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
231:
232: END;
233:
234: PROCEDURE dtl_rpt_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

Line 248: poa_dbi_sutil_pkg.drill_process_parameters(p_param, l_cur_suffix, l_where_clause, l_in_join_tbl, 'PO', '6.0', 'COM','PQC');

244: BEGIN
245:
246: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
247:
248: poa_dbi_sutil_pkg.drill_process_parameters(p_param, l_cur_suffix, l_where_clause, l_in_join_tbl, 'PO', '6.0', 'COM','PQC');
249:
250: IF(l_in_join_tbl is not null) then
251:
252: FOR i in 1 .. l_in_join_tbl.COUNT