[Home] [Help]
2815: l_msg_code VARCHAR2(2000);
2816:
2817: -- End of variables used for debugging purpose
2818:
2819: l_Projfunc_Currency_Code pa_projects_all.projfunc_currency_code%TYPE := NULL;
2820: l_Project_Currency_Code pa_projects_all.project_currency_code%TYPE := NULL;
2821: l_Txn_Currency_Code pa_projects_all.projfunc_currency_code%TYPE := NULL;
2822: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
2823: l_cost_impl_flag VARCHAR2(1);
2816:
2817: -- End of variables used for debugging purpose
2818:
2819: l_Projfunc_Currency_Code pa_projects_all.projfunc_currency_code%TYPE := NULL;
2820: l_Project_Currency_Code pa_projects_all.project_currency_code%TYPE := NULL;
2821: l_Txn_Currency_Code pa_projects_all.projfunc_currency_code%TYPE := NULL;
2822: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
2823: l_cost_impl_flag VARCHAR2(1);
2824: l_rev_impl_flag VARCHAR2(1);
2817: -- End of variables used for debugging purpose
2818:
2819: l_Projfunc_Currency_Code pa_projects_all.projfunc_currency_code%TYPE := NULL;
2820: l_Project_Currency_Code pa_projects_all.project_currency_code%TYPE := NULL;
2821: l_Txn_Currency_Code pa_projects_all.projfunc_currency_code%TYPE := NULL;
2822: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
2823: l_cost_impl_flag VARCHAR2(1);
2824: l_rev_impl_flag VARCHAR2(1);
2825: l_cost_impact_impl_flag VARCHAR2(1);
2818:
2819: l_Projfunc_Currency_Code pa_projects_all.projfunc_currency_code%TYPE := NULL;
2820: l_Project_Currency_Code pa_projects_all.project_currency_code%TYPE := NULL;
2821: l_Txn_Currency_Code pa_projects_all.projfunc_currency_code%TYPE := NULL;
2822: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
2823: l_cost_impl_flag VARCHAR2(1);
2824: l_rev_impl_flag VARCHAR2(1);
2825: l_cost_impact_impl_flag VARCHAR2(1);
2826: l_rev_impact_impl_flag VARCHAR2(1);
3440: pa_debug.g_err_stage:= 'Fetching l_project_structure_version_id :'||l_project_structure_version_id;
3441: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3442: END IF;
3443:
3444: -- Select the details required from pa_projects_all so that they can be used in the later part of the code
3445: SELECT project_currency_code
3446: ,projfunc_currency_code
3447: ,nvl(baseline_funding_flag,'N')
3448: INTO l_project_currency_code
3447: ,nvl(baseline_funding_flag,'N')
3448: INTO l_project_currency_code
3449: ,l_projfunc_currency_code
3450: ,l_baseline_funding_flag
3451: FROM pa_projects_all
3452: WHERE project_id=l_project_id;
3453:
3454: IF P_PA_debug_mode = 'Y' THEN
3455: pa_debug.g_err_stage:= 'Fetching l_project_currency_code :'||l_project_currency_code;
10408: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
10409: l_ci_cost_version_id pa_budget_versions.budget_version_id%TYPE;
10410: l_ci_rev_version_id pa_budget_versions.budget_version_id%TYPE;
10411: l_ci_all_version_id pa_budget_versions.budget_version_id%TYPE;
10412: l_project_id pa_projects_all.project_id%TYPE;
10413: l_source_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
10414: l_calling_mode_for_chk_api VARCHAR2(30);
10415: l_merge_possible_code_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
10416: l_copy_ci_ver_flag VARCHAR2(1);
11762: l_impl_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11763: l_impl_equipment_quant_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11764: l_impl_agr_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11765:
11766: l_project_id pa_projects_all.project_id%TYPE;
11767:
11768: --Variable used for passing ci id to the change management baseline API.
11769: l_CI_ID_Tab PA_PLSQL_DATATYPES.IdTabTyp;
11770: X_Err_Code NUMBER;
11798: l_impl_pfc_rev_amt NUMBER;
11799: l_implemented_amt NUMBER := 0;
11800: l_implemented_pc_amt NUMBER;
11801: l_implemented_pfc_amt NUMBER;
11802: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
11803: l_projfunc_currency_code pa_projects_all.project_currency_code%TYPE;
11804: l_ci_already_impl_flag VARCHAR2(1) := 'N';
11805:
11806: l_final_rev_par_impl_flag pa_budget_versions.rev_partially_impl_flag%TYPE;
11799: l_implemented_amt NUMBER := 0;
11800: l_implemented_pc_amt NUMBER;
11801: l_implemented_pfc_amt NUMBER;
11802: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
11803: l_projfunc_currency_code pa_projects_all.project_currency_code%TYPE;
11804: l_ci_already_impl_flag VARCHAR2(1) := 'N';
11805:
11806: l_final_rev_par_impl_flag pa_budget_versions.rev_partially_impl_flag%TYPE;
11807: --Bug 4136238
11939: l_project_id,
11940: l_project_currency_code,
11941: l_projfunc_currency_code
11942: FROM pa_budget_versions pbv,
11943: pa_projects_all p
11944: WHERE pbv.project_id = p.project_id
11945: AND pbv.budget_version_id = p_budget_version_id;
11946:
11947: IF l_debug_mode = 'Y' THEN
12862: Nvl(pj.baseline_funding_flag, 'N')
12863: INTO l_targ_app_cost_flag,
12864: l_targ_app_rev_flag,
12865: l_baseline_funding_flag
12866: FROM pa_projects_all pj,
12867: pa_budget_versions bv
12868: WHERE bv.budget_version_id = l_budget_version_id_tbl(j)
12869: AND bv.project_id = pj.project_id;
12870: EXCEPTION