APPS.ISC_DBI_OT_ARR_RT_TR_PKG dependencies on ISC_DBI_SUTIL_PKG

Line 51: isc_dbi_sutil_pkg.process_parameters (

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

Line 146: ' || isc_dbi_sutil_pkg.change_str (

142: l_sel_clause :=
143: 'SELECT
144: ' || ' cal.name VIEWBY,
145: nvl(c_trip_arrivals,0) ISC_MEASURE_1,
146: ' || isc_dbi_sutil_pkg.change_str (
147: p_new_numerator => 'c_trip_arrivals',
148: p_old_numerator => 'p_trip_arrivals',
149: p_denominator => 'p_trip_arrivals',
150: p_measure_name => 'ISC_MEASURE_2') || ', -- Trip Arrivals Change

Line 153: ' || isc_dbi_sutil_pkg.change_str (

149: p_denominator => 'p_trip_arrivals',
150: p_measure_name => 'ISC_MEASURE_2') || ', -- Trip Arrivals Change
151: nvl(p_stop_arrivals,0) ISC_MEASURE_3,
152: nvl(c_stop_arrivals,0) ISC_MEASURE_4,
153: ' || isc_dbi_sutil_pkg.change_str (
154: p_new_numerator => 'c_stop_arrivals',
155: p_old_numerator => 'p_stop_arrivals',
156: p_denominator => 'p_stop_arrivals',
157: p_measure_name => 'ISC_MEASURE_5') || ', -- Trip Stop Arrivals Change

Line 160: ' || isc_dbi_sutil_pkg.change_str (

156: p_denominator => 'p_stop_arrivals',
157: p_measure_name => 'ISC_MEASURE_5') || ', -- Trip Stop Arrivals Change
158: nvl(p_ot_arrivals,0) ISC_MEASURE_8,
159: nvl(c_ot_arrivals,0) ISC_MEASURE_6,
160: ' || isc_dbi_sutil_pkg.change_str (
161: p_new_numerator => 'c_trip_arrivals',
162: p_old_numerator => 'p_trip_arrivals',
163: p_denominator => 'p_trip_arrivals',
164: p_measure_name => 'ISC_MEASURE_7') || ', -- On-Time Trip Stop Arrivals Change

Line 165: ' || isc_dbi_sutil_pkg.rate_str (

161: p_new_numerator => 'c_trip_arrivals',
162: p_old_numerator => 'p_trip_arrivals',
163: p_denominator => 'p_trip_arrivals',
164: p_measure_name => 'ISC_MEASURE_7') || ', -- On-Time Trip Stop Arrivals Change
165: ' || isc_dbi_sutil_pkg.rate_str (
166: p_numerator => 'p_ot_arrivals',
167: p_denominator => 'p_stop_arrivals',
168: p_rate_type => 'PERCENT',
169: p_measure_name => 'ISC_MEASURE_9') || ', -- OT Arrival Rate Prior

Line 170: ' || isc_dbi_sutil_pkg.rate_str (

166: p_numerator => 'p_ot_arrivals',
167: p_denominator => 'p_stop_arrivals',
168: p_rate_type => 'PERCENT',
169: p_measure_name => 'ISC_MEASURE_9') || ', -- OT Arrival Rate Prior
170: ' || isc_dbi_sutil_pkg.rate_str (
171: p_numerator => 'c_ot_arrivals',
172: p_denominator => 'c_stop_arrivals',
173: p_rate_type => 'PERCENT',
174: p_measure_name => 'ISC_MEASURE_10') || ', -- OT Arrival Rate

Line 175: ' || isc_dbi_sutil_pkg.change_rate_str (

171: p_numerator => 'c_ot_arrivals',
172: p_denominator => 'c_stop_arrivals',
173: p_rate_type => 'PERCENT',
174: p_measure_name => 'ISC_MEASURE_10') || ', -- OT Arrival Rate
175: ' || isc_dbi_sutil_pkg.change_rate_str (
176: p_new_numerator => 'c_ot_arrivals',
177: p_new_denominator => 'c_stop_arrivals',
178: p_old_numerator => 'p_ot_arrivals',
179: p_old_denominator => 'p_stop_arrivals',