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 127: ,p_bls_inserted_after_id IN pa_budget_lines.budget_line_id%TYPE DEFAULT NULL

123: ==============================================================================*/
124:
125: PROCEDURE Round_Budget_Line_Amounts(
126: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
127: ,p_bls_inserted_after_id IN pa_budget_lines.budget_line_id%TYPE DEFAULT NULL
128: ,p_calling_context IN VARCHAR2
129: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
130: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
131: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 141: 4:TABLE ACCESS BY INDEX ROWID PA_BUDGET_LINES :(cost=49,rows=1)

137: * Shared memory(M) = 62831, Parse Time(S) = 0 , Total Cost = 51, Nof. FTS = 0
138: 1:SELECT STATEMENT :(cost=51,rows=1)
139: 2:SORT ORDER BY :(cost=51,rows=1)
140: 3:FILTER :(cost=,rows=)
141: 4:TABLE ACCESS BY INDEX ROWID PA_BUDGET_LINES :(cost=49,rows=1)
142: 5:INDEX RANGE SCAN PA_BUDGET_LINES_N3 :(cost=2,rows=1)
143: 4:TABLE ACCESS BY INDEX ROWID PA_RESOURCE_ASSIGNMENTS :(cost=2,rows=1)
144: 5:INDEX UNIQUE SCAN PA_RESOURCE_ASSIGNMENTS_U1 :(cost=1,rows=1)
145: * Refer to bug for more details

Line 142: 5:INDEX RANGE SCAN PA_BUDGET_LINES_N3 :(cost=2,rows=1)

138: 1:SELECT STATEMENT :(cost=51,rows=1)
139: 2:SORT ORDER BY :(cost=51,rows=1)
140: 3:FILTER :(cost=,rows=)
141: 4:TABLE ACCESS BY INDEX ROWID PA_BUDGET_LINES :(cost=49,rows=1)
142: 5:INDEX RANGE SCAN PA_BUDGET_LINES_N3 :(cost=2,rows=1)
143: 4:TABLE ACCESS BY INDEX ROWID PA_RESOURCE_ASSIGNMENTS :(cost=2,rows=1)
144: 5:INDEX UNIQUE SCAN PA_RESOURCE_ASSIGNMENTS_U1 :(cost=1,rows=1)
145: * Refer to bug for more details
146: */

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

157: --p_project_currency_code and p_projfunc_...tbls will be rounded based on p_projfunc_currency_code
158: ---->px_quantity_tbl will be rounded to have max 5 digits after decimal point
159: PROCEDURE round_amounts
160: ( px_quantity_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
161: ,p_agr_currency_code IN OUT NOCOPY pa_budget_lines.txn_currency_code%TYPE --File.Sql.39 bug 4440895
162: ,px_txn_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
163: ,px_txn_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
164: ,px_txn_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
165: ,p_project_currency_code IN OUT NOCOPY pa_budget_lines.project_currency_code%TYPE --File.Sql.39 bug 4440895

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

161: ,p_agr_currency_code IN OUT NOCOPY pa_budget_lines.txn_currency_code%TYPE --File.Sql.39 bug 4440895
162: ,px_txn_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
163: ,px_txn_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
164: ,px_txn_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
165: ,p_project_currency_code IN OUT NOCOPY pa_budget_lines.project_currency_code%TYPE --File.Sql.39 bug 4440895
166: ,px_project_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
167: ,px_project_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
168: ,px_project_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
169: ,p_projfunc_currency_code IN OUT NOCOPY pa_budget_lines.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895

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

165: ,p_project_currency_code IN OUT NOCOPY pa_budget_lines.project_currency_code%TYPE --File.Sql.39 bug 4440895
166: ,px_project_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
167: ,px_project_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
168: ,px_project_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
169: ,p_projfunc_currency_code IN OUT NOCOPY pa_budget_lines.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
170: ,px_projfunc_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
171: ,px_projfunc_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
172: ,px_projfunc_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
173: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895