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_MULTI_CURRENCY_PKG dependencies on PA_BUDGET_LINES

Line 1935: from pa_budget_lines a

1931: ,a.init_revenue
1932: ,a.project_init_raw_cost
1933: ,a.project_init_burdened_cost
1934: ,a.project_init_revenue
1935: from pa_budget_lines a
1936: ,pa_budget_versions bv
1937: --,pa_fp_txn_currencies c
1938: where a.budget_version_id = p_budget_version_id
1939: and bv.budget_version_id = a.budget_version_id

Line 2485: --hr_utility.trace('Updating pa_budget_lines...');

2481:
2482: L_ROWCOUNT := l_projfunc_currency_code_tab.count;
2483:
2484: IF l_rowcount > 0 THEN
2485: --hr_utility.trace('Updating pa_budget_lines...');
2486: FORALL i in 1..l_rowcount
2487: UPDATE pa_budget_lines
2488: SET projfunc_currency_code = l_projfunc_currency_code_tab(i)
2489: ,projfunc_cost_rate_type = l_projfunc_cost_rate_type_tab(i)

Line 2487: UPDATE pa_budget_lines

2483:
2484: IF l_rowcount > 0 THEN
2485: --hr_utility.trace('Updating pa_budget_lines...');
2486: FORALL i in 1..l_rowcount
2487: UPDATE pa_budget_lines
2488: SET projfunc_currency_code = l_projfunc_currency_code_tab(i)
2489: ,projfunc_cost_rate_type = l_projfunc_cost_rate_type_tab(i)
2490: ,projfunc_cost_exchange_rate = l_projfunc_cost_rate_tab(i)
2491: ,projfunc_cost_rate_date_type = l_projfunc_cost_rt_dt_typ_tab(i)

Line 2677: ,p_bls_inserted_after_id IN pa_budget_lines.budget_line_id%TYPE DEFAULT NULL

