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 809: PA_MULTI_CURRENCY_BILLING.get_project_defaults (

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

Line 1107: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(

1103:
1104: l_conversion_between := 'BTC_PF';
1105:
1106:
1107: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(
1108: p_from_currency_tab => l_bill_trans_curr_code_tab,
1109: p_to_currency_tab => l_projfunc_curr_code_tab,
1110: p_conversion_date_tab => l_projfunc_rate_date_tab,
1111: p_conversion_type_tab => l_projfunc_rate_type_tab,

Line 1144: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(

1140: IF (l_currency_flag <> 'Y') THEN
1141:
1142: l_conversion_between := 'BTC_PC';
1143:
1144: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(
1145: p_from_currency_tab => l_bill_trans_curr_code_tab,
1146: p_to_currency_tab => l_project_curr_code_tab,
1147: p_conversion_date_tab => l_project_rate_date_tab,
1148: p_conversion_type_tab => l_project_rate_type_tab,

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

1318: SET raw_revenue =
1319: DECODE(l_final_error_status_tab(i), 'N', l_revproc_amount_tab(i), NULL),
1320: adjusted_revenue =
1321: DECODE(l_final_error_status_tab(i), 'N',
1322: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(l_revproc_adj_rev_tab(i),
1323: l_revproc_curr_code_tab(i)), NULL),
1324: project_raw_revenue =
1325: DECODE(l_final_error_status_tab(i), 'N', l_project_amount_tab(i), NULL),
1326: projfunc_raw_revenue =

Line 1742: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

1738:
1739: /* Calculating BTC amount from bill trans raw revenue and raw revenue */
1740:
1741: l_BTC_amount_tab(I) :=
1742: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
1743: ( l_revenue_amount_tab(I) / l_raw_revenue(I) ) * l_bill_trans_raw_revenue(I),l_bill_trans_currency_code_tab(i));
1744:
1745:
1746: /* Calculating the project amount from bill trans raw revenue and raw revenue */

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

1744:
1745:
1746: /* Calculating the project amount from bill trans raw revenue and raw revenue */
1747:
1748: l_project_amount_tab(I) := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
1749: ( l_revenue_amount_tab(I) / l_raw_revenue(I) ) * l_project_raw_revenue(I),l_project_currency_code_tab(i));
1750:
1751:
1752: /* Calculating project functional amount from bill trans raw revenue and raw revenue */

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

1751:
1752: /* Calculating project functional amount from bill trans raw revenue and raw revenue */
1753:
1754:
1755: l_projfunc_amount_tab(I) := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
1756: ( l_revenue_amount_tab(I) / l_raw_revenue(I) ) * l_projfunc_raw_revenue(I), l_projfunc_currency_code_tab(i));
1757:
1758:
1759: /* Debug message for MCB testing */

Line 1815: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(

1811: IF g1_debug_mode = 'Y' THEN
1812: PA_MCB_INVOICE_PKG.log_message('rdl_amount_conversion: ' || 'Funding is not equal to PF and project .....');
1813: END IF;
1814:
1815: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(
1816: p_from_currency_tab => l_bill_trans_currency_code_tab,
1817: p_to_currency_tab => l_funding_currency_code_tab,
1818: p_conversion_date_tab => l_funding_rev_rate_date_tab,
1819: p_conversion_type_tab => l_funding_rev_rate_type_tab,

Line 2027: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(

2023: IF g1_debug_mode = 'Y' THEN
2024: PA_MCB_INVOICE_PKG.log_message('rdl_amount_conversion: '||'Before convert_amount_bulk to derive rtc amt.....');
2025: END IF;
2026:
2027: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(
2028: p_from_currency_tab => l_pf_currency_code_t1_tab,
2029: p_to_currency_tab => l_rt_currency_code_t1_tab,
2030: p_conversion_date_tab => l_rt_rate_date_t1_tab,
2031: p_conversion_type_tab => l_rt_rate_type_t1_tab,

Line 2137: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

2133:
2134: FORALL I IN 1 .. l_ei_id_tab.COUNT
2135: UPDATE pa_cust_rev_dist_lines
2136: SET bill_trans_amount =
2137: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
2138: l_BTC_amount_tab(i),l_bill_trans_currency_code_tab(i)),
2139: project_revenue_amount =
2140: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
2141: l_project_amount_tab(i),l_project_currency_code_tab(i)),

Line 2140: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

2136: SET bill_trans_amount =
2137: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
2138: l_BTC_amount_tab(i),l_bill_trans_currency_code_tab(i)),
2139: project_revenue_amount =
2140: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
2141: l_project_amount_tab(i),l_project_currency_code_tab(i)),
2142: projfunc_revenue_amount =
2143: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
2144: l_projfunc_amount_tab(i),l_projfunc_currency_code_tab(i)),

Line 2143: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

2139: project_revenue_amount =
2140: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
2141: l_project_amount_tab(i),l_project_currency_code_tab(i)),
2142: projfunc_revenue_amount =
2143: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
2144: l_projfunc_amount_tab(i),l_projfunc_currency_code_tab(i)),
2145: funding_revenue_amount =
2146: DECODE(l_funding_status_tab(I), 'N',
2147: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

Line 2147: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

2143: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
2144: l_projfunc_amount_tab(i),l_projfunc_currency_code_tab(i)),
2145: funding_revenue_amount =
2146: DECODE(l_funding_status_tab(I), 'N',
2147: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
2148: l_funding_amount_tab(I),l_funding_currency_code_tab(i)),
2149: NULL),
2150: funding_rev_rate_type =
2151: DECODE(l_funding_status_tab(I), 'N', l_funding_rev_rate_type_tab(I),NULL),

