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 1968: from pa_budget_lines a

1964: ,a.init_revenue
1965: ,a.project_init_raw_cost
1966: ,a.project_init_burdened_cost
1967: ,a.project_init_revenue
1968: from pa_budget_lines a
1969: ,pa_budget_versions bv
1970: --,pa_fp_txn_currencies c
1971: where a.budget_version_id = p_budget_version_id
1972: and bv.budget_version_id = a.budget_version_id

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

2514:
2515: L_ROWCOUNT := l_projfunc_currency_code_tab.count;
2516:
2517: IF l_rowcount > 0 THEN
2518: --hr_utility.trace('Updating pa_budget_lines...');
2519: FORALL i in 1..l_rowcount
2520: UPDATE pa_budget_lines
2521: SET projfunc_currency_code = l_projfunc_currency_code_tab(i)
2522: ,projfunc_cost_rate_type = l_projfunc_cost_rate_type_tab(i)

Line 2520: UPDATE pa_budget_lines

2516:
2517: IF l_rowcount > 0 THEN
2518: --hr_utility.trace('Updating pa_budget_lines...');
2519: FORALL i in 1..l_rowcount
2520: UPDATE pa_budget_lines
2521: SET projfunc_currency_code = l_projfunc_currency_code_tab(i)
2522: ,projfunc_cost_rate_type = l_projfunc_cost_rate_type_tab(i)
2523: ,projfunc_cost_exchange_rate = l_projfunc_cost_rate_tab(i)
2524: ,projfunc_cost_rate_date_type = l_projfunc_cost_rt_dt_typ_tab(i)

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

2706: ==============================================================================*/
2707:
2708: PROCEDURE Round_Budget_Line_Amounts(
2709: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
2710: ,p_bls_inserted_after_id IN pa_budget_lines.budget_line_id%TYPE DEFAULT NULL
2711: ,p_calling_context IN VARCHAR2
2712: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2713: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2714: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 2786: FROM pa_budget_lines pbl,

2782: SELECT pbl.ROWID, pbl.resource_assignment_id,pbl.start_date, pbl.quantity,
2783: pbl.raw_cost, pbl.burdened_cost, pbl.revenue,pbl.projfunc_currency_code,
2784: pbl.project_raw_cost, pbl.project_burdened_cost, pbl.project_revenue, pbl.project_currency_code,
2785: pbl.txn_raw_cost, pbl.txn_burdened_cost, pbl.txn_revenue, pbl.txn_currency_code, pra.rate_based_flag
2786: FROM pa_budget_lines pbl,
2787: pa_resource_assignments pra
2788: WHERE pbl.budget_version_id = p_budget_version_id
2789: AND pra.resource_assignment_id=pbl.resource_assignment_id
2790: ORDER BY pbl.txn_currency_code;

Line 2801: FROM pa_budget_lines pbl,

2797: SELECT pbl.ROWID, pbl.resource_assignment_id,pbl.start_date, pbl.quantity,
2798: pbl.raw_cost, pbl.burdened_cost, pbl.revenue,pbl.projfunc_currency_code,
2799: pbl.project_raw_cost, pbl.project_burdened_cost, pbl.project_revenue, pbl.project_currency_code,
2800: pbl.txn_raw_cost, pbl.txn_burdened_cost, pbl.txn_revenue, pbl.txn_currency_code, pra.rate_based_flag
2801: FROM pa_budget_lines pbl,
2802: pa_resource_assignments pra
2803: WHERE pbl.budget_version_id = p_budget_version_id
2804: AND pra.resource_assignment_id=pbl.resource_assignment_id
2805: AND budget_line_id > p_bls_inserted_after_id

Line 3089: -- Update pa_budget_lines with the rounded amounts

3085: END IF;
3086: --Code changes for bug 4200168 ends here.
3087: END IF; --IF p_calling_context <> 'COPY_VERSION' THEN
3088:
3089: -- Update pa_budget_lines with the rounded amounts
3090: --Bug 4052403. In the Updates below, made sure that for non rate-based planning transactions, the quanity is updated to
3091: --raw cost/revenue as the case may be
3092: IF p_calling_context = 'COPY_VERSION' THEN
3093: -- Update txn currency amounts well, PC and PFC amounts would be null at this point of time

Line 3096: UPDATE PA_BUDGET_LINES

3092: IF p_calling_context = 'COPY_VERSION' THEN
3093: -- Update txn currency amounts well, PC and PFC amounts would be null at this point of time
3094: -- Stamp cost rate, burden cost rate and bill rate as overrides
3095: FORALL i in l_txn_row_id_tab.first .. l_txn_row_id_tab.last
3096: UPDATE PA_BUDGET_LINES
3097: SET --While deriving the override rates below, the expression used here for calculating quantity is used.
3098: --Hence whenever this derivation is changed, the change has to be reflected below in override rate
3099: --derivation also
3100: quantity = Decode(l_rate_based_flag_tab(i),

Line 3151: UPDATE PA_BUDGET_LINES

3147: -- If any line is affected by change order merge, then cur conv rate type is stamped as 'USER'
3148: -- All other lines would have rounded amounts any way and the program should not alter them
3149: -- So only exchange rate column is updated for those lines with 'USER' as the rate type
3150: FORALL i in l_txn_row_id_tab.first .. l_txn_row_id_tab.last
3151: UPDATE PA_BUDGET_LINES
3152: SET quantity = Decode(l_rate_based_flag_tab(i),
3153: 'N',Decode(l_version_type,
3154: 'REVENUE',l_txn_revenue_tab(i),
3155: l_txn_raw_cost_tab(i)),

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

3301: --p_project_currency_code and p_projfunc_...tbls will be rounded based on p_projfunc_currency_code
3302: ---->px_quantity_tbl will be rounded to have max 5 digits after decimal point
3303: PROCEDURE round_amounts
3304: ( px_quantity_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3305: ,p_agr_currency_code IN OUT NOCOPY pa_budget_lines.txn_currency_code%TYPE --File.Sql.39 bug 4440895
3306: ,px_txn_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3307: ,px_txn_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3308: ,px_txn_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3309: ,p_project_currency_code IN OUT NOCOPY pa_budget_lines.project_currency_code%TYPE --File.Sql.39 bug 4440895

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

3305: ,p_agr_currency_code IN OUT NOCOPY pa_budget_lines.txn_currency_code%TYPE --File.Sql.39 bug 4440895
3306: ,px_txn_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3307: ,px_txn_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3308: ,px_txn_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3309: ,p_project_currency_code IN OUT NOCOPY pa_budget_lines.project_currency_code%TYPE --File.Sql.39 bug 4440895
3310: ,px_project_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3311: ,px_project_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3312: ,px_project_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3313: ,p_projfunc_currency_code IN OUT NOCOPY pa_budget_lines.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895

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

3309: ,p_project_currency_code IN OUT NOCOPY pa_budget_lines.project_currency_code%TYPE --File.Sql.39 bug 4440895
3310: ,px_project_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3311: ,px_project_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3312: ,px_project_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3313: ,p_projfunc_currency_code IN OUT NOCOPY pa_budget_lines.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
3314: ,px_projfunc_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3315: ,px_projfunc_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3316: ,px_projfunc_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3317: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895