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

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

18: BEGIN
19: l_in_join_tables := '';
20: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
21:
22: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
23: if(l_sec_context = 'OU' or l_sec_context = 'OU/COM') then
24: poa_dbi_sutil_pkg.drill_process_parameters(
25: p_param => p_param,
26: p_cur_suffix => l_cur_suffix,

Line 24: poa_dbi_sutil_pkg.drill_process_parameters(

20: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
21:
22: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
23: if(l_sec_context = 'OU' or l_sec_context = 'OU/COM') then
24: poa_dbi_sutil_pkg.drill_process_parameters(
25: p_param => p_param,
26: p_cur_suffix => l_cur_suffix,
27: p_where_clause => l_where_clause,
28: p_in_join_tbl => l_in_join_tbl,

Line 34: poa_dbi_sutil_pkg.drill_process_parameters(

30: p_version => '6.0',
31: p_role => 'COM',
32: p_mv_set => 'PODCUT');
33: elsif(l_sec_context = 'COMP') then
34: poa_dbi_sutil_pkg.drill_process_parameters(
35: p_param => p_param,
36: p_cur_suffix => l_cur_suffix,
37: p_where_clause => l_where_clause,
38: p_in_join_tbl => l_in_join_tbl,

Line 147: poa_dbi_sutil_pkg.bind_com_cc_values(x_custom_output, p_param);

143:
144: x_custom_sql := l_query;
145: poa_dbi_util_pkg.get_custom_status_binds(x_custom_output);
146: if(l_sec_context = 'COMP')then
147: poa_dbi_sutil_pkg.bind_com_cc_values(x_custom_output, p_param);
148: end if;
149: end;
150:
151:

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

162: BEGIN
163: l_in_join_tables := '';
164: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
165:
166: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
167: if(l_sec_context = 'OU' or l_sec_context = 'OU/COM') then
168: poa_dbi_sutil_pkg.drill_process_parameters(
169: p_param => p_param,
170: p_cur_suffix => l_cur_suffix,

Line 168: poa_dbi_sutil_pkg.drill_process_parameters(

164: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
165:
166: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
167: if(l_sec_context = 'OU' or l_sec_context = 'OU/COM') then
168: poa_dbi_sutil_pkg.drill_process_parameters(
169: p_param => p_param,
170: p_cur_suffix => l_cur_suffix,
171: p_where_clause => l_where_clause,
172: p_in_join_tbl => l_in_join_tbl,

Line 178: poa_dbi_sutil_pkg.drill_process_parameters(

174: p_version => '6.0',
175: p_role => 'COM',
176: p_mv_set => 'PODCUT');
177: elsif (l_sec_context = 'COMP') then
178: poa_dbi_sutil_pkg.drill_process_parameters(
179: p_param => p_param,
180: p_cur_suffix => l_cur_suffix,
181: p_where_clause => l_where_clause,
182: p_in_join_tbl => l_in_join_tbl,

Line 259: poa_dbi_sutil_pkg.bind_com_cc_values(x_custom_output, p_param);

255:
256: x_custom_sql := l_query;
257: poa_dbi_util_pkg.get_custom_status_binds(x_custom_output);
258: if(l_sec_context = 'COMP')then
259: poa_dbi_sutil_pkg.bind_com_cc_values(x_custom_output, p_param);
260: end if;
261: end;
262:
263: PROCEDURE pcl_drill_rpt_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

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

273: BEGIN
274: l_in_join_tables := '';
275: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
276:
277: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
278: if(l_sec_context = 'OU' or l_sec_context = 'OU/COM') then
279: poa_dbi_sutil_pkg.drill_process_parameters(
280: p_param => p_param,
281: p_cur_suffix => l_cur_suffix,

Line 279: poa_dbi_sutil_pkg.drill_process_parameters(

275: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
276:
277: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
278: if(l_sec_context = 'OU' or l_sec_context = 'OU/COM') then
279: poa_dbi_sutil_pkg.drill_process_parameters(
280: p_param => p_param,
281: p_cur_suffix => l_cur_suffix,
282: p_where_clause => l_where_clause,
283: p_in_join_tbl => l_in_join_tbl,

Line 289: poa_dbi_sutil_pkg.drill_process_parameters(

285: p_version => '6.0',
286: p_role => 'COM',
287: p_mv_set => 'PODCUT');
288: elsif(l_sec_context = 'COMP') then
289: poa_dbi_sutil_pkg.drill_process_parameters(
290: p_param => p_param,
291: p_cur_suffix => l_cur_suffix,
292: p_where_clause => l_where_clause,
293: p_in_join_tbl => l_in_join_tbl,

Line 398: poa_dbi_sutil_pkg.bind_com_cc_values(x_custom_output, p_param);

394:
395: x_custom_sql := l_query;
396: poa_dbi_util_pkg.get_custom_status_binds(x_custom_output);
397: if(l_sec_context = 'COMP')then
398: poa_dbi_sutil_pkg.bind_com_cc_values(x_custom_output, p_param);
399: end if;
400: end;
401:
402: FUNCTION get_con_dtl_filter_where return VARCHAR2

Line 404: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

400: end;
401:
402: FUNCTION get_con_dtl_filter_where return VARCHAR2
403: IS
404: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
405: BEGIN
406: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
407: l_col_tbl.extend;
408: l_col_tbl(1) := 'POA_MEASURE1';

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

402: FUNCTION get_con_dtl_filter_where return VARCHAR2
403: IS
404: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
405: BEGIN
406: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
407: l_col_tbl.extend;
408: l_col_tbl(1) := 'POA_MEASURE1';
409: l_col_tbl.extend;
410: l_col_tbl(2) := 'POA_MEASURE2';

Line 411: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

407: l_col_tbl.extend;
408: l_col_tbl(1) := 'POA_MEASURE1';
409: l_col_tbl.extend;
410: l_col_tbl(2) := 'POA_MEASURE2';
411: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
412:
413: END;
414:
415: FUNCTION get_ncp_dtl_filter_where return VARCHAR2

Line 417: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

413: END;
414:
415: FUNCTION get_ncp_dtl_filter_where return VARCHAR2
416: IS
417: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
418: BEGIN
419: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
420: l_col_tbl.extend;
421: l_col_tbl(1) := 'POA_MEASURE1';

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

415: FUNCTION get_ncp_dtl_filter_where return VARCHAR2
416: IS
417: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
418: BEGIN
419: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
420: l_col_tbl.extend;
421: l_col_tbl(1) := 'POA_MEASURE1';
422: l_col_tbl.extend;
423: l_col_tbl(2) := 'POA_MEASURE2';

Line 424: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

420: l_col_tbl.extend;
421: l_col_tbl(1) := 'POA_MEASURE1';
422: l_col_tbl.extend;
423: l_col_tbl(2) := 'POA_MEASURE2';
424: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
425:
426: END;
427:
428: FUNCTION get_pcl_dtl_filter_where return VARCHAR2

Line 430: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

426: END;
427:
428: FUNCTION get_pcl_dtl_filter_where return VARCHAR2
429: IS
430: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
431: BEGIN
432: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
433: l_col_tbl.extend;
434: l_col_tbl(1) := 'POA_MEASURE1';

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

428: FUNCTION get_pcl_dtl_filter_where return VARCHAR2
429: IS
430: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
431: BEGIN
432: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
433: l_col_tbl.extend;
434: l_col_tbl(1) := 'POA_MEASURE1';
435: l_col_tbl.extend;
436: l_col_tbl(2) := 'POA_MEASURE2';

Line 439: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

435: l_col_tbl.extend;
436: l_col_tbl(2) := 'POA_MEASURE2';
437: l_col_tbl.extend;
438: l_col_tbl(3) := 'POA_MEASURE3';
439: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
440:
441: END;
442:
443: