DBA Data[Home] [Help]

APPS.PA_PROGRESS_UTILS dependencies on PA_CURRENCY

Line 6316: --x_BCWP := pa_currency.round_trans_currency_amt((l_Baseline_Amount*P_Overide_Percent_Complete)/100, l_prj_currency_code);

6312: --x_BCWP := trunc((l_Baseline_Amount*P_Overide_Percent_Complete)/100,2);
6313: If l_TASK_WEIGHT_BASIS_CODE = 'EFFORT' then
6314: x_BCWP := round((l_Baseline_Amount*P_Overide_Percent_Complete)/100,5);
6315: else
6316: --x_BCWP := pa_currency.round_trans_currency_amt((l_Baseline_Amount*P_Overide_Percent_Complete)/100, l_prj_currency_code);
6317: x_BCWP := pa_currency.round_trans_currency_amt1((l_Baseline_Amount*P_Overide_Percent_Complete)/100, l_prj_currency_code);
6318: end if;
6319:
6320: /* End fix for Bug # 4050324. */

Line 6317: x_BCWP := pa_currency.round_trans_currency_amt1((l_Baseline_Amount*P_Overide_Percent_Complete)/100, l_prj_currency_code);

6313: If l_TASK_WEIGHT_BASIS_CODE = 'EFFORT' then
6314: x_BCWP := round((l_Baseline_Amount*P_Overide_Percent_Complete)/100,5);
6315: else
6316: --x_BCWP := pa_currency.round_trans_currency_amt((l_Baseline_Amount*P_Overide_Percent_Complete)/100, l_prj_currency_code);
6317: x_BCWP := pa_currency.round_trans_currency_amt1((l_Baseline_Amount*P_Overide_Percent_Complete)/100, l_prj_currency_code);
6318: end if;
6319:
6320: /* End fix for Bug # 4050324. */
6321:

Line 6842: l_return_bcws := pa_currency.round_trans_currency_amt1(l_return_bcws, l_prj_currency_code);

6838: CLOSE cur_proj_curr;
6839: else
6840: l_prj_currency_code := p_prj_currency_code;
6841: end if;
6842: l_return_bcws := pa_currency.round_trans_currency_amt1(l_return_bcws, l_prj_currency_code);
6843: --l_return_bcws := pa_currency.round_trans_currency_amt(l_return_bcws, l_prj_currency_code);
6844: --l_return_bcws := pa_currency.round_trans_currency_amt(l_return_bcws, p_prj_currency_code);
6845: --end bug 3908112
6846:

Line 6843: --l_return_bcws := pa_currency.round_trans_currency_amt(l_return_bcws, l_prj_currency_code);

6839: else
6840: l_prj_currency_code := p_prj_currency_code;
6841: end if;
6842: l_return_bcws := pa_currency.round_trans_currency_amt1(l_return_bcws, l_prj_currency_code);
6843: --l_return_bcws := pa_currency.round_trans_currency_amt(l_return_bcws, l_prj_currency_code);
6844: --l_return_bcws := pa_currency.round_trans_currency_amt(l_return_bcws, p_prj_currency_code);
6845: --end bug 3908112
6846:
6847: END IF;

Line 6844: --l_return_bcws := pa_currency.round_trans_currency_amt(l_return_bcws, p_prj_currency_code);

6840: l_prj_currency_code := p_prj_currency_code;
6841: end if;
6842: l_return_bcws := pa_currency.round_trans_currency_amt1(l_return_bcws, l_prj_currency_code);
6843: --l_return_bcws := pa_currency.round_trans_currency_amt(l_return_bcws, l_prj_currency_code);
6844: --l_return_bcws := pa_currency.round_trans_currency_amt(l_return_bcws, p_prj_currency_code);
6845: --end bug 3908112
6846:
6847: END IF;
6848: --bug 3824042, end

Line 10802: --l_etc_brdncost_tc := nvl(pa_currency.round_trans_currency_amt((nvl(p_etc_quantity,0) * nvl(l_plan_burden_multiplier_etc,0)), p_txn_currency_code),0) + nvl(p_etc_quantity,0);

