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 2233: ,SUM(pa_currency.round_trans_currency_amt1((txn_raw_cost * project_cost_exchange_rate),project_currency_code)) round_project_raw_cost

2229: ,SUM(txn_init_revenue)
2230: ,SUM(txn_raw_cost * project_cost_exchange_rate) unround_project_raw_cost
2231: ,SUM(txn_burdened_cost * project_cost_exchange_rate) unround_project_burden_cost
2232: ,SUM(txn_revenue * project_rev_exchange_rate) unround_project_revenue
2233: ,SUM(pa_currency.round_trans_currency_amt1((txn_raw_cost * project_cost_exchange_rate),project_currency_code)) round_project_raw_cost
2234: ,SUM(pa_currency.round_trans_currency_amt1((txn_burdened_cost * project_cost_exchange_rate),project_currency_code)) round_project_burden_cost
2235: ,SUM(pa_currency.round_trans_currency_amt1((txn_revenue * project_rev_exchange_rate),project_currency_code)) round_project_revenue
2236: ,SUM(txn_raw_cost * projfunc_cost_exchange_rate) unround_projfunc_raw_cost
2237: ,SUM(txn_burdened_cost * projfunc_cost_exchange_rate) unround_projfunc_burden_cost

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

2230: ,SUM(txn_raw_cost * project_cost_exchange_rate) unround_project_raw_cost
2231: ,SUM(txn_burdened_cost * project_cost_exchange_rate) unround_project_burden_cost
2232: ,SUM(txn_revenue * project_rev_exchange_rate) unround_project_revenue
2233: ,SUM(pa_currency.round_trans_currency_amt1((txn_raw_cost * project_cost_exchange_rate),project_currency_code)) round_project_raw_cost
2234: ,SUM(pa_currency.round_trans_currency_amt1((txn_burdened_cost * project_cost_exchange_rate),project_currency_code)) round_project_burden_cost
2235: ,SUM(pa_currency.round_trans_currency_amt1((txn_revenue * project_rev_exchange_rate),project_currency_code)) round_project_revenue
2236: ,SUM(txn_raw_cost * projfunc_cost_exchange_rate) unround_projfunc_raw_cost
2237: ,SUM(txn_burdened_cost * projfunc_cost_exchange_rate) unround_projfunc_burden_cost
2238: ,SUM(txn_revenue * projfunc_rev_exchange_rate) unround_projfunc_revenue

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

2231: ,SUM(txn_burdened_cost * project_cost_exchange_rate) unround_project_burden_cost
2232: ,SUM(txn_revenue * project_rev_exchange_rate) unround_project_revenue
2233: ,SUM(pa_currency.round_trans_currency_amt1((txn_raw_cost * project_cost_exchange_rate),project_currency_code)) round_project_raw_cost
2234: ,SUM(pa_currency.round_trans_currency_amt1((txn_burdened_cost * project_cost_exchange_rate),project_currency_code)) round_project_burden_cost
2235: ,SUM(pa_currency.round_trans_currency_amt1((txn_revenue * project_rev_exchange_rate),project_currency_code)) round_project_revenue
2236: ,SUM(txn_raw_cost * projfunc_cost_exchange_rate) unround_projfunc_raw_cost
2237: ,SUM(txn_burdened_cost * projfunc_cost_exchange_rate) unround_projfunc_burden_cost
2238: ,SUM(txn_revenue * projfunc_rev_exchange_rate) unround_projfunc_revenue
2239: ,SUM(pa_currency.round_trans_currency_amt1((txn_raw_cost * projfunc_cost_exchange_rate),projfunc_currency_code)) round_projfunc_raw_cost

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

2235: ,SUM(pa_currency.round_trans_currency_amt1((txn_revenue * project_rev_exchange_rate),project_currency_code)) round_project_revenue
2236: ,SUM(txn_raw_cost * projfunc_cost_exchange_rate) unround_projfunc_raw_cost
2237: ,SUM(txn_burdened_cost * projfunc_cost_exchange_rate) unround_projfunc_burden_cost
2238: ,SUM(txn_revenue * projfunc_rev_exchange_rate) unround_projfunc_revenue
2239: ,SUM(pa_currency.round_trans_currency_amt1((txn_raw_cost * projfunc_cost_exchange_rate),projfunc_currency_code)) round_projfunc_raw_cost
2240: ,SUM(pa_currency.round_trans_currency_amt1((txn_burdened_cost * projfunc_cost_exchange_rate),projfunc_currency_code)) round_projfunc_burden_cost
2241: ,SUM(pa_currency.round_trans_currency_amt1((txn_revenue * projfunc_rev_exchange_rate),projfunc_currency_code)) round_projfunc_revenue
2242: ,to_number(NULL) diff_proj_raw_cost
2243: ,to_number(NULL) diff_proj_burden_cost

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

2236: ,SUM(txn_raw_cost * projfunc_cost_exchange_rate) unround_projfunc_raw_cost
2237: ,SUM(txn_burdened_cost * projfunc_cost_exchange_rate) unround_projfunc_burden_cost
2238: ,SUM(txn_revenue * projfunc_rev_exchange_rate) unround_projfunc_revenue
2239: ,SUM(pa_currency.round_trans_currency_amt1((txn_raw_cost * projfunc_cost_exchange_rate),projfunc_currency_code)) round_projfunc_raw_cost
2240: ,SUM(pa_currency.round_trans_currency_amt1((txn_burdened_cost * projfunc_cost_exchange_rate),projfunc_currency_code)) round_projfunc_burden_cost
2241: ,SUM(pa_currency.round_trans_currency_amt1((txn_revenue * projfunc_rev_exchange_rate),projfunc_currency_code)) round_projfunc_revenue
2242: ,to_number(NULL) diff_proj_raw_cost
2243: ,to_number(NULL) diff_proj_burden_cost
2244: ,to_number(NULL) diff_proj_revenue

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

