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

Line 53: poa_dbi_sutil_pkg.process_parameters(P_PARAM => p_param

49: BEGIN
50: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
51: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
52:
53: poa_dbi_sutil_pkg.process_parameters(P_PARAM => p_param
54: ,P_VIEW_BY => l_view_by
55: ,P_VIEW_BY_COL_NAME => l_view_by_col
56: ,P_VIEW_BY_VALUE => l_view_by_value
57: ,P_COMPARISON_TYPE => l_comparison_type

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

69: ,P_FUNC_AREA => 'PO'
70: ,P_VERSION => '6.0'
71: ,P_ROLE => 'COM'
72: ,P_MV_SET => 'RTX');
73: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
74: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN
75: l_to_date_type := 'RLX';
76: ELSE
77: l_to_date_type := 'XTD';

Line 141: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

137: END status_sql;
138:
139: FUNCTION get_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
140: IS
141: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
142: BEGIN
143: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
144: l_col_tbl.extend;
145: l_col_tbl(1) := 'POA_MEASURE3';

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

139: FUNCTION get_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
140: IS
141: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
142: BEGIN
143: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
144: l_col_tbl.extend;
145: l_col_tbl(1) := 'POA_MEASURE3';
146: l_col_tbl.extend;
147: l_col_tbl(2) := 'POA_PERCENT1';

Line 164: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

160: l_col_tbl(8) := 'POA_MEASURE1';
161: l_col_tbl.extend;
162: l_col_tbl(9) := 'POA_MEASURE2';
163: end if;
164: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
165:
166: END;
167:
168:

Line 178: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(P_VIEWBY => p_view_by_dim

174: ,p_view_by_col IN VARCHAR2
175: ,p_url IN VARCHAR2) RETURN VARCHAR2 IS
176: l_sel_clause VARCHAR2(8000);
177: BEGIN
178: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(P_VIEWBY => p_view_by_dim
179: ,P_FUNC_AREA => 'PO'
180: ,P_VERSION => '6.0');
181: IF(p_view_by_dim = 'ITEM+POA_ITEMS') THEN
182: l_sel_clause := l_sel_clause || '

Line 299: poa_dbi_sutil_pkg.process_parameters(p_param => p_param

295: BEGIN
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 => p_param
300: ,p_view_by => l_view_by
301: ,p_view_by_col_name => l_view_by_col
302: ,p_view_by_value => l_view_by_value
303: ,p_comparison_type => l_comparison_type

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

316: ,p_version => '6.0'
317: ,p_role => 'COM'
318: ,p_mv_set => 'RTX');
319: --
320: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
321: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN
322: l_to_date_type := 'RLX';
323: ELSE
324: l_to_date_type := 'XTD';

Line 350: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

346:
347:
348: FUNCTION get_reason_filter_where return VARCHAR2
349: IS
350: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
351: BEGIN
352: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
353: l_col_tbl.extend;
354: l_col_tbl(1) := 'POA_MEASURE1';

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

348: FUNCTION get_reason_filter_where return VARCHAR2
349: IS
350: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
351: BEGIN
352: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
353: l_col_tbl.extend;
354: l_col_tbl(1) := 'POA_MEASURE1';
355: l_col_tbl.extend;
356: l_col_tbl(2) := 'POA_PERCENT1';

Line 360: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

356: l_col_tbl(2) := 'POA_PERCENT1';
357: l_col_tbl.extend;
358: l_col_tbl(3) := 'POA_PERCENT2';
359:
360: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
361:
362: END;
363:
364:

Line 374: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(P_VIEWBY => p_view_by_dim

370: ,p_url IN VARCHAR2) RETURN VARCHAR2
371: IS
372: l_sel_clause VARCHAR2(4000);
373: BEGIN
374: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(P_VIEWBY => p_view_by_dim
375: ,P_FUNC_AREA => 'PO'
376: ,P_VERSION => '6.0');
377: --
378: l_sel_clause := l_sel_clause || 'oset.reason_id POA_ATTRIBUTE1,' ;