DBA Data[Home] [Help]

APPS.PA_FP_MULTI_CURRENCY_PKG dependencies on PA_NUM_TBL_TYPE

Line 160: ( px_quantity_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type

156: ---->p_txn...tbls will be rounded based on p_agr_currency_code, p_project_...tbls will be rounded based on
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

Line 162: ,px_txn_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type

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
166: ,px_project_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type

Line 163: ,px_txn_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type

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
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

Line 164: ,px_txn_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type

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
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

Line 166: ,px_project_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type

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
170: ,px_projfunc_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type

Line 167: ,px_project_burdened_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
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

Line 168: ,px_project_revenue_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
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

Line 170: ,px_projfunc_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type

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
174: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 171: ,px_projfunc_burdened_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
174: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
175: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 172: ,px_projfunc_revenue_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
174: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
175: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
176: END PA_FP_MULTI_CURRENCY_PKG;