APPS.PA_FP_CONTROL_ITEMS_IMPACT_PKG dependencies on PA_PROJECTS_ALL

Line 5: p_project_id IN Pa_Projects_All.Project_Id%TYPE,

1: PACKAGE BODY Pa_Fp_Control_Items_Impact_Pkg AS
2: /* $Header: PAFPCIIB.pls 120.4.12010000.3 2008/11/18 15:41:06 bnoorbha ship $ */
3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4: PROCEDURE Maintain_Ctrl_Item_Version(
5: p_project_id IN Pa_Projects_All.Project_Id%TYPE,
6: p_ci_id IN NUMBER,
7: p_fp_pref_code IN VARCHAR2,
8: p_fin_plan_type_id_cost IN NUMBER,
9: p_fin_plan_type_id_rev IN NUMBER,

Line 34: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;

30: l_bv_id_all NUMBER;
31: l_element_type pa_budget_versions.version_type%TYPE;
32: l_plan_version_id NUMBER;
33: l_proj_fp_option_id NUMBER;
34: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
35: l_projfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;
36: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
37: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
38: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;

Line 35: l_projfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;

31: l_element_type pa_budget_versions.version_type%TYPE;
32: l_plan_version_id NUMBER;
33: l_proj_fp_option_id NUMBER;
34: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
35: l_projfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;
36: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
37: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
38: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
39: l_no_of_app_plan_types NUMBER;

Line 46: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;

42: l_data VARCHAR2(1000);
43: l_msg_index_out NUMBER:=0;
44: l_msg_count NUMBER;
45: l_ci_impact_id NUMBER;
46: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
47: l_agreement_id PA_AGREEMENTS_ALL.Agreement_Id%TYPE;
48: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE;
49: l_est_proj_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
50: l_est_proj_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;

Line 182: FROM Pa_Projects_All

178: NVL(Baseline_Funding_Flag,'N') INTO
179: l_proj_curr_code,
180: l_projfunc_curr_code,
181: l_baseline_Funding_flag
182: FROM Pa_Projects_All
183: WHERE
184: Project_Id = p_project_id;
185:
186: /* Bug 3799500: rounding the quantities, if they are not null

Line 594: p_project_id IN Pa_Projects_All.Project_Id%TYPE,

590: p_data => x_msg_data);
591: END Maintain_Ctrl_Item_Version;
592:
593: PROCEDURE Maintain_Plan_Version(
594: p_project_id IN Pa_Projects_All.Project_Id%TYPE,
595: p_ci_id IN NUMBER,
596: p_fp_pref_code IN VARCHAR2,
597: p_fin_plan_type_id IN NUMBER,
598: p_est_proj_raw_cost IN NUMBER,