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

Line 42: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value, l_comparison_type,

38: BEGIN
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,l_view_by,l_view_by_col,l_view_by_value, l_comparison_type,
43: l_xtd, l_as_of_date, l_prev_as_of_date, l_cur_suffix, l_nested_pattern,
44: l_where_clause, l_mv, l_join_tbl, l_in_join_tbl,
45: x_custom_output,'N','AP','5.0','VPP','MID');
46:

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

44: l_where_clause, l_mv, l_join_tbl, l_in_join_tbl,
45: x_custom_output,'N','AP','5.0','VPP','MID');
46:
47: /* Get the Context Code of the Dashboard and set the Period Type to be XTD or Rolling */
48: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
49: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN
50: l_to_date_type := 'RLX';
51: ELSE
52: l_to_date_type := 'XTD';

Line 103: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value,l_comparison_type,

99: BEGIN
100: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
101: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
102:
103: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value,l_comparison_type,
104: l_xtd, l_as_of_date, l_prev_as_of_date, l_cur_suffix, l_nested_pattern,
105: l_where_clause, l_mv, l_join_tbl, l_in_join_tbl,x_custom_output,
106: 'Y','AP','5.0','VPP','MID');
107: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);

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

103: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value,l_comparison_type,
104: l_xtd, l_as_of_date, l_prev_as_of_date, l_cur_suffix, l_nested_pattern,
105: l_where_clause, l_mv, l_join_tbl, l_in_join_tbl,x_custom_output,
106: 'Y','AP','5.0','VPP','MID');
107: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
108: /* Get the Context Code of the Dashboard and set the Period Type to be XTD or Rolling */
109: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN
110: l_to_date_type := 'RLX';
111: ELSE

Line 159: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value,l_comparison_type,

155: BEGIN
156: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
157: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
158:
159: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value,l_comparison_type,
160: l_xtd, l_as_of_date, l_prev_as_of_date, l_cur_suffix, l_nested_pattern,
161: l_where_clause, l_mv, l_join_tbl, l_in_join_tbl,x_custom_output,
162: 'N','AP', '5.0', 'VPP','MID');
163: /* Get the Context Code of the Dashboard and set the Period Type to be XTD or Rolling */

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

160: l_xtd, l_as_of_date, l_prev_as_of_date, l_cur_suffix, l_nested_pattern,
161: l_where_clause, l_mv, l_join_tbl, l_in_join_tbl,x_custom_output,
162: 'N','AP', '5.0', 'VPP','MID');
163: /* Get the Context Code of the Dashboard and set the Period Type to be XTD or Rolling */
164: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
165: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN
166: l_to_date_type := 'RLX';
167: ELSE
168: l_to_date_type := 'XTD';

Line 203: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

199:
200:
201: FUNCTION get_kpi_filter_where return VARCHAR2
202: IS
203: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
204: BEGIN
205: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
206: l_col_tbl.extend;
207: l_col_tbl(1) := 'POA_PERCENT2';

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

201: FUNCTION get_kpi_filter_where return VARCHAR2
202: IS
203: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
204: BEGIN
205: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
206: l_col_tbl.extend;
207: l_col_tbl(1) := 'POA_PERCENT2';
208: l_col_tbl.extend;
209: l_col_tbl(2) := 'POA_PERCENT1';

Line 211: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

207: l_col_tbl(1) := 'POA_PERCENT2';
208: l_col_tbl.extend;
209: l_col_tbl(2) := 'POA_PERCENT1';
210:
211: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
212:
213: END;
214:
215:

Line 219: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

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

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

217: FUNCTION get_status_filter_where return VARCHAR2
218: IS
219: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
220: BEGIN
221: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
222: l_col_tbl.extend;
223: l_col_tbl(1) := 'POA_MEASURE1';
224: l_col_tbl.extend;
225: l_col_tbl(2) := 'POA_PERCENT2';

Line 231: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

227: l_col_tbl(3) := 'POA_PERCENT1';
228: l_col_tbl.extend;
229: l_col_tbl(4) := 'POA_MEASURE3';
230:
231: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
232:
233: END;
234:
235: