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

Line 5001: l_txn_raw_cost_tab(l_rwCounter) := pa_currency.round_trans_currency_amt1((((nvl(i.bl_quantity,0)-nvl(i.bl_init_quantity,0) + nvl(i.fp_quantity,0))*

4997: l_end_date_tab(l_rwCounter) := i.end_date;
4998: l_period_name_tab(l_rwCounter) := i.period_name;
4999: l_quantity_tab(l_rwCounter) := nvl(i.fp_quantity,0);
5000: IF p_budget_version_type in ('ALL','COST') Then
5001: l_txn_raw_cost_tab(l_rwCounter) := pa_currency.round_trans_currency_amt1((((nvl(i.bl_quantity,0)-nvl(i.bl_init_quantity,0) + nvl(i.fp_quantity,0))*
5002: nvl(i.txn_cost_rate_override,i.txn_standard_cost_rate)) +nvl(i.txn_init_raw_cost,0)),i.txn_currency_code);
5003: l_txn_burden_cost_tab(l_rwCounter) := pa_currency.round_trans_currency_amt1((((nvl(i.bl_quantity,0)-nvl(i.bl_init_quantity,0) + nvl(i.fp_quantity,0))*
5004: nvl(i.burden_cost_rate_override,i.burden_cost_rate)) + nvl(i.txn_init_burdened_cost,0)),i.txn_currency_code);
5005: ELSE

Line 5003: l_txn_burden_cost_tab(l_rwCounter) := pa_currency.round_trans_currency_amt1((((nvl(i.bl_quantity,0)-nvl(i.bl_init_quantity,0) + nvl(i.fp_quantity,0))*

4999: l_quantity_tab(l_rwCounter) := nvl(i.fp_quantity,0);
5000: IF p_budget_version_type in ('ALL','COST') Then
5001: l_txn_raw_cost_tab(l_rwCounter) := pa_currency.round_trans_currency_amt1((((nvl(i.bl_quantity,0)-nvl(i.bl_init_quantity,0) + nvl(i.fp_quantity,0))*
5002: nvl(i.txn_cost_rate_override,i.txn_standard_cost_rate)) +nvl(i.txn_init_raw_cost,0)),i.txn_currency_code);
5003: l_txn_burden_cost_tab(l_rwCounter) := pa_currency.round_trans_currency_amt1((((nvl(i.bl_quantity,0)-nvl(i.bl_init_quantity,0) + nvl(i.fp_quantity,0))*
5004: nvl(i.burden_cost_rate_override,i.burden_cost_rate)) + nvl(i.txn_init_burdened_cost,0)),i.txn_currency_code);
5005: ELSE
5006: l_txn_raw_cost_tab(l_rwCounter) := NULL;
5007: l_txn_burden_cost_tab(l_rwCounter) := NULL;

Line 5010: l_txn_revenue_tab(l_rwCounter) := pa_currency.round_trans_currency_amt1((((nvl(i.bl_quantity,0)-nvl(i.bl_init_quantity,0) + nvl(i.fp_quantity,0))*

5006: l_txn_raw_cost_tab(l_rwCounter) := NULL;
5007: l_txn_burden_cost_tab(l_rwCounter) := NULL;
5008: END IF;
5009: IF p_budget_version_type in ('ALL','REVENUE') Then
5010: l_txn_revenue_tab(l_rwCounter) := pa_currency.round_trans_currency_amt1((((nvl(i.bl_quantity,0)-nvl(i.bl_init_quantity,0) + nvl(i.fp_quantity,0))*
5011: nvl(i.txn_bill_rate_override,i.txn_standard_bill_rate)) +nvl(i.txn_init_revenue,0)),i.txn_currency_code);
5012: Else
5013: l_txn_revenue_tab(l_rwCounter) := NULL;
5014: End If;

Line 5073: ,pa_currency.round_trans_currency_amt1((bl.txn_raw_cost * bl.project_cost_exchange_rate ),bl.project_currency_code)))

5069: FORALL i IN l_budget_line_id_tab.FIRST .. l_budget_line_id_tab.LAST
5070: UPDATE PA_BUDGET_LINES bl
5071: SET bl.project_raw_cost = decode(p_budget_version_type,'REVENUE',bl.project_raw_cost
5072: ,decode(bl.project_currency_code,bl.txn_currency_code,bl.txn_raw_cost
5073: ,pa_currency.round_trans_currency_amt1((bl.txn_raw_cost * bl.project_cost_exchange_rate ),bl.project_currency_code)))
5074: ,bl.project_burdened_cost = decode(p_budget_version_type,'REVENUE',bl.project_burdened_cost
5075: ,decode(bl.project_currency_code,bl.txn_currency_code,bl.txn_burdened_cost
5076: ,pa_currency.round_trans_currency_amt1((bl.txn_burdened_cost * bl.project_cost_exchange_rate ),bl.project_currency_code)))
5077: ,bl.project_revenue = decode(p_budget_version_type,'COST',bl.project_revenue

Line 5076: ,pa_currency.round_trans_currency_amt1((bl.txn_burdened_cost * bl.project_cost_exchange_rate ),bl.project_currency_code)))

5072: ,decode(bl.project_currency_code,bl.txn_currency_code,bl.txn_raw_cost
5073: ,pa_currency.round_trans_currency_amt1((bl.txn_raw_cost * bl.project_cost_exchange_rate ),bl.project_currency_code)))
5074: ,bl.project_burdened_cost = decode(p_budget_version_type,'REVENUE',bl.project_burdened_cost
5075: ,decode(bl.project_currency_code,bl.txn_currency_code,bl.txn_burdened_cost
5076: ,pa_currency.round_trans_currency_amt1((bl.txn_burdened_cost * bl.project_cost_exchange_rate ),bl.project_currency_code)))
5077: ,bl.project_revenue = decode(p_budget_version_type,'COST',bl.project_revenue
5078: ,decode(bl.project_currency_code,bl.txn_currency_code,bl.project_revenue
5079: ,pa_currency.round_trans_currency_amt1((bl.project_revenue*bl.project_rev_exchange_rate ),bl.project_currency_code)))
5080: ,bl.raw_cost = decode(p_budget_version_type,'REVENUE',bl.raw_cost

Line 5079: ,pa_currency.round_trans_currency_amt1((bl.project_revenue*bl.project_rev_exchange_rate ),bl.project_currency_code)))

5075: ,decode(bl.project_currency_code,bl.txn_currency_code,bl.txn_burdened_cost
5076: ,pa_currency.round_trans_currency_amt1((bl.txn_burdened_cost * bl.project_cost_exchange_rate ),bl.project_currency_code)))
5077: ,bl.project_revenue = decode(p_budget_version_type,'COST',bl.project_revenue
5078: ,decode(bl.project_currency_code,bl.txn_currency_code,bl.project_revenue
5079: ,pa_currency.round_trans_currency_amt1((bl.project_revenue*bl.project_rev_exchange_rate ),bl.project_currency_code)))
5080: ,bl.raw_cost = decode(p_budget_version_type,'REVENUE',bl.raw_cost
5081: ,decode(bl.projfunc_currency_code,bl.txn_currency_code,bl.txn_raw_cost
5082: ,pa_currency.round_trans_currency_amt1((bl.txn_raw_cost * bl.projfunc_cost_exchange_rate ),bl.projfunc_currency_code)))
5083: ,bl.burdened_cost = decode(p_budget_version_type,'REVENUE',bl.burdened_cost

Line 5082: ,pa_currency.round_trans_currency_amt1((bl.txn_raw_cost * bl.projfunc_cost_exchange_rate ),bl.projfunc_currency_code)))

5078: ,decode(bl.project_currency_code,bl.txn_currency_code,bl.project_revenue
5079: ,pa_currency.round_trans_currency_amt1((bl.project_revenue*bl.project_rev_exchange_rate ),bl.project_currency_code)))
5080: ,bl.raw_cost = decode(p_budget_version_type,'REVENUE',bl.raw_cost
5081: ,decode(bl.projfunc_currency_code,bl.txn_currency_code,bl.txn_raw_cost
5082: ,pa_currency.round_trans_currency_amt1((bl.txn_raw_cost * bl.projfunc_cost_exchange_rate ),bl.projfunc_currency_code)))
5083: ,bl.burdened_cost = decode(p_budget_version_type,'REVENUE',bl.burdened_cost
5084: ,decode(bl.projfunc_currency_code,bl.txn_currency_code,bl.txn_burdened_cost
5085: ,pa_currency.round_trans_currency_amt1((bl.txn_burdened_cost * bl.projfunc_cost_exchange_rate ),bl.projfunc_currency_code)))
5086: ,bl.revenue = decode(p_budget_version_type,'COST',bl.revenue

Line 5085: ,pa_currency.round_trans_currency_amt1((bl.txn_burdened_cost * bl.projfunc_cost_exchange_rate ),bl.projfunc_currency_code)))