10798: If (p_rate_based_flag = 'N') then
10799:
10800: -- 5.1). Use the resource rate burden multiplier to convert etc_rawcost_tc into etc_brdncost_tc.
10801:
10802: --l_etc_brdncost_tc := nvl(pa_currency.round_trans_currency_amt((nvl(p_etc_quantity,0) * nvl(l_plan_burden_multiplier_etc,0)), p_txn_currency_code),0) + nvl(p_etc_quantity,0);
10803: l_etc_brdncost_tc := nvl(pa_currency.round_trans_currency_amt1((nvl(p_etc_quantity,0) * nvl(l_plan_burden_multiplier_etc,0)), p_txn_currency_code),0) + nvl(p_etc_quantity,0);
10804: -- 5.2). Use the resource rate burden multiplier to convert act_rawcost_tc_this_period into act_brdncost_tc_this_period.
10805:
10806: --l_act_brdncost_tc_this_period := nvl(pa_currency.round_trans_currency_amt(

Line 10803: l_etc_brdncost_tc := nvl(pa_currency.round_trans_currency_amt1((nvl(p_etc_quantity,0) * nvl(l_plan_burden_multiplier_etc,0)), p_txn_currency_code),0) + nvl(p_etc_quantity,0);

10799:
10800: -- 5.1). Use the resource rate burden multiplier to convert etc_rawcost_tc into etc_brdncost_tc.
10801:
10802: --l_etc_brdncost_tc := nvl(pa_currency.round_trans_currency_amt((nvl(p_etc_quantity,0) * nvl(l_plan_burden_multiplier_etc,0)), p_txn_currency_code),0) + nvl(p_etc_quantity,0);
10803: l_etc_brdncost_tc := nvl(pa_currency.round_trans_currency_amt1((nvl(p_etc_quantity,0) * nvl(l_plan_burden_multiplier_etc,0)), p_txn_currency_code),0) + nvl(p_etc_quantity,0);
10804: -- 5.2). Use the resource rate burden multiplier to convert act_rawcost_tc_this_period into act_brdncost_tc_this_period.
10805:
10806: --l_act_brdncost_tc_this_period := nvl(pa_currency.round_trans_currency_amt(
10807: -- (nvl(p_act_quantity_this_period,0) * nvl(l_plan_burden_multiplier_act,0)), p_txn_currency_code),0) + nvl(p_act_quantity_this_period,0);

