eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ISC_DBI_CARR_BILL_PAY_PKG dependencies on ISC_DBI_SUTIL_PKG

Line 61: isc_dbi_sutil_pkg.process_parameters (

57: l_col_tbl2 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
58: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
59:
60: -- get all the query parameters for the RTX MV
61: isc_dbi_sutil_pkg.process_parameters (
62: p_param => p_param,
63: p_view_by => l_view_by,
64: p_view_by_col_name => l_view_by_col,
65: p_comparison_type => l_comparison_type,

Line 115: isc_dbi_sutil_pkg.process_parameters (

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

Line 236: l_view_by_col_name := isc_dbi_sutil_pkg.get_view_by_col_name (p_view_by_dim);

232: BEGIN
233:
234: -- initialization block
235: -- Column to get view by column name
236: l_view_by_col_name := isc_dbi_sutil_pkg.get_view_by_col_name (p_view_by_dim);
237:
238: -- fact column view by's
239: l_view_by_fact_col := isc_dbi_sutil_pkg.get_fact_select_columns (p_join_tbl);
240:

Line 239: l_view_by_fact_col := isc_dbi_sutil_pkg.get_fact_select_columns (p_join_tbl);

235: -- Column to get view by column name
236: l_view_by_col_name := isc_dbi_sutil_pkg.get_view_by_col_name (p_view_by_dim);
237:
238: -- fact column view by's
239: l_view_by_fact_col := isc_dbi_sutil_pkg.get_fact_select_columns (p_join_tbl);
240:
241:
242: -- Outer select clause
243: l_sel_clause :=

Line 244: 'SELECT ' || isc_dbi_sutil_pkg.get_view_by_select_clause (p_view_by_dim)

240:
241:
242: -- Outer select clause
243: l_sel_clause :=
244: 'SELECT ' || isc_dbi_sutil_pkg.get_view_by_select_clause (p_view_by_dim)
245: || 'oset.ISC_MEASURE_9 ISC_MEASURE_9,
246: ' || 'oset.ISC_MEASURE_10 ISC_MEASURE_10,
247: ' || 'oset.ISC_MEASURE_11 ISC_MEASURE_11,
248: ' || 'oset.ISC_MEASURE_12 ISC_MEASURE_12,

Line 305: ' || isc_dbi_sutil_pkg.change_str (

301: c_approved_amt ISC_MEASURE_21,
302: c_bill_amt - c_approved_amt ISC_MEASURE_22,
303: c_approved_amt_total ISC_MEASURE_25,
304: c_bill_amt_total - c_approved_amt_total ISC_MEASURE_26,
305: ' || isc_dbi_sutil_pkg.change_str (
306: p_new_numerator => 'c_payment_amt',
307: p_old_numerator => 'p_payment_amt',
308: p_denominator => 'p_payment_amt',
309: p_measure_name => 'ISC_MEASURE_11') || ', -- Payment Change

Line 311: ' || isc_dbi_sutil_pkg.change_str (

307: p_old_numerator => 'p_payment_amt',
308: p_denominator => 'p_payment_amt',
309: p_measure_name => 'ISC_MEASURE_11') || ', -- Payment Change
310:
311: ' || isc_dbi_sutil_pkg.change_str (
312: p_new_numerator => 'c_payment_amt_total',
313: p_old_numerator => 'p_payment_amt_total',
314: p_denominator => 'p_payment_amt_total',
315: p_measure_name => 'ISC_MEASURE_2') || ', -- GT - Total Payment Change

Line 317: ' || isc_dbi_sutil_pkg.rate_str (

313: p_old_numerator => 'p_payment_amt_total',
314: p_denominator => 'p_payment_amt_total',
315: p_measure_name => 'ISC_MEASURE_2') || ', -- GT - Total Payment Change
316:
317: ' || isc_dbi_sutil_pkg.rate_str (
318: p_numerator => 'c_payment_amt',
319: p_denominator => 'c_payment_amt_total',
320: p_rate_type => 'PERCENT',
321: p_measure_name => 'ISC_MEASURE_12') || ', -- Percent of Total

Line 323: ' || isc_dbi_sutil_pkg.rate_str (

319: p_denominator => 'c_payment_amt_total',
320: p_rate_type => 'PERCENT',
321: p_measure_name => 'ISC_MEASURE_12') || ', -- Percent of Total
322:
323: ' || isc_dbi_sutil_pkg.rate_str (
324: p_numerator => 'c_payment_amt_total',
325: p_denominator => 'c_payment_amt_total',
326: p_rate_type => 'PERCENT',
327: p_measure_name => 'ISC_MEASURE_3') || ', -- GT- Percent of Total

