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.PA_MCB_REVENUE_PKG dependencies on PA_MULTI_CURRENCY_BILLING

Line 383: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(

379:
380: l_conversion_between := 'BTC_PF';
381:
382:
383: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(
384: p_from_currency_tab => l_bill_trans_curr_code_tab,
385: p_to_currency_tab => l_projfunc_curr_code_tab,
386: p_conversion_date_tab => l_projfunc_rate_date_tab,
387: p_conversion_type_tab => l_projfunc_rate_type_tab,

Line 420: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(

416: IF (l_currency_flag <> 'Y') THEN
417:
418: l_conversion_between := 'BTC_PC';
419:
420: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(
421: p_from_currency_tab => l_bill_trans_curr_code_tab,
422: p_to_currency_tab => l_project_curr_code_tab,
423: p_conversion_date_tab => l_project_rate_date_tab,
424: p_conversion_type_tab => l_project_rate_type_tab,

Line 807: PA_MULTI_CURRENCY_BILLING.get_project_defaults (

803:
804:
805: -- Get the Project Level Defaults
806:
807: PA_MULTI_CURRENCY_BILLING.get_project_defaults (
808: p_project_id => p_project_id,
809: x_multi_currency_billing_flag => l_multi_currency_billing_flag,
810: x_baseline_funding_flag => l_baseline_funding_flag,
811: x_revproc_currency_code => l_revproc_currency_code,

Line 1064: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(

1060:
1061: l_conversion_between := 'BTC_PF';
1062:
1063:
1064: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(
1065: p_from_currency_tab => l_bill_trans_curr_code_tab,
1066: p_to_currency_tab => l_projfunc_curr_code_tab,
1067: p_conversion_date_tab => l_projfunc_rate_date_tab,
1068: p_conversion_type_tab => l_projfunc_rate_type_tab,

Line 1101: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(

1097: IF (l_currency_flag <> 'Y') THEN
1098:
1099: l_conversion_between := 'BTC_PC';
1100:
1101: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(
1102: p_from_currency_tab => l_bill_trans_curr_code_tab,
1103: p_to_currency_tab => l_project_curr_code_tab,
1104: p_conversion_date_tab => l_project_rate_date_tab,
1105: p_conversion_type_tab => l_project_rate_type_tab,

Line 1279: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(l_revproc_adj_rev_tab(i),

1275: SET raw_revenue =
1276: DECODE(l_final_error_status_tab(i), 'N', l_revproc_amount_tab(i), NULL),
1277: adjusted_revenue =
1278: DECODE(l_final_error_status_tab(i), 'N',
1279: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(l_revproc_adj_rev_tab(i),
1280: l_revproc_curr_code_tab(i)), NULL),
1281: project_raw_revenue =
1282: DECODE(l_final_error_status_tab(i), 'N', l_project_amount_tab(i), NULL),
1283: projfunc_raw_revenue =

Line 1699: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

1695:
1696: /* Calculating BTC amount from bill trans raw revenue and raw revenue */
1697:
1698: l_BTC_amount_tab(I) :=
1699: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
1700: ( l_revenue_amount_tab(I) / l_raw_revenue(I) ) * l_bill_trans_raw_revenue(I),l_bill_trans_currency_code_tab(i));
1701:
1702:
1703: /* Calculating the project amount from bill trans raw revenue and raw revenue */

Line 1705: l_project_amount_tab(I) := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

1701:
1702:
1703: /* Calculating the project amount from bill trans raw revenue and raw revenue */
1704:
1705: l_project_amount_tab(I) := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
1706: ( l_revenue_amount_tab(I) / l_raw_revenue(I) ) * l_project_raw_revenue(I),l_project_currency_code_tab(i));
1707:
1708:
1709: /* Calculating project functional amount from bill trans raw revenue and raw revenue */

Line 1712: l_projfunc_amount_tab(I) := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

1708:
1709: /* Calculating project functional amount from bill trans raw revenue and raw revenue */
1710:
1711:
1712: l_projfunc_amount_tab(I) := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
1713: ( l_revenue_amount_tab(I) / l_raw_revenue(I) ) * l_projfunc_raw_revenue(I), l_projfunc_currency_code_tab(i));
1714:
1715:
1716: /* Debug message for MCB testing */

Line 1772: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(

1768: IF g1_debug_mode = 'Y' THEN
1769: PA_MCB_INVOICE_PKG.log_message('rdl_amount_conversion: ' || 'Funding is not equal to PF and project .....');
1770: END IF;
1771:
1772: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(
1773: p_from_currency_tab => l_bill_trans_currency_code_tab,
1774: p_to_currency_tab => l_funding_currency_code_tab,
1775: p_conversion_date_tab => l_funding_rev_rate_date_tab,
1776: p_conversion_type_tab => l_funding_rev_rate_type_tab,

Line 1984: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(

1980: IF g1_debug_mode = 'Y' THEN
1981: PA_MCB_INVOICE_PKG.log_message('rdl_amount_conversion: '||'Before convert_amount_bulk to derive rtc amt.....');
1982: END IF;
1983:
1984: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(
1985: p_from_currency_tab => l_pf_currency_code_t1_tab,
1986: p_to_currency_tab => l_rt_currency_code_t1_tab,
1987: p_conversion_date_tab => l_rt_rate_date_t1_tab,
1988: p_conversion_type_tab => l_rt_rate_type_t1_tab,

Line 2093: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

2089:
2090: FORALL I IN 1 .. l_ei_id_tab.COUNT
2091: UPDATE pa_cust_rev_dist_lines
2092: SET bill_trans_amount =
2093: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
2094: l_BTC_amount_tab(i),l_bill_trans_currency_code_tab(i)),
2095: project_revenue_amount =
2096: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
2097: l_project_amount_tab(i),l_project_currency_code_tab(i)),

Line 2096: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

2092: SET bill_trans_amount =
2093: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
2094: l_BTC_amount_tab(i),l_bill_trans_currency_code_tab(i)),
2095: project_revenue_amount =
2096: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
2097: l_project_amount_tab(i),l_project_currency_code_tab(i)),
2098: projfunc_revenue_amount =
2099: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
2100: l_projfunc_amount_tab(i),l_projfunc_currency_code_tab(i)),

Line 2099: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

2095: project_revenue_amount =
2096: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
2097: l_project_amount_tab(i),l_project_currency_code_tab(i)),
2098: projfunc_revenue_amount =
2099: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
2100: l_projfunc_amount_tab(i),l_projfunc_currency_code_tab(i)),
2101: funding_revenue_amount =
2102: DECODE(l_funding_status_tab(I), 'N',
2103: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

Line 2103: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

2099: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
2100: l_projfunc_amount_tab(i),l_projfunc_currency_code_tab(i)),
2101: funding_revenue_amount =
2102: DECODE(l_funding_status_tab(I), 'N',
2103: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
2104: l_funding_amount_tab(I),l_funding_currency_code_tab(i)),
2105: NULL),
2106: funding_rev_rate_type =
2107: DECODE(l_funding_status_tab(I), 'N', l_funding_rev_rate_type_tab(I),NULL),

Line 2116: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

2112: revtrans_currency_code =
2113: DECODE(l_revtrans_status_tab(I), 'N', l_revtrans_currency_code_tab(I),NULL),
2114: revtrans_amount =
2115: DECODE(l_revtrans_status_tab(I), 'N',
2116: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
2117: l_revtrans_amount_tab(I),l_revtrans_currency_code_tab(i)), NULL),
2118: revproc_revtrans_rate_type =
2119: DECODE(l_revtrans_status_tab(I), 'N', l_revtrans_rate_type_tab(I),NULL),
2120: revproc_revtrans_rate_date =

Line 2355: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(

2351:
2352: l_conversion_between := 'BTC_FC';
2353:
2354:
2355: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(
2356: p_from_currency_tab => l_bill_trans_currency_code_tab,
2357: p_to_currency_tab => l_funding_currency_code_tab,
2358: p_conversion_date_tab => l_funding_rev_rate_date_tab,
2359: p_conversion_type_tab => l_funding_rev_rate_type_tab,

Line 2452: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(

2448: l_revtrans_numerator_tab(1) := NULL;
2449: l_funding_bill_rate_tab(1) := NULL;
2450:
2451:
2452: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(
2453: p_from_currency_tab => l_projfunc_currency_code_tab,
2454: p_to_currency_tab => l_revtrans_currency_code_tab,
2455: p_conversion_date_tab => l_revtrans_rate_date_tab,
2456: p_conversion_type_tab => l_revtrans_rate_type_tab,

Line 2778: PA_MULTI_CURRENCY_BILLING.get_project_defaults (

2774: END IF;
2775:
2776: -- Get the Project Level Defaults
2777:
2778: PA_MULTI_CURRENCY_BILLING.get_project_defaults (
2779: p_project_id => l_project_id,
2780: x_multi_currency_billing_flag => l_multi_currency_billing_flag,
2781: x_baseline_funding_flag => l_baseline_funding_flag,
2782: x_revproc_currency_code => l_revproc_currency_code,

Line 2906: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(

2902:
2903: l_conversion_between := 'BTC_PF';
2904:
2905:
2906: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(
2907: p_from_currency_tab => l_bill_trans_curr_code_tab,
2908: p_to_currency_tab => l_revproc_curr_code_tab,
2909: p_conversion_date_tab => l_revproc_rate_date_tab,
2910: p_conversion_type_tab => l_revproc_rate_type_tab,