1631: THEN
1632: l_actual_effort_this_period := round(l_actual_effort_this_period, 5);
1633: l_etc_effort_this_period := round(l_etc_effort_this_period, 5);
1634: ELSE
1635: l_actual_effort_this_period := pa_currency.round_trans_currency_amt(l_actual_effort_this_period, l_txn_currency_code);
1636: l_etc_effort_this_period := pa_currency.round_trans_currency_amt(l_etc_effort_this_period, l_txn_currency_code);
1637: END IF;
1638: --bug 3824042, round effort upto 2 deciaml places, end
1639:
1632: l_actual_effort_this_period := round(l_actual_effort_this_period, 5);
1633: l_etc_effort_this_period := round(l_etc_effort_this_period, 5);
1634: ELSE
1635: l_actual_effort_this_period := pa_currency.round_trans_currency_amt(l_actual_effort_this_period, l_txn_currency_code);
1636: l_etc_effort_this_period := pa_currency.round_trans_currency_amt(l_etc_effort_this_period, l_txn_currency_code);
1637: END IF;
1638: --bug 3824042, round effort upto 2 deciaml places, end
1639:
1640: --BUG3630743 (Get all planned values)
1914: END IF;
1915:
1916: -- Bug 3784874 currency conversion for ETC End
1917:
1918: /* l_burden_cost := pa_currency.round_trans_currency_amt(
1919: l_txn_raw_cost * l_burden_multiplier, l_txn_curr_code) +
1920: l_txn_raw_cost ;*/
1921:
1922: -- Raw Cost Changes End
1959: l_act_txn_raw_cost := nvl(l_actual_effort_this_period,0) * l_res_raw_rate; -- This is incremental
1960: l_act_txn_bur_cost := nvl(l_actual_effort_this_period,0) * l_res_burden_rate; -- This is incremental
1961: -- Raw Cost Changes End
1962: --bug 3824042 start
1963: l_act_txn_raw_cost := pa_currency.round_trans_currency_amt(l_act_txn_raw_cost, l_txn_currency_code);
1964: l_act_txn_bur_cost := pa_currency.round_trans_currency_amt(l_act_txn_bur_cost, l_txn_currency_code);
1965: --bug 3824042 end
1966: ELSE
1967: --l_act_txn_cost := null; -- This is incremental
1960: l_act_txn_bur_cost := nvl(l_actual_effort_this_period,0) * l_res_burden_rate; -- This is incremental
1961: -- Raw Cost Changes End
1962: --bug 3824042 start
1963: l_act_txn_raw_cost := pa_currency.round_trans_currency_amt(l_act_txn_raw_cost, l_txn_currency_code);
1964: l_act_txn_bur_cost := pa_currency.round_trans_currency_amt(l_act_txn_bur_cost, l_txn_currency_code);
1965: --bug 3824042 end
1966: ELSE
1967: --l_act_txn_cost := null; -- This is incremental
1968: l_act_txn_raw_cost := null; -- Raw Cost Changes
2020: l_etc_txn_raw_cost := nvl(l_etc_effort_this_period,0)*l_plan_res_raw_rate; -- This is cumulative
2021: l_etc_txn_bur_cost := nvl(l_etc_effort_this_period,0)*l_plan_res_burden_rate; -- This is cumulative
2022: -- Raw Cost Changes End
2023: --bug 3824042 start
2024: l_etc_txn_raw_cost := pa_currency.round_trans_currency_amt(l_etc_txn_raw_cost, l_txn_currency_code);
2025: l_etc_txn_bur_cost := pa_currency.round_trans_currency_amt(l_etc_txn_bur_cost, l_txn_currency_code);
2026: --bug 3824042 end
2027: ELSE
2028: --l_etc_txn_cost := null; -- This is cumulative
2021: l_etc_txn_bur_cost := nvl(l_etc_effort_this_period,0)*l_plan_res_burden_rate; -- This is cumulative
2022: -- Raw Cost Changes End
2023: --bug 3824042 start
2024: l_etc_txn_raw_cost := pa_currency.round_trans_currency_amt(l_etc_txn_raw_cost, l_txn_currency_code);
2025: l_etc_txn_bur_cost := pa_currency.round_trans_currency_amt(l_etc_txn_bur_cost, l_txn_currency_code);
2026: --bug 3824042 end
2027: ELSE
2028: --l_etc_txn_cost := null; -- This is cumulative
2029: l_etc_txn_raw_cost := null; -- Raw Cost Changes
2058: l_act_txn_raw_cost := l_actual_effort_this_period;
2059: l_etc_txn_raw_cost := l_etc_effort_this_period;
2060: -- Bug 3801745 End
2061:
2062: l_act_txn_bur_cost := nvl( pa_currency.round_trans_currency_amt(
2063: l_act_txn_raw_cost * l_burden_multiplier, l_txn_currency_code),0) +
2064: l_act_txn_raw_cost ;
2065: -- Bug 3627315 : Using plan burden multiplier instead of actual
2066: l_etc_txn_bur_cost := nvl( pa_currency.round_trans_currency_amt(
2062: l_act_txn_bur_cost := nvl( pa_currency.round_trans_currency_amt(
2063: l_act_txn_raw_cost * l_burden_multiplier, l_txn_currency_code),0) +
2064: l_act_txn_raw_cost ;
2065: -- Bug 3627315 : Using plan burden multiplier instead of actual
2066: l_etc_txn_bur_cost := nvl( pa_currency.round_trans_currency_amt(
2067: l_etc_txn_raw_cost * l_plan_burden_multiplier, l_txn_currency_code),0) +
2068: l_etc_txn_raw_cost ;
2069: End IF;-- NVL(l_track_wp_cost_flag, 'Y') = 'Y' THEN -- Bug 3801745
2070: -- Raw Cost Changes End
2286: --BUG3630743
2287: */
2288:
2289:
2290: --bug 3824042, round all the cost figures by calling pa_currency api, start
2291:
2292: l_act_projfunc_raw_cost := pa_currency.round_trans_currency_amt(l_act_projfunc_raw_cost, l_prjfunc_currency_code);
2293: l_act_project_raw_cost := pa_currency.round_trans_currency_amt(l_act_project_raw_cost, l_prj_currency_code);
2294: l_act_projfunc_bur_cost := pa_currency.round_trans_currency_amt(l_act_projfunc_bur_cost, l_prjfunc_currency_code);
2288:
2289:
2290: --bug 3824042, round all the cost figures by calling pa_currency api, start
2291:
2292: l_act_projfunc_raw_cost := pa_currency.round_trans_currency_amt(l_act_projfunc_raw_cost, l_prjfunc_currency_code);
2293: l_act_project_raw_cost := pa_currency.round_trans_currency_amt(l_act_project_raw_cost, l_prj_currency_code);
2294: l_act_projfunc_bur_cost := pa_currency.round_trans_currency_amt(l_act_projfunc_bur_cost, l_prjfunc_currency_code);
2295: l_act_project_bur_cost := pa_currency.round_trans_currency_amt(l_act_project_bur_cost, l_prj_currency_code);
2296:
2289:
2290: --bug 3824042, round all the cost figures by calling pa_currency api, start
2291:
2292: l_act_projfunc_raw_cost := pa_currency.round_trans_currency_amt(l_act_projfunc_raw_cost, l_prjfunc_currency_code);
2293: l_act_project_raw_cost := pa_currency.round_trans_currency_amt(l_act_project_raw_cost, l_prj_currency_code);
2294: l_act_projfunc_bur_cost := pa_currency.round_trans_currency_amt(l_act_projfunc_bur_cost, l_prjfunc_currency_code);
2295: l_act_project_bur_cost := pa_currency.round_trans_currency_amt(l_act_project_bur_cost, l_prj_currency_code);
2296:
2297: l_etc_projfunc_raw_cost := pa_currency.round_trans_currency_amt(l_etc_projfunc_raw_cost, l_prjfunc_currency_code);
2290: --bug 3824042, round all the cost figures by calling pa_currency api, start
2291:
2292: l_act_projfunc_raw_cost := pa_currency.round_trans_currency_amt(l_act_projfunc_raw_cost, l_prjfunc_currency_code);
2293: l_act_project_raw_cost := pa_currency.round_trans_currency_amt(l_act_project_raw_cost, l_prj_currency_code);
2294: l_act_projfunc_bur_cost := pa_currency.round_trans_currency_amt(l_act_projfunc_bur_cost, l_prjfunc_currency_code);
2295: l_act_project_bur_cost := pa_currency.round_trans_currency_amt(l_act_project_bur_cost, l_prj_currency_code);
2296:
2297: l_etc_projfunc_raw_cost := pa_currency.round_trans_currency_amt(l_etc_projfunc_raw_cost, l_prjfunc_currency_code);
2298: l_etc_project_raw_cost := pa_currency.round_trans_currency_amt(l_etc_project_raw_cost, l_prj_currency_code);
2291:
2292: l_act_projfunc_raw_cost := pa_currency.round_trans_currency_amt(l_act_projfunc_raw_cost, l_prjfunc_currency_code);
2293: l_act_project_raw_cost := pa_currency.round_trans_currency_amt(l_act_project_raw_cost, l_prj_currency_code);
2294: l_act_projfunc_bur_cost := pa_currency.round_trans_currency_amt(l_act_projfunc_bur_cost, l_prjfunc_currency_code);
2295: l_act_project_bur_cost := pa_currency.round_trans_currency_amt(l_act_project_bur_cost, l_prj_currency_code);
2296:
2297: l_etc_projfunc_raw_cost := pa_currency.round_trans_currency_amt(l_etc_projfunc_raw_cost, l_prjfunc_currency_code);
2298: l_etc_project_raw_cost := pa_currency.round_trans_currency_amt(l_etc_project_raw_cost, l_prj_currency_code);
2299: l_etc_projfunc_bur_cost := pa_currency.round_trans_currency_amt(l_etc_projfunc_bur_cost, l_prjfunc_currency_code);
2293: l_act_project_raw_cost := pa_currency.round_trans_currency_amt(l_act_project_raw_cost, l_prj_currency_code);
2294: l_act_projfunc_bur_cost := pa_currency.round_trans_currency_amt(l_act_projfunc_bur_cost, l_prjfunc_currency_code);
2295: l_act_project_bur_cost := pa_currency.round_trans_currency_amt(l_act_project_bur_cost, l_prj_currency_code);
2296:
2297: l_etc_projfunc_raw_cost := pa_currency.round_trans_currency_amt(l_etc_projfunc_raw_cost, l_prjfunc_currency_code);
2298: l_etc_project_raw_cost := pa_currency.round_trans_currency_amt(l_etc_project_raw_cost, l_prj_currency_code);
2299: l_etc_projfunc_bur_cost := pa_currency.round_trans_currency_amt(l_etc_projfunc_bur_cost, l_prjfunc_currency_code);
2300: l_etc_project_bur_cost := pa_currency.round_trans_currency_amt(l_etc_project_bur_cost, l_prj_currency_code);
2301:
2294: l_act_projfunc_bur_cost := pa_currency.round_trans_currency_amt(l_act_projfunc_bur_cost, l_prjfunc_currency_code);
2295: l_act_project_bur_cost := pa_currency.round_trans_currency_amt(l_act_project_bur_cost, l_prj_currency_code);
2296:
2297: l_etc_projfunc_raw_cost := pa_currency.round_trans_currency_amt(l_etc_projfunc_raw_cost, l_prjfunc_currency_code);
2298: l_etc_project_raw_cost := pa_currency.round_trans_currency_amt(l_etc_project_raw_cost, l_prj_currency_code);
2299: l_etc_projfunc_bur_cost := pa_currency.round_trans_currency_amt(l_etc_projfunc_bur_cost, l_prjfunc_currency_code);
2300: l_etc_project_bur_cost := pa_currency.round_trans_currency_amt(l_etc_project_bur_cost, l_prj_currency_code);
2301:
2302: --bug 3824042, round all the cost figures by calling pa_currency api, end
2295: l_act_project_bur_cost := pa_currency.round_trans_currency_amt(l_act_project_bur_cost, l_prj_currency_code);
2296:
2297: l_etc_projfunc_raw_cost := pa_currency.round_trans_currency_amt(l_etc_projfunc_raw_cost, l_prjfunc_currency_code);
2298: l_etc_project_raw_cost := pa_currency.round_trans_currency_amt(l_etc_project_raw_cost, l_prj_currency_code);
2299: l_etc_projfunc_bur_cost := pa_currency.round_trans_currency_amt(l_etc_projfunc_bur_cost, l_prjfunc_currency_code);
2300: l_etc_project_bur_cost := pa_currency.round_trans_currency_amt(l_etc_project_bur_cost, l_prj_currency_code);
2301:
2302: --bug 3824042, round all the cost figures by calling pa_currency api, end
2303:
2296:
2297: l_etc_projfunc_raw_cost := pa_currency.round_trans_currency_amt(l_etc_projfunc_raw_cost, l_prjfunc_currency_code);
2298: l_etc_project_raw_cost := pa_currency.round_trans_currency_amt(l_etc_project_raw_cost, l_prj_currency_code);
2299: l_etc_projfunc_bur_cost := pa_currency.round_trans_currency_amt(l_etc_projfunc_bur_cost, l_prjfunc_currency_code);
2300: l_etc_project_bur_cost := pa_currency.round_trans_currency_amt(l_etc_project_bur_cost, l_prj_currency_code);
2301:
2302: --bug 3824042, round all the cost figures by calling pa_currency api, end
2303:
2304:
2298: l_etc_project_raw_cost := pa_currency.round_trans_currency_amt(l_etc_project_raw_cost, l_prj_currency_code);
2299: l_etc_projfunc_bur_cost := pa_currency.round_trans_currency_amt(l_etc_projfunc_bur_cost, l_prjfunc_currency_code);
2300: l_etc_project_bur_cost := pa_currency.round_trans_currency_amt(l_etc_project_bur_cost, l_prj_currency_code);
2301:
2302: --bug 3824042, round all the cost figures by calling pa_currency api, end
2303:
2304:
2305: IF l_resource_class_code = 'PEOPLE' --maansari7/6 bug 3742356
2306: THEN