APPS.ISC_DBI_CARR_BILL_PAY_TRD_PKG dependencies on ISC_DBI_SUTIL_PKG

Line 59: isc_dbi_sutil_pkg.process_parameters (

55: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
56: x_custom_sql := l_query;
57:
58: -- get all the query parameters
59: isc_dbi_sutil_pkg.process_parameters (
60: p_param => p_param,
61: p_view_by => l_view_by,
62: p_view_by_col_name => l_view_by_col,
63: p_comparison_type => l_comparison_type,

Line 114: isc_dbi_sutil_pkg.process_parameters (

110:
111:
112:
113:
114: isc_dbi_sutil_pkg.process_parameters (
115: p_param => p_param,
116: p_view_by => l_view_by,
117: p_view_by_col_name => l_view_by_col,
118: p_comparison_type => l_comparison_type,

Line 229: ' || isc_dbi_sutil_pkg.change_str (

225: 'SELECT
226: ' || ' cal_name VIEWBY,
227: p_payment_amt ISC_MEASURE_9,
228: c_payment_amt ISC_MEASURE_10,
229: ' || isc_dbi_sutil_pkg.change_str (
230: p_new_numerator => 'c_payment_amt',
231: p_old_numerator => 'p_payment_amt',
232: p_denominator => 'p_payment_amt',
233: p_measure_name => 'ISC_MEASURE_11') || ', -- Payment Change

Line 235: ' || isc_dbi_sutil_pkg.change_str (

231: p_old_numerator => 'p_payment_amt',
232: p_denominator => 'p_payment_amt',
233: p_measure_name => 'ISC_MEASURE_11') || ', -- Payment Change
234: c_bill_amt - c_fully_paid_amt ISC_MEASURE_15, --- Bill to Paid Variance Amount
235: ' || isc_dbi_sutil_pkg.change_str (
236: p_new_numerator => '(c_bill_amt - c_fully_paid_amt)',
237: p_old_numerator => '(p_bill_amt - p_fully_paid_amt)',
238: p_denominator => '(p_bill_amt - p_fully_paid_amt)',
239: p_measure_name => 'ISC_MEASURE_16') || ', -- Billed to Paid Variance Amount Change

Line 240: ' || isc_dbi_sutil_pkg.change_str (

236: p_new_numerator => '(c_bill_amt - c_fully_paid_amt)',
237: p_old_numerator => '(p_bill_amt - p_fully_paid_amt)',
238: p_denominator => '(p_bill_amt - p_fully_paid_amt)',
239: p_measure_name => 'ISC_MEASURE_16') || ', -- Billed to Paid Variance Amount Change
240: ' || isc_dbi_sutil_pkg.change_str (
241: p_new_numerator => 'p_bill_amt',
242: p_old_numerator => 'p_fully_paid_amt',
243: p_denominator => 'p_fully_paid_amt',
244: p_measure_name => 'ISC_MEASURE_17') || ', --(Bill-to-Paid Variance Percent) Prior

Line 245: ' || isc_dbi_sutil_pkg.change_str (

241: p_new_numerator => 'p_bill_amt',
242: p_old_numerator => 'p_fully_paid_amt',
243: p_denominator => 'p_fully_paid_amt',
244: p_measure_name => 'ISC_MEASURE_17') || ', --(Bill-to-Paid Variance Percent) Prior
245: ' || isc_dbi_sutil_pkg.change_str (
246: p_new_numerator => 'c_bill_amt',
247: p_old_numerator => 'c_fully_paid_amt',
248: p_denominator => 'c_fully_paid_amt',
249: p_measure_name => 'ISC_MEASURE_18') || ', --(Bill-to-Paid Variance Percent) Current

Line 250: ' || isc_dbi_sutil_pkg.change_rate_str (

246: p_new_numerator => 'c_bill_amt',
247: p_old_numerator => 'c_fully_paid_amt',
248: p_denominator => 'c_fully_paid_amt',
249: p_measure_name => 'ISC_MEASURE_18') || ', --(Bill-to-Paid Variance Percent) Current
250: ' || isc_dbi_sutil_pkg.change_rate_str (
251: p_new_numerator => '(c_bill_amt - c_fully_paid_amt)',
252: p_new_denominator => 'c_fully_paid_amt',
253: p_old_numerator => '(p_bill_amt - p_fully_paid_amt)',
254: p_old_denominator => 'p_fully_paid_amt',

Line 258: ' || isc_dbi_sutil_pkg.change_str (

254: p_old_denominator => 'p_fully_paid_amt',
255: p_rate_type => 'RATIO',
256: p_measure_name => 'ISC_MEASURE_19') || ', -- Bill-to_Paid Variance Percent Change
257: c_bill_amt - c_approved_amt ISC_MEASURE_22, --- Bill to Approved Variance Amount
258: ' || isc_dbi_sutil_pkg.change_str (
259: p_new_numerator => '(c_bill_amt - c_approved_amt)',
260: p_old_numerator => '(p_bill_amt - p_approved_amt)',
261: p_denominator => '(p_bill_amt - p_approved_amt)',
262: p_measure_name => 'ISC_MEASURE_21') || ',--Billed to Approved Variance Amount Change

Line 263: ' || isc_dbi_sutil_pkg.change_str (

259: p_new_numerator => '(c_bill_amt - c_approved_amt)',
260: p_old_numerator => '(p_bill_amt - p_approved_amt)',
261: p_denominator => '(p_bill_amt - p_approved_amt)',
262: p_measure_name => 'ISC_MEASURE_21') || ',--Billed to Approved Variance Amount Change
263: ' || isc_dbi_sutil_pkg.change_str (
264: p_new_numerator => 'p_bill_amt',
265: p_old_numerator => 'p_approved_amt',
266: p_denominator => 'p_approved_amt',
267: p_measure_name => 'ISC_MEASURE_12') ||',--(Bill-to-Approved Variance Percent) Prior

Line 268: ' || isc_dbi_sutil_pkg.change_str (

264: p_new_numerator => 'p_bill_amt',
265: p_old_numerator => 'p_approved_amt',
266: p_denominator => 'p_approved_amt',
267: p_measure_name => 'ISC_MEASURE_12') ||',--(Bill-to-Approved Variance Percent) Prior
268: ' || isc_dbi_sutil_pkg.change_str (
269: p_new_numerator => 'c_bill_amt',
270: p_old_numerator => 'c_approved_amt',
271: p_denominator => 'c_approved_amt',
272: p_measure_name => 'ISC_MEASURE_23') ||',--(Bill-to-Approved Var Percent) Current

Line 273: ' || isc_dbi_sutil_pkg.change_rate_str (

269: p_new_numerator => 'c_bill_amt',
270: p_old_numerator => 'c_approved_amt',
271: p_denominator => 'c_approved_amt',
272: p_measure_name => 'ISC_MEASURE_23') ||',--(Bill-to-Approved Var Percent) Current
273: ' || isc_dbi_sutil_pkg.change_rate_str (
274: p_new_numerator => '(c_bill_amt - c_approved_amt)',
275: p_new_denominator => 'c_approved_amt',
276: p_old_numerator => '(p_bill_amt - p_approved_amt)',
277: p_old_denominator => 'p_approved_amt',