[Home] [Help]
48: c_allow_raw_cost_rate_flag VARCHAR2,
49: c_allow_burd_cost_rate_flag VARCHAR2,
50: c_allow_bill_rate_flag VARCHAR2,
51: c_project_id pa_projects_all.project_id%TYPE,
52: c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE,
53: c_version_type pa_budget_versions.version_type%TYPE,
54: c_request_id pa_budget_versions.request_id%TYPE
55: )
56: IS
468: fpt.plan_class_code,
469: Decode(bv.version_type, 'COST', fpo.cost_time_phased_code,
470: 'REVENUE', fpo.revenue_time_phased_code, 'ALL', fpo.all_time_phased_code) time_phased_code
471: FROM pa_budget_versions bv,
472: pa_fin_plan_types_b fpt,
473: pa_proj_fp_options fpo
474: WHERE bv.budget_version_id = c_budget_version_id
475: AND bv.budget_version_id = fpo.fin_plan_version_id
476: AND bv.project_id = fpo.project_id
478:
479: l_record_version_number pa_budget_versions.record_version_number%TYPE;
480: l_period_mask_id pa_period_masks_b.period_mask_id%TYPE;
481: l_project_id pa_projects_all.project_id%TYPE;
482: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
483: l_ci_id pa_control_items.ci_id%TYPE;
484: l_version_type pa_budget_versions.version_type%TYPE;
485: l_app_cost_plan_type_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
486: l_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
486: l_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
487: l_prime_cost_fcst_flag pa_budget_versions.primary_cost_forecast_flag%TYPE;
488: l_prime_rev_fcst_flag pa_budget_versions.primary_rev_forecast_flag%TYPE;
489: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
490: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
491: l_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
492: l_pm_rec_version_number pa_period_masks_b.record_version_number%TYPE;
493:
494: is_periodic_layout VARCHAR2(1) := 'N';
6782: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6783: p_budget_lines_tbl IN PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE,
6784: p_ra_id_tbl IN SYSTEM.pa_num_tbl_type,
6785: p_etc_start_date IN pa_budget_versions.etc_start_date%TYPE,
6786: p_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
6787: p_first_pd_bf_pm_en_dt IN DATE,
6788: p_last_pd_af_pm_st_dt IN DATE,
6789: p_prd_mask_st_date_tbl IN SYSTEM.pa_date_tbl_type,
6790: p_prd_mask_end_date_tbl IN SYSTEM.pa_date_tbl_type,
10349: l_etc_method_code_tbl_1 SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
10350:
10351: is_periodic_setup VARCHAR2(1) := 'N';
10352: l_prep_pbl_calling_context VARCHAR2(30);
10353: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
10354:
10355: l_ra_id_tbl SYSTEM.pa_num_tbl_type;
10356: l_task_id_tbl SYSTEM.pa_num_tbl_type;
10357: l_rlm_id_tbl SYSTEM.pa_num_tbl_type;
11539: l_module_name VARCHAR2(100):='PAFPWAPB.process_MSExcel_data';
11540:
11541: --End of variables used for debugging
11542: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
11543: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
11544: l_request_id pa_budget_versions.request_id%TYPE;
11545: l_submit_bdgt_flag VARCHAR2(1);
11546: l_submit_fcst_flag VARCHAR2(1);
11547: l_version_type pa_budget_versions.version_type%TYPE;
11551: -- error messages present in the interface table corresponding to a set of run_id
11552: -- for the upload session.
11553:
11554: CURSOR l_get_error_msg_to_report_csr (c_run_id pa_fp_webadi_upload_inf.run_id%TYPE,
11555: c_plan_class pa_fin_plan_types_b.plan_class_code%TYPE,
11556: c_version_type pa_budget_versions.version_type%TYPE,
11557: c_request_id pa_budget_versions.request_id%TYPE)
11558: IS
11559: -- 4497321.Perf Fix:Modified SELECT query inorder to improve the performance.
11616: pbv.version_type
11617: INTO l_plan_class_code,
11618: l_version_type
11619: FROM pa_budget_versions pbv,
11620: pa_fin_plan_types_b fin
11621: WHERE pbv.budget_version_id = l_budget_version_id
11622: AND fin.fin_plan_type_id = pbv.fin_plan_type_id;
11623:
11624: --log1('----- STAGE CR3-------');
12161: --This Cursor is used to get the Amount Type and Conversion Attribute information of the budget version.
12162: CURSOR amt_type_cur(c_project_id pa_fp_proj_xl_amt_types.project_id%TYPE,
12163: c_fin_plan_type_id pa_fp_proj_xl_amt_types.fin_plan_type_id%TYPE,
12164: c_option_type pa_fp_proj_xl_amt_types.option_type%TYPE,
12165: c_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE)
12166: IS
12167: SELECT amt.amount_type_code,
12168: amt_lu.meaning amount_type_name,
12169: decode(decode(amt.amount_type_code,'TOTAL_REV',l_proj_fp_options_rec.projfunc_rev_rate_type,l_proj_fp_options_rec.projfunc_cost_rate_type),null,null,
12284: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
12285: l_org_id pa_projects_all.org_id%TYPE;
12286: l_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE;
12287: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
12288: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
12289: l_project_name pa_projects_all.name%TYPE;
12290: l_project_number pa_projects_all.segment1%TYPE;
12291: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
12292: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;