5081: ,decode(bl.projfunc_currency_code,bl.txn_currency_code,bl.txn_raw_cost
5082: ,pa_currency.round_trans_currency_amt1((bl.txn_raw_cost * bl.projfunc_cost_exchange_rate ),bl.projfunc_currency_code)))
5083: ,bl.burdened_cost = decode(p_budget_version_type,'REVENUE',bl.burdened_cost
5084: ,decode(bl.projfunc_currency_code,bl.txn_currency_code,bl.txn_burdened_cost
5085: ,pa_currency.round_trans_currency_amt1((bl.txn_burdened_cost * bl.projfunc_cost_exchange_rate ),bl.projfunc_currency_code)))
5086: ,bl.revenue = decode(p_budget_version_type,'COST',bl.revenue
5087: ,decode(bl.projfunc_currency_code,bl.txn_currency_code,bl.project_revenue
5088: ,pa_currency.round_trans_currency_amt1((bl.project_revenue*bl.projfunc_rev_exchange_rate ),bl.projfunc_currency_code)))
5089: WHERE bl.budget_line_id = l_budget_line_id_tab(i)

Line 5088: ,pa_currency.round_trans_currency_amt1((bl.project_revenue*bl.projfunc_rev_exchange_rate ),bl.projfunc_currency_code)))

5084: ,decode(bl.projfunc_currency_code,bl.txn_currency_code,bl.txn_burdened_cost
5085: ,pa_currency.round_trans_currency_amt1((bl.txn_burdened_cost * bl.projfunc_cost_exchange_rate ),bl.projfunc_currency_code)))
5086: ,bl.revenue = decode(p_budget_version_type,'COST',bl.revenue
5087: ,decode(bl.projfunc_currency_code,bl.txn_currency_code,bl.project_revenue
5088: ,pa_currency.round_trans_currency_amt1((bl.project_revenue*bl.projfunc_rev_exchange_rate ),bl.projfunc_currency_code)))
5089: WHERE bl.budget_line_id = l_budget_line_id_tab(i)
5090: AND bl.budget_version_id = p_budget_version_id ;
5091:
5092: END IF;

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

8934: l_diff_raw_cost_tab(i) := nvl(l_unrounded_txn_raw_cost_tab(i),0) - nvl(l_rounded_txn_raw_cost_tab(i),0);
8935: l_diff_burden_cost_tab(i) := nvl(l_unround_txn_burden_cost_tab(i),0) - nvl(l_rounded_txn_burden_cost_tab(i),0);
8936: l_diff_revenue_tab(i) := nvl(l_unrounded_txn_revenue_tab(i),0) - nvl(l_rounded_txn_revenue_tab(i),0);
8937:
8938: l_diff_raw_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_raw_cost_tab(i),l_txn_currency_code_tab(i));
8939: l_diff_burden_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_burden_cost_tab(i),l_txn_currency_code_tab(i));
8940: l_diff_revenue_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_revenue_tab(i),l_txn_currency_code_tab(i));
8941: END LOOP;
8942:

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

8935: l_diff_burden_cost_tab(i) := nvl(l_unround_txn_burden_cost_tab(i),0) - nvl(l_rounded_txn_burden_cost_tab(i),0);
8936: l_diff_revenue_tab(i) := nvl(l_unrounded_txn_revenue_tab(i),0) - nvl(l_rounded_txn_revenue_tab(i),0);
8937:
8938: l_diff_raw_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_raw_cost_tab(i),l_txn_currency_code_tab(i));
8939: l_diff_burden_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_burden_cost_tab(i),l_txn_currency_code_tab(i));
8940: l_diff_revenue_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_revenue_tab(i),l_txn_currency_code_tab(i));
8941: END LOOP;
8942:
8943: g_stage := 'Update_rounding_diff_bl:102';

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

8936: l_diff_revenue_tab(i) := nvl(l_unrounded_txn_revenue_tab(i),0) - nvl(l_rounded_txn_revenue_tab(i),0);
8937:
8938: l_diff_raw_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_raw_cost_tab(i),l_txn_currency_code_tab(i));
8939: l_diff_burden_cost_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_burden_cost_tab(i),l_txn_currency_code_tab(i));
8940: l_diff_revenue_tab(i) := pa_currency.round_trans_currency_amt1(l_diff_revenue_tab(i),l_txn_currency_code_tab(i));
8941: END LOOP;
8942:
8943: g_stage := 'Update_rounding_diff_bl:102';
8944: print_msg('Updating pa_budget_line last line with the rounding difference amount');

Line 9855: SET bl.txn_raw_cost = decode((nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(

9851:
9852: --print_msg(' Num Of rows UPDATED ['||sql%rowcount||']');
9853: FORALL i IN l_tmp2_budget_line_id_tab.FIRST .. l_tmp2_budget_line_id_tab.LAST
9854: UPDATE pa_budget_lines bl
9855: SET bl.txn_raw_cost = decode((nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9856: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9857: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)),0,NULL,
9858: (nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9859: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *

Line 9858: (nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(

9854: UPDATE pa_budget_lines bl
9855: SET bl.txn_raw_cost = decode((nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9856: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9857: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)),0,NULL,
9858: (nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9859: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9860: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)))
9861: ,bl.txn_burdened_cost = decode((nvl(bl.txn_init_burdened_cost,0) + pa_currency.round_trans_currency_amt1(
9862: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *

Line 9861: ,bl.txn_burdened_cost = decode((nvl(bl.txn_init_burdened_cost,0) + pa_currency.round_trans_currency_amt1(

9857: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)),0,NULL,
9858: (nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9859: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9860: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)))
9861: ,bl.txn_burdened_cost = decode((nvl(bl.txn_init_burdened_cost,0) + pa_currency.round_trans_currency_amt1(
9862: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9863: (nvl(bl.burden_cost_rate_override,nvl(burden_cost_rate,0))),bl.txn_currency_code)),0,NULL,
9864: (nvl(bl.txn_init_burdened_cost,0) + pa_currency.round_trans_currency_amt1(
9865: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *

Line 9864: (nvl(bl.txn_init_burdened_cost,0) + pa_currency.round_trans_currency_amt1(

9860: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)))
9861: ,bl.txn_burdened_cost = decode((nvl(bl.txn_init_burdened_cost,0) + pa_currency.round_trans_currency_amt1(
9862: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9863: (nvl(bl.burden_cost_rate_override,nvl(burden_cost_rate,0))),bl.txn_currency_code)),0,NULL,
9864: (nvl(bl.txn_init_burdened_cost,0) + pa_currency.round_trans_currency_amt1(
9865: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9866: (nvl(bl.burden_cost_rate_override,nvl(burden_cost_rate,0))),bl.txn_currency_code)))
9867: ,bl.txn_revenue = decode((nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9868: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *

Line 9867: ,bl.txn_revenue = decode((nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(

9863: (nvl(bl.burden_cost_rate_override,nvl(burden_cost_rate,0))),bl.txn_currency_code)),0,NULL,
9864: (nvl(bl.txn_init_burdened_cost,0) + pa_currency.round_trans_currency_amt1(
9865: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9866: (nvl(bl.burden_cost_rate_override,nvl(burden_cost_rate,0))),bl.txn_currency_code)))
9867: ,bl.txn_revenue = decode((nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9868: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9869: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))),bl.txn_currency_code)),0,NULL,
9870: (nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9871: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *

Line 9870: (nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(

9866: (nvl(bl.burden_cost_rate_override,nvl(burden_cost_rate,0))),bl.txn_currency_code)))
9867: ,bl.txn_revenue = decode((nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9868: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9869: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))),bl.txn_currency_code)),0,NULL,
9870: (nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9871: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9872: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))),bl.txn_currency_code)))
9873: WHERE bl.budget_line_id = l_tmp2_budget_line_id_tab(i);
9874: