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

Line 42: poa_dbi_sutil_pkg.process_parameters(p_param

38:
39: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
40: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
41:
42: poa_dbi_sutil_pkg.process_parameters(p_param
43: ,l_view_by
44: ,l_view_by_col
45: ,l_view_by_value
46: ,l_comparison_type

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

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

Line 130: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

126:
127:
128: FUNCTION get_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
129: IS
130: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
131: BEGIN
132: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
133: l_col_tbl.extend;
134: l_col_tbl(1) := 'POA_MEASURE1';

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

128: FUNCTION get_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
129: IS
130: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
131: BEGIN
132: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
133: l_col_tbl.extend;
134: l_col_tbl(1) := 'POA_MEASURE1';
135: l_col_tbl.extend;
136: l_col_tbl(2) := 'POA_MEASURE2';

Line 158: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

154: l_col_tbl(9) := 'POA_MEASURE5';
155: end if;
156:
157:
158: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
159:
160: END;
161:
162: FUNCTION get_status_sel_clause(p_view_by_dim in VARCHAR2

Line 169: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

165: l_sel_clause varchar2(8000);
166: --
167: BEGIN
168: --
169: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
170: ,'PO'
171: ,'6.0');
172: --
173: if(p_view_by_dim = 'ITEM+POA_ITEMS') then

Line 299: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value,l_comparison_type,l_xtd,l_as_of_date,l_prev_as_of_date,l_cur_suffix,l_nested_pattern,l_where_clause,l_mv,l_join_tbl,l_in_join_tbl,

295:
296: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
297: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
298:
299: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value,l_comparison_type,l_xtd,l_as_of_date,l_prev_as_of_date,l_cur_suffix,l_nested_pattern,l_where_clause,l_mv,l_join_tbl,l_in_join_tbl,
300: x_custom_output,
301: 'N','PO', '6.0', 'COM','RTX');
302:
303: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);

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

299: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value,l_comparison_type,l_xtd,l_as_of_date,l_prev_as_of_date,l_cur_suffix,l_nested_pattern,l_where_clause,l_mv,l_join_tbl,l_in_join_tbl,
300: x_custom_output,
301: 'N','PO', '6.0', 'COM','RTX');
302:
303: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
304: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN
305: l_to_date_type := 'RLX';
306: ELSE
307: l_to_date_type := 'XTD';

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

339: l_sel_clause varchar2(4000);
340:
341: BEGIN
342:
343: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim,'PO','6.0');
344:
345: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
346: l_sel_clause := l_sel_clause || '
347: v.description POA_ATTRIBUTE1, --Description

Line 430: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

426:
427:
428: FUNCTION get_retdist_filter_where(p_view_by IN VARCHAR2) 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_retdist_filter_where(p_view_by IN VARCHAR2) 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_MEASURE9';

Line 450: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

446: if(p_view_by = 'ITEM+POA_ITEMS') then
447: l_col_tbl.extend;
448: l_col_tbl(7) := 'POA_MEASURE14';
449: end if;
450: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
451:
452: END;
453:
454: PROCEDURE trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

Line 509: poa_dbi_sutil_pkg.process_parameters(p_param,

505: BEGIN
506: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
507: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
508:
509: poa_dbi_sutil_pkg.process_parameters(p_param,
510: l_view_by,
511: l_view_by_col_name,
512: l_view_by_value,
513: l_comparison_type,

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

525: 'PO',
526: '6.0',
527: 'COM',
528: 'RTX');
529: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
530: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN
531: l_to_date_type := 'RLX';
532: ELSE
533: l_to_date_type := 'XTD';

Line 594: poa_dbi_sutil_pkg.process_parameters(p_param,

590:
591: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
592: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
593:
594: poa_dbi_sutil_pkg.process_parameters(p_param,
595: l_view_by,
596: l_view_by_col_name,
597: l_view_by_value,
598: l_comparison_type,

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

610: 'PO',
611: '6.0',
612: 'COM',
613: 'RTX');
614: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
615: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN
616: l_to_date_type := 'RLX';
617: ELSE
618: l_to_date_type := 'XTD';

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

620:
621: poa_dbi_util_pkg.add_column(l_col_tbl, 'amt_return_' || l_cur_suffix, 'amt_return','Y',3,p_to_date_type => l_to_date_type);
622: poa_dbi_util_pkg.add_column(l_col_tbl,'num_txns_return_cnt','cnt_return','Y',3, p_to_date_type => l_to_date_type);
623:
624: l_query := poa_dbi_sutil_pkg.get_viewby_select_clause(l_view_by, 'PO','6.0');
625:
626: l_query := l_query || '
627: oset.POA_MEASURE1 POA_MEASURE1, -- Return Amount
628: oset.POA_MEASURE2 poa_measure2, -- Prior Return Amount