DBA Data[Home] [Help]

APPS.PA_PROGRESS_UTILS dependencies on PA_CURRENCY

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

6277: --x_BCWP := trunc((l_Baseline_Amount*P_Overide_Percent_Complete)/100,2);
6278: If l_TASK_WEIGHT_BASIS_CODE = 'EFFORT' then
6279: x_BCWP := round((l_Baseline_Amount*P_Overide_Percent_Complete)/100,5);
6280: else
6281: --x_BCWP := pa_currency.round_trans_currency_amt((l_Baseline_Amount*P_Overide_Percent_Complete)/100, l_prj_currency_code);
6282: x_BCWP := pa_currency.round_trans_currency_amt1((l_Baseline_Amount*P_Overide_Percent_Complete)/100, l_prj_currency_code);
6283: end if;
6284:
6285: /* End fix for Bug # 4050324. */

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

6278: If l_TASK_WEIGHT_BASIS_CODE = 'EFFORT' then
6279: x_BCWP := round((l_Baseline_Amount*P_Overide_Percent_Complete)/100,5);
6280: else
6281: --x_BCWP := pa_currency.round_trans_currency_amt((l_Baseline_Amount*P_Overide_Percent_Complete)/100, l_prj_currency_code);
6282: x_BCWP := pa_currency.round_trans_currency_amt1((l_Baseline_Amount*P_Overide_Percent_Complete)/100, l_prj_currency_code);
6283: end if;
6284:
6285: /* End fix for Bug # 4050324. */
6286:

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

6798: CLOSE cur_proj_curr;
6799: else
6800: l_prj_currency_code := p_prj_currency_code;
6801: end if;
6802: l_return_bcws := pa_currency.round_trans_currency_amt1(l_return_bcws, l_prj_currency_code);
6803: --l_return_bcws := pa_currency.round_trans_currency_amt(l_return_bcws, l_prj_currency_code);
6804: --l_return_bcws := pa_currency.round_trans_currency_amt(l_return_bcws, p_prj_currency_code);
6805: --end bug 3908112
6806:

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

6799: else
6800: l_prj_currency_code := p_prj_currency_code;
6801: end if;
6802: l_return_bcws := pa_currency.round_trans_currency_amt1(l_return_bcws, l_prj_currency_code);
6803: --l_return_bcws := pa_currency.round_trans_currency_amt(l_return_bcws, l_prj_currency_code);
6804: --l_return_bcws := pa_currency.round_trans_currency_amt(l_return_bcws, p_prj_currency_code);
6805: --end bug 3908112
6806:
6807: END IF;

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

6800: l_prj_currency_code := p_prj_currency_code;
6801: end if;
6802: l_return_bcws := pa_currency.round_trans_currency_amt1(l_return_bcws, l_prj_currency_code);
6803: --l_return_bcws := pa_currency.round_trans_currency_amt(l_return_bcws, l_prj_currency_code);
6804: --l_return_bcws := pa_currency.round_trans_currency_amt(l_return_bcws, p_prj_currency_code);
6805: --end bug 3908112
6806:
6807: END IF;
6808: --bug 3824042, end

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

10723: If (p_rate_based_flag = 'N') then
10724:
10725: -- 5.1). Use the resource rate burden multiplier to convert etc_rawcost_tc into etc_brdncost_tc.
10726:
10727: --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);
10728: 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);
10729: -- 5.2). Use the resource rate burden multiplier to convert act_rawcost_tc_this_period into act_brdncost_tc_this_period.
10730:
10731: --l_act_brdncost_tc_this_period := nvl(pa_currency.round_trans_currency_amt(

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

10724:
10725: -- 5.1). Use the resource rate burden multiplier to convert etc_rawcost_tc into etc_brdncost_tc.
10726:
10727: --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);
10728: 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);
10729: -- 5.2). Use the resource rate burden multiplier to convert act_rawcost_tc_this_period into act_brdncost_tc_this_period.
10730:
10731: --l_act_brdncost_tc_this_period := nvl(pa_currency.round_trans_currency_amt(
10732: -- (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 10731: --l_act_brdncost_tc_this_period := nvl(pa_currency.round_trans_currency_amt(

10727: --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);
10728: 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);
10729: -- 5.2). Use the resource rate burden multiplier to convert act_rawcost_tc_this_period into act_brdncost_tc_this_period.
10730:
10731: --l_act_brdncost_tc_this_period := nvl(pa_currency.round_trans_currency_amt(
10732: -- (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);
10733:
10734: l_act_brdncost_tc_this_period := nvl(pa_currency.round_trans_currency_amt1(
10735: (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 10734: l_act_brdncost_tc_this_period := nvl(pa_currency.round_trans_currency_amt1(

10730:
10731: --l_act_brdncost_tc_this_period := nvl(pa_currency.round_trans_currency_amt(
10732: -- (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);
10733:
10734: l_act_brdncost_tc_this_period := nvl(pa_currency.round_trans_currency_amt1(
10735: (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);
10736:
10737: else
10738:

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

10737: else
10738:
10739: -- 6.1). Use resource burden rate to convert etc_effort into etc_brdncost_tc:
10740:
10741: --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);
10742: 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);
10743:
10744: -- 6.2). Use resource burden rate to convert act_effort_this_period into
10745: -- act_brdncost_tc_this_period.

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

10738:
10739: -- 6.1). Use resource burden rate to convert etc_effort into etc_brdncost_tc:
10740:
10741: --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);
10742: 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);
10743:
10744: -- 6.2). Use resource burden rate to convert act_effort_this_period into
10745: -- act_brdncost_tc_this_period.
10746:

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

10743:
10744: -- 6.2). Use resource burden rate to convert act_effort_this_period into
10745: -- act_brdncost_tc_this_period.
10746:
10747: --l_act_brdncost_tc_this_period := pa_currency.round_trans_currency_amt(
10748: -- (nvl(p_act_quantity_this_period,0) * nvl(l_plan_res_burden_rate_act,0)), p_txn_currency_code);
10749: l_act_brdncost_tc_this_period := pa_currency.round_trans_currency_amt1(
10750: (nvl(p_act_quantity_this_period,0) * nvl(l_plan_res_burden_rate_act,0)), p_txn_currency_code);
10751: end if; -- If (p_rate_based_flag = 'N') then

Line 10749: l_act_brdncost_tc_this_period := pa_currency.round_trans_currency_amt1(

10745: -- act_brdncost_tc_this_period.
10746:
10747: --l_act_brdncost_tc_this_period := pa_currency.round_trans_currency_amt(
10748: -- (nvl(p_act_quantity_this_period,0) * nvl(l_plan_res_burden_rate_act,0)), p_txn_currency_code);
10749: l_act_brdncost_tc_this_period := pa_currency.round_trans_currency_amt1(
10750: (nvl(p_act_quantity_this_period,0) * nvl(l_plan_res_burden_rate_act,0)), p_txn_currency_code);
10751: end if; -- If (p_rate_based_flag = 'N') then
10752:
10753: -- 7.1). Convert etc_brdncost_tc into etc_brdncost_pc. To do this we use the API:

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

11424: END IF;
11425: if (p_rate_based_flag = 'N') then
11426: x_res_raw_rate := 1;
11427: x_res_brdn_mult_ovrate := l_plan_burden_multiplier_etc;
11428: -- 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);
11429: 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);
11430: else
11431: x_res_brdn_mult_ovrate := l_plan_res_burden_rate_etc;
11432: --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 11429: 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);

11425: if (p_rate_based_flag = 'N') then
11426: x_res_raw_rate := 1;
11427: x_res_brdn_mult_ovrate := l_plan_burden_multiplier_etc;
11428: -- 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);
11429: 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);
11430: else
11431: x_res_brdn_mult_ovrate := l_plan_res_burden_rate_etc;
11432: --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);
11433: 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 11432: --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);

11428: -- 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);
11429: 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);
11430: else
11431: x_res_brdn_mult_ovrate := l_plan_res_burden_rate_etc;
11432: --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);
11433: 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);
11434: end if;
11435: --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);
11436: 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 11433: 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);

11429: 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);
11430: else
11431: x_res_brdn_mult_ovrate := l_plan_res_burden_rate_etc;
11432: --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);
11433: 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);
11434: end if;
11435: --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);
11436: 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);
11437:

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

11431: x_res_brdn_mult_ovrate := l_plan_res_burden_rate_etc;
11432: --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);
11433: 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);
11434: end if;
11435: --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);
11436: 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);
11437:
11438: -- convert all costs to proj curr and proj func curr
11439:

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

11432: --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);
11433: 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);
11434: end if;
11435: --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);
11436: 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);
11437:
11438: -- convert all costs to proj curr and proj func curr
11439:
11440: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(