Line 329: ' || isc_dbi_sutil_pkg.change_str (

325: p_denominator => 'c_payment_amt_total',
326: p_rate_type => 'PERCENT',
327: p_measure_name => 'ISC_MEASURE_3') || ', -- GT- Percent of Total
328:
329: ' || isc_dbi_sutil_pkg.change_str (
330: p_new_numerator => 'p_bill_amt',
331: p_old_numerator => 'p_fully_paid_amt',
332: p_denominator => 'p_fully_paid_amt',
333: p_measure_name => 'ISC_MEASURE_17') || ', -- (Bill-to-Paid Variance Percent) Prior

Line 335: ' || isc_dbi_sutil_pkg.change_str (

331: p_old_numerator => 'p_fully_paid_amt',
332: p_denominator => 'p_fully_paid_amt',
333: p_measure_name => 'ISC_MEASURE_17') || ', -- (Bill-to-Paid Variance Percent) Prior
334:
335: ' || isc_dbi_sutil_pkg.change_str (
336: p_new_numerator => 'p_bill_amt',
337: p_old_numerator => 'p_fully_paid_amt',
338: p_denominator => 'p_fully_paid_amt',
339: p_measure_name => 'ISC_MEASURE_35') || ', -- KPI (Bill-to-Paid Variance Percent) Prior

Line 341: ' || isc_dbi_sutil_pkg.change_str (

337: p_old_numerator => 'p_fully_paid_amt',
338: p_denominator => 'p_fully_paid_amt',
339: p_measure_name => 'ISC_MEASURE_35') || ', -- KPI (Bill-to-Paid Variance Percent) Prior
340:
341: ' || isc_dbi_sutil_pkg.change_str (
342: p_new_numerator => 'p_bill_amt_total',
343: p_old_numerator => 'p_fully_paid_amt_total',
344: p_denominator => 'p_fully_paid_amt_total',
345: p_measure_name => 'ISC_MEASURE_30') || ', -- GT (Bill-to-Paid Variance Percent) Prior

Line 347: ' || isc_dbi_sutil_pkg.change_str (

343: p_old_numerator => 'p_fully_paid_amt_total',
344: p_denominator => 'p_fully_paid_amt_total',
345: p_measure_name => 'ISC_MEASURE_30') || ', -- GT (Bill-to-Paid Variance Percent) Prior
346:
347: ' || isc_dbi_sutil_pkg.change_str (
348: p_new_numerator => 'c_bill_amt',
349: p_old_numerator => 'c_fully_paid_amt',
350: p_denominator => 'c_fully_paid_amt',
351: p_measure_name => 'ISC_MEASURE_18') || ', --(Bill-to-Paid Variance Percent) Current

Line 353: ' || isc_dbi_sutil_pkg.change_str (

349: p_old_numerator => 'c_fully_paid_amt',
350: p_denominator => 'c_fully_paid_amt',
351: p_measure_name => 'ISC_MEASURE_18') || ', --(Bill-to-Paid Variance Percent) Current
352:
353: ' || isc_dbi_sutil_pkg.change_str (
354: p_new_numerator => 'c_bill_amt',
355: p_old_numerator => 'c_fully_paid_amt',
356: p_denominator => 'c_fully_paid_amt',
357: p_measure_name => 'ISC_MEASURE_33') || ', --(Bill-to-Paid Variance Percent) Current (for KPI)

Line 359: ' || isc_dbi_sutil_pkg.change_str (

355: p_old_numerator => 'c_fully_paid_amt',
356: p_denominator => 'c_fully_paid_amt',
357: p_measure_name => 'ISC_MEASURE_33') || ', --(Bill-to-Paid Variance Percent) Current (for KPI)
358:
359: ' || isc_dbi_sutil_pkg.change_str (
360: p_new_numerator => 'c_bill_amt_total',
361: p_old_numerator => 'c_fully_paid_amt_total',
362: p_denominator => 'c_fully_paid_amt_total',
363: p_measure_name => 'ISC_MEASURE_7') || ', -- GT-(Bill-to-Paid Variance Percent) Current

Line 365: ' || isc_dbi_sutil_pkg.change_str (

