2700: -- l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2701: --l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2702: --l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2703: l_txn_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2704: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2705: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2706: l_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2707:
2708: /*l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2701: --l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2702: --l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2703: l_txn_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2704: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2705: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2706: l_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2707:
2708: /*l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2709: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2702: --l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2703: l_txn_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2704: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2705: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2706: l_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2707:
2708: /*l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2709: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2710: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2716:
2717: l_projfunc_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2718: l_proj_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2719:
2720: l_projfunc_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2721: l_projfunc_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2722: l_projfunc_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2723:
2724: l_proj_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2717: l_projfunc_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2718: l_proj_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2719:
2720: l_projfunc_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2721: l_projfunc_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2722: l_projfunc_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2723:
2724: l_proj_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2725: l_proj_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2718: l_proj_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2719:
2720: l_projfunc_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2721: l_projfunc_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2722: l_projfunc_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2723:
2724: l_proj_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2725: l_proj_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2726: l_proj_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2720: l_projfunc_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2721: l_projfunc_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2722: l_projfunc_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2723:
2724: l_proj_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2725: l_proj_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2726: l_proj_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2727:
2728: --these tables below are introduced to store values when the txn, projfunc and project currency are not equal
2721: l_projfunc_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2722: l_projfunc_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2723:
2724: l_proj_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2725: l_proj_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2726: l_proj_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2727:
2728: --these tables below are introduced to store values when the txn, projfunc and project currency are not equal
2729: -- for any budget line.
2722: l_projfunc_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2723:
2724: l_proj_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2725: l_proj_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2726: l_proj_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2727:
2728: --these tables below are introduced to store values when the txn, projfunc and project currency are not equal
2729: -- for any budget line.
2730:
2727:
2728: --these tables below are introduced to store values when the txn, projfunc and project currency are not equal
2729: -- for any budget line.
2730:
2731: l_projfunc_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2732: l_prjfnc_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2733: l_projfunc_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2734: l_proj_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2735: l_proj_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2728: --these tables below are introduced to store values when the txn, projfunc and project currency are not equal
2729: -- for any budget line.
2730:
2731: l_projfunc_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2732: l_prjfnc_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2733: l_projfunc_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2734: l_proj_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2735: l_proj_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2736: l_proj_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2729: -- for any budget line.
2730:
2731: l_projfunc_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2732: l_prjfnc_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2733: l_projfunc_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2734: l_proj_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2735: l_proj_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2736: l_proj_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2737: l_pfc_tmp_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(); --store the projfunc currency code.
2730:
2731: l_projfunc_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2732: l_prjfnc_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2733: l_projfunc_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2734: l_proj_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2735: l_proj_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2736: l_proj_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2737: l_pfc_tmp_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(); --store the projfunc currency code.
2738: l_pc_tmp_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(); -- store the proj currency code.
2731: l_projfunc_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2732: l_prjfnc_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2733: l_projfunc_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2734: l_proj_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2735: l_proj_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2736: l_proj_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2737: l_pfc_tmp_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(); --store the projfunc currency code.
2738: l_pc_tmp_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(); -- store the proj currency code.
2739: --Code changes for bug 4200168 ends here.
2732: l_prjfnc_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2733: l_projfunc_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2734: l_proj_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2735: l_proj_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2736: l_proj_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2737: l_pfc_tmp_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(); --store the projfunc currency code.
2738: l_pc_tmp_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(); -- store the proj currency code.
2739: --Code changes for bug 4200168 ends here.
2740:
3267: ---->p_txn...tbls will be rounded based on p_agr_currency_code, p_project_...tbls will be rounded based on
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
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
3277: ,px_project_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
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
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
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
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
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
3281: ,px_projfunc_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
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
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
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
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
3285: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
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
3285: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3286: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
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
3285: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3286: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
3287: IS