APPS.ISC_DBI_FR_COST_PER_D_TR_PKG dependencies on ISC_DBI_SUTIL_PKG

Line 53: isc_dbi_sutil_pkg.process_parameters (

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

Line 165: ' || isc_dbi_sutil_pkg.change_str (

161: 'SELECT
162: ' || ' cal.name VIEWBY,
163: nvl(p_freight_cost,0) ISC_MEASURE_9,
164: nvl(c_freight_cost,0) ISC_MEASURE_1,
165: ' || isc_dbi_sutil_pkg.change_str (
166: p_new_numerator => 'c_freight_cost',
167: p_old_numerator => 'p_freight_cost',
168: p_denominator => 'p_freight_cost',
169: p_measure_name => 'ISC_MEASURE_2') || ', -- Rated Fr Cost Change

Line 172: ' || isc_dbi_sutil_pkg.change_str (

168: p_denominator => 'p_freight_cost',
169: p_measure_name => 'ISC_MEASURE_2') || ', -- Rated Fr Cost Change
170: nvl(p_freight_distance,0) ISC_MEASURE_10,
171: nvl(c_freight_distance,0) ISC_MEASURE_4,
172: ' || isc_dbi_sutil_pkg.change_str (
173: p_new_numerator => 'c_freight_distance',
174: p_old_numerator => 'p_freight_distance',
175: p_denominator => 'p_freight_distance',
176: p_measure_name => 'ISC_MEASURE_5') || ', -- Rated Fr Distance Change

Line 177: ' || isc_dbi_sutil_pkg.rate_str (

173: p_new_numerator => 'c_freight_distance',
174: p_old_numerator => 'p_freight_distance',
175: p_denominator => 'p_freight_distance',
176: p_measure_name => 'ISC_MEASURE_5') || ', -- Rated Fr Distance Change
177: ' || isc_dbi_sutil_pkg.rate_str (
178: p_numerator => 'p_freight_cost',
179: p_denominator => 'p_freight_distance',
180: p_rate_type => 'RATIO',
181: p_measure_name => 'ISC_MEASURE_11') || ', -- Fr Cost per Distance Prior

Line 182: ' || isc_dbi_sutil_pkg.rate_str (

178: p_numerator => 'p_freight_cost',
179: p_denominator => 'p_freight_distance',
180: p_rate_type => 'RATIO',
181: p_measure_name => 'ISC_MEASURE_11') || ', -- Fr Cost per Distance Prior
182: ' || isc_dbi_sutil_pkg.rate_str (
183: p_numerator => 'c_freight_cost',
184: p_denominator => 'c_freight_distance',
185: p_rate_type => 'RATIO',
186: p_measure_name => 'ISC_MEASURE_7') || ', -- Fr Cost per Distance

Line 187: ' || isc_dbi_sutil_pkg.change_rate_str (

183: p_numerator => 'c_freight_cost',
184: p_denominator => 'c_freight_distance',
185: p_rate_type => 'RATIO',
186: p_measure_name => 'ISC_MEASURE_7') || ', -- Fr Cost per Distance
187: ' || isc_dbi_sutil_pkg.change_rate_str (
188: p_new_numerator => 'c_freight_cost',
189: p_new_denominator => 'c_freight_distance',
190: p_old_numerator => 'p_freight_cost',
191: p_old_denominator => 'p_freight_distance',