DBA Data[Home] [Help]

APPS.PA_FP_MULTI_CURRENCY_PKG dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 2736: l_txn_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

2732: --l_txn_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
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:

Line 2750: l_projfunc_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

2746: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2747: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2748: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;*/
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();

Line 2751: l_proj_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

2747: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2748: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;*/
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();

Line 2770: l_pfc_tmp_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(); --store the projfunc currency code.

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:
2774: --Bug 4052403

Line 2771: l_pc_tmp_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(); -- store the proj currency code.

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:
2774: --Bug 4052403
2775: l_rate_based_flag_tab pa_plsql_datatypes.Char1TabTyp;

Line 3333: l_agr_currency_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

3329: l_debug_level5 CONSTANT NUMBER :=5;
3330: l_module_name VARCHAR2(200) := 'PAFPMCPB.round_amounts';
3331:
3332: --Code changes for bug 4200168 starts here.
3333: l_agr_currency_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
3334: l_project_currency_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
3335: l_projfunc_currency_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
3336: --Code changes for bug 4200168 ends here.
3337:

Line 3334: l_project_currency_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

3330: l_module_name VARCHAR2(200) := 'PAFPMCPB.round_amounts';
3331:
3332: --Code changes for bug 4200168 starts here.
3333: l_agr_currency_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
3334: l_project_currency_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
3335: l_projfunc_currency_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
3336: --Code changes for bug 4200168 ends here.
3337:
3338: BEGIN

Line 3335: l_projfunc_currency_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

3331:
3332: --Code changes for bug 4200168 starts here.
3333: l_agr_currency_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
3334: l_project_currency_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
3335: l_projfunc_currency_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
3336: --Code changes for bug 4200168 ends here.
3337:
3338: BEGIN
3339: x_msg_count := 0;