[Home] [Help]
5087: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
5088: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5089:
5090: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
5091: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
5092:
5093: --Following parameters are needed for amounts check
5094: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;
5095: lx_raw_cost_flag VARCHAR2(1) := NULL;
9403: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
9404: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
9405: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
9406:
9407: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
9408: /*Added local variables for bug 6408139*/
9409: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
9410: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
9411: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
13051: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
13052: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13053:
13054: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
13055: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
13056:
13057: --Following parameters are needed for amounts check
13058: l_amount_set_id NUMBER;
13059: lx_raw_cost_flag VARCHAR2(1) := NULL;
14347: l_bdgt_lines_skip_flag varchar2(1);
14348: l_targ_request_id pa_budget_versions.request_id%TYPE;
14349:
14350: --This variable will be used to call pa_resource_asgn_curr maintenance api - IPM Arch Enhancement
14351: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
14352:
14353: -- Bug 4588279, 27-SEP-05, jwhite ------------------
14354:
14355: -- Funds Check API Call
16383: END IF;
16384:
16385: --IPM Architecture Enhancement - Start
16386:
16387: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
16388: (P_BUDGET_VERSION_ID => l_budget_version_id,
16389: X_FP_COLS_REC => l_fp_cols_rec,
16390: X_RETURN_STATUS => p_return_status,
16391: X_MSG_COUNT => p_msg_count,
16392: X_MSG_DATA => p_msg_data);
16393:
16394: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
16395: IF l_debug_mode = 'Y' THEN
16396: pa_debug.g_err_stage:= 'Error in PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DETAILS';
16397: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level5);
16398: END IF;
16399: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
16400: END IF;
17327:
17328: --Added for bug 4224464
17329: l_budget_amount_code pa_budget_types.budget_amount_code%type;
17330:
17331: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
17332:
17333: --Bug 5475184. In the below set, pt stands for "plan type".
17334: l_pt_amount_set_id pa_proj_fp_options.cost_amount_set_id%TYPE;
17335: l_pt_raw_cost_flag VARCHAR2(1);
19122: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type;
19123: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
19124: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type;
19125:
19126: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
19127:
19128: l_budget_lines_in_tbl PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE;
19129: l_budget_lines_out_tbl PA_BUDGET_PUB.G_BUDGET_LINES_OUT_TBL%TYPE;
19130: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type;