eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_CONTROL_ITEMS_IMPACT_PKG dependencies on PA_BUDGET_VERSIONS

Line 31: l_element_type pa_budget_versions.version_type%TYPE;

27: l_bv_id VARCHAR2(50);
28: l_bv_id_cost NUMBER;
29: l_bv_id_rev NUMBER;
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;

Line 36: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%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;
40: l_message_name fnd_new_messages.message_name%TYPE;

Line 37: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;

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;
40: l_message_name fnd_new_messages.message_name%TYPE;
41: l_msg_data VARCHAR2(1000);

Line 38: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;

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;
40: l_message_name fnd_new_messages.message_name%TYPE;
41: l_msg_data VARCHAR2(1000);
42: l_data VARCHAR2(1000);

Line 49: l_est_proj_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;

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;
51: l_est_qty pa_budget_versions.est_quantity%TYPE;
52: l_est_equip_qty pa_budget_versions.est_equipment_quantity%TYPE;
53: l_est_proj_revenue pa_budget_versions.est_project_revenue%TYPE;

Line 50: l_est_proj_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;

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;
51: l_est_qty pa_budget_versions.est_quantity%TYPE;
52: l_est_equip_qty pa_budget_versions.est_equipment_quantity%TYPE;
53: l_est_proj_revenue pa_budget_versions.est_project_revenue%TYPE;
54:

Line 51: l_est_qty pa_budget_versions.est_quantity%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;
51: l_est_qty pa_budget_versions.est_quantity%TYPE;
52: l_est_equip_qty pa_budget_versions.est_equipment_quantity%TYPE;
53: l_est_proj_revenue pa_budget_versions.est_project_revenue%TYPE;
54:
55: l_approved_cost_plan_type_flag Pa_Proj_Fp_Options.APPROVED_COST_PLAN_TYPE_FLAG%TYPE; -- Added for bug 4907408

Line 52: l_est_equip_qty pa_budget_versions.est_equipment_quantity%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;
51: l_est_qty pa_budget_versions.est_quantity%TYPE;
52: l_est_equip_qty pa_budget_versions.est_equipment_quantity%TYPE;
53: l_est_proj_revenue pa_budget_versions.est_project_revenue%TYPE;
54:
55: l_approved_cost_plan_type_flag Pa_Proj_Fp_Options.APPROVED_COST_PLAN_TYPE_FLAG%TYPE; -- Added for bug 4907408
56:

Line 53: l_est_proj_revenue pa_budget_versions.est_project_revenue%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;
51: l_est_qty pa_budget_versions.est_quantity%TYPE;
52: l_est_equip_qty pa_budget_versions.est_equipment_quantity%TYPE;
53: l_est_proj_revenue pa_budget_versions.est_project_revenue%TYPE;
54:
55: l_approved_cost_plan_type_flag Pa_Proj_Fp_Options.APPROVED_COST_PLAN_TYPE_FLAG%TYPE; -- Added for bug 4907408
56:
57: -- Bug 5845142. Selected app cost/rev flags too.

Line 69: FROM pa_budget_versions

65: version_type,
66: agreement_id,
67: approved_cost_plan_type_flag,
68: approved_rev_plan_type_flag
69: FROM pa_budget_versions
70: WHERE project_id=p_project_id
71: AND ci_id=p_ci_id;
72: est_amt_rec est_amt_csr%ROWTYPE;
73: est_amt_rec_tmp est_amt_csr%ROWTYPE;

Line 76: l_cost_ci_plan_version_id pa_budget_versions.budget_version_id%TYPE;

72: est_amt_rec est_amt_csr%ROWTYPE;
73: est_amt_rec_tmp est_amt_csr%ROWTYPE;
74:
75: --Bug 7497389
76: l_cost_ci_plan_version_id pa_budget_versions.budget_version_id%TYPE;
77: l_rev_ci_plan_version_id pa_budget_versions.budget_version_id%TYPE;
78: BEGIN
79: FND_MSG_PUB.initialize;
80: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 77: l_rev_ci_plan_version_id pa_budget_versions.budget_version_id%TYPE;

73: est_amt_rec_tmp est_amt_csr%ROWTYPE;
74:
75: --Bug 7497389
76: l_cost_ci_plan_version_id pa_budget_versions.budget_version_id%TYPE;
77: l_rev_ci_plan_version_id pa_budget_versions.budget_version_id%TYPE;
78: BEGIN
79: FND_MSG_PUB.initialize;
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81: l_agreement_id := p_agreement_id;

Line 640: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;

636: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
637: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
638: x_plan_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
639: ) IS
640: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
641: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
642: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
643: l_bv_id NUMBER;
644: l_plan_version_id NUMBER;

Line 641: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;

637: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
638: x_plan_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
639: ) IS
640: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
641: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
642: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
643: l_bv_id NUMBER;
644: l_plan_version_id NUMBER;
645: l_proj_fp_option_id NUMBER;

Line 642: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;

638: x_plan_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
639: ) IS
640: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
641: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
642: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
643: l_bv_id NUMBER;
644: l_plan_version_id NUMBER;
645: l_proj_fp_option_id NUMBER;
646: l_agreement_id PA_AGREEMENTS_ALL.Agreement_Id%TYPE;

Line 707: SELECT Budget_Version_Id INTO l_bv_id FROM Pa_Budget_Versions bv

703: ELSE
704: l_agreement_id := NULL;
705: END IF;
706: BEGIN
707: SELECT Budget_Version_Id INTO l_bv_id FROM Pa_Budget_Versions bv
708: WHERE
709: bv.Project_Id = p_project_id AND
710: NVL(bv.Fin_Plan_Type_id,-1) = p_fin_plan_type_id AND
711: NVL(bv.ci_id,-1) = p_ci_id AND

Line 875: UPDATE Pa_Budget_Versions SET

871: WHERE RESOURCE_ASSIGNMENT_ID = -1;
872:
873: END IF;
874: /* for proj curr code equal to projfunc curr code chk */
875: UPDATE Pa_Budget_Versions SET
876: est_project_raw_cost = p_est_proj_raw_cost,
877: est_project_burdened_cost = p_est_proj_bd_cost,
878: est_project_revenue = p_est_proj_revenue,
879: est_quantity = p_est_qty,

Line 948: FROM pa_budget_versions

944: record_version_number
945: BULK COLLECT INTO
946: l_bv_id_tab,
947: l_rv_number_tab
948: FROM pa_budget_versions
949: WHERE
950: project_id = p_project_id AND
951: ci_id = p_ci_id;
952: EXCEPTION