Line 2160: NVL(PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(

2156: revtrans_currency_code =
2157: DECODE(l_revtrans_status_tab(I), 'N', l_revtrans_currency_code_tab(I),NULL),
2158: revtrans_amount =
2159: DECODE(l_revtrans_status_tab(I), 'N',
2160: NVL(PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
2161: l_revtrans_amount_tab(I),l_revtrans_currency_code_tab(i)),0), NULL),
2162: revproc_revtrans_rate_type =
2163: DECODE(l_revtrans_status_tab(I), 'N', l_revtrans_rate_type_tab(I),NULL),
2164: revproc_revtrans_rate_date =

Line 2399: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(

2395:
2396: l_conversion_between := 'BTC_FC';
2397:
2398:
2399: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(
2400: p_from_currency_tab => l_bill_trans_currency_code_tab,
2401: p_to_currency_tab => l_funding_currency_code_tab,
2402: p_conversion_date_tab => l_funding_rev_rate_date_tab,
2403: p_conversion_type_tab => l_funding_rev_rate_type_tab,

Line 2496: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(

2492: l_revtrans_numerator_tab(1) := NULL;
2493: l_funding_bill_rate_tab(1) := NULL;
2494:
2495:
2496: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(
2497: p_from_currency_tab => l_projfunc_currency_code_tab,
2498: p_to_currency_tab => l_revtrans_currency_code_tab,
2499: p_conversion_date_tab => l_revtrans_rate_date_tab,
2500: p_conversion_type_tab => l_revtrans_rate_type_tab,

Line 2822: PA_MULTI_CURRENCY_BILLING.get_project_defaults (

2818: END IF;
2819:
2820: -- Get the Project Level Defaults
2821:
2822: PA_MULTI_CURRENCY_BILLING.get_project_defaults (
2823: p_project_id => l_project_id,
2824: x_multi_currency_billing_flag => l_multi_currency_billing_flag,
2825: x_baseline_funding_flag => l_baseline_funding_flag,
2826: x_revproc_currency_code => l_revproc_currency_code,

Line 2950: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(

2946:
2947: l_conversion_between := 'BTC_PF';
2948:
2949:
2950: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk(
2951: p_from_currency_tab => l_bill_trans_curr_code_tab,
2952: p_to_currency_tab => l_revproc_curr_code_tab,
2953: p_conversion_date_tab => l_revproc_rate_date_tab,
2954: p_conversion_type_tab => l_revproc_rate_type_tab,