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.ISC_DBI_OT_ARR_RT_PKG dependencies on ISC_DBI_SUTIL_PKG

Line 52: isc_dbi_sutil_pkg.process_parameters (

48: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
49: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
50:
51: -- get all the query parameters
52: isc_dbi_sutil_pkg.process_parameters (
53: p_param => p_param,
54: p_view_by => l_view_by,
55: p_view_by_col_name => l_view_by_col,
56: p_comparison_type => l_comparison_type,

Line 168: l_view_by_col_name := isc_dbi_sutil_pkg.get_view_by_col_name (p_view_by_dim);

164:
165: -- initialization block
166:
167: -- Column to get view by column name
168: l_view_by_col_name := isc_dbi_sutil_pkg.get_view_by_col_name (p_view_by_dim);
169:
170: -- fact column view by's
171: l_view_by_fact_col := isc_dbi_sutil_pkg.get_fact_select_columns (p_join_tbl);
172:

Line 171: l_view_by_fact_col := isc_dbi_sutil_pkg.get_fact_select_columns (p_join_tbl);

167: -- Column to get view by column name
168: l_view_by_col_name := isc_dbi_sutil_pkg.get_view_by_col_name (p_view_by_dim);
169:
170: -- fact column view by's
171: l_view_by_fact_col := isc_dbi_sutil_pkg.get_fact_select_columns (p_join_tbl);
172:
173: -- Outer select clause
174: l_sel_clause :=
175: 'SELECT

Line 176: ' || isc_dbi_sutil_pkg.get_view_by_select_clause (p_view_by_dim)

172:
173: -- Outer select clause
174: l_sel_clause :=
175: 'SELECT
176: ' || isc_dbi_sutil_pkg.get_view_by_select_clause (p_view_by_dim)
177: || 'oset.ISC_MEASURE_1 ISC_MEASURE_1,
178: ' || 'oset.ISC_MEASURE_2 ISC_MEASURE_2,
179: ' || 'oset.ISC_MEASURE_3 ISC_MEASURE_3,
180: ' || 'oset.ISC_MEASURE_4 ISC_MEASURE_4,

Line 221: ' || isc_dbi_sutil_pkg.change_str (

217: nvl(c_stop_arrivals_total,0) ISC_MEASURE_14,
218: nvl(c_early_arrivals_total,0) ISC_MEASURE_16,
219: nvl(c_late_arrivals_total,0) ISC_MEASURE_17,
220: nvl(c_ot_arrivals_total,0) ISC_MEASURE_18,
221: ' || isc_dbi_sutil_pkg.change_str (
222: p_new_numerator => 'c_trip_arrivals',
223: p_old_numerator => 'p_trip_arrivals',
224: p_denominator => 'p_trip_arrivals',
225: p_measure_name => 'ISC_MEASURE_2') || ', -- Trip Arrivals Change

Line 226: ' || isc_dbi_sutil_pkg.change_str (

222: p_new_numerator => 'c_trip_arrivals',
223: p_old_numerator => 'p_trip_arrivals',
224: p_denominator => 'p_trip_arrivals',
225: p_measure_name => 'ISC_MEASURE_2') || ', -- Trip Arrivals Change
226: ' || isc_dbi_sutil_pkg.change_str (
227: p_new_numerator => 'c_stop_arrivals',
228: p_old_numerator => 'p_stop_arrivals',
229: p_denominator => 'p_stop_arrivals',
230: p_measure_name => 'ISC_MEASURE_5') || ', -- Trip Stop Arrivals Change

Line 231: ' || isc_dbi_sutil_pkg.rate_str (

227: p_new_numerator => 'c_stop_arrivals',
228: p_old_numerator => 'p_stop_arrivals',
229: p_denominator => 'p_stop_arrivals',
230: p_measure_name => 'ISC_MEASURE_5') || ', -- Trip Stop Arrivals Change
231: ' || isc_dbi_sutil_pkg.rate_str (
232: p_numerator => 'p_ot_arrivals',
233: p_denominator => 'p_stop_arrivals',
234: p_rate_type => 'PERCENT',
235: p_measure_name => 'ISC_MEASURE_9') || ', -- OT Arrival Rate Prior

Line 236: ' || isc_dbi_sutil_pkg.rate_str (

