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_FP_CALC_PLAN_PKG dependencies on PA_CURRENCY

Line 2263: ,SUM(pa_currency.round_trans_currency_amt1((txn_raw_cost * project_cost_exchange_rate),project_currency_code)) round_project_raw_cost

2259: ,SUM(txn_init_revenue)
2260: ,SUM(txn_raw_cost * project_cost_exchange_rate) unround_project_raw_cost
2261: ,SUM(txn_burdened_cost * project_cost_exchange_rate) unround_project_burden_cost
2262: ,SUM(txn_revenue * project_rev_exchange_rate) unround_project_revenue
2263: ,SUM(pa_currency.round_trans_currency_amt1((txn_raw_cost * project_cost_exchange_rate),project_currency_code)) round_project_raw_cost
2264: ,SUM(pa_currency.round_trans_currency_amt1((txn_burdened_cost * project_cost_exchange_rate),project_currency_code)) round_project_burden_cost
2265: ,SUM(pa_currency.round_trans_currency_amt1((txn_revenue * project_rev_exchange_rate),project_currency_code)) round_project_revenue
2266: ,SUM(txn_raw_cost * projfunc_cost_exchange_rate) unround_projfunc_raw_cost
2267: ,SUM(txn_burdened_cost * projfunc_cost_exchange_rate) unround_projfunc_burden_cost

Line 2264: ,SUM(pa_currency.round_trans_currency_amt1((txn_burdened_cost * project_cost_exchange_rate),project_currency_code)) round_project_burden_cost

2260: ,SUM(txn_raw_cost * project_cost_exchange_rate) unround_project_raw_cost
2261: ,SUM(txn_burdened_cost * project_cost_exchange_rate) unround_project_burden_cost
2262: ,SUM(txn_revenue * project_rev_exchange_rate) unround_project_revenue
2263: ,SUM(pa_currency.round_trans_currency_amt1((txn_raw_cost * project_cost_exchange_rate),project_currency_code)) round_project_raw_cost
2264: ,SUM(pa_currency.round_trans_currency_amt1((txn_burdened_cost * project_cost_exchange_rate),project_currency_code)) round_project_burden_cost
2265: ,SUM(pa_currency.round_trans_currency_amt1((txn_revenue * project_rev_exchange_rate),project_currency_code)) round_project_revenue
2266: ,SUM(txn_raw_cost * projfunc_cost_exchange_rate) unround_projfunc_raw_cost
2267: ,SUM(txn_burdened_cost * projfunc_cost_exchange_rate) unround_projfunc_burden_cost
2268: ,SUM(txn_revenue * projfunc_rev_exchange_rate) unround_projfunc_revenue

Line 2265: ,SUM(pa_currency.round_trans_currency_amt1((txn_revenue * project_rev_exchange_rate),project_currency_code)) round_project_revenue

2261: ,SUM(txn_burdened_cost * project_cost_exchange_rate) unround_project_burden_cost
2262: ,SUM(txn_revenue * project_rev_exchange_rate) unround_project_revenue
2263: ,SUM(pa_currency.round_trans_currency_amt1((txn_raw_cost * project_cost_exchange_rate),project_currency_code)) round_project_raw_cost
2264: ,SUM(pa_currency.round_trans_currency_amt1((txn_burdened_cost * project_cost_exchange_rate),project_currency_code)) round_project_burden_cost
2265: ,SUM(pa_currency.round_trans_currency_amt1((txn_revenue * project_rev_exchange_rate),project_currency_code)) round_project_revenue
2266: ,SUM(txn_raw_cost * projfunc_cost_exchange_rate) unround_projfunc_raw_cost
2267: ,SUM(txn_burdened_cost * projfunc_cost_exchange_rate) unround_projfunc_burden_cost
2268: ,SUM(txn_revenue * projfunc_rev_exchange_rate) unround_projfunc_revenue
2269: ,SUM(pa_currency.round_trans_currency_amt1((txn_raw_cost * projfunc_cost_exchange_rate),projfunc_currency_code)) round_projfunc_raw_cost

Line 2269: ,SUM(pa_currency.round_trans_currency_amt1((txn_raw_cost * projfunc_cost_exchange_rate),projfunc_currency_code)) round_projfunc_raw_cost

2265: ,SUM(pa_currency.round_trans_currency_amt1((txn_revenue * project_rev_exchange_rate),project_currency_code)) round_project_revenue
2266: ,SUM(txn_raw_cost * projfunc_cost_exchange_rate) unround_projfunc_raw_cost
2267: ,SUM(txn_burdened_cost * projfunc_cost_exchange_rate) unround_projfunc_burden_cost
2268: ,SUM(txn_revenue * projfunc_rev_exchange_rate) unround_projfunc_revenue
2269: ,SUM(pa_currency.round_trans_currency_amt1((txn_raw_cost * projfunc_cost_exchange_rate),projfunc_currency_code)) round_projfunc_raw_cost
2270: ,SUM(pa_currency.round_trans_currency_amt1((txn_burdened_cost * projfunc_cost_exchange_rate),projfunc_currency_code)) round_projfunc_burden_cost
2271: ,SUM(pa_currency.round_trans_currency_amt1((txn_revenue * projfunc_rev_exchange_rate),projfunc_currency_code)) round_projfunc_revenue
2272: ,to_number(NULL) diff_proj_raw_cost
2273: ,to_number(NULL) diff_proj_burden_cost

Line 2270: ,SUM(pa_currency.round_trans_currency_amt1((txn_burdened_cost * projfunc_cost_exchange_rate),projfunc_currency_code)) round_projfunc_burden_cost

2266: ,SUM(txn_raw_cost * projfunc_cost_exchange_rate) unround_projfunc_raw_cost
2267: ,SUM(txn_burdened_cost * projfunc_cost_exchange_rate) unround_projfunc_burden_cost
2268: ,SUM(txn_revenue * projfunc_rev_exchange_rate) unround_projfunc_revenue
2269: ,SUM(pa_currency.round_trans_currency_amt1((txn_raw_cost * projfunc_cost_exchange_rate),projfunc_currency_code)) round_projfunc_raw_cost
2270: ,SUM(pa_currency.round_trans_currency_amt1((txn_burdened_cost * projfunc_cost_exchange_rate),projfunc_currency_code)) round_projfunc_burden_cost
2271: ,SUM(pa_currency.round_trans_currency_amt1((txn_revenue * projfunc_rev_exchange_rate),projfunc_currency_code)) round_projfunc_revenue
2272: ,to_number(NULL) diff_proj_raw_cost
2273: ,to_number(NULL) diff_proj_burden_cost
2274: ,to_number(NULL) diff_proj_revenue

Line 2271: ,SUM(pa_currency.round_trans_currency_amt1((txn_revenue * projfunc_rev_exchange_rate),projfunc_currency_code)) round_projfunc_revenue

2267: ,SUM(txn_burdened_cost * projfunc_cost_exchange_rate) unround_projfunc_burden_cost
2268: ,SUM(txn_revenue * projfunc_rev_exchange_rate) unround_projfunc_revenue
2269: ,SUM(pa_currency.round_trans_currency_amt1((txn_raw_cost * projfunc_cost_exchange_rate),projfunc_currency_code)) round_projfunc_raw_cost
2270: ,SUM(pa_currency.round_trans_currency_amt1((txn_burdened_cost * projfunc_cost_exchange_rate),projfunc_currency_code)) round_projfunc_burden_cost
2271: ,SUM(pa_currency.round_trans_currency_amt1((txn_revenue * projfunc_rev_exchange_rate),projfunc_currency_code)) round_projfunc_revenue
2272: ,to_number(NULL) diff_proj_raw_cost
2273: ,to_number(NULL) diff_proj_burden_cost
2274: ,to_number(NULL) diff_proj_revenue
2275: ,to_number(NULL) diff_projfunc_raw_cost

