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 4972: 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))*

4968: l_end_date_tab(l_rwCounter) := i.end_date;
4969: l_period_name_tab(l_rwCounter) := i.period_name;
4970: l_quantity_tab(l_rwCounter) := nvl(i.fp_quantity,0);
4971: IF p_budget_version_type in ('ALL','COST') Then
4972: 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))*
4973: nvl(i.txn_cost_rate_override,i.txn_standard_cost_rate)) +nvl(i.txn_init_raw_cost,0)),i.txn_currency_code);
4974: 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))*
4975: nvl(i.burden_cost_rate_override,i.burden_cost_rate)) + nvl(i.txn_init_burdened_cost,0)),i.txn_currency_code);
4976: ELSE

Line 4974: 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))*

4970: l_quantity_tab(l_rwCounter) := nvl(i.fp_quantity,0);
4971: IF p_budget_version_type in ('ALL','COST') Then
4972: 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))*
4973: nvl(i.txn_cost_rate_override,i.txn_standard_cost_rate)) +nvl(i.txn_init_raw_cost,0)),i.txn_currency_code);
4974: 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))*
4975: nvl(i.burden_cost_rate_override,i.burden_cost_rate)) + nvl(i.txn_init_burdened_cost,0)),i.txn_currency_code);
4976: ELSE
4977: l_txn_raw_cost_tab(l_rwCounter) := NULL;
4978: l_txn_burden_cost_tab(l_rwCounter) := NULL;

Line 4981: 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))*

4977: l_txn_raw_cost_tab(l_rwCounter) := NULL;
4978: l_txn_burden_cost_tab(l_rwCounter) := NULL;
4979: END IF;
4980: IF p_budget_version_type in ('ALL','REVENUE') Then
4981: 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))*
4982: nvl(i.txn_bill_rate_override,i.txn_standard_bill_rate)) +nvl(i.txn_init_revenue,0)),i.txn_currency_code);
4983: Else
4984: l_txn_revenue_tab(l_rwCounter) := NULL;
4985: End If;

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

5040: FORALL i IN l_budget_line_id_tab.FIRST .. l_budget_line_id_tab.LAST
5041: UPDATE PA_BUDGET_LINES bl
5042: SET bl.project_raw_cost = decode(p_budget_version_type,'REVENUE',bl.project_raw_cost
5043: ,decode(bl.project_currency_code,bl.txn_currency_code,bl.txn_raw_cost
5044: ,pa_currency.round_trans_currency_amt1((bl.txn_raw_cost * bl.project_cost_exchange_rate ),bl.project_currency_code)))
5045: ,bl.project_burdened_cost = decode(p_budget_version_type,'REVENUE',bl.project_burdened_cost
5046: ,decode(bl.project_currency_code,bl.txn_currency_code,bl.txn_burdened_cost
5047: ,pa_currency.round_trans_currency_amt1((bl.txn_burdened_cost * bl.project_cost_exchange_rate ),bl.project_currency_code)))
5048: ,bl.project_revenue = decode(p_budget_version_type,'COST',bl.project_revenue

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

5043: ,decode(bl.project_currency_code,bl.txn_currency_code,bl.txn_raw_cost
5044: ,pa_currency.round_trans_currency_amt1((bl.txn_raw_cost * bl.project_cost_exchange_rate ),bl.project_currency_code)))
5045: ,bl.project_burdened_cost = decode(p_budget_version_type,'REVENUE',bl.project_burdened_cost
5046: ,decode(bl.project_currency_code,bl.txn_currency_code,bl.txn_burdened_cost
5047: ,pa_currency.round_trans_currency_amt1((bl.txn_burdened_cost * bl.project_cost_exchange_rate ),bl.project_currency_code)))
5048: ,bl.project_revenue = decode(p_budget_version_type,'COST',bl.project_revenue
5049: ,decode(bl.project_currency_code,bl.txn_currency_code,bl.project_revenue
5050: ,pa_currency.round_trans_currency_amt1((bl.project_revenue*bl.project_rev_exchange_rate ),bl.project_currency_code)))
5051: ,bl.raw_cost = decode(p_budget_version_type,'REVENUE',bl.raw_cost

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

5046: ,decode(bl.project_currency_code,bl.txn_currency_code,bl.txn_burdened_cost
5047: ,pa_currency.round_trans_currency_amt1((bl.txn_burdened_cost * bl.project_cost_exchange_rate ),bl.project_currency_code)))
5048: ,bl.project_revenue = decode(p_budget_version_type,'COST',bl.project_revenue
5049: ,decode(bl.project_currency_code,bl.txn_currency_code,bl.project_revenue
5050: ,pa_currency.round_trans_currency_amt1((bl.project_revenue*bl.project_rev_exchange_rate ),bl.project_currency_code)))
5051: ,bl.raw_cost = decode(p_budget_version_type,'REVENUE',bl.raw_cost
5052: ,decode(bl.projfunc_currency_code,bl.txn_currency_code,bl.txn_raw_cost
5053: ,pa_currency.round_trans_currency_amt1((bl.txn_raw_cost * bl.projfunc_cost_exchange_rate ),bl.projfunc_currency_code)))
5054: ,bl.burdened_cost = decode(p_budget_version_type,'REVENUE',bl.burdened_cost

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

5049: ,decode(bl.project_currency_code,bl.txn_currency_code,bl.project_revenue
5050: ,pa_currency.round_trans_currency_amt1((bl.project_revenue*bl.project_rev_exchange_rate ),bl.project_currency_code)))
5051: ,bl.raw_cost = decode(p_budget_version_type,'REVENUE',bl.raw_cost
5052: ,decode(bl.projfunc_currency_code,bl.txn_currency_code,bl.txn_raw_cost
5053: ,pa_currency.round_trans_currency_amt1((bl.txn_raw_cost * bl.projfunc_cost_exchange_rate ),bl.projfunc_currency_code)))
5054: ,bl.burdened_cost = decode(p_budget_version_type,'REVENUE',bl.burdened_cost
5055: ,decode(bl.projfunc_currency_code,bl.txn_currency_code,bl.txn_burdened_cost
5056: ,pa_currency.round_trans_currency_amt1((bl.txn_burdened_cost * bl.projfunc_cost_exchange_rate ),bl.projfunc_currency_code)))
5057: ,bl.revenue = decode(p_budget_version_type,'COST',bl.revenue

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

5052: ,decode(bl.projfunc_currency_code,bl.txn_currency_code,bl.txn_raw_cost
5053: ,pa_currency.round_trans_currency_amt1((bl.txn_raw_cost * bl.projfunc_cost_exchange_rate ),bl.projfunc_currency_code)))
5054: ,bl.burdened_cost = decode(p_budget_version_type,'REVENUE',bl.burdened_cost
5055: ,decode(bl.projfunc_currency_code,bl.txn_currency_code,bl.txn_burdened_cost
5056: ,pa_currency.round_trans_currency_amt1((bl.txn_burdened_cost * bl.projfunc_cost_exchange_rate ),bl.projfunc_currency_code)))
5057: ,bl.revenue = decode(p_budget_version_type,'COST',bl.revenue
5058: ,decode(bl.projfunc_currency_code,bl.txn_currency_code,bl.project_revenue
5059: ,pa_currency.round_trans_currency_amt1((bl.project_revenue*bl.projfunc_rev_exchange_rate ),bl.projfunc_currency_code)))
5060: WHERE bl.budget_line_id = l_budget_line_id_tab(i)

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

