APPS.ISC_DBI_CST_REC_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 149: ' || isc_dbi_sutil_pkg.change_str (

145: 'SELECT
146: ' || ' cal.name VIEWBY,
147: nvl(p_freight_cost,0) ISC_MEASURE_11,
148: nvl(c_freight_cost,0) ISC_MEASURE_2,
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_3') || ', -- Estimated Fr Cost Change

Line 156: ' || isc_dbi_sutil_pkg.change_str (

152: p_denominator => 'p_freight_cost',
153: p_measure_name => 'ISC_MEASURE_3') || ', -- Estimated Fr Cost Change
154: nvl(p_freight_charge,0) ISC_MEASURE_4,
155: nvl(c_freight_charge,0) ISC_MEASURE_5,
156: ' || isc_dbi_sutil_pkg.change_str (
157: p_new_numerator => 'c_freight_charge',
158: p_old_numerator => 'p_freight_charge',
159: p_denominator => 'p_freight_charge',
160: p_measure_name => 'ISC_MEASURE_6') || ', -- Order Fr Charge Change

Line 161: ' || isc_dbi_sutil_pkg.rate_str (

157: p_new_numerator => 'c_freight_charge',
158: p_old_numerator => 'p_freight_charge',
159: p_denominator => 'p_freight_charge',
160: p_measure_name => 'ISC_MEASURE_6') || ', -- Order Fr Charge Change
161: ' || isc_dbi_sutil_pkg.rate_str (
162: p_numerator => 'p_freight_charge',
163: p_denominator => 'p_freight_cost',
164: p_rate_type => 'PERCENT',
165: p_measure_name => 'ISC_MEASURE_8') || ', -- Prior Recovery Rate

Line 166: ' || isc_dbi_sutil_pkg.rate_str (

162: p_numerator => 'p_freight_charge',
163: p_denominator => 'p_freight_cost',
164: p_rate_type => 'PERCENT',
165: p_measure_name => 'ISC_MEASURE_8') || ', -- Prior Recovery Rate
166: ' || isc_dbi_sutil_pkg.rate_str (
167: p_numerator => 'c_freight_charge',
168: p_denominator => 'c_freight_cost',
169: p_rate_type => 'PERCENT',
170: p_measure_name => 'ISC_MEASURE_9') || ', -- Recovery Rate

Line 171: ' || isc_dbi_sutil_pkg.change_rate_str (

167: p_numerator => 'c_freight_charge',
168: p_denominator => 'c_freight_cost',
169: p_rate_type => 'PERCENT',
170: p_measure_name => 'ISC_MEASURE_9') || ', -- Recovery Rate
171: ' || isc_dbi_sutil_pkg.change_rate_str (
172: p_new_numerator => 'c_freight_charge',
173: p_new_denominator => 'c_freight_cost',
174: p_old_numerator => 'p_freight_charge',
175: p_old_denominator => 'p_freight_cost',