Line 2424: l_diff_proj_raw_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_proj_raw_cost_tab(i),l_proj_currency_code_tab(i));

2420: l_diff_proj_raw_cost_tab(i) := nvl(l_unround_proj_raw_cost_tab(i),0) - nvl(l_round_proj_raw_cost_tab(i),0);
2421: l_diff_proj_burd_cost_tab(i) := nvl(l_unround_proj_burd_cost_tab(i),0) - nvl(l_round_proj_burd_cost_tab(i),0);
2422: l_diff_proj_rev_tab(i) := nvl(l_unround_proj_rev_tab(i),0) - nvl(l_round_proj_rev_tab(i),0);
2423:
2424: l_diff_proj_raw_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_proj_raw_cost_tab(i),l_proj_currency_code_tab(i));
2425: l_diff_proj_burd_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_proj_burd_cost_tab(i),l_proj_currency_code_tab(i));
2426: l_diff_proj_rev_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_proj_rev_tab(i),l_proj_currency_code_tab(i));
2427: /* projfunc discrepancy */
2428: l_diff_pjfc_raw_cost_tab(i) := nvl(l_unround_pjfc_raw_cost_tab(i),0) - nvl(l_round_pjfc_raw_cost_tab(i),0);

Line 2425: l_diff_proj_burd_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_proj_burd_cost_tab(i),l_proj_currency_code_tab(i));

2421: l_diff_proj_burd_cost_tab(i) := nvl(l_unround_proj_burd_cost_tab(i),0) - nvl(l_round_proj_burd_cost_tab(i),0);
2422: l_diff_proj_rev_tab(i) := nvl(l_unround_proj_rev_tab(i),0) - nvl(l_round_proj_rev_tab(i),0);
2423:
2424: l_diff_proj_raw_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_proj_raw_cost_tab(i),l_proj_currency_code_tab(i));
2425: l_diff_proj_burd_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_proj_burd_cost_tab(i),l_proj_currency_code_tab(i));
2426: l_diff_proj_rev_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_proj_rev_tab(i),l_proj_currency_code_tab(i));
2427: /* projfunc discrepancy */
2428: l_diff_pjfc_raw_cost_tab(i) := nvl(l_unround_pjfc_raw_cost_tab(i),0) - nvl(l_round_pjfc_raw_cost_tab(i),0);
2429: l_diff_pjfc_burd_cost_tab(i) := nvl(l_unround_pjfc_burd_cost_tab(i),0) - nvl(l_round_pjfc_burd_cost_tab(i),0);

Line 2426: l_diff_proj_rev_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_proj_rev_tab(i),l_proj_currency_code_tab(i));

2422: l_diff_proj_rev_tab(i) := nvl(l_unround_proj_rev_tab(i),0) - nvl(l_round_proj_rev_tab(i),0);
2423:
2424: l_diff_proj_raw_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_proj_raw_cost_tab(i),l_proj_currency_code_tab(i));
2425: l_diff_proj_burd_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_proj_burd_cost_tab(i),l_proj_currency_code_tab(i));
2426: l_diff_proj_rev_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_proj_rev_tab(i),l_proj_currency_code_tab(i));
2427: /* projfunc discrepancy */
2428: l_diff_pjfc_raw_cost_tab(i) := nvl(l_unround_pjfc_raw_cost_tab(i),0) - nvl(l_round_pjfc_raw_cost_tab(i),0);
2429: l_diff_pjfc_burd_cost_tab(i) := nvl(l_unround_pjfc_burd_cost_tab(i),0) - nvl(l_round_pjfc_burd_cost_tab(i),0);
2430: l_diff_pjfc_rev_tab(i) := nvl(l_unround_pjfc_rev_tab(i),0) - nvl(l_round_pjfc_rev_tab(i),0);

Line 2432: l_diff_pjfc_raw_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_pjfc_raw_cost_tab(i),l_pjfc_currency_code_tab(i));

2428: l_diff_pjfc_raw_cost_tab(i) := nvl(l_unround_pjfc_raw_cost_tab(i),0) - nvl(l_round_pjfc_raw_cost_tab(i),0);
2429: l_diff_pjfc_burd_cost_tab(i) := nvl(l_unround_pjfc_burd_cost_tab(i),0) - nvl(l_round_pjfc_burd_cost_tab(i),0);
2430: l_diff_pjfc_rev_tab(i) := nvl(l_unround_pjfc_rev_tab(i),0) - nvl(l_round_pjfc_rev_tab(i),0);
2431:
2432: l_diff_pjfc_raw_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_pjfc_raw_cost_tab(i),l_pjfc_currency_code_tab(i));
2433: l_diff_pjfc_burd_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_pjfc_burd_cost_tab(i),l_pjfc_currency_code_tab(i));
2434: l_diff_pjfc_rev_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_pjfc_rev_tab(i),l_pjfc_currency_code_tab(i));
2435: END LOOP;
2436:

Line 2433: l_diff_pjfc_burd_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_pjfc_burd_cost_tab(i),l_pjfc_currency_code_tab(i));

2429: l_diff_pjfc_burd_cost_tab(i) := nvl(l_unround_pjfc_burd_cost_tab(i),0) - nvl(l_round_pjfc_burd_cost_tab(i),0);
2430: l_diff_pjfc_rev_tab(i) := nvl(l_unround_pjfc_rev_tab(i),0) - nvl(l_round_pjfc_rev_tab(i),0);
2431:
2432: l_diff_pjfc_raw_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_pjfc_raw_cost_tab(i),l_pjfc_currency_code_tab(i));
2433: l_diff_pjfc_burd_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_pjfc_burd_cost_tab(i),l_pjfc_currency_code_tab(i));
2434: l_diff_pjfc_rev_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_pjfc_rev_tab(i),l_pjfc_currency_code_tab(i));
2435: END LOOP;
2436:
2437: l_null_revenue_amts_flag := 'N';

Line 2434: l_diff_pjfc_rev_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_pjfc_rev_tab(i),l_pjfc_currency_code_tab(i));

2430: l_diff_pjfc_rev_tab(i) := nvl(l_unround_pjfc_rev_tab(i),0) - nvl(l_round_pjfc_rev_tab(i),0);
2431:
2432: l_diff_pjfc_raw_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_pjfc_raw_cost_tab(i),l_pjfc_currency_code_tab(i));
2433: l_diff_pjfc_burd_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_pjfc_burd_cost_tab(i),l_pjfc_currency_code_tab(i));
2434: l_diff_pjfc_rev_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_pjfc_rev_tab(i),l_pjfc_currency_code_tab(i));
2435: END LOOP;
2436:
2437: l_null_revenue_amts_flag := 'N';
2438: IF (p_calling_module IN ('BUDGET_GENERATION','FORECAST_GENERATION') AND p_budget_version_type = 'ALL'

Line 2583: ,pa_currency.round_trans_currency_amt1((nvl(txn_raw_cost,0) - nvl(txn_init_raw_cost,0)),txn_currency_code))) rounded_txn_raw_cost

2579: ,SUM(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(rw_cost_rate_override,cost_rate))) unrounded_txn_raw_cost
2580: ,SUM(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(burden_cost_rate_override,burden_cost_rate))) unrounded_txn_burdened_cost
2581: ,SUM(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(bill_rate_override,bill_rate))) unrounded_txn_revenue
2582: ,SUM(decode(nvl(rw_cost_rate_override,nvl(cost_rate,0)),0,0
2583: ,pa_currency.round_trans_currency_amt1((nvl(txn_raw_cost,0) - nvl(txn_init_raw_cost,0)),txn_currency_code))) rounded_txn_raw_cost
2584: ,SUM(decode(nvl(burden_cost_rate_override,nvl(burden_cost_rate,0)),0,0
2585: ,pa_currency.round_trans_currency_amt1((nvl(txn_burdened_cost,0) - nvl(txn_init_burdened_cost,0)),txn_currency_code))) rounded_txn_burdened_cost
2586: ,SUM(decode(nvl(bill_rate_override,nvl(bill_rate,0)),0,0
2587: ,pa_currency.round_trans_currency_amt1((nvl(txn_revenue,0) - nvl(txn_init_revenue,0)),txn_currency_code))) rounded_txn_revenue

Line 2585: ,pa_currency.round_trans_currency_amt1((nvl(txn_burdened_cost,0) - nvl(txn_init_burdened_cost,0)),txn_currency_code))) rounded_txn_burdened_cost

2581: ,SUM(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(bill_rate_override,bill_rate))) unrounded_txn_revenue
2582: ,SUM(decode(nvl(rw_cost_rate_override,nvl(cost_rate,0)),0,0
2583: ,pa_currency.round_trans_currency_amt1((nvl(txn_raw_cost,0) - nvl(txn_init_raw_cost,0)),txn_currency_code))) rounded_txn_raw_cost
2584: ,SUM(decode(nvl(burden_cost_rate_override,nvl(burden_cost_rate,0)),0,0
2585: ,pa_currency.round_trans_currency_amt1((nvl(txn_burdened_cost,0) - nvl(txn_init_burdened_cost,0)),txn_currency_code))) rounded_txn_burdened_cost
2586: ,SUM(decode(nvl(bill_rate_override,nvl(bill_rate,0)),0,0
2587: ,pa_currency.round_trans_currency_amt1((nvl(txn_revenue,0) - nvl(txn_init_revenue,0)),txn_currency_code))) rounded_txn_revenue
2588: /**
2589: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(rw_cost_rate_override,cost_rate))

Line 2587: ,pa_currency.round_trans_currency_amt1((nvl(txn_revenue,0) - nvl(txn_init_revenue,0)),txn_currency_code))) rounded_txn_revenue

2583: ,pa_currency.round_trans_currency_amt1((nvl(txn_raw_cost,0) - nvl(txn_init_raw_cost,0)),txn_currency_code))) rounded_txn_raw_cost
2584: ,SUM(decode(nvl(burden_cost_rate_override,nvl(burden_cost_rate,0)),0,0
2585: ,pa_currency.round_trans_currency_amt1((nvl(txn_burdened_cost,0) - nvl(txn_init_burdened_cost,0)),txn_currency_code))) rounded_txn_burdened_cost
2586: ,SUM(decode(nvl(bill_rate_override,nvl(bill_rate,0)),0,0
2587: ,pa_currency.round_trans_currency_amt1((nvl(txn_revenue,0) - nvl(txn_init_revenue,0)),txn_currency_code))) rounded_txn_revenue
2588: /**
2589: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(rw_cost_rate_override,cost_rate))
2590: ,txn_currency_code)) rounded_txn_raw_cost
2591: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(burden_cost_rate_override,burden_cost_rate))

Line 2589: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(rw_cost_rate_override,cost_rate))

2585: ,pa_currency.round_trans_currency_amt1((nvl(txn_burdened_cost,0) - nvl(txn_init_burdened_cost,0)),txn_currency_code))) rounded_txn_burdened_cost
2586: ,SUM(decode(nvl(bill_rate_override,nvl(bill_rate,0)),0,0
2587: ,pa_currency.round_trans_currency_amt1((nvl(txn_revenue,0) - nvl(txn_init_revenue,0)),txn_currency_code))) rounded_txn_revenue
2588: /**
2589: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(rw_cost_rate_override,cost_rate))
2590: ,txn_currency_code)) rounded_txn_raw_cost
2591: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(burden_cost_rate_override,burden_cost_rate))
2592: ,txn_currency_code)) rounded_txn_burdened_cost
2593: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(bill_rate_override,bill_rate))

Line 2591: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(burden_cost_rate_override,burden_cost_rate))

2587: ,pa_currency.round_trans_currency_amt1((nvl(txn_revenue,0) - nvl(txn_init_revenue,0)),txn_currency_code))) rounded_txn_revenue
2588: /**
2589: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(rw_cost_rate_override,cost_rate))
2590: ,txn_currency_code)) rounded_txn_raw_cost
2591: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(burden_cost_rate_override,burden_cost_rate))
2592: ,txn_currency_code)) rounded_txn_burdened_cost
2593: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(bill_rate_override,bill_rate))
2594: ,txn_currency_code)) rounded_txn_revenue
2595: **/

Line 2593: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(bill_rate_override,bill_rate))

2589: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(rw_cost_rate_override,cost_rate))
2590: ,txn_currency_code)) rounded_txn_raw_cost
2591: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(burden_cost_rate_override,burden_cost_rate))
2592: ,txn_currency_code)) rounded_txn_burdened_cost
2593: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(bill_rate_override,bill_rate))
2594: ,txn_currency_code)) rounded_txn_revenue
2595: **/
2596: ,to_number(NULL) diff_raw_cost
2597: ,to_number(NULL) diff_burden_cost

Line 2702: l_diff_raw_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_raw_cost_tab(i),l_txn_currency_code_tab(i));

2698: FOR i IN l_resource_assignment_tab.FIRST .. l_resource_assignment_tab.LAST LOOP
2699: l_diff_raw_cost_tab(i) := nvl(l_unrounded_txn_raw_cost_tab(i),0) - nvl(l_rounded_txn_raw_cost_tab(i),0);
2700: l_diff_burden_cost_tab(i) := nvl(l_unround_txn_burden_cost_tab(i),0) - nvl(l_rounded_txn_burden_cost_tab(i),0);
2701: l_diff_revenue_tab(i) := nvl(l_unrounded_txn_revenue_tab(i),0) - nvl(l_rounded_txn_revenue_tab(i),0);
2702: l_diff_raw_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_raw_cost_tab(i),l_txn_currency_code_tab(i));
2703: l_diff_burden_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_burden_cost_tab(i),l_txn_currency_code_tab(i));
2704: l_diff_revenue_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_revenue_tab(i),l_txn_currency_code_tab(i));
2705: END LOOP;
2706:

Line 2703: l_diff_burden_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_burden_cost_tab(i),l_txn_currency_code_tab(i));

2699: l_diff_raw_cost_tab(i) := nvl(l_unrounded_txn_raw_cost_tab(i),0) - nvl(l_rounded_txn_raw_cost_tab(i),0);
2700: l_diff_burden_cost_tab(i) := nvl(l_unround_txn_burden_cost_tab(i),0) - nvl(l_rounded_txn_burden_cost_tab(i),0);
2701: l_diff_revenue_tab(i) := nvl(l_unrounded_txn_revenue_tab(i),0) - nvl(l_rounded_txn_revenue_tab(i),0);
2702: l_diff_raw_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_raw_cost_tab(i),l_txn_currency_code_tab(i));
2703: l_diff_burden_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_burden_cost_tab(i),l_txn_currency_code_tab(i));
2704: l_diff_revenue_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_revenue_tab(i),l_txn_currency_code_tab(i));
2705: END LOOP;
2706:
2707: l_null_revenue_amts_flag := 'N';

Line 2704: l_diff_revenue_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_revenue_tab(i),l_txn_currency_code_tab(i));

2700: l_diff_burden_cost_tab(i) := nvl(l_unround_txn_burden_cost_tab(i),0) - nvl(l_rounded_txn_burden_cost_tab(i),0);
2701: l_diff_revenue_tab(i) := nvl(l_unrounded_txn_revenue_tab(i),0) - nvl(l_rounded_txn_revenue_tab(i),0);
2702: l_diff_raw_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_raw_cost_tab(i),l_txn_currency_code_tab(i));
2703: l_diff_burden_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_burden_cost_tab(i),l_txn_currency_code_tab(i));
2704: l_diff_revenue_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_revenue_tab(i),l_txn_currency_code_tab(i));
2705: END LOOP;
2706:
2707: l_null_revenue_amts_flag := 'N';
2708: IF (p_calling_module IN ('BUDGET_GENERATION','FORECAST_GENERATION') AND p_budget_version_type = 'ALL'

Line 6395: ,(NVL(tmp.init_quantity,0)+ pa_currency.round_trans_currency_amt1 (

6391: UPDATE /*+ INDEX(TMP PA_FP_ROLLUP_TMP_N1) */ pa_fp_rollup_tmp tmp
6392: SET tmp.old_quantity = decode(l_quantity_adj_pct,NULL,to_number(NULL),tmp.quantity)
6393: ,tmp.quantity = decode(l_quantity_adj_pct,NULL,tmp.quantity
6394: ,decode(NVL(tmp.rate_based_flag,'N'),'N'
6395: ,(NVL(tmp.init_quantity,0)+ pa_currency.round_trans_currency_amt1 (
6396: ((NVL(tmp.quantity,0) - nvl(tmp.init_quantity,0))
6397: * ((l_quantity_adj_pct + 100)/100)),tmp.txn_currency_code))
6398: ,(NVL(tmp.init_quantity,0)+ Round(((NVL(tmp.quantity,0) - nvl(tmp.init_quantity,0))
6399: * ((l_quantity_adj_pct + 100)/100)),5)))

Line 6440: ,(NVL(tmp.init_quantity,0)+ pa_currency.round_trans_currency_amt1 (

6436: ,decode(l_quantity_adj_pct,NULL,to_number(NULL),tmp.quantity))
6437: ,tmp.quantity = decode(NVL(tmp.rate_based_flag,'N'),'N',tmp.quantity
6438: ,decode(l_quantity_adj_pct,NULL,tmp.quantity
6439: ,decode(NVL(tmp.rate_based_flag,'N'),'N'
6440: ,(NVL(tmp.init_quantity,0)+ pa_currency.round_trans_currency_amt1 (
6441: ((NVL(tmp.quantity,0) - nvl(tmp.init_quantity,0))
6442: * ((l_quantity_adj_pct + 100)/100)),tmp.txn_currency_code))
6443: ,(NVL(tmp.init_quantity,0)+ Round(((NVL(tmp.quantity,0) - nvl(tmp.init_quantity,0))
6444: * ((l_quantity_adj_pct + 100)/100)),5)))

Line 6501: ,(NVL(tmp.txn_init_raw_cost,0)+ pa_currency.round_trans_currency_amt1 (

6497: decode(l_revenue_adj_pct,NULL,to_number(null),tmp.txn_revenue)
6498: ,tmp.txn_raw_cost =
6499: decode(l_raw_cost_adj_pct,NULL,tmp.txn_raw_cost
6500: ,decode(tmp.txn_raw_cost,NULL,NULL,0,0
6501: ,(NVL(tmp.txn_init_raw_cost,0)+ pa_currency.round_trans_currency_amt1 (
6502: ((NVL(tmp.txn_raw_cost,0) - nvl(tmp.txn_init_raw_cost,0))
6503: * ((l_raw_cost_adj_pct + 100)/100)),tmp.txn_currency_code))))
6504: ,tmp.txn_revenue =
6505: decode(l_revenue_adj_pct,NULL,tmp.txn_revenue

Line 6507: ,(NVL(tmp.txn_init_revenue,0)+ pa_currency.round_trans_currency_amt1 (

6503: * ((l_raw_cost_adj_pct + 100)/100)),tmp.txn_currency_code))))
6504: ,tmp.txn_revenue =
6505: decode(l_revenue_adj_pct,NULL,tmp.txn_revenue
6506: ,decode(tmp.txn_revenue,NULL,NULL,0,0
6507: ,(NVL(tmp.txn_init_revenue,0)+ pa_currency.round_trans_currency_amt1 (
6508: ((NVL(tmp.txn_revenue,0) - nvl(tmp.txn_init_revenue,0))
6509: * ((l_revenue_adj_pct + 100)/100)),tmp.txn_currency_code))))
6510: ,tmp.quantity = decode(NVL(tmp.rate_based_flag,'N'),'Y',tmp.quantity
6511: ,decode(l_raw_cost_adj_pct,NULL

Line 6514: ,'REVENUE', (NVL(tmp.txn_init_revenue,0)+ pa_currency.round_trans_currency_amt1 (

6510: ,tmp.quantity = decode(NVL(tmp.rate_based_flag,'N'),'Y',tmp.quantity
6511: ,decode(l_raw_cost_adj_pct,NULL
6512: ,decode(l_revenue_adj_pct, NULL, tmp.quantity
6513: ,decode(g_fp_budget_version_type,'COST',tmp.quantity
6514: ,'REVENUE', (NVL(tmp.txn_init_revenue,0)+ pa_currency.round_trans_currency_amt1 (
6515: ((NVL(tmp.txn_revenue,0) - nvl(tmp.txn_init_revenue,0))
6516: * ((l_revenue_adj_pct + 100)/100)),tmp.txn_currency_code))
6517: ,'ALL',decode(nvl(tmp.rw_cost_rate_override,0),0
6518: ,(NVL(tmp.txn_init_revenue,0)+ pa_currency.round_trans_currency_amt1 (

Line 6518: ,(NVL(tmp.txn_init_revenue,0)+ pa_currency.round_trans_currency_amt1 (

6514: ,'REVENUE', (NVL(tmp.txn_init_revenue,0)+ pa_currency.round_trans_currency_amt1 (
6515: ((NVL(tmp.txn_revenue,0) - nvl(tmp.txn_init_revenue,0))
6516: * ((l_revenue_adj_pct + 100)/100)),tmp.txn_currency_code))
6517: ,'ALL',decode(nvl(tmp.rw_cost_rate_override,0),0
6518: ,(NVL(tmp.txn_init_revenue,0)+ pa_currency.round_trans_currency_amt1 (
6519: ((NVL(tmp.txn_revenue,0) - nvl(tmp.txn_init_revenue,0))
6520: * ((l_revenue_adj_pct + 100)/100)),tmp.txn_currency_code))
6521: ,tmp.quantity)))
6522: ,decode(g_fp_budget_version_type,'REVENUE',tmp.quantity

Line 6523: ,'COST',(NVL(tmp.txn_init_raw_cost,0)+ pa_currency.round_trans_currency_amt1 (

6519: ((NVL(tmp.txn_revenue,0) - nvl(tmp.txn_init_revenue,0))
6520: * ((l_revenue_adj_pct + 100)/100)),tmp.txn_currency_code))
6521: ,tmp.quantity)))
6522: ,decode(g_fp_budget_version_type,'REVENUE',tmp.quantity
6523: ,'COST',(NVL(tmp.txn_init_raw_cost,0)+ pa_currency.round_trans_currency_amt1 (
6524: ((NVL(tmp.txn_raw_cost,0) - nvl(tmp.txn_init_raw_cost,0))
6525: * ((l_raw_cost_adj_pct + 100)/100)),tmp.txn_currency_code))
6526: ,'ALL',decode(nvl(tmp.rw_cost_rate_override,0),0,tmp.quantity
6527: ,(NVL(tmp.txn_init_raw_cost,0)+ pa_currency.round_trans_currency_amt1 (

Line 6527: ,(NVL(tmp.txn_init_raw_cost,0)+ pa_currency.round_trans_currency_amt1 (

6523: ,'COST',(NVL(tmp.txn_init_raw_cost,0)+ pa_currency.round_trans_currency_amt1 (
6524: ((NVL(tmp.txn_raw_cost,0) - nvl(tmp.txn_init_raw_cost,0))
6525: * ((l_raw_cost_adj_pct + 100)/100)),tmp.txn_currency_code))
6526: ,'ALL',decode(nvl(tmp.rw_cost_rate_override,0),0,tmp.quantity
6527: ,(NVL(tmp.txn_init_raw_cost,0)+ pa_currency.round_trans_currency_amt1 (
6528: ((NVL(tmp.txn_raw_cost,0) - nvl(tmp.txn_init_raw_cost,0))
6529: * ((l_raw_cost_adj_pct + 100)/100)),tmp.txn_currency_code))))))
6530: ,tmp.burden_cost_rate_override =
6531: Decode(g_fp_budget_version_type,'REVENUE',tmp.burden_cost_rate_override

Line 6621: l_quantity_old_tab(i) := pa_currency.round_trans_currency_amt1

6617: FOR i IN l_blId_tab.FIRST .. l_blId_tab.LAST LOOP
6618: If l_ratebase_tab(i) = 'Y' Then
6619: l_quantity_old_tab(i) := Round_Quantity(l_quantity_old_tab(i));
6620: Else
6621: l_quantity_old_tab(i) := pa_currency.round_trans_currency_amt1
6622: (l_quantity_old_tab(i),l_txn_cur_tab(i));
6623: End If;
6624: IF l_quantity_old_tab(i) <> l_quantity_new_tab(i) Then
6625: l_quantity_diff_tab(i) := l_quantity_old_tab(i) - l_quantity_new_tab(i);

Line 6642: l_rawcost_old_tab(i) := pa_currency.round_trans_currency_amt1

6638: print_msg(g_stage);
6639: End If;
6640: FOR i IN l_blId_tab.FIRST .. l_blId_tab.LAST LOOP
6641: If l_ratebase_tab(i) = 'N' Then
6642: l_rawcost_old_tab(i) := pa_currency.round_trans_currency_amt1
6643: (l_rawcost_old_tab(i),l_txn_cur_tab(i));
6644: End If;
6645: IF l_rawcost_old_tab(i) <> l_rawcost_new_tab(i) Then
6646: l_rawcost_diff_tab(i) := l_rawcost_old_tab(i) - l_rawcost_new_tab(i);

Line 6671: l_revenue_old_tab(i) := pa_currency.round_trans_currency_amt1

6667: print_msg(g_stage);
6668: End If;
6669: FOR i IN l_blId_tab.FIRST .. l_blId_tab.LAST LOOP
6670: If l_ratebase_tab(i) = 'N' Then
6671: l_revenue_old_tab(i) := pa_currency.round_trans_currency_amt1
6672: (l_revenue_old_tab(i),l_txn_cur_tab(i));
6673: End If;
6674: IF l_revenue_old_tab(i) <> l_revenue_new_tab(i) Then
6675: l_revenue_diff_tab(i) := l_revenue_old_tab(i) - l_revenue_new_tab(i);

Line 9541: l_txn_plan_quantity := pa_currency.round_trans_currency_amt1(l_txn_plan_quantity,l_txn_currency_code);

9537:
9538: /* Rounding Enhancements: round off the given quantity and amounts before start processing */
9539: If l_txn_plan_quantity is NOT NULL Then
9540: If l_rate_based_flag = 'N' THEN
9541: l_txn_plan_quantity := pa_currency.round_trans_currency_amt1(l_txn_plan_quantity,l_txn_currency_code);
9542: Else
9543: l_txn_plan_quantity := round_quantity(l_txn_plan_quantity);
9544: End If;
9545: End If;

Line 9548: l_txn_raw_cost := pa_currency.round_trans_currency_amt1(l_txn_raw_cost,l_txn_currency_code);

9544: End If;
9545: End If;
9546:
9547: If l_txn_raw_cost is NOT NULL Then
9548: l_txn_raw_cost := pa_currency.round_trans_currency_amt1(l_txn_raw_cost,l_txn_currency_code);
9549: End If;
9550: If l_txn_burdened_cost is NOT NULL Then
9551: l_txn_burdened_cost := pa_currency.round_trans_currency_amt1(l_txn_burdened_cost,l_txn_currency_code);
9552: End If;

Line 9551: l_txn_burdened_cost := pa_currency.round_trans_currency_amt1(l_txn_burdened_cost,l_txn_currency_code);

9547: If l_txn_raw_cost is NOT NULL Then
9548: l_txn_raw_cost := pa_currency.round_trans_currency_amt1(l_txn_raw_cost,l_txn_currency_code);
9549: End If;
9550: If l_txn_burdened_cost is NOT NULL Then
9551: l_txn_burdened_cost := pa_currency.round_trans_currency_amt1(l_txn_burdened_cost,l_txn_currency_code);
9552: End If;
9553: If l_txn_revenue is NOT NULL Then
9554: l_txn_revenue := pa_currency.round_trans_currency_amt1(l_txn_revenue,l_txn_currency_code);
9555: End If;

Line 9554: l_txn_revenue := pa_currency.round_trans_currency_amt1(l_txn_revenue,l_txn_currency_code);

9550: If l_txn_burdened_cost is NOT NULL Then
9551: l_txn_burdened_cost := pa_currency.round_trans_currency_amt1(l_txn_burdened_cost,l_txn_currency_code);
9552: End If;
9553: If l_txn_revenue is NOT NULL Then
9554: l_txn_revenue := pa_currency.round_trans_currency_amt1(l_txn_revenue,l_txn_currency_code);
9555: End If;
9556:
9557: /* compare with budget line values
9558: * and populate the changed flags. Based on these flag apply the

Line 10713: l_txn_raw_cost := pa_currency.round_trans_currency_amt1(l_txn_raw_cost,rec.txn_currency_code);

10709: If NVL(l_txn_raw_cost,0) <> NVL(rec.txn_raw_cost,0) Then
10710: --Bug 6781055
10711: l_rec_modified_in_cl_flag:='Y';
10712:
10713: l_txn_raw_cost := pa_currency.round_trans_currency_amt1(l_txn_raw_cost,rec.txn_currency_code);
10714: l_txn_plan_quantity := l_txn_raw_cost;
10715: l_cl_raw_rejection_code := NULL;
10716: /* change in raw cost changes the burden cost rate */
10717: --Bug 6781055

Line 10734: l_txn_raw_cost := pa_currency.round_trans_currency_amt1(l_txn_raw_cost,rec.txn_currency_code);

10730: Else
10731: If NVL(l_txn_raw_cost,0) <> NVL(rec.txn_raw_cost,0) Then
10732: --Bug 6781055
10733: l_rec_modified_in_cl_flag:='Y';
10734: l_txn_raw_cost := pa_currency.round_trans_currency_amt1(l_txn_raw_cost,rec.txn_currency_code);
10735: l_cl_raw_rejection_code := NULL;
10736: --Bug 6781055
10737: If nvl(l_txn_plan_quantity-l_cl_init_quantity,0) <> 0 Then
10738: l_rw_cost_rate_override := (l_txn_raw_cost-l_cl_init_raw_cost)/(l_txn_plan_quantity-l_cl_init_quantity);

Line 10744: l_txn_raw_cost := pa_currency.round_trans_currency_amt1(l_txn_raw_cost,rec.txn_currency_code);

10740: End If;
10741: Else --{calculate override -- Bug 14117870
10742: If ( (nvl(p_calling_module,'BUDGET_GENERATION') = 'BUDGET_GENERATION')
10743: AND (nvl(l_txn_plan_quantity,0) <> 0) )Then
10744: l_txn_raw_cost := pa_currency.round_trans_currency_amt1(l_txn_raw_cost,rec.txn_currency_code);
10745: l_cl_raw_rejection_code := NULL;
10746: -- l_rw_cost_rate_override := l_txn_raw_cost/l_txn_plan_quantity;
10747: --l_rw_cost_rate_override := pa_currency.round_trans_currency_amt1(l_rw_cost_rate_override,rec.txn_currency_code); -- Bug 14398131
10748: End If; -- Bug 14117870

Line 10747: --l_rw_cost_rate_override := pa_currency.round_trans_currency_amt1(l_rw_cost_rate_override,rec.txn_currency_code); -- Bug 14398131

10743: AND (nvl(l_txn_plan_quantity,0) <> 0) )Then
10744: l_txn_raw_cost := pa_currency.round_trans_currency_amt1(l_txn_raw_cost,rec.txn_currency_code);
10745: l_cl_raw_rejection_code := NULL;
10746: -- l_rw_cost_rate_override := l_txn_raw_cost/l_txn_plan_quantity;
10747: --l_rw_cost_rate_override := pa_currency.round_trans_currency_amt1(l_rw_cost_rate_override,rec.txn_currency_code); -- Bug 14398131
10748: End If; -- Bug 14117870
10749: End If;
10750: End If;
10751: End If;

Line 10785: l_txn_burdened_cost := pa_currency.round_trans_currency_amt1(l_txn_burdened_cost,rec.txn_currency_code);

10781: /* re derive the burden cost rate override after calling the client extn */
10782: If NVl(l_txn_burdened_cost,0) <> NVl(rec.txn_burdened_cost,0) Then
10783: --Bug 6781055
10784: l_rec_modified_in_cl_flag:='Y';
10785: l_txn_burdened_cost := pa_currency.round_trans_currency_amt1(l_txn_burdened_cost,rec.txn_currency_code);
10786: l_cl_burd_rejection_code := NULL;
10787: --Bug 6781055
10788: If nvl(l_txn_plan_quantity-l_cl_init_quantity,0) <> 0 Then
10789: l_burden_cost_rate_override := (l_txn_burdened_cost-l_cl_init_burd_cost)/(l_txn_plan_quantity-l_cl_init_quantity);

Line 10795: l_txn_burdened_cost := pa_currency.round_trans_currency_amt1(l_txn_burdened_cost,rec.txn_currency_code);

10791: End if;
10792: Else --{calculate override -- Bug 14117870
10793: If ( (nvl(p_calling_module,'BUDGET_GENERATION') = 'BUDGET_GENERATION')
10794: AND (nvl(l_txn_plan_quantity,0) <> 0) )Then
10795: l_txn_burdened_cost := pa_currency.round_trans_currency_amt1(l_txn_burdened_cost,rec.txn_currency_code);
10796: l_cl_raw_rejection_code := NULL;
10797: --l_burden_cost_rate_override := l_txn_burdened_cost/l_txn_plan_quantity;
10798: --l_burden_cost_rate_override := pa_currency.round_trans_currency_amt1(l_burden_cost_rate_override,rec.txn_currency_code); -- Bug 14398131
10799: End If; -- Bug 14117870

Line 10798: --l_burden_cost_rate_override := pa_currency.round_trans_currency_amt1(l_burden_cost_rate_override,rec.txn_currency_code); -- Bug 14398131

10794: AND (nvl(l_txn_plan_quantity,0) <> 0) )Then
10795: l_txn_burdened_cost := pa_currency.round_trans_currency_amt1(l_txn_burdened_cost,rec.txn_currency_code);
10796: l_cl_raw_rejection_code := NULL;
10797: --l_burden_cost_rate_override := l_txn_burdened_cost/l_txn_plan_quantity;
10798: --l_burden_cost_rate_override := pa_currency.round_trans_currency_amt1(l_burden_cost_rate_override,rec.txn_currency_code); -- Bug 14398131
10799: End If; -- Bug 14117870
10800: End if;
10801: End If ; -- end of version type
10802:

Line 10838: l_txn_revenue := pa_currency.round_trans_currency_amt1(l_txn_revenue,rec.txn_currency_code);

10834: If rec.rate_based_flag = 'N' Then
10835: If NVL(l_txn_revenue,0) <> NVL(rec.txn_revenue,0) Then
10836: --Bug 6781055
10837: l_rec_modified_in_cl_flag:='Y';
10838: l_txn_revenue := pa_currency.round_trans_currency_amt1(l_txn_revenue,rec.txn_currency_code);
10839: l_cl_rev_rejection_code := NULL;
10840: If rec.version_type = 'REVENUE' Then
10841: l_txn_plan_quantity := l_txn_revenue;
10842: l_bill_rate_override := 1;

Line 10854: l_txn_revenue := pa_currency.round_trans_currency_amt1(l_txn_revenue,rec.txn_currency_code);

10850: Else
10851: If NVL(l_txn_revenue,0) <> NVL(rec.txn_revenue,0) Then
10852: --Bug 6781055
10853: l_rec_modified_in_cl_flag:='Y';
10854: l_txn_revenue := pa_currency.round_trans_currency_amt1(l_txn_revenue,rec.txn_currency_code);
10855: l_cl_rev_rejection_code := NULL;
10856: --Bug 6781055
10857: If nvl(l_txn_plan_quantity-l_cl_init_quantity,0) <> 0 Then
10858: l_bill_rate_override := (l_txn_revenue-l_cl_init_revenue)/(l_txn_plan_quantity-l_cl_init_quantity);

Line 11688: x_final_txn_raw_cost := pa_currency.round_trans_currency_amt1(x_final_txn_raw_cost,p_final_txn_curr_code);

11684:
11685: IF NVL(l_return_status,'S') = 'S' Then
11686: IF nvl(p_denom_raw_cost,0) <> 0 Then
11687: x_final_txn_raw_cost := p_denom_raw_cost * x_final_txn_exch_rate;
11688: x_final_txn_raw_cost := pa_currency.round_trans_currency_amt1(x_final_txn_raw_cost,p_final_txn_curr_code);
11689: End If;
11690: IF nvl(p_denom_burden_cost,0) <> 0 Then
11691: x_final_txn_burden_cost := p_denom_burden_cost * x_final_txn_exch_rate;
11692: x_final_txn_burden_cost := pa_currency.round_trans_currency_amt1(x_final_txn_burden_cost,p_final_txn_curr_code);

Line 11692: x_final_txn_burden_cost := pa_currency.round_trans_currency_amt1(x_final_txn_burden_cost,p_final_txn_curr_code);

11688: x_final_txn_raw_cost := pa_currency.round_trans_currency_amt1(x_final_txn_raw_cost,p_final_txn_curr_code);
11689: End If;
11690: IF nvl(p_denom_burden_cost,0) <> 0 Then
11691: x_final_txn_burden_cost := p_denom_burden_cost * x_final_txn_exch_rate;
11692: x_final_txn_burden_cost := pa_currency.round_trans_currency_amt1(x_final_txn_burden_cost,p_final_txn_curr_code);
11693: End If;
11694: IF nvl(p_denom_revenue,0) <> 0 Then
11695: x_final_txn_revenue := p_denom_revenue * x_final_txn_exch_rate;
11696: x_final_txn_revenue := pa_currency.round_trans_currency_amt1(x_final_txn_revenue,p_final_txn_curr_code);

Line 11696: x_final_txn_revenue := pa_currency.round_trans_currency_amt1(x_final_txn_revenue,p_final_txn_curr_code);

11692: x_final_txn_burden_cost := pa_currency.round_trans_currency_amt1(x_final_txn_burden_cost,p_final_txn_curr_code);
11693: End If;
11694: IF nvl(p_denom_revenue,0) <> 0 Then
11695: x_final_txn_revenue := p_denom_revenue * x_final_txn_exch_rate;
11696: x_final_txn_revenue := pa_currency.round_trans_currency_amt1(x_final_txn_revenue,p_final_txn_curr_code);
11697: End If;
11698: End If;
11699: END IF;
11700: END IF;

Line 13064: x_burden_cost := pa_currency.round_trans_currency_amt1

13060: x_burden_cost_rate := x_cost_rate;
13061: ElsIF NVL(x_burden_multiplier,0) <> 0 Then
13062: x_burden_cost_rate := ((l_txn_plan_quantity * x_cost_rate) +
13063: ((l_txn_plan_quantity * x_cost_rate)*NVL(x_burden_multiplier,0)))/l_txn_plan_quantity;
13064: x_burden_cost := pa_currency.round_trans_currency_amt1
13065: ((l_txn_plan_quantity *x_burden_cost_rate),NVL(x_cost_txn_curr_code,l_txn_currency_code));
13066: END IF;
13067: END IF;
13068: END IF;

Line 13079: IF x_raw_revenue = (pa_currency.round_trans_currency_amt1(

13075: /* check whether markup is applied on raw cost or burdened cost then
13076: * derive the bill rate based on unrounded revenue
13077: */
13078: IF NVL(x_bill_markup_percentage,0) <> 0 Then
13079: IF x_raw_revenue = (pa_currency.round_trans_currency_amt1(
13080: ((1+x_bill_markup_percentage/100)*x_raw_cost),NVL(x_rev_txn_curr_code
13081: ,NVL(x_cost_txn_curr_code,l_txn_currency_code)))) Then
13082: x_bill_rate := ((1+x_bill_markup_percentage/100)*x_raw_cost)/l_txn_plan_quantity;
13083:

Line 13084: Elsif x_raw_revenue = (pa_currency.round_trans_currency_amt1(

13080: ((1+x_bill_markup_percentage/100)*x_raw_cost),NVL(x_rev_txn_curr_code
13081: ,NVL(x_cost_txn_curr_code,l_txn_currency_code)))) Then
13082: x_bill_rate := ((1+x_bill_markup_percentage/100)*x_raw_cost)/l_txn_plan_quantity;
13083:
13084: Elsif x_raw_revenue = (pa_currency.round_trans_currency_amt1(
13085: ((1+x_bill_markup_percentage/100)*x_burden_cost),NVL(x_rev_txn_curr_code
13086: ,NVL(x_cost_txn_curr_code,l_txn_currency_code)))) Then
13087: x_bill_rate := ((1+x_bill_markup_percentage/100)*x_burden_cost)/l_txn_plan_quantity;
13088:

Line 13217: x_raw_cost := pa_currency.round_trans_currency_amt1(x_raw_cost,NVL(x_cost_txn_curr_code,l_txn_currency_code_override));

13213: End If;
13214: End If;
13215: END If; --}
13216: IF NVL(x_raw_cost,0) <> 0 Then
13217: x_raw_cost := pa_currency.round_trans_currency_amt1(x_raw_cost,NVL(x_cost_txn_curr_code,l_txn_currency_code_override));
13218: End If;
13219:
13220: IF NVL(x_burden_cost,0) <> 0 Then
13221: x_burden_cost := pa_currency.round_trans_currency_amt1(x_burden_cost,

Line 13221: x_burden_cost := pa_currency.round_trans_currency_amt1(x_burden_cost,

13217: x_raw_cost := pa_currency.round_trans_currency_amt1(x_raw_cost,NVL(x_cost_txn_curr_code,l_txn_currency_code_override));
13218: End If;
13219:
13220: IF NVL(x_burden_cost,0) <> 0 Then
13221: x_burden_cost := pa_currency.round_trans_currency_amt1(x_burden_cost,
13222: NVL(l_txn_currency_code_override,x_cost_txn_curr_code));
13223: End If;
13224:
13225: If NVL(x_raw_revenue,0) <> 0 Then

Line 13226: x_raw_revenue := pa_currency.round_trans_currency_amt1(x_raw_revenue,

13222: NVL(l_txn_currency_code_override,x_cost_txn_curr_code));
13223: End If;
13224:
13225: If NVL(x_raw_revenue,0) <> 0 Then
13226: x_raw_revenue := pa_currency.round_trans_currency_amt1(x_raw_revenue,
13227: NVL(x_rev_txn_curr_code,l_txn_currency_code_override));
13228: End If;
13229:
13230: /***

Line 14217: x_raw_cost := pa_currency.round_trans_currency_amt1(x_raw_cost,

14213: END IF;
14214: END IF;
14215:
14216: IF NVL(x_raw_cost,0) <> 0 Then
14217: x_raw_cost := pa_currency.round_trans_currency_amt1(x_raw_cost,
14218: NVL(l_Final_txn_currency_code,l_txn_currency_code));
14219: End If;
14220:
14221: IF NVL(x_burden_cost,0) <> 0 Then

Line 14222: x_burden_cost := pa_currency.round_trans_currency_amt1(x_burden_cost,

14218: NVL(l_Final_txn_currency_code,l_txn_currency_code));
14219: End If;
14220:
14221: IF NVL(x_burden_cost,0) <> 0 Then
14222: x_burden_cost := pa_currency.round_trans_currency_amt1(x_burden_cost,
14223: NVL(l_Final_txn_currency_code,l_txn_currency_code));
14224: End If;
14225:
14226: If NVL(x_raw_revenue,0) <> 0 Then

Line 14227: x_raw_revenue := pa_currency.round_trans_currency_amt1(x_raw_revenue,

14223: NVL(l_Final_txn_currency_code,l_txn_currency_code));
14224: End If;
14225:
14226: If NVL(x_raw_revenue,0) <> 0 Then
14227: x_raw_revenue := pa_currency.round_trans_currency_amt1(x_raw_revenue,
14228: NVL(l_Final_txn_currency_code,l_txn_currency_code));
14229: End If;
14230: End If; --}
14231:

Line 14491: i.quantity := pa_currency.round_trans_currency_amt1(i.quantity,p_txn_currency_code);

14487: If NVL(i.quantity,0) <> 0 Then
14488: If p_rate_based_flag = 'Y' Then
14489: i.quantity := Round_quantity(i.quantity);
14490: Else
14491: i.quantity := pa_currency.round_trans_currency_amt1(i.quantity,p_txn_currency_code);
14492: End If;
14493: End If;
14494: If NVL(i.txn_raw_cost,0) <> 0 Then
14495: i.txn_raw_cost := pa_currency.round_trans_currency_amt1(i.txn_raw_cost,p_txn_currency_code);

Line 14495: i.txn_raw_cost := pa_currency.round_trans_currency_amt1(i.txn_raw_cost,p_txn_currency_code);

14491: i.quantity := pa_currency.round_trans_currency_amt1(i.quantity,p_txn_currency_code);
14492: End If;
14493: End If;
14494: If NVL(i.txn_raw_cost,0) <> 0 Then
14495: i.txn_raw_cost := pa_currency.round_trans_currency_amt1(i.txn_raw_cost,p_txn_currency_code);
14496: End If;
14497: If NVL(i.txn_burdened_cost,0) <> 0 Then
14498: i.txn_burdened_cost := pa_currency.round_trans_currency_amt1(i.txn_burdened_cost,p_txn_currency_code);
14499: End If;

Line 14498: i.txn_burdened_cost := pa_currency.round_trans_currency_amt1(i.txn_burdened_cost,p_txn_currency_code);

14494: If NVL(i.txn_raw_cost,0) <> 0 Then
14495: i.txn_raw_cost := pa_currency.round_trans_currency_amt1(i.txn_raw_cost,p_txn_currency_code);
14496: End If;
14497: If NVL(i.txn_burdened_cost,0) <> 0 Then
14498: i.txn_burdened_cost := pa_currency.round_trans_currency_amt1(i.txn_burdened_cost,p_txn_currency_code);
14499: End If;
14500: If NVL(i.txn_revenue,0) <> 0 Then
14501: i.txn_revenue := pa_currency.round_trans_currency_amt1(i.txn_revenue,p_txn_currency_code);
14502: End If;

Line 14501: i.txn_revenue := pa_currency.round_trans_currency_amt1(i.txn_revenue,p_txn_currency_code);

14497: If NVL(i.txn_burdened_cost,0) <> 0 Then
14498: i.txn_burdened_cost := pa_currency.round_trans_currency_amt1(i.txn_burdened_cost,p_txn_currency_code);
14499: End If;
14500: If NVL(i.txn_revenue,0) <> 0 Then
14501: i.txn_revenue := pa_currency.round_trans_currency_amt1(i.txn_revenue,p_txn_currency_code);
14502: End If;
14503: /* end of bug 4221022 */
14504:
14505: x_init_raw_cost := i.init_raw_cost;

Line 14886: pa_currency.round_trans_currency_amt1(

14882: nvl(p_init_quantity,0)) *
14883: nvl(x_txn_b_cost_rate_override,
14884: x_txn_b_cost_rate));
14885: x_txn_burdened_cost :=
14886: pa_currency.round_trans_currency_amt1(
14887: x_txn_burdened_cost,p_txn_currency_code);
14888: x_txn_burdened_cost_addl := nvl(x_txn_burdened_cost,0) -
14889: nvl(p_init_burdened_cost,0);
14890: END IF;

Line 15043: x_txn_revenue_addl := pa_currency.round_trans_currency_amt1(

15039: x_txn_revenue_addl := (nvl(x_txn_plan_quantity,0) -
15040: nvl(p_init_quantity,0)) *
15041: nvl(x_txn_bill_rate_override,
15042: x_txn_bill_rate);
15043: x_txn_revenue_addl := pa_currency.round_trans_currency_amt1(
15044: x_txn_revenue_addl, p_txn_currency_code);
15045: x_txn_revenue := x_txn_revenue_addl + nvl(p_init_revenue,0);
15046: x_txn_plan_quantity_addl := nvl(x_txn_plan_quantity,0) -
15047: nvl(p_bl_quantity,0);

Line 15180: -- x_txn_raw_cost := pa_currency.round_trans_currency_amt1(

15176:
15177: -- x_txn_raw_cost := NVL(x_txn_plan_quantity ,0) *
15178: -- NVL(x_txn_rw_cost_rate_override,
15179: -- x_txn_raw_cost_rate);
15180: -- x_txn_raw_cost := pa_currency.round_trans_currency_amt1(
15181: -- x_txn_raw_cost, p_txn_currency_code);
15182:
15183: -- C1, C2 and C3: rederive cost rate override as raw cost / quantity
15184: IF (nvl(x_txn_plan_quantity, 0) - nvl(p_init_quantity,0)) <> 0 THEN

Line 15213: x_txn_raw_cost := pa_currency.round_trans_currency_amt1(

15209: x_txn_raw_cost :=(NVL(p_init_raw_cost,0) +
15210: ((NVL(x_txn_plan_quantity ,0) - NVL(p_init_quantity,0)) *
15211: NVL(x_txn_rw_cost_rate_override,x_txn_raw_cost_rate)));
15212:
15213: x_txn_raw_cost := pa_currency.round_trans_currency_amt1(
15214: x_txn_raw_cost, p_txn_currency_code);
15215: x_txn_raw_cost_addl := nvl(x_txn_raw_cost,0) -
15216: nvl(p_bl_raw_cost,0);
15217: ELSIF (p_qty_changed_flag = 'Y' AND -- Case C4, C8, C11, C17

Line 15306: x_txn_raw_cost := pa_currency.round_trans_currency_amt1(

15302: x_txn_raw_cost :=(NVL(p_init_raw_cost,0) +
15303: ((NVL(x_txn_plan_quantity ,0) - NVL(p_init_quantity,0)) *
15304: NVL(x_txn_rw_cost_rate_override,x_txn_raw_cost_rate)));
15305:
15306: x_txn_raw_cost := pa_currency.round_trans_currency_amt1(
15307: x_txn_raw_cost,p_txn_currency_code);
15308: x_txn_raw_cost_addl := nvl(x_txn_raw_cost,0) -
15309: nvl(p_bl_raw_cost,0);
15310: END IF;

Line 15356: x_txn_burdened_cost := pa_currency.round_trans_currency_amt1(

15352: p_qty_changed_flag = 'Y') THEN
15353: x_txn_burdened_cost := x_txn_plan_quantity *
15354: NVL(x_txn_b_cost_rate_override,
15355: x_txn_b_cost_rate);
15356: x_txn_burdened_cost := pa_currency.round_trans_currency_amt1(
15357: x_txn_burdened_cost,
15358: p_txn_currency_code);
15359: x_txn_burdened_cost_addl := nvl(x_txn_burdened_cost,0) -
15360: nvl(p_bl_burdened_cost,0);

Line 15467: x_txn_revenue := pa_currency.round_trans_currency_amt1(

15463: (Nvl(x_txn_plan_quantity,0) <> 0)) THEN
15464:
15465: x_txn_revenue := NVL(x_txn_plan_quantity ,0) *
15466: NVL(x_txn_bill_rate_override, x_txn_bill_rate);
15467: x_txn_revenue := pa_currency.round_trans_currency_amt1(
15468: x_txn_revenue,p_txn_currency_code);
15469: x_txn_revenue_addl := nvl(x_txn_revenue,0) -
15470: nvl(p_bl_revenue,0);
15471: END IF;

Line 15573: x_txn_revenue := pa_currency.round_trans_currency_amt1(

15569: -- CR3, CR11, CR12, CR23: rederive revenue as quantity * bill rate
15570: -- CR13, CR24, CR25, CR31: rederive revenue as quantity * bill rate
15571: x_txn_revenue := NVL(x_txn_plan_quantity ,0) *
15572: NVL(x_txn_bill_rate_override, x_txn_bill_rate);
15573: x_txn_revenue := pa_currency.round_trans_currency_amt1(
15574: x_txn_revenue,p_txn_currency_code);
15575: x_txn_revenue_addl := nvl(x_txn_revenue,0) - nvl(p_bl_revenue,0);
15576:
15577: END IF; -- end of checks