361: p_old_numerator => 'c_fully_paid_amt_total',
362: p_denominator => 'c_fully_paid_amt_total',
363: p_measure_name => 'ISC_MEASURE_7') || ', -- GT-(Bill-to-Paid Variance Percent) Current
364:
365: ' || isc_dbi_sutil_pkg.change_str (
366: p_new_numerator => 'c_bill_amt_total',
367: p_old_numerator => 'c_fully_paid_amt_total',
368: p_denominator => 'c_fully_paid_amt_total',
369: p_measure_name => 'ISC_MEASURE_34') || ', -- KPIGT-(Bill-to-Paid Variance Percent) Current

Line 371: ' || isc_dbi_sutil_pkg.change_rate_str (

367: p_old_numerator => 'c_fully_paid_amt_total',
368: p_denominator => 'c_fully_paid_amt_total',
369: p_measure_name => 'ISC_MEASURE_34') || ', -- KPIGT-(Bill-to-Paid Variance Percent) Current
370:
371: ' || isc_dbi_sutil_pkg.change_rate_str (
372: p_new_numerator => '(c_bill_amt - c_fully_paid_amt)',
373: p_new_denominator => 'c_fully_paid_amt',
374: p_old_numerator => '(p_bill_amt - p_fully_paid_amt)',
375: p_old_denominator => 'p_fully_paid_amt',

Line 379: ' || isc_dbi_sutil_pkg.change_rate_str (

375: p_old_denominator => 'p_fully_paid_amt',
376: p_rate_type => 'RATIO',
377: p_measure_name => 'ISC_MEASURE_19') || ', -- Bill-to_Paid Variance Percent Change
378:
379: ' || isc_dbi_sutil_pkg.change_rate_str (
380: p_new_numerator => '(c_bill_amt_total - c_fully_paid_amt_total)',
381: p_new_denominator => 'c_fully_paid_amt_total',
382: p_old_numerator => '(p_bill_amt_total - p_fully_paid_amt_total)',
383: p_old_denominator => 'p_fully_paid_amt_total',

Line 387: ' || isc_dbi_sutil_pkg.change_str (

383: p_old_denominator => 'p_fully_paid_amt_total',
384: p_rate_type => 'RATIO',
385: p_measure_name => 'ISC_MEASURE_8') || ', --GT - Bill-to_Paid Variance Percent Change
386:
387: ' || isc_dbi_sutil_pkg.change_str (
388: p_new_numerator => 'c_bill_amt',
389: p_old_numerator => 'c_approved_amt',
390: p_denominator => 'c_approved_amt',
391: p_measure_name => 'ISC_MEASURE_23') ||',--(Bill-to-Approved Var Percent) Current

Line 393: ' || isc_dbi_sutil_pkg.change_rate_str (

389: p_old_numerator => 'c_approved_amt',
390: p_denominator => 'c_approved_amt',
391: p_measure_name => 'ISC_MEASURE_23') ||',--(Bill-to-Approved Var Percent) Current
392:
393: ' || isc_dbi_sutil_pkg.change_rate_str (
394: p_new_numerator => '(c_bill_amt - c_approved_amt)',
395: p_new_denominator => 'c_approved_amt',
396: p_old_numerator => '(p_bill_amt - p_approved_amt)',
397: p_old_denominator => 'p_approved_amt',

Line 401: ' || isc_dbi_sutil_pkg.change_str (

397: p_old_denominator => 'p_approved_amt',
398: p_rate_type => 'RATIO',
399: p_measure_name => 'ISC_MEASURE_24') || ', -- Bill-to-Approved Variance Percent Change
400:
401: ' || isc_dbi_sutil_pkg.change_str (
402: p_new_numerator => 'c_bill_amt_total',
403: p_old_numerator => 'c_approved_amt_total',
404: p_denominator => 'c_approved_amt_total',
405: p_measure_name => 'ISC_MEASURE_27') ||',--GT (Bill-to-Approved Var Percent) Current

Line 407: ' || isc_dbi_sutil_pkg.change_rate_str (

403: p_old_numerator => 'c_approved_amt_total',
404: p_denominator => 'c_approved_amt_total',
405: p_measure_name => 'ISC_MEASURE_27') ||',--GT (Bill-to-Approved Var Percent) Current
406:
407: ' || isc_dbi_sutil_pkg.change_rate_str (
408: p_new_numerator => '(c_bill_amt_total - c_approved_amt_total)',
409: p_new_denominator => 'c_approved_amt_total',
410: p_old_numerator => '(p_bill_amt_total - p_approved_amt_total)',
411: p_old_denominator => 'p_approved_amt_total',