[Home] [Help]
2089: l_budget_ver_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2090:
2091: -- End Bug 3673111 --------------------------------------------------------------
2092: -- Added for Bug# 7187487
2093: l_budget_status_code_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2094:
2095:
2096: --Bug 4300363
2097: l_upg_bl_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2103: l_upg_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2104: l_upg_txn_burdened_cost_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2105: l_upg_txn_revenue_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2106: l_upg_txn_revenue_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type(); --Bug 5676682
2107: l_upg_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2108: l_upg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2109: l_upg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2110: l_upg_bill_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2111: l_upg_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
3774: --2.0(Zero)s are passed as input for amounts instead of NULL.
3775: PROCEDURE Apply_Calculate_FPM_Rules
3776: ( p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
3777: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
3778: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
3779: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
3780: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
3781: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
3782: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type