APPS.PA_FIN_PLAN_PVT dependencies on PA_FIN_PLAN_TYPES_B

Line 293: l_fin_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

289: l_ar_flag VARCHAR2(1);
290: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
291: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE;
292: l_fin_plan_level_code VARCHAR2(30);
293: l_fin_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
294: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
295: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
296: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
297: l_pm_product_code pa_budget_versions.pm_product_code%TYPE;

Line 461: pa_fin_plan_types_b pavl

457: from pa_project_types_all pt,
458: pa_projects_all pr,
459: pa_budget_versions bv,
460: pa_proj_fp_options opt,
461: pa_fin_plan_types_b pavl
462: where bv.budget_version_id = p_budget_version_id and
463: opt.fin_plan_version_id = bv.budget_version_id and
464: bv.project_id = pr.project_id and
465: pr.project_type = pt.project_type and

Line 1477: pa_fin_plan_types_b pavl

1473: pa_projects_all pr,
1474: pa_budget_versions bv,
1475: -- pa_budget_entry_methods be,
1476: pa_proj_fp_options opt,
1477: pa_fin_plan_types_b pavl
1478: where bv.budget_version_id = p_budget_version_id and
1479: opt.fin_plan_version_id = bv.budget_version_id and
1480: bv.project_id = pr.project_id and
1481: -- be.budget_entry_method_code = bv.budget_entry_method_code and

Line 1801: from pa_fin_plan_types_b pt

1797: select 'Y',
1798: bv.project_id,
1799: bv.fin_plan_type_id,
1800: bv.version_type
1801: from pa_fin_plan_types_b pt
1802: ,pa_budget_versions bv
1803: where pt.fin_plan_type_id = bv.fin_plan_type_id
1804: and bv.budget_version_id = p_target_bv_id
1805: and (pt.approved_cost_plan_type_flag = 'Y'

Line 3776: x_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

3772: SELECT fin_plan_type_id
3773: FROM pa_fin_plan_types_vl
3774: WHERE name=p_fin_plan_type_name;
3775:
3776: x_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
3777:
3778: BEGIN
3779:
3780: OPEN l_get_plan_type_id_csr(p_fin_plan_type_name);

Line 3804: ( p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

3800: find the id of the name) tehe Id is passed. Otherwise an error message is thrown
3801: */
3802:
3803: PROCEDURE convert_plan_type_name_to_id
3804: ( p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
3805: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
3806: ,x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
3807: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3808: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 3806: ,x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895

3802:
3803: PROCEDURE convert_plan_type_name_to_id
3804: ( p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
3805: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
3806: ,x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
3807: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3808: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3809: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3810: ) IS

Line 3813: (p_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)

3809: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3810: ) IS
3811:
3812: CURSOR l_fin_plan_type_id_csr
3813: (p_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)
3814: IS
3815: SELECT fin_plan_type_id
3816: FROM pa_fin_plan_types_b
3817: WHERE fin_plan_type_id=p_fin_plan_type_id;

Line 3816: FROM pa_fin_plan_types_b

3812: CURSOR l_fin_plan_type_id_csr
3813: (p_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)
3814: IS
3815: SELECT fin_plan_type_id
3816: FROM pa_fin_plan_types_b
3817: WHERE fin_plan_type_id=p_fin_plan_type_id;
3818:
3819: l_msg_count NUMBER := 0;
3820: l_data VARCHAR2(2000);

Line 4058: ,pa_fin_plan_types_b pft

4054:
4055: SELECT pfo.proj_fp_options_id
4056: INTO l_proj_fp_options_id
4057: FROM pa_proj_fp_options pfo
4058: ,pa_fin_plan_types_b pft
4059: WHERE pfo.project_id = p_project_id
4060: AND pfo.fin_plan_type_id = pft.fin_plan_type_id
4061: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE
4062: AND nvl(pft.use_for_workplan_flag,'N') = 'Y';