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_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 3737: x_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

3733: SELECT fin_plan_type_id
3734: FROM pa_fin_plan_types_vl
3735: WHERE name=p_fin_plan_type_name;
3736:
3737: x_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
3738:
3739: BEGIN
3740:
3741: OPEN l_get_plan_type_id_csr(p_fin_plan_type_name);

Line 3765: ( p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

3761: find the id of the name) tehe Id is passed. Otherwise an error message is thrown
3762: */
3763:
3764: PROCEDURE convert_plan_type_name_to_id
3765: ( p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
3766: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
3767: ,x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
3768: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3769: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

3763:
3764: PROCEDURE convert_plan_type_name_to_id
3765: ( p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
3766: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
3767: ,x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
3768: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3769: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3770: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3771: ) IS

Line 3774: (p_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)

3770: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3771: ) IS
3772:
3773: CURSOR l_fin_plan_type_id_csr
3774: (p_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)
3775: IS
3776: SELECT fin_plan_type_id
3777: FROM pa_fin_plan_types_b
3778: WHERE fin_plan_type_id=p_fin_plan_type_id;

Line 3777: FROM pa_fin_plan_types_b

3773: CURSOR l_fin_plan_type_id_csr
3774: (p_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)
3775: IS
3776: SELECT fin_plan_type_id
3777: FROM pa_fin_plan_types_b
3778: WHERE fin_plan_type_id=p_fin_plan_type_id;
3779:
3780: l_msg_count NUMBER := 0;
3781: l_data VARCHAR2(2000);

Line 4019: ,pa_fin_plan_types_b pft

4015:
4016: SELECT pfo.proj_fp_options_id
4017: INTO l_proj_fp_options_id
4018: FROM pa_proj_fp_options pfo
4019: ,pa_fin_plan_types_b pft
4020: WHERE pfo.project_id = p_project_id
4021: AND pfo.fin_plan_type_id = pft.fin_plan_type_id
4022: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE
4023: AND nvl(pft.use_for_workplan_flag,'N') = 'Y';