DBA Data[Home] [Help]

APPS.PA_FP_MULTI_CURRENCY_PKG dependencies on PA_NUM_TBL_TYPE

Line 2737: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2733: -- l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2734: --l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2735: --l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2736: l_txn_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2737: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2738: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2739: l_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2740:
2741: /*l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;

Line 2738: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2734: --l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2735: --l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2736: l_txn_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2737: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2738: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2739: l_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2740:
2741: /*l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2742: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 2739: l_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2735: --l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2736: l_txn_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2737: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2738: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2739: l_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2740:
2741: /*l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2742: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2743: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 2753: l_projfunc_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2749:
2750: l_projfunc_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2751: l_proj_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2752:
2753: l_projfunc_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2754: l_projfunc_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2755: l_projfunc_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2756:
2757: l_proj_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 2754: l_projfunc_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2750: l_projfunc_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2751: l_proj_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2752:
2753: l_projfunc_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2754: l_projfunc_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2755: l_projfunc_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2756:
2757: l_proj_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2758: l_proj_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 2755: l_projfunc_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2751: l_proj_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2752:
2753: l_projfunc_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2754: l_projfunc_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2755: l_projfunc_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2756:
2757: l_proj_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2758: l_proj_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2759: l_proj_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 2757: l_proj_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2753: l_projfunc_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2754: l_projfunc_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2755: l_projfunc_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2756:
2757: l_proj_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2758: l_proj_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2759: l_proj_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2760:
2761: --these tables below are introduced to store values when the txn, projfunc and project currency are not equal

Line 2758: l_proj_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2754: l_projfunc_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2755: l_projfunc_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2756:
2757: l_proj_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2758: l_proj_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2759: l_proj_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2760:
2761: --these tables below are introduced to store values when the txn, projfunc and project currency are not equal
2762: -- for any budget line.

Line 2759: l_proj_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2755: l_projfunc_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2756:
2757: l_proj_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2758: l_proj_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2759: l_proj_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2760:
2761: --these tables below are introduced to store values when the txn, projfunc and project currency are not equal
2762: -- for any budget line.
2763:

Line 2764: l_projfunc_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2760:
2761: --these tables below are introduced to store values when the txn, projfunc and project currency are not equal
2762: -- for any budget line.
2763:
2764: l_projfunc_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2765: l_prjfnc_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2766: l_projfunc_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2767: l_proj_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2768: l_proj_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 2765: l_prjfnc_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2761: --these tables below are introduced to store values when the txn, projfunc and project currency are not equal
2762: -- for any budget line.
2763:
2764: l_projfunc_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2765: l_prjfnc_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2766: l_projfunc_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2767: l_proj_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2768: l_proj_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2769: l_proj_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 2766: l_projfunc_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2762: -- for any budget line.
2763:
2764: l_projfunc_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2765: l_prjfnc_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2766: l_projfunc_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2767: l_proj_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2768: l_proj_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2769: l_proj_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2770: l_pfc_tmp_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(); --store the projfunc currency code.

Line 2767: l_proj_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2763:
2764: l_projfunc_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2765: l_prjfnc_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2766: l_projfunc_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2767: l_proj_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2768: l_proj_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2769: l_proj_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2770: l_pfc_tmp_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(); --store the projfunc currency code.
2771: l_pc_tmp_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(); -- store the proj currency code.

Line 2768: l_proj_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2764: l_projfunc_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2765: l_prjfnc_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2766: l_projfunc_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2767: l_proj_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2768: l_proj_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2769: l_proj_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2770: l_pfc_tmp_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(); --store the projfunc currency code.
2771: l_pc_tmp_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(); -- store the proj currency code.
2772: --Code changes for bug 4200168 ends here.

Line 2769: l_proj_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2765: l_prjfnc_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2766: l_projfunc_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2767: l_proj_raw_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2768: l_proj_burdened_cost_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2769: l_proj_revenue_tmp_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2770: l_pfc_tmp_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(); --store the projfunc currency code.
2771: l_pc_tmp_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(); -- store the proj currency code.
2772: --Code changes for bug 4200168 ends here.
2773:

Line 3304: ( px_quantity_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type

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

Line 3306: ,px_txn_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type

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

Line 3307: ,px_txn_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type

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

Line 3308: ,px_txn_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type

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

Line 3310: ,px_project_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type

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

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

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

Line 3314: ,px_projfunc_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type

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

Line 3315: ,px_projfunc_burdened_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
3318: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3319: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 3316: ,px_projfunc_revenue_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
3318: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3319: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
3320: IS