[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
467: fpt.plan_class_code,
468: Decode(bv.version_type, 'COST', fpo.cost_time_phased_code,
469: 'REVENUE', fpo.revenue_time_phased_code, 'ALL', fpo.all_time_phased_code) time_phased_code
470: FROM pa_budget_versions bv,
471: pa_fin_plan_types_b fpt,
472: pa_proj_fp_options fpo
473: WHERE bv.budget_version_id = c_budget_version_id
474: AND bv.budget_version_id = fpo.fin_plan_version_id
475: AND bv.project_id = fpo.project_id
477:
478: l_record_version_number pa_budget_versions.record_version_number%TYPE;
479: l_period_mask_id pa_period_masks_b.period_mask_id%TYPE;
480: l_project_id pa_projects_all.project_id%TYPE;
481: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
482: l_ci_id pa_control_items.ci_id%TYPE;
483: l_version_type pa_budget_versions.version_type%TYPE;
484: l_app_cost_plan_type_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
485: l_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
485: l_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
486: l_prime_cost_fcst_flag pa_budget_versions.primary_cost_forecast_flag%TYPE;
487: l_prime_rev_fcst_flag pa_budget_versions.primary_rev_forecast_flag%TYPE;
488: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
489: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
490: l_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
491: l_pm_rec_version_number pa_period_masks_b.record_version_number%TYPE;
492:
493: is_periodic_layout VARCHAR2(1) := 'N';
6675: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6676: p_budget_lines_tbl IN PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE,
6677: p_ra_id_tbl IN SYSTEM.pa_num_tbl_type,
6678: p_etc_start_date IN pa_budget_versions.etc_start_date%TYPE,
6679: p_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
6680: p_first_pd_bf_pm_en_dt IN DATE,
6681: p_last_pd_af_pm_st_dt IN DATE,
6682: p_prd_mask_st_date_tbl IN SYSTEM.pa_date_tbl_type,
6683: p_prd_mask_end_date_tbl IN SYSTEM.pa_date_tbl_type,
10170: l_etc_method_code_tbl_1 SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
10171:
10172: is_periodic_setup VARCHAR2(1) := 'N';
10173: l_prep_pbl_calling_context VARCHAR2(30);
10174: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
10175:
10176: l_ra_id_tbl SYSTEM.pa_num_tbl_type;
10177: l_task_id_tbl SYSTEM.pa_num_tbl_type;
10178: l_rlm_id_tbl SYSTEM.pa_num_tbl_type;
11309: l_module_name VARCHAR2(100):='PAFPWAPB.process_MSExcel_data';
11310:
11311: --End of variables used for debugging
11312: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
11313: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
11314: l_request_id pa_budget_versions.request_id%TYPE;
11315: l_submit_bdgt_flag VARCHAR2(1);
11316: l_submit_fcst_flag VARCHAR2(1);
11317: l_version_type pa_budget_versions.version_type%TYPE;
11321: -- error messages present in the interface table corresponding to a set of run_id
11322: -- for the upload session.
11323:
11324: CURSOR l_get_error_msg_to_report_csr (c_run_id pa_fp_webadi_upload_inf.run_id%TYPE,
11325: c_plan_class pa_fin_plan_types_b.plan_class_code%TYPE,
11326: c_version_type pa_budget_versions.version_type%TYPE,
11327: c_request_id pa_budget_versions.request_id%TYPE)
11328: IS
11329: -- 4497321.Perf Fix:Modified SELECT query inorder to improve the performance.
11386: pbv.version_type
11387: INTO l_plan_class_code,
11388: l_version_type
11389: FROM pa_budget_versions pbv,
11390: pa_fin_plan_types_b fin
11391: WHERE pbv.budget_version_id = l_budget_version_id
11392: AND fin.fin_plan_type_id = pbv.fin_plan_type_id;
11393:
11394: --log1('----- STAGE CR3-------');
11928: --This Cursor is used to get the Amount Type and Conversion Attribute information of the budget version.
11929: CURSOR amt_type_cur(c_project_id pa_fp_proj_xl_amt_types.project_id%TYPE,
11930: c_fin_plan_type_id pa_fp_proj_xl_amt_types.fin_plan_type_id%TYPE,
11931: c_option_type pa_fp_proj_xl_amt_types.option_type%TYPE,
11932: c_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE)
11933: IS
11934: SELECT amt.amount_type_code,
11935: amt_lu.meaning amount_type_name,
11936: 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,
12051: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
12052: l_org_id pa_projects_all.org_id%TYPE;
12053: l_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE;
12054: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
12055: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
12056: l_project_name pa_projects_all.name%TYPE;
12057: l_project_number pa_projects_all.segment1%TYPE;
12058: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
12059: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;