2673: ==============================================================================*/
2674:
2675: PROCEDURE Round_Budget_Line_Amounts(
2676: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
2677: ,p_bls_inserted_after_id IN pa_budget_lines.budget_line_id%TYPE DEFAULT NULL
2678: ,p_calling_context IN VARCHAR2
2679: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2680: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2681: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 2753: FROM pa_budget_lines pbl,

2749: SELECT pbl.ROWID, pbl.resource_assignment_id,pbl.start_date, pbl.quantity,
2750: pbl.raw_cost, pbl.burdened_cost, pbl.revenue,pbl.projfunc_currency_code,
2751: pbl.project_raw_cost, pbl.project_burdened_cost, pbl.project_revenue, pbl.project_currency_code,
2752: pbl.txn_raw_cost, pbl.txn_burdened_cost, pbl.txn_revenue, pbl.txn_currency_code, pra.rate_based_flag
2753: FROM pa_budget_lines pbl,
2754: pa_resource_assignments pra
2755: WHERE pbl.budget_version_id = p_budget_version_id
2756: AND pra.resource_assignment_id=pbl.resource_assignment_id
2757: ORDER BY pbl.txn_currency_code;

Line 2768: FROM pa_budget_lines pbl,

2764: SELECT pbl.ROWID, pbl.resource_assignment_id,pbl.start_date, pbl.quantity,
2765: pbl.raw_cost, pbl.burdened_cost, pbl.revenue,pbl.projfunc_currency_code,
2766: pbl.project_raw_cost, pbl.project_burdened_cost, pbl.project_revenue, pbl.project_currency_code,
2767: pbl.txn_raw_cost, pbl.txn_burdened_cost, pbl.txn_revenue, pbl.txn_currency_code, pra.rate_based_flag
2768: FROM pa_budget_lines pbl,
2769: pa_resource_assignments pra
2770: WHERE pbl.budget_version_id = p_budget_version_id
2771: AND pra.resource_assignment_id=pbl.resource_assignment_id
2772: AND budget_line_id > p_bls_inserted_after_id

Line 3056: -- Update pa_budget_lines with the rounded amounts

3052: END IF;
3053: --Code changes for bug 4200168 ends here.
3054: END IF; --IF p_calling_context <> 'COPY_VERSION' THEN
3055:
3056: -- Update pa_budget_lines with the rounded amounts
3057: --Bug 4052403. In the Updates below, made sure that for non rate-based planning transactions, the quanity is updated to
3058: --raw cost/revenue as the case may be
3059: IF p_calling_context = 'COPY_VERSION' THEN
3060: -- Update txn currency amounts well, PC and PFC amounts would be null at this point of time

Line 3063: UPDATE PA_BUDGET_LINES

3059: IF p_calling_context = 'COPY_VERSION' THEN
3060: -- Update txn currency amounts well, PC and PFC amounts would be null at this point of time
3061: -- Stamp cost rate, burden cost rate and bill rate as overrides
3062: FORALL i in l_txn_row_id_tab.first .. l_txn_row_id_tab.last
3063: UPDATE PA_BUDGET_LINES
3064: SET --While deriving the override rates below, the expression used here for calculating quantity is used.
3065: --Hence whenever this derivation is changed, the change has to be reflected below in override rate
3066: --derivation also
3067: quantity = Decode(l_rate_based_flag_tab(i),

Line 3118: UPDATE PA_BUDGET_LINES

3114: -- If any line is affected by change order merge, then cur conv rate type is stamped as 'USER'
3115: -- All other lines would have rounded amounts any way and the program should not alter them
3116: -- So only exchange rate column is updated for those lines with 'USER' as the rate type
3117: FORALL i in l_txn_row_id_tab.first .. l_txn_row_id_tab.last
3118: UPDATE PA_BUDGET_LINES
3119: SET quantity = Decode(l_rate_based_flag_tab(i),
3120: 'N',Decode(l_version_type,
3121: 'REVENUE',l_txn_revenue_tab(i),
3122: l_txn_raw_cost_tab(i)),

Line 3272: ,p_agr_currency_code IN OUT NOCOPY pa_budget_lines.txn_currency_code%TYPE --File.Sql.39 bug 4440895

3268: --p_project_currency_code and p_projfunc_...tbls will be rounded based on p_projfunc_currency_code
3269: ---->px_quantity_tbl will be rounded to have max 5 digits after decimal point
3270: PROCEDURE round_amounts
3271: ( px_quantity_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3272: ,p_agr_currency_code IN OUT NOCOPY pa_budget_lines.txn_currency_code%TYPE --File.Sql.39 bug 4440895
3273: ,px_txn_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3274: ,px_txn_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3275: ,px_txn_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3276: ,p_project_currency_code IN OUT NOCOPY pa_budget_lines.project_currency_code%TYPE --File.Sql.39 bug 4440895

Line 3276: ,p_project_currency_code IN OUT NOCOPY pa_budget_lines.project_currency_code%TYPE --File.Sql.39 bug 4440895

3272: ,p_agr_currency_code IN OUT NOCOPY pa_budget_lines.txn_currency_code%TYPE --File.Sql.39 bug 4440895
3273: ,px_txn_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3274: ,px_txn_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3275: ,px_txn_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3276: ,p_project_currency_code IN OUT NOCOPY pa_budget_lines.project_currency_code%TYPE --File.Sql.39 bug 4440895
3277: ,px_project_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3278: ,px_project_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3279: ,px_project_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3280: ,p_projfunc_currency_code IN OUT NOCOPY pa_budget_lines.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895

Line 3280: ,p_projfunc_currency_code IN OUT NOCOPY pa_budget_lines.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895

3276: ,p_project_currency_code IN OUT NOCOPY pa_budget_lines.project_currency_code%TYPE --File.Sql.39 bug 4440895
3277: ,px_project_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3278: ,px_project_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3279: ,px_project_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3280: ,p_projfunc_currency_code IN OUT NOCOPY pa_budget_lines.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
3281: ,px_projfunc_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3282: ,px_projfunc_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3283: ,px_projfunc_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3284: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895