5055: ,decode(bl.projfunc_currency_code,bl.txn_currency_code,bl.txn_burdened_cost
5056: ,pa_currency.round_trans_currency_amt1((bl.txn_burdened_cost * bl.projfunc_cost_exchange_rate ),bl.projfunc_currency_code)))
5057: ,bl.revenue = decode(p_budget_version_type,'COST',bl.revenue
5058: ,decode(bl.projfunc_currency_code,bl.txn_currency_code,bl.project_revenue
5059: ,pa_currency.round_trans_currency_amt1((bl.project_revenue*bl.projfunc_rev_exchange_rate ),bl.projfunc_currency_code)))
5060: WHERE bl.budget_line_id = l_budget_line_id_tab(i)
5061: AND bl.budget_version_id = p_budget_version_id ;
5062:
5063: END IF;

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

9617:
9618: --print_msg(' Num Of rows UPDATED ['||sql%rowcount||']');
9619: FORALL i IN l_tmp2_budget_line_id_tab.FIRST .. l_tmp2_budget_line_id_tab.LAST
9620: UPDATE pa_budget_lines bl
9621: SET bl.txn_raw_cost = decode((nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9622: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9623: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)),0,NULL,
9624: (nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9625: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *

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

9620: UPDATE pa_budget_lines bl
9621: SET bl.txn_raw_cost = decode((nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9622: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9623: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)),0,NULL,
9624: (nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9625: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9626: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)))
9627: ,bl.txn_burdened_cost = decode((nvl(bl.txn_init_burdened_cost,0) + pa_currency.round_trans_currency_amt1(
9628: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *

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

9623: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)),0,NULL,
9624: (nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9625: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9626: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)))
9627: ,bl.txn_burdened_cost = decode((nvl(bl.txn_init_burdened_cost,0) + pa_currency.round_trans_currency_amt1(
9628: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9629: (nvl(bl.burden_cost_rate_override,nvl(burden_cost_rate,0))),bl.txn_currency_code)),0,NULL,
9630: (nvl(bl.txn_init_burdened_cost,0) + pa_currency.round_trans_currency_amt1(
9631: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *

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

9626: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)))
9627: ,bl.txn_burdened_cost = decode((nvl(bl.txn_init_burdened_cost,0) + pa_currency.round_trans_currency_amt1(
9628: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9629: (nvl(bl.burden_cost_rate_override,nvl(burden_cost_rate,0))),bl.txn_currency_code)),0,NULL,
9630: (nvl(bl.txn_init_burdened_cost,0) + pa_currency.round_trans_currency_amt1(
9631: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9632: (nvl(bl.burden_cost_rate_override,nvl(burden_cost_rate,0))),bl.txn_currency_code)))
9633: ,bl.txn_revenue = decode((nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9634: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *

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

9629: (nvl(bl.burden_cost_rate_override,nvl(burden_cost_rate,0))),bl.txn_currency_code)),0,NULL,
9630: (nvl(bl.txn_init_burdened_cost,0) + pa_currency.round_trans_currency_amt1(
9631: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9632: (nvl(bl.burden_cost_rate_override,nvl(burden_cost_rate,0))),bl.txn_currency_code)))
9633: ,bl.txn_revenue = decode((nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9634: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9635: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))),bl.txn_currency_code)),0,NULL,
9636: (nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9637: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *

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

9632: (nvl(bl.burden_cost_rate_override,nvl(burden_cost_rate,0))),bl.txn_currency_code)))
9633: ,bl.txn_revenue = decode((nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9634: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9635: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))),bl.txn_currency_code)),0,NULL,
9636: (nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9637: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9638: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))),bl.txn_currency_code)))
9639: WHERE bl.budget_line_id = l_tmp2_budget_line_id_tab(i);
9640: