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: CURSOR est_amt_csr

Line 66: FROM pa_budget_versions

62: est_equipment_quantity,
63: est_project_revenue,
64: version_type,
65: agreement_id
66: FROM pa_budget_versions
67: WHERE project_id=p_project_id
68: AND ci_id=p_ci_id;
69: est_amt_rec est_amt_csr%ROWTYPE;
70: est_amt_rec_tmp est_amt_csr%ROWTYPE;

Line 73: l_cost_ci_plan_version_id pa_budget_versions.budget_version_id%TYPE;

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

Line 74: l_rev_ci_plan_version_id pa_budget_versions.budget_version_id%TYPE;

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

Line 615: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;

611: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
612: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
613: x_plan_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
614: ) IS
615: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
616: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
617: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
618: l_bv_id NUMBER;
619: l_plan_version_id NUMBER;

Line 616: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;

612: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
613: x_plan_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
614: ) IS
615: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
616: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
617: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
618: l_bv_id NUMBER;
619: l_plan_version_id NUMBER;
620: l_proj_fp_option_id NUMBER;

Line 617: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;

613: x_plan_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
614: ) IS
615: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
616: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
617: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
618: l_bv_id NUMBER;
619: l_plan_version_id NUMBER;
620: l_proj_fp_option_id NUMBER;
621: l_agreement_id PA_AGREEMENTS_ALL.Agreement_Id%TYPE;

Line 660: SELECT Budget_Version_Id INTO l_bv_id FROM Pa_Budget_Versions bv

656: ELSE
657: l_agreement_id := NULL;
658: END IF;
659: BEGIN
660: SELECT Budget_Version_Id INTO l_bv_id FROM Pa_Budget_Versions bv
661: WHERE
662: bv.Project_Id = p_project_id AND
663: NVL(bv.Fin_Plan_Type_id,-1) = p_fin_plan_type_id AND
664: NVL(bv.ci_id,-1) = p_ci_id AND

Line 825: UPDATE Pa_Budget_Versions SET

821: WHERE RESOURCE_ASSIGNMENT_ID = -1;
822:
823: END IF;
824: /* for proj curr code equal to projfunc curr code chk */
825: UPDATE Pa_Budget_Versions SET
826: est_project_raw_cost = p_est_proj_raw_cost,
827: est_project_burdened_cost = p_est_proj_bd_cost,
828: est_project_revenue = p_est_proj_revenue,
829: est_quantity = p_est_qty,

Line 898: FROM pa_budget_versions

894: record_version_number
895: BULK COLLECT INTO
896: l_bv_id_tab,
897: l_rv_number_tab
898: FROM pa_budget_versions
899: WHERE
900: project_id = p_project_id AND
901: ci_id = p_ci_id;
902: EXCEPTION