Line 10806: --l_act_brdncost_tc_this_period := nvl(pa_currency.round_trans_currency_amt(

10802: --l_etc_brdncost_tc := nvl(pa_currency.round_trans_currency_amt((nvl(p_etc_quantity,0) * nvl(l_plan_burden_multiplier_etc,0)), p_txn_currency_code),0) + nvl(p_etc_quantity,0);
10803: l_etc_brdncost_tc := nvl(pa_currency.round_trans_currency_amt1((nvl(p_etc_quantity,0) * nvl(l_plan_burden_multiplier_etc,0)), p_txn_currency_code),0) + nvl(p_etc_quantity,0);
10804: -- 5.2). Use the resource rate burden multiplier to convert act_rawcost_tc_this_period into act_brdncost_tc_this_period.
10805:
10806: --l_act_brdncost_tc_this_period := nvl(pa_currency.round_trans_currency_amt(
10807: -- (nvl(p_act_quantity_this_period,0) * nvl(l_plan_burden_multiplier_act,0)), p_txn_currency_code),0) + nvl(p_act_quantity_this_period,0);
10808:
10809: l_act_brdncost_tc_this_period := nvl(pa_currency.round_trans_currency_amt1(
10810: (nvl(p_act_quantity_this_period,0) * nvl(l_plan_burden_multiplier_act,0)), p_txn_currency_code),0) + nvl(p_act_quantity_this_period,0);

Line 10809: l_act_brdncost_tc_this_period := nvl(pa_currency.round_trans_currency_amt1(

10805:
10806: --l_act_brdncost_tc_this_period := nvl(pa_currency.round_trans_currency_amt(
10807: -- (nvl(p_act_quantity_this_period,0) * nvl(l_plan_burden_multiplier_act,0)), p_txn_currency_code),0) + nvl(p_act_quantity_this_period,0);
10808:
10809: l_act_brdncost_tc_this_period := nvl(pa_currency.round_trans_currency_amt1(
10810: (nvl(p_act_quantity_this_period,0) * nvl(l_plan_burden_multiplier_act,0)), p_txn_currency_code),0) + nvl(p_act_quantity_this_period,0);
10811:
10812: else
10813:

Line 10816: --l_etc_brdncost_tc := pa_currency.round_trans_currency_amt((nvl(p_etc_quantity,0) * nvl(l_plan_res_burden_rate_etc,0)), p_txn_currency_code);

10812: else
10813:
10814: -- 6.1). Use resource burden rate to convert etc_effort into etc_brdncost_tc:
10815:
10816: --l_etc_brdncost_tc := pa_currency.round_trans_currency_amt((nvl(p_etc_quantity,0) * nvl(l_plan_res_burden_rate_etc,0)), p_txn_currency_code);
10817: l_etc_brdncost_tc := pa_currency.round_trans_currency_amt1((nvl(p_etc_quantity,0) * nvl(l_plan_res_burden_rate_etc,0)), p_txn_currency_code);
10818:
10819: -- 6.2). Use resource burden rate to convert act_effort_this_period into
10820: -- act_brdncost_tc_this_period.

Line 10817: l_etc_brdncost_tc := pa_currency.round_trans_currency_amt1((nvl(p_etc_quantity,0) * nvl(l_plan_res_burden_rate_etc,0)), p_txn_currency_code);

10813:
10814: -- 6.1). Use resource burden rate to convert etc_effort into etc_brdncost_tc:
10815:
10816: --l_etc_brdncost_tc := pa_currency.round_trans_currency_amt((nvl(p_etc_quantity,0) * nvl(l_plan_res_burden_rate_etc,0)), p_txn_currency_code);
10817: l_etc_brdncost_tc := pa_currency.round_trans_currency_amt1((nvl(p_etc_quantity,0) * nvl(l_plan_res_burden_rate_etc,0)), p_txn_currency_code);
10818:
10819: -- 6.2). Use resource burden rate to convert act_effort_this_period into
10820: -- act_brdncost_tc_this_period.
10821:

Line 10822: --l_act_brdncost_tc_this_period := pa_currency.round_trans_currency_amt(

10818:
10819: -- 6.2). Use resource burden rate to convert act_effort_this_period into
10820: -- act_brdncost_tc_this_period.
10821:
10822: --l_act_brdncost_tc_this_period := pa_currency.round_trans_currency_amt(
10823: -- (nvl(p_act_quantity_this_period,0) * nvl(l_plan_res_burden_rate_act,0)), p_txn_currency_code);
10824: l_act_brdncost_tc_this_period := pa_currency.round_trans_currency_amt1(
10825: (nvl(p_act_quantity_this_period,0) * nvl(l_plan_res_burden_rate_act,0)), p_txn_currency_code);
10826: end if; -- If (p_rate_based_flag = 'N') then

Line 10824: l_act_brdncost_tc_this_period := pa_currency.round_trans_currency_amt1(

10820: -- act_brdncost_tc_this_period.
10821:
10822: --l_act_brdncost_tc_this_period := pa_currency.round_trans_currency_amt(
10823: -- (nvl(p_act_quantity_this_period,0) * nvl(l_plan_res_burden_rate_act,0)), p_txn_currency_code);
10824: l_act_brdncost_tc_this_period := pa_currency.round_trans_currency_amt1(
10825: (nvl(p_act_quantity_this_period,0) * nvl(l_plan_res_burden_rate_act,0)), p_txn_currency_code);
10826: end if; -- If (p_rate_based_flag = 'N') then
10827:
10828: -- 7.1). Convert etc_brdncost_tc into etc_brdncost_pc. To do this we use the API:

Line 11507: -- x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0) + nvl(p_quantity,0);

11503: END IF;
11504: if (p_rate_based_flag = 'N') then
11505: x_res_raw_rate := 1;
11506: x_res_brdn_mult_ovrate := l_plan_burden_multiplier_etc;
11507: -- x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0) + nvl(p_quantity,0);
11508: x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt1((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0) + nvl(p_quantity,0);
11509: else
11510: x_res_brdn_mult_ovrate := l_plan_res_burden_rate_etc;
11511: --x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0);

Line 11508: x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt1((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0) + nvl(p_quantity,0);

11504: if (p_rate_based_flag = 'N') then
11505: x_res_raw_rate := 1;
11506: x_res_brdn_mult_ovrate := l_plan_burden_multiplier_etc;
11507: -- x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0) + nvl(p_quantity,0);
11508: x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt1((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0) + nvl(p_quantity,0);
11509: else
11510: x_res_brdn_mult_ovrate := l_plan_res_burden_rate_etc;
11511: --x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0);
11512: x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt1((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0);

Line 11511: --x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0);

11507: -- x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0) + nvl(p_quantity,0);
11508: x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt1((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0) + nvl(p_quantity,0);
11509: else
11510: x_res_brdn_mult_ovrate := l_plan_res_burden_rate_etc;
11511: --x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0);
11512: x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt1((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0);
11513: end if;
11514: --x_rawcost_tc := nvl(pa_currency.round_trans_currency_amt((nvl(p_quantity,0) * nvl(x_res_raw_rate,0)), p_txn_currency_code),0);
11515: x_rawcost_tc := nvl(pa_currency.round_trans_currency_amt1((nvl(p_quantity,0) * nvl(x_res_raw_rate,0)), p_txn_currency_code),0);

Line 11512: x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt1((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0);

11508: x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt1((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0) + nvl(p_quantity,0);
11509: else
11510: x_res_brdn_mult_ovrate := l_plan_res_burden_rate_etc;
11511: --x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0);
11512: x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt1((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0);
11513: end if;
11514: --x_rawcost_tc := nvl(pa_currency.round_trans_currency_amt((nvl(p_quantity,0) * nvl(x_res_raw_rate,0)), p_txn_currency_code),0);
11515: x_rawcost_tc := nvl(pa_currency.round_trans_currency_amt1((nvl(p_quantity,0) * nvl(x_res_raw_rate,0)), p_txn_currency_code),0);
11516:

Line 11514: --x_rawcost_tc := nvl(pa_currency.round_trans_currency_amt((nvl(p_quantity,0) * nvl(x_res_raw_rate,0)), p_txn_currency_code),0);

11510: x_res_brdn_mult_ovrate := l_plan_res_burden_rate_etc;
11511: --x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0);
11512: x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt1((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0);
11513: end if;
11514: --x_rawcost_tc := nvl(pa_currency.round_trans_currency_amt((nvl(p_quantity,0) * nvl(x_res_raw_rate,0)), p_txn_currency_code),0);
11515: x_rawcost_tc := nvl(pa_currency.round_trans_currency_amt1((nvl(p_quantity,0) * nvl(x_res_raw_rate,0)), p_txn_currency_code),0);
11516:
11517: -- convert all costs to proj curr and proj func curr
11518:

Line 11515: x_rawcost_tc := nvl(pa_currency.round_trans_currency_amt1((nvl(p_quantity,0) * nvl(x_res_raw_rate,0)), p_txn_currency_code),0);

11511: --x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0);
11512: x_brdncost_tc := nvl(pa_currency.round_trans_currency_amt1((nvl(p_quantity,0) * nvl(x_res_brdn_mult_ovrate,0)), p_txn_currency_code),0);
11513: end if;
11514: --x_rawcost_tc := nvl(pa_currency.round_trans_currency_amt((nvl(p_quantity,0) * nvl(x_res_raw_rate,0)), p_txn_currency_code),0);
11515: x_rawcost_tc := nvl(pa_currency.round_trans_currency_amt1((nvl(p_quantity,0) * nvl(x_res_raw_rate,0)), p_txn_currency_code),0);
11516:
11517: -- convert all costs to proj curr and proj func curr
11518:
11519: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(