APPS.ISC_DBI_FR_COST_PER_V_TR_PKG dependencies on ISC_DBI_SUTIL_PKG

Line 52: isc_dbi_sutil_pkg.process_parameters (

48: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
49: x_custom_sql := l_query;
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 149: ' || isc_dbi_sutil_pkg.change_str (

145: 'SELECT
146: ' || ' cal.name VIEWBY,
147: nvl(p_freight_cost,0) ISC_MEASURE_9,
148: nvl(c_freight_cost,0) ISC_MEASURE_1,
149: ' || isc_dbi_sutil_pkg.change_str (
150: p_new_numerator => 'c_freight_cost',
151: p_old_numerator => 'p_freight_cost',
152: p_denominator => 'p_freight_cost',
153: p_measure_name => 'ISC_MEASURE_2') || ', -- Rated Fr Cost Change

Line 156: ' || isc_dbi_sutil_pkg.change_str (

152: p_denominator => 'p_freight_cost',
153: p_measure_name => 'ISC_MEASURE_2') || ', -- Rated Fr Cost Change
154: nvl(p_freight_volume,0) ISC_MEASURE_10,
155: nvl(c_freight_volume,0) ISC_MEASURE_4,
156: ' || isc_dbi_sutil_pkg.change_str (
157: p_new_numerator => 'c_freight_volume',
158: p_old_numerator => 'p_freight_volume',
159: p_denominator => 'p_freight_volume',
160: p_measure_name => 'ISC_MEASURE_5') || ', -- Rated Fr Volume Change

Line 161: ' || isc_dbi_sutil_pkg.rate_str (

157: p_new_numerator => 'c_freight_volume',
158: p_old_numerator => 'p_freight_volume',
159: p_denominator => 'p_freight_volume',
160: p_measure_name => 'ISC_MEASURE_5') || ', -- Rated Fr Volume Change
161: ' || isc_dbi_sutil_pkg.rate_str (
162: p_numerator => 'p_freight_cost',
163: p_denominator => 'p_freight_volume',
164: p_rate_type => 'RATIO',
165: p_measure_name => 'ISC_MEASURE_11') || ', -- Fr Cost per Volume Prior

Line 166: ' || isc_dbi_sutil_pkg.rate_str (

162: p_numerator => 'p_freight_cost',
163: p_denominator => 'p_freight_volume',
164: p_rate_type => 'RATIO',
165: p_measure_name => 'ISC_MEASURE_11') || ', -- Fr Cost per Volume Prior
166: ' || isc_dbi_sutil_pkg.rate_str (
167: p_numerator => 'c_freight_cost',
168: p_denominator => 'c_freight_volume',
169: p_rate_type => 'RATIO',
170: p_measure_name => 'ISC_MEASURE_7') || ', -- Fr Cost per Volume

Line 171: ' || isc_dbi_sutil_pkg.change_rate_str (

167: p_numerator => 'c_freight_cost',
168: p_denominator => 'c_freight_volume',
169: p_rate_type => 'RATIO',
170: p_measure_name => 'ISC_MEASURE_7') || ', -- Fr Cost per Volume
171: ' || isc_dbi_sutil_pkg.change_rate_str (
172: p_new_numerator => 'c_freight_cost',
173: p_new_denominator => 'c_freight_volume',
174: p_old_numerator => 'p_freight_cost',
175: p_old_denominator => 'p_freight_volume',