232: p_numerator => 'p_ot_arrivals',
233: p_denominator => 'p_stop_arrivals',
234: p_rate_type => 'PERCENT',
235: p_measure_name => 'ISC_MEASURE_9') || ', -- OT Arrival Rate Prior
236: ' || isc_dbi_sutil_pkg.rate_str (
237: p_numerator => 'p_ot_arrivals_total',
238: p_denominator => 'p_stop_arrivals_total',
239: p_rate_type => 'PERCENT',
240: p_measure_name => 'ISC_MEASURE_22') || ', -- Grand OT Arrival Rate Prior

Line 241: ' || isc_dbi_sutil_pkg.rate_str (

237: p_numerator => 'p_ot_arrivals_total',
238: p_denominator => 'p_stop_arrivals_total',
239: p_rate_type => 'PERCENT',
240: p_measure_name => 'ISC_MEASURE_22') || ', -- Grand OT Arrival Rate Prior
241: ' || isc_dbi_sutil_pkg.rate_str (
242: p_numerator => 'c_ot_arrivals',
243: p_denominator => 'c_stop_arrivals',
244: p_rate_type => 'PERCENT',
245: p_measure_name => 'ISC_MEASURE_10') || ', -- OT Arrival Rate

Line 246: ' || isc_dbi_sutil_pkg.change_rate_str (

242: p_numerator => 'c_ot_arrivals',
243: p_denominator => 'c_stop_arrivals',
244: p_rate_type => 'PERCENT',
245: p_measure_name => 'ISC_MEASURE_10') || ', -- OT Arrival Rate
246: ' || isc_dbi_sutil_pkg.change_rate_str (
247: p_new_numerator => 'c_ot_arrivals',
248: p_new_denominator => 'c_stop_arrivals',
249: p_old_numerator => 'p_ot_arrivals',
250: p_old_denominator => 'p_stop_arrivals',

Line 253: ' || isc_dbi_sutil_pkg.change_str (

249: p_old_numerator => 'p_ot_arrivals',
250: p_old_denominator => 'p_stop_arrivals',
251: p_rate_type => 'PERCENT',
252: p_measure_name => 'ISC_MEASURE_11') || ', -- OT Arrival Rate Change
253: ' || isc_dbi_sutil_pkg.change_str (
254: p_new_numerator => 'c_trip_arrivals_total',
255: p_old_numerator => 'p_trip_arrivals_total',
256: p_denominator => 'p_trip_arrivals_total',
257: p_measure_name => 'ISC_MEASURE_13') || ', -- Grand Total Trip Arrivals Change

Line 258: ' || isc_dbi_sutil_pkg.change_str (

254: p_new_numerator => 'c_trip_arrivals_total',
255: p_old_numerator => 'p_trip_arrivals_total',
256: p_denominator => 'p_trip_arrivals_total',
257: p_measure_name => 'ISC_MEASURE_13') || ', -- Grand Total Trip Arrivals Change
258: ' || isc_dbi_sutil_pkg.change_str (
259: p_new_numerator => 'c_stop_arrivals_total',
260: p_old_numerator => 'p_stop_arrivals_total',
261: p_denominator => 'p_stop_arrivals_total',
262: p_measure_name => 'ISC_MEASURE_15') || ', -- Grand Total Trip Stop Arrivals Change

Line 263: ' || isc_dbi_sutil_pkg.rate_str (

259: p_new_numerator => 'c_stop_arrivals_total',
260: p_old_numerator => 'p_stop_arrivals_total',
261: p_denominator => 'p_stop_arrivals_total',
262: p_measure_name => 'ISC_MEASURE_15') || ', -- Grand Total Trip Stop Arrivals Change
263: ' || isc_dbi_sutil_pkg.rate_str (
264: p_numerator => 'c_ot_arrivals_total',
265: p_denominator => 'c_stop_arrivals_total',
266: p_rate_type => 'PERCENT',
267: p_measure_name => 'ISC_MEASURE_19') || ', -- Grand Total OT Arrival Rate

Line 268: ' || isc_dbi_sutil_pkg.change_rate_str (

264: p_numerator => 'c_ot_arrivals_total',
265: p_denominator => 'c_stop_arrivals_total',
266: p_rate_type => 'PERCENT',
267: p_measure_name => 'ISC_MEASURE_19') || ', -- Grand Total OT Arrival Rate
268: ' || isc_dbi_sutil_pkg.change_rate_str (
269: p_new_numerator => 'c_ot_arrivals_total',
270: p_new_denominator => 'c_stop_arrivals_total',
271: p_old_numerator => 'p_ot_arrivals_total',
272: p_old_denominator => 'p_stop_arrivals_total',