2237: ,SUM(txn_burdened_cost * projfunc_cost_exchange_rate) unround_projfunc_burden_cost
2238: ,SUM(txn_revenue * projfunc_rev_exchange_rate) unround_projfunc_revenue
2239: ,SUM(pa_currency.round_trans_currency_amt1((txn_raw_cost * projfunc_cost_exchange_rate),projfunc_currency_code)) round_projfunc_raw_cost
2240: ,SUM(pa_currency.round_trans_currency_amt1((txn_burdened_cost * projfunc_cost_exchange_rate),projfunc_currency_code)) round_projfunc_burden_cost
2241: ,SUM(pa_currency.round_trans_currency_amt1((txn_revenue * projfunc_rev_exchange_rate),projfunc_currency_code)) round_projfunc_revenue
2242: ,to_number(NULL) diff_proj_raw_cost
2243: ,to_number(NULL) diff_proj_burden_cost
2244: ,to_number(NULL) diff_proj_revenue
2245: ,to_number(NULL) diff_projfunc_raw_cost

Line 2394: 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));

2390: 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);
2391: 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);
2392: l_diff_proj_rev_tab(i) := nvl(l_unround_proj_rev_tab(i),0) - nvl(l_round_proj_rev_tab(i),0);
2393:
2394: 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));
2395: 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));
2396: l_diff_proj_rev_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_proj_rev_tab(i),l_proj_currency_code_tab(i));
2397: /* projfunc discrepancy */
2398: 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 2395: 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));

2391: 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);
2392: l_diff_proj_rev_tab(i) := nvl(l_unround_proj_rev_tab(i),0) - nvl(l_round_proj_rev_tab(i),0);
2393:
2394: 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));
2395: 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));
2396: l_diff_proj_rev_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_proj_rev_tab(i),l_proj_currency_code_tab(i));
2397: /* projfunc discrepancy */
2398: 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);
2399: 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 2396: l_diff_proj_rev_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_proj_rev_tab(i),l_proj_currency_code_tab(i));

2392: l_diff_proj_rev_tab(i) := nvl(l_unround_proj_rev_tab(i),0) - nvl(l_round_proj_rev_tab(i),0);
2393:
2394: 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));
2395: 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));
2396: l_diff_proj_rev_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_proj_rev_tab(i),l_proj_currency_code_tab(i));
2397: /* projfunc discrepancy */
2398: 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);
2399: 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);
2400: l_diff_pjfc_rev_tab(i) := nvl(l_unround_pjfc_rev_tab(i),0) - nvl(l_round_pjfc_rev_tab(i),0);

Line 2402: 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));

2398: 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);
2399: 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);
2400: l_diff_pjfc_rev_tab(i) := nvl(l_unround_pjfc_rev_tab(i),0) - nvl(l_round_pjfc_rev_tab(i),0);
2401:
2402: 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));
2403: 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));
2404: l_diff_pjfc_rev_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_pjfc_rev_tab(i),l_pjfc_currency_code_tab(i));
2405: END LOOP;
2406:

Line 2403: 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));

2399: 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);
2400: l_diff_pjfc_rev_tab(i) := nvl(l_unround_pjfc_rev_tab(i),0) - nvl(l_round_pjfc_rev_tab(i),0);
2401:
2402: 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));
2403: 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));
2404: l_diff_pjfc_rev_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_pjfc_rev_tab(i),l_pjfc_currency_code_tab(i));
2405: END LOOP;
2406:
2407: l_null_revenue_amts_flag := 'N';

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

2400: l_diff_pjfc_rev_tab(i) := nvl(l_unround_pjfc_rev_tab(i),0) - nvl(l_round_pjfc_rev_tab(i),0);
2401:
2402: 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));
2403: 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));
2404: l_diff_pjfc_rev_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_pjfc_rev_tab(i),l_pjfc_currency_code_tab(i));
2405: END LOOP;
2406:
2407: l_null_revenue_amts_flag := 'N';
2408: IF (p_calling_module IN ('BUDGET_GENERATION','FORECAST_GENERATION') AND p_budget_version_type = 'ALL'

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

2549: ,SUM(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(rw_cost_rate_override,cost_rate))) unrounded_txn_raw_cost
2550: ,SUM(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(burden_cost_rate_override,burden_cost_rate))) unrounded_txn_burdened_cost
2551: ,SUM(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(bill_rate_override,bill_rate))) unrounded_txn_revenue
2552: ,SUM(decode(nvl(rw_cost_rate_override,nvl(cost_rate,0)),0,0
2553: ,pa_currency.round_trans_currency_amt1((nvl(txn_raw_cost,0) - nvl(txn_init_raw_cost,0)),txn_currency_code))) rounded_txn_raw_cost
2554: ,SUM(decode(nvl(burden_cost_rate_override,nvl(burden_cost_rate,0)),0,0
2555: ,pa_currency.round_trans_currency_amt1((nvl(txn_burdened_cost,0) - nvl(txn_init_burdened_cost,0)),txn_currency_code))) rounded_txn_burdened_cost
2556: ,SUM(decode(nvl(bill_rate_override,nvl(bill_rate,0)),0,0
2557: ,pa_currency.round_trans_currency_amt1((nvl(txn_revenue,0) - nvl(txn_init_revenue,0)),txn_currency_code))) rounded_txn_revenue

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

2551: ,SUM(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(bill_rate_override,bill_rate))) unrounded_txn_revenue
2552: ,SUM(decode(nvl(rw_cost_rate_override,nvl(cost_rate,0)),0,0
2553: ,pa_currency.round_trans_currency_amt1((nvl(txn_raw_cost,0) - nvl(txn_init_raw_cost,0)),txn_currency_code))) rounded_txn_raw_cost
2554: ,SUM(decode(nvl(burden_cost_rate_override,nvl(burden_cost_rate,0)),0,0
2555: ,pa_currency.round_trans_currency_amt1((nvl(txn_burdened_cost,0) - nvl(txn_init_burdened_cost,0)),txn_currency_code))) rounded_txn_burdened_cost
2556: ,SUM(decode(nvl(bill_rate_override,nvl(bill_rate,0)),0,0
2557: ,pa_currency.round_trans_currency_amt1((nvl(txn_revenue,0) - nvl(txn_init_revenue,0)),txn_currency_code))) rounded_txn_revenue
2558: /**
2559: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(rw_cost_rate_override,cost_rate))

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

2553: ,pa_currency.round_trans_currency_amt1((nvl(txn_raw_cost,0) - nvl(txn_init_raw_cost,0)),txn_currency_code))) rounded_txn_raw_cost
2554: ,SUM(decode(nvl(burden_cost_rate_override,nvl(burden_cost_rate,0)),0,0
2555: ,pa_currency.round_trans_currency_amt1((nvl(txn_burdened_cost,0) - nvl(txn_init_burdened_cost,0)),txn_currency_code))) rounded_txn_burdened_cost
2556: ,SUM(decode(nvl(bill_rate_override,nvl(bill_rate,0)),0,0
2557: ,pa_currency.round_trans_currency_amt1((nvl(txn_revenue,0) - nvl(txn_init_revenue,0)),txn_currency_code))) rounded_txn_revenue
2558: /**
2559: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(rw_cost_rate_override,cost_rate))
2560: ,txn_currency_code)) rounded_txn_raw_cost
2561: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(burden_cost_rate_override,burden_cost_rate))

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

2555: ,pa_currency.round_trans_currency_amt1((nvl(txn_burdened_cost,0) - nvl(txn_init_burdened_cost,0)),txn_currency_code))) rounded_txn_burdened_cost
2556: ,SUM(decode(nvl(bill_rate_override,nvl(bill_rate,0)),0,0
2557: ,pa_currency.round_trans_currency_amt1((nvl(txn_revenue,0) - nvl(txn_init_revenue,0)),txn_currency_code))) rounded_txn_revenue
2558: /**
2559: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(rw_cost_rate_override,cost_rate))
2560: ,txn_currency_code)) rounded_txn_raw_cost
2561: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(burden_cost_rate_override,burden_cost_rate))
2562: ,txn_currency_code)) rounded_txn_burdened_cost
2563: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(bill_rate_override,bill_rate))

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

2557: ,pa_currency.round_trans_currency_amt1((nvl(txn_revenue,0) - nvl(txn_init_revenue,0)),txn_currency_code))) rounded_txn_revenue
2558: /**
2559: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(rw_cost_rate_override,cost_rate))
2560: ,txn_currency_code)) rounded_txn_raw_cost
2561: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(burden_cost_rate_override,burden_cost_rate))
2562: ,txn_currency_code)) rounded_txn_burdened_cost
2563: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(bill_rate_override,bill_rate))
2564: ,txn_currency_code)) rounded_txn_revenue
2565: **/

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

2559: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(rw_cost_rate_override,cost_rate))
2560: ,txn_currency_code)) rounded_txn_raw_cost
2561: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(burden_cost_rate_override,burden_cost_rate))
2562: ,txn_currency_code)) rounded_txn_burdened_cost
2563: ,SUM(pa_currency.round_trans_currency_amt1(((NVL(quantity,0) - nvl(init_quantity,0)) * nvl(bill_rate_override,bill_rate))
2564: ,txn_currency_code)) rounded_txn_revenue
2565: **/
2566: ,to_number(NULL) diff_raw_cost
2567: ,to_number(NULL) diff_burden_cost

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

2668: FOR i IN l_resource_assignment_tab.FIRST .. l_resource_assignment_tab.LAST LOOP
2669: l_diff_raw_cost_tab(i) := nvl(l_unrounded_txn_raw_cost_tab(i),0) - nvl(l_rounded_txn_raw_cost_tab(i),0);
2670: l_diff_burden_cost_tab(i) := nvl(l_unround_txn_burden_cost_tab(i),0) - nvl(l_rounded_txn_burden_cost_tab(i),0);
2671: l_diff_revenue_tab(i) := nvl(l_unrounded_txn_revenue_tab(i),0) - nvl(l_rounded_txn_revenue_tab(i),0);
2672: l_diff_raw_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_raw_cost_tab(i),l_txn_currency_code_tab(i));
2673: l_diff_burden_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_burden_cost_tab(i),l_txn_currency_code_tab(i));
2674: l_diff_revenue_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_revenue_tab(i),l_txn_currency_code_tab(i));
2675: END LOOP;
2676:

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

2669: l_diff_raw_cost_tab(i) := nvl(l_unrounded_txn_raw_cost_tab(i),0) - nvl(l_rounded_txn_raw_cost_tab(i),0);
2670: l_diff_burden_cost_tab(i) := nvl(l_unround_txn_burden_cost_tab(i),0) - nvl(l_rounded_txn_burden_cost_tab(i),0);
2671: l_diff_revenue_tab(i) := nvl(l_unrounded_txn_revenue_tab(i),0) - nvl(l_rounded_txn_revenue_tab(i),0);
2672: l_diff_raw_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_raw_cost_tab(i),l_txn_currency_code_tab(i));
2673: l_diff_burden_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_burden_cost_tab(i),l_txn_currency_code_tab(i));
2674: l_diff_revenue_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_revenue_tab(i),l_txn_currency_code_tab(i));
2675: END LOOP;
2676:
2677: l_null_revenue_amts_flag := 'N';

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

2670: l_diff_burden_cost_tab(i) := nvl(l_unround_txn_burden_cost_tab(i),0) - nvl(l_rounded_txn_burden_cost_tab(i),0);
2671: l_diff_revenue_tab(i) := nvl(l_unrounded_txn_revenue_tab(i),0) - nvl(l_rounded_txn_revenue_tab(i),0);
2672: l_diff_raw_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_raw_cost_tab(i),l_txn_currency_code_tab(i));
2673: l_diff_burden_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_burden_cost_tab(i),l_txn_currency_code_tab(i));
2674: l_diff_revenue_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_revenue_tab(i),l_txn_currency_code_tab(i));
2675: END LOOP;
2676:
2677: l_null_revenue_amts_flag := 'N';
2678: IF (p_calling_module IN ('BUDGET_GENERATION','FORECAST_GENERATION') AND p_budget_version_type = 'ALL'

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

6356: UPDATE /*+ INDEX(TMP PA_FP_ROLLUP_TMP_N1) */ pa_fp_rollup_tmp tmp
6357: SET tmp.old_quantity = decode(l_quantity_adj_pct,NULL,to_number(NULL),tmp.quantity)
6358: ,tmp.quantity = decode(l_quantity_adj_pct,NULL,tmp.quantity
6359: ,decode(NVL(tmp.rate_based_flag,'N'),'N'
6360: ,(NVL(tmp.init_quantity,0)+ pa_currency.round_trans_currency_amt1 (
6361: ((NVL(tmp.quantity,0) - nvl(tmp.init_quantity,0))
6362: * ((l_quantity_adj_pct + 100)/100)),tmp.txn_currency_code))
6363: ,(NVL(tmp.init_quantity,0)+ Round(((NVL(tmp.quantity,0) - nvl(tmp.init_quantity,0))
6364: * ((l_quantity_adj_pct + 100)/100)),5)))

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

6401: ,decode(l_quantity_adj_pct,NULL,to_number(NULL),tmp.quantity))
6402: ,tmp.quantity = decode(NVL(tmp.rate_based_flag,'N'),'N',tmp.quantity
6403: ,decode(l_quantity_adj_pct,NULL,tmp.quantity
6404: ,decode(NVL(tmp.rate_based_flag,'N'),'N'
6405: ,(NVL(tmp.init_quantity,0)+ pa_currency.round_trans_currency_amt1 (
6406: ((NVL(tmp.quantity,0) - nvl(tmp.init_quantity,0))
6407: * ((l_quantity_adj_pct + 100)/100)),tmp.txn_currency_code))
6408: ,(NVL(tmp.init_quantity,0)+ Round(((NVL(tmp.quantity,0) - nvl(tmp.init_quantity,0))
6409: * ((l_quantity_adj_pct + 100)/100)),5)))

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

6462: decode(l_revenue_adj_pct,NULL,to_number(null),tmp.txn_revenue)
6463: ,tmp.txn_raw_cost =
6464: decode(l_raw_cost_adj_pct,NULL,tmp.txn_raw_cost
6465: ,decode(tmp.txn_raw_cost,NULL,NULL,0,0
6466: ,(NVL(tmp.txn_init_raw_cost,0)+ pa_currency.round_trans_currency_amt1 (
6467: ((NVL(tmp.txn_raw_cost,0) - nvl(tmp.txn_init_raw_cost,0))
6468: * ((l_raw_cost_adj_pct + 100)/100)),tmp.txn_currency_code))))
6469: ,tmp.txn_revenue =
6470: decode(l_revenue_adj_pct,NULL,tmp.txn_revenue

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

6468: * ((l_raw_cost_adj_pct + 100)/100)),tmp.txn_currency_code))))
6469: ,tmp.txn_revenue =
6470: decode(l_revenue_adj_pct,NULL,tmp.txn_revenue
6471: ,decode(tmp.txn_revenue,NULL,NULL,0,0
6472: ,(NVL(tmp.txn_init_revenue,0)+ pa_currency.round_trans_currency_amt1 (
6473: ((NVL(tmp.txn_revenue,0) - nvl(tmp.txn_init_revenue,0))
6474: * ((l_revenue_adj_pct + 100)/100)),tmp.txn_currency_code))))
6475: ,tmp.quantity = decode(NVL(tmp.rate_based_flag,'N'),'Y',tmp.quantity
6476: ,decode(l_raw_cost_adj_pct,NULL

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

6475: ,tmp.quantity = decode(NVL(tmp.rate_based_flag,'N'),'Y',tmp.quantity
6476: ,decode(l_raw_cost_adj_pct,NULL
6477: ,decode(l_revenue_adj_pct, NULL, tmp.quantity
6478: ,decode(g_fp_budget_version_type,'COST',tmp.quantity
6479: ,'REVENUE', (NVL(tmp.txn_init_revenue,0)+ pa_currency.round_trans_currency_amt1 (
6480: ((NVL(tmp.txn_revenue,0) - nvl(tmp.txn_init_revenue,0))
6481: * ((l_revenue_adj_pct + 100)/100)),tmp.txn_currency_code))
6482: ,'ALL',decode(nvl(tmp.rw_cost_rate_override,0),0
6483: ,(NVL(tmp.txn_init_revenue,0)+ pa_currency.round_trans_currency_amt1 (

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

6479: ,'REVENUE', (NVL(tmp.txn_init_revenue,0)+ pa_currency.round_trans_currency_amt1 (
6480: ((NVL(tmp.txn_revenue,0) - nvl(tmp.txn_init_revenue,0))
6481: * ((l_revenue_adj_pct + 100)/100)),tmp.txn_currency_code))
6482: ,'ALL',decode(nvl(tmp.rw_cost_rate_override,0),0
6483: ,(NVL(tmp.txn_init_revenue,0)+ pa_currency.round_trans_currency_amt1 (
6484: ((NVL(tmp.txn_revenue,0) - nvl(tmp.txn_init_revenue,0))
6485: * ((l_revenue_adj_pct + 100)/100)),tmp.txn_currency_code))
6486: ,tmp.quantity)))
6487: ,decode(g_fp_budget_version_type,'REVENUE',tmp.quantity

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

6484: ((NVL(tmp.txn_revenue,0) - nvl(tmp.txn_init_revenue,0))
6485: * ((l_revenue_adj_pct + 100)/100)),tmp.txn_currency_code))
6486: ,tmp.quantity)))
6487: ,decode(g_fp_budget_version_type,'REVENUE',tmp.quantity
6488: ,'COST',(NVL(tmp.txn_init_raw_cost,0)+ pa_currency.round_trans_currency_amt1 (
6489: ((NVL(tmp.txn_raw_cost,0) - nvl(tmp.txn_init_raw_cost,0))
6490: * ((l_raw_cost_adj_pct + 100)/100)),tmp.txn_currency_code))
6491: ,'ALL',decode(nvl(tmp.rw_cost_rate_override,0),0,tmp.quantity
6492: ,(NVL(tmp.txn_init_raw_cost,0)+ pa_currency.round_trans_currency_amt1 (

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

6488: ,'COST',(NVL(tmp.txn_init_raw_cost,0)+ pa_currency.round_trans_currency_amt1 (
6489: ((NVL(tmp.txn_raw_cost,0) - nvl(tmp.txn_init_raw_cost,0))
6490: * ((l_raw_cost_adj_pct + 100)/100)),tmp.txn_currency_code))
6491: ,'ALL',decode(nvl(tmp.rw_cost_rate_override,0),0,tmp.quantity
6492: ,(NVL(tmp.txn_init_raw_cost,0)+ pa_currency.round_trans_currency_amt1 (
6493: ((NVL(tmp.txn_raw_cost,0) - nvl(tmp.txn_init_raw_cost,0))
6494: * ((l_raw_cost_adj_pct + 100)/100)),tmp.txn_currency_code))))))
6495: ,tmp.burden_cost_rate_override =
6496: Decode(g_fp_budget_version_type,'REVENUE',tmp.burden_cost_rate_override

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

6582: FOR i IN l_blId_tab.FIRST .. l_blId_tab.LAST LOOP
6583: If l_ratebase_tab(i) = 'Y' Then
6584: l_quantity_old_tab(i) := Round_Quantity(l_quantity_old_tab(i));
6585: Else
6586: l_quantity_old_tab(i) := pa_currency.round_trans_currency_amt1
6587: (l_quantity_old_tab(i),l_txn_cur_tab(i));
6588: End If;
6589: IF l_quantity_old_tab(i) <> l_quantity_new_tab(i) Then
6590: l_quantity_diff_tab(i) := l_quantity_old_tab(i) - l_quantity_new_tab(i);

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

6603: print_msg(g_stage);
6604: End If;
6605: FOR i IN l_blId_tab.FIRST .. l_blId_tab.LAST LOOP
6606: If l_ratebase_tab(i) = 'N' Then
6607: l_rawcost_old_tab(i) := pa_currency.round_trans_currency_amt1
6608: (l_rawcost_old_tab(i),l_txn_cur_tab(i));
6609: End If;
6610: IF l_rawcost_old_tab(i) <> l_rawcost_new_tab(i) Then
6611: l_rawcost_diff_tab(i) := l_rawcost_old_tab(i) - l_rawcost_new_tab(i);

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

6632: print_msg(g_stage);
6633: End If;
6634: FOR i IN l_blId_tab.FIRST .. l_blId_tab.LAST LOOP
6635: If l_ratebase_tab(i) = 'N' Then
6636: l_revenue_old_tab(i) := pa_currency.round_trans_currency_amt1
6637: (l_revenue_old_tab(i),l_txn_cur_tab(i));
6638: End If;
6639: IF l_revenue_old_tab(i) <> l_revenue_new_tab(i) Then
6640: l_revenue_diff_tab(i) := l_revenue_old_tab(i) - l_revenue_new_tab(i);

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

9430:
9431: /* Rounding Enhancements: round off the given quantity and amounts before start processing */
9432: If l_txn_plan_quantity is NOT NULL Then
9433: If l_rate_based_flag = 'N' THEN
9434: l_txn_plan_quantity := pa_currency.round_trans_currency_amt1(l_txn_plan_quantity,l_txn_currency_code);
9435: Else
9436: l_txn_plan_quantity := round_quantity(l_txn_plan_quantity);
9437: End If;
9438: End If;

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

9437: End If;
9438: End If;
9439:
9440: If l_txn_raw_cost is NOT NULL Then
9441: l_txn_raw_cost := pa_currency.round_trans_currency_amt1(l_txn_raw_cost,l_txn_currency_code);
9442: End If;
9443: If l_txn_burdened_cost is NOT NULL Then
9444: l_txn_burdened_cost := pa_currency.round_trans_currency_amt1(l_txn_burdened_cost,l_txn_currency_code);
9445: End If;

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

9440: If l_txn_raw_cost is NOT NULL Then
9441: l_txn_raw_cost := pa_currency.round_trans_currency_amt1(l_txn_raw_cost,l_txn_currency_code);
9442: End If;
9443: If l_txn_burdened_cost is NOT NULL Then
9444: l_txn_burdened_cost := pa_currency.round_trans_currency_amt1(l_txn_burdened_cost,l_txn_currency_code);
9445: End If;
9446: If l_txn_revenue is NOT NULL Then
9447: l_txn_revenue := pa_currency.round_trans_currency_amt1(l_txn_revenue,l_txn_currency_code);
9448: End If;

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

9443: If l_txn_burdened_cost is NOT NULL Then
9444: l_txn_burdened_cost := pa_currency.round_trans_currency_amt1(l_txn_burdened_cost,l_txn_currency_code);
9445: End If;
9446: If l_txn_revenue is NOT NULL Then
9447: l_txn_revenue := pa_currency.round_trans_currency_amt1(l_txn_revenue,l_txn_currency_code);
9448: End If;
9449:
9450: /* compare with budget line values
9451: * and populate the changed flags. Based on these flag apply the

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

10602: If NVL(l_txn_raw_cost,0) <> NVL(rec.txn_raw_cost,0) Then
10603: --Bug 6781055
10604: l_rec_modified_in_cl_flag:='Y';
10605:
10606: l_txn_raw_cost := pa_currency.round_trans_currency_amt1(l_txn_raw_cost,rec.txn_currency_code);
10607: l_txn_plan_quantity := l_txn_raw_cost;
10608: l_cl_raw_rejection_code := NULL;
10609: /* change in raw cost changes the burden cost rate */
10610: --Bug 6781055

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

10623: Else
10624: If NVL(l_txn_raw_cost,0) <> NVL(rec.txn_raw_cost,0) Then
10625: --Bug 6781055
10626: l_rec_modified_in_cl_flag:='Y';
10627: l_txn_raw_cost := pa_currency.round_trans_currency_amt1(l_txn_raw_cost,rec.txn_currency_code);
10628: l_cl_raw_rejection_code := NULL;
10629: --Bug 6781055
10630: If nvl(l_txn_plan_quantity-l_cl_init_quantity,0) <> 0 Then
10631: l_rw_cost_rate_override := (l_txn_raw_cost-l_cl_init_raw_cost)/(l_txn_plan_quantity-l_cl_init_quantity);

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

10666: /* re derive the burden cost rate override after calling the client extn */
10667: If NVl(l_txn_burdened_cost,0) <> NVl(rec.txn_burdened_cost,0) Then
10668: --Bug 6781055
10669: l_rec_modified_in_cl_flag:='Y';
10670: l_txn_burdened_cost := pa_currency.round_trans_currency_amt1(l_txn_burdened_cost,rec.txn_currency_code);
10671: l_cl_burd_rejection_code := NULL;
10672: --Bug 6781055
10673: If nvl(l_txn_plan_quantity-l_cl_init_quantity,0) <> 0 Then
10674: l_burden_cost_rate_override := (l_txn_burdened_cost-l_cl_init_burd_cost)/(l_txn_plan_quantity-l_cl_init_quantity);

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

10711: If rec.rate_based_flag = 'N' Then
10712: If NVL(l_txn_revenue,0) <> NVL(rec.txn_revenue,0) Then
10713: --Bug 6781055
10714: l_rec_modified_in_cl_flag:='Y';
10715: l_txn_revenue := pa_currency.round_trans_currency_amt1(l_txn_revenue,rec.txn_currency_code);
10716: l_cl_rev_rejection_code := NULL;
10717: If rec.version_type = 'REVENUE' Then
10718: l_txn_plan_quantity := l_txn_revenue;
10719: l_bill_rate_override := 1;

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

10727: Else
10728: If NVL(l_txn_revenue,0) <> NVL(rec.txn_revenue,0) Then
10729: --Bug 6781055
10730: l_rec_modified_in_cl_flag:='Y';
10731: l_txn_revenue := pa_currency.round_trans_currency_amt1(l_txn_revenue,rec.txn_currency_code);
10732: l_cl_rev_rejection_code := NULL;
10733: --Bug 6781055
10734: If nvl(l_txn_plan_quantity-l_cl_init_quantity,0) <> 0 Then
10735: l_bill_rate_override := (l_txn_revenue-l_cl_init_revenue)/(l_txn_plan_quantity-l_cl_init_quantity);

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

11504:
11505: IF NVL(l_return_status,'S') = 'S' Then
11506: IF nvl(p_denom_raw_cost,0) <> 0 Then
11507: x_final_txn_raw_cost := p_denom_raw_cost * x_final_txn_exch_rate;
11508: x_final_txn_raw_cost := pa_currency.round_trans_currency_amt1(x_final_txn_raw_cost,p_final_txn_curr_code);
11509: End If;
11510: IF nvl(p_denom_burden_cost,0) <> 0 Then
11511: x_final_txn_burden_cost := p_denom_burden_cost * x_final_txn_exch_rate;
11512: x_final_txn_burden_cost := pa_currency.round_trans_currency_amt1(x_final_txn_burden_cost,p_final_txn_curr_code);

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

11508: x_final_txn_raw_cost := pa_currency.round_trans_currency_amt1(x_final_txn_raw_cost,p_final_txn_curr_code);
11509: End If;
11510: IF nvl(p_denom_burden_cost,0) <> 0 Then
11511: x_final_txn_burden_cost := p_denom_burden_cost * x_final_txn_exch_rate;
11512: x_final_txn_burden_cost := pa_currency.round_trans_currency_amt1(x_final_txn_burden_cost,p_final_txn_curr_code);
11513: End If;
11514: IF nvl(p_denom_revenue,0) <> 0 Then
11515: x_final_txn_revenue := p_denom_revenue * x_final_txn_exch_rate;
11516: x_final_txn_revenue := pa_currency.round_trans_currency_amt1(x_final_txn_revenue,p_final_txn_curr_code);

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

11512: x_final_txn_burden_cost := pa_currency.round_trans_currency_amt1(x_final_txn_burden_cost,p_final_txn_curr_code);
11513: End If;
11514: IF nvl(p_denom_revenue,0) <> 0 Then
11515: x_final_txn_revenue := p_denom_revenue * x_final_txn_exch_rate;
11516: x_final_txn_revenue := pa_currency.round_trans_currency_amt1(x_final_txn_revenue,p_final_txn_curr_code);
11517: End If;
11518: End If;
11519: END IF;
11520: END IF;

Line 12873: x_burden_cost := pa_currency.round_trans_currency_amt1

12869: x_burden_cost_rate := x_cost_rate;
12870: ElsIF NVL(x_burden_multiplier,0) <> 0 Then
12871: x_burden_cost_rate := ((l_txn_plan_quantity * x_cost_rate) +
12872: ((l_txn_plan_quantity * x_cost_rate)*NVL(x_burden_multiplier,0)))/l_txn_plan_quantity;
12873: x_burden_cost := pa_currency.round_trans_currency_amt1
12874: ((l_txn_plan_quantity *x_burden_cost_rate),NVL(x_cost_txn_curr_code,l_txn_currency_code));
12875: END IF;
12876: END IF;
12877: END IF;

Line 12888: IF x_raw_revenue = (pa_currency.round_trans_currency_amt1(

12884: /* check whether markup is applied on raw cost or burdened cost then
12885: * derive the bill rate based on unrounded revenue
12886: */
12887: IF NVL(x_bill_markup_percentage,0) <> 0 Then
12888: IF x_raw_revenue = (pa_currency.round_trans_currency_amt1(
12889: ((1+x_bill_markup_percentage/100)*x_raw_cost),NVL(x_rev_txn_curr_code
12890: ,NVL(x_cost_txn_curr_code,l_txn_currency_code)))) Then
12891: x_bill_rate := ((1+x_bill_markup_percentage/100)*x_raw_cost)/l_txn_plan_quantity;
12892:

Line 12893: Elsif x_raw_revenue = (pa_currency.round_trans_currency_amt1(

12889: ((1+x_bill_markup_percentage/100)*x_raw_cost),NVL(x_rev_txn_curr_code
12890: ,NVL(x_cost_txn_curr_code,l_txn_currency_code)))) Then
12891: x_bill_rate := ((1+x_bill_markup_percentage/100)*x_raw_cost)/l_txn_plan_quantity;
12892:
12893: Elsif x_raw_revenue = (pa_currency.round_trans_currency_amt1(
12894: ((1+x_bill_markup_percentage/100)*x_burden_cost),NVL(x_rev_txn_curr_code
12895: ,NVL(x_cost_txn_curr_code,l_txn_currency_code)))) Then
12896: x_bill_rate := ((1+x_bill_markup_percentage/100)*x_burden_cost)/l_txn_plan_quantity;
12897:

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

13023: End If;
13024: END If; --}
13025:
13026: IF NVL(x_raw_cost,0) <> 0 Then
13027: x_raw_cost := pa_currency.round_trans_currency_amt1(x_raw_cost,NVL(x_cost_txn_curr_code,l_txn_currency_code_override));
13028: End If;
13029:
13030: IF NVL(x_burden_cost,0) <> 0 Then
13031: x_burden_cost := pa_currency.round_trans_currency_amt1(x_burden_cost,

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

13027: x_raw_cost := pa_currency.round_trans_currency_amt1(x_raw_cost,NVL(x_cost_txn_curr_code,l_txn_currency_code_override));
13028: End If;
13029:
13030: IF NVL(x_burden_cost,0) <> 0 Then
13031: x_burden_cost := pa_currency.round_trans_currency_amt1(x_burden_cost,
13032: NVL(l_txn_currency_code_override,x_cost_txn_curr_code));
13033: End If;
13034:
13035: If NVL(x_raw_revenue,0) <> 0 Then

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

13032: NVL(l_txn_currency_code_override,x_cost_txn_curr_code));
13033: End If;
13034:
13035: If NVL(x_raw_revenue,0) <> 0 Then
13036: x_raw_revenue := pa_currency.round_trans_currency_amt1(x_raw_revenue,
13037: NVL(x_rev_txn_curr_code,l_txn_currency_code_override));
13038: End If;
13039:
13040: /***

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

14001: END IF;
14002: END IF;
14003:
14004: IF NVL(x_raw_cost,0) <> 0 Then
14005: x_raw_cost := pa_currency.round_trans_currency_amt1(x_raw_cost,
14006: NVL(l_Final_txn_currency_code,l_txn_currency_code));
14007: End If;
14008:
14009: IF NVL(x_burden_cost,0) <> 0 Then

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

14006: NVL(l_Final_txn_currency_code,l_txn_currency_code));
14007: End If;
14008:
14009: IF NVL(x_burden_cost,0) <> 0 Then
14010: x_burden_cost := pa_currency.round_trans_currency_amt1(x_burden_cost,
14011: NVL(l_Final_txn_currency_code,l_txn_currency_code));
14012: End If;
14013:
14014: If NVL(x_raw_revenue,0) <> 0 Then

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

14011: NVL(l_Final_txn_currency_code,l_txn_currency_code));
14012: End If;
14013:
14014: If NVL(x_raw_revenue,0) <> 0 Then
14015: x_raw_revenue := pa_currency.round_trans_currency_amt1(x_raw_revenue,
14016: NVL(l_Final_txn_currency_code,l_txn_currency_code));
14017: End If;
14018: End If; --}
14019:

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

14275: If NVL(i.quantity,0) <> 0 Then
14276: If p_rate_based_flag = 'Y' Then
14277: i.quantity := Round_quantity(i.quantity);
14278: Else
14279: i.quantity := pa_currency.round_trans_currency_amt1(i.quantity,p_txn_currency_code);
14280: End If;
14281: End If;
14282: If NVL(i.txn_raw_cost,0) <> 0 Then
14283: i.txn_raw_cost := pa_currency.round_trans_currency_amt1(i.txn_raw_cost,p_txn_currency_code);

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

14279: i.quantity := pa_currency.round_trans_currency_amt1(i.quantity,p_txn_currency_code);
14280: End If;
14281: End If;
14282: If NVL(i.txn_raw_cost,0) <> 0 Then
14283: i.txn_raw_cost := pa_currency.round_trans_currency_amt1(i.txn_raw_cost,p_txn_currency_code);
14284: End If;
14285: If NVL(i.txn_burdened_cost,0) <> 0 Then
14286: i.txn_burdened_cost := pa_currency.round_trans_currency_amt1(i.txn_burdened_cost,p_txn_currency_code);
14287: End If;

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

14282: If NVL(i.txn_raw_cost,0) <> 0 Then
14283: i.txn_raw_cost := pa_currency.round_trans_currency_amt1(i.txn_raw_cost,p_txn_currency_code);
14284: End If;
14285: If NVL(i.txn_burdened_cost,0) <> 0 Then
14286: i.txn_burdened_cost := pa_currency.round_trans_currency_amt1(i.txn_burdened_cost,p_txn_currency_code);
14287: End If;
14288: If NVL(i.txn_revenue,0) <> 0 Then
14289: i.txn_revenue := pa_currency.round_trans_currency_amt1(i.txn_revenue,p_txn_currency_code);
14290: End If;

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

14285: If NVL(i.txn_burdened_cost,0) <> 0 Then
14286: i.txn_burdened_cost := pa_currency.round_trans_currency_amt1(i.txn_burdened_cost,p_txn_currency_code);
14287: End If;
14288: If NVL(i.txn_revenue,0) <> 0 Then
14289: i.txn_revenue := pa_currency.round_trans_currency_amt1(i.txn_revenue,p_txn_currency_code);
14290: End If;
14291: /* end of bug 4221022 */
14292:
14293: x_init_raw_cost := i.init_raw_cost;

Line 14674: pa_currency.round_trans_currency_amt1(

14670: nvl(p_init_quantity,0)) *
14671: nvl(x_txn_b_cost_rate_override,
14672: x_txn_b_cost_rate));
14673: x_txn_burdened_cost :=
14674: pa_currency.round_trans_currency_amt1(
14675: x_txn_burdened_cost,p_txn_currency_code);
14676: x_txn_burdened_cost_addl := nvl(x_txn_burdened_cost,0) -
14677: nvl(p_init_burdened_cost,0);
14678: END IF;

Line 14831: x_txn_revenue_addl := pa_currency.round_trans_currency_amt1(

14827: x_txn_revenue_addl := (nvl(x_txn_plan_quantity,0) -
14828: nvl(p_init_quantity,0)) *
14829: nvl(x_txn_bill_rate_override,
14830: x_txn_bill_rate);
14831: x_txn_revenue_addl := pa_currency.round_trans_currency_amt1(
14832: x_txn_revenue_addl, p_txn_currency_code);
14833: x_txn_revenue := x_txn_revenue_addl + nvl(p_init_revenue,0);
14834: x_txn_plan_quantity_addl := nvl(x_txn_plan_quantity,0) -
14835: nvl(p_bl_quantity,0);

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

14964:
14965: -- x_txn_raw_cost := NVL(x_txn_plan_quantity ,0) *
14966: -- NVL(x_txn_rw_cost_rate_override,
14967: -- x_txn_raw_cost_rate);
14968: -- x_txn_raw_cost := pa_currency.round_trans_currency_amt1(
14969: -- x_txn_raw_cost, p_txn_currency_code);
14970:
14971: -- C1, C2 and C3: rederive cost rate override as raw cost / quantity
14972: IF (nvl(x_txn_plan_quantity, 0) - nvl(p_init_quantity,0)) <> 0 THEN

Line 15001: x_txn_raw_cost := pa_currency.round_trans_currency_amt1(

14997: x_txn_raw_cost :=(NVL(p_init_raw_cost,0) +
14998: ((NVL(x_txn_plan_quantity ,0) - NVL(p_init_quantity,0)) *
14999: NVL(x_txn_rw_cost_rate_override,x_txn_raw_cost_rate)));
15000:
15001: x_txn_raw_cost := pa_currency.round_trans_currency_amt1(
15002: x_txn_raw_cost, p_txn_currency_code);
15003: x_txn_raw_cost_addl := nvl(x_txn_raw_cost,0) -
15004: nvl(p_bl_raw_cost,0);
15005: ELSIF (p_qty_changed_flag = 'Y' AND -- Case C4, C8, C11, C17

Line 15094: x_txn_raw_cost := pa_currency.round_trans_currency_amt1(

15090: x_txn_raw_cost :=(NVL(p_init_raw_cost,0) +
15091: ((NVL(x_txn_plan_quantity ,0) - NVL(p_init_quantity,0)) *
15092: NVL(x_txn_rw_cost_rate_override,x_txn_raw_cost_rate)));
15093:
15094: x_txn_raw_cost := pa_currency.round_trans_currency_amt1(
15095: x_txn_raw_cost,p_txn_currency_code);
15096: x_txn_raw_cost_addl := nvl(x_txn_raw_cost,0) -
15097: nvl(p_bl_raw_cost,0);
15098: END IF;

Line 15144: x_txn_burdened_cost := pa_currency.round_trans_currency_amt1(

15140: p_qty_changed_flag = 'Y') THEN
15141: x_txn_burdened_cost := x_txn_plan_quantity *
15142: NVL(x_txn_b_cost_rate_override,
15143: x_txn_b_cost_rate);
15144: x_txn_burdened_cost := pa_currency.round_trans_currency_amt1(
15145: x_txn_burdened_cost,
15146: p_txn_currency_code);
15147: x_txn_burdened_cost_addl := nvl(x_txn_burdened_cost,0) -
15148: nvl(p_bl_burdened_cost,0);

Line 15255: x_txn_revenue := pa_currency.round_trans_currency_amt1(

15251: (Nvl(x_txn_plan_quantity,0) <> 0)) THEN
15252:
15253: x_txn_revenue := NVL(x_txn_plan_quantity ,0) *
15254: NVL(x_txn_bill_rate_override, x_txn_bill_rate);
15255: x_txn_revenue := pa_currency.round_trans_currency_amt1(
15256: x_txn_revenue,p_txn_currency_code);
15257: x_txn_revenue_addl := nvl(x_txn_revenue,0) -
15258: nvl(p_bl_revenue,0);
15259: END IF;

Line 15361: x_txn_revenue := pa_currency.round_trans_currency_amt1(

15357: -- CR3, CR11, CR12, CR23: rederive revenue as quantity * bill rate
15358: -- CR13, CR24, CR25, CR31: rederive revenue as quantity * bill rate
15359: x_txn_revenue := NVL(x_txn_plan_quantity ,0) *
15360: NVL(x_txn_bill_rate_override, x_txn_bill_rate);
15361: x_txn_revenue := pa_currency.round_trans_currency_amt1(
15362: x_txn_revenue,p_txn_currency_code);
15363: x_txn_revenue_addl := nvl(x_txn_revenue,0) - nvl(p_bl_revenue,0);
15364:
15365: END IF; -- end of checks