DBA Data[Home] [Help]

APPS.PA_FP_ELEMENTS_PUB dependencies on PA_PROJECTS

Line 232: l_to_project_id pa_projects.project_id%TYPE;

228: l_from_proj_fp_option_id pa_proj_fp_options.PROJ_FP_OPTIONS_ID%TYPE;
229: l_from_element_type pa_fp_elements.ELEMENT_TYPE%TYPE;
230: l_to_fin_plan_type_id pa_proj_fp_options.FIN_PLAN_TYPE_ID%TYPE;
231: l_to_fin_plan_version_id pa_proj_fp_options.FIN_PLAN_VERSION_ID%TYPE;
232: l_to_project_id pa_projects.project_id%TYPE;
233: l_from_project_id pa_projects.project_id%TYPE;
234: l_element_level VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK;
235:
236: l_source_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE; /* M20-AUG */

Line 233: l_from_project_id pa_projects.project_id%TYPE;

229: l_from_element_type pa_fp_elements.ELEMENT_TYPE%TYPE;
230: l_to_fin_plan_type_id pa_proj_fp_options.FIN_PLAN_TYPE_ID%TYPE;
231: l_to_fin_plan_version_id pa_proj_fp_options.FIN_PLAN_VERSION_ID%TYPE;
232: l_to_project_id pa_projects.project_id%TYPE;
233: l_from_project_id pa_projects.project_id%TYPE;
234: l_element_level VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK;
235:
236: l_source_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE; /* M20-AUG */
237: l_target_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE; /* M20-AUG */

Line 3792: l_project_id pa_projects_all.project_id%TYPE;

3788: --l_projfunc_revenue_tbl pa_fp_rollup_pkg.l_projfunc_revenue_tbl_typ;
3789: --l_quantity_tbl pa_fp_rollup_pkg.l_quantity_tbl_typ;
3790: /* Bug 2677597 - declaration change end */
3791:
3792: l_project_id pa_projects_all.project_id%TYPE;
3793: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3794: l_element_type pa_fp_elements.element_type%TYPE;
3795: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
3796: l_mixed_resource_planned_flag VARCHAR2(1); -- Added for Bug:- 2625872

Line 6030: ( p_project_id IN pa_projects_all.project_id%TYPE

6026: /* Bug 2976168. Changed the signature of the api. This api will now be called from
6027: pa_fin_plan_maint_ver_global.resubmit_concurrent_request */
6028:
6029: PROCEDURE make_new_tasks_plannable
6030: ( p_project_id IN pa_projects_all.project_id%TYPE
6031: ,p_tasks_tbl IN pa_fp_elements_pub.l_wbs_refresh_tasks_tbl_typ
6032: ,p_refresh_fp_options_tbl IN PA_PLSQL_DATATYPES.IdTabTyp
6033: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6034: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 6378: (p_project_id IN pa_projects_all.project_id%TYPE

6374:
6375: */
6376:
6377: PROCEDURE maintain_plannable_tasks
6378: (p_project_id IN pa_projects_all.project_id%TYPE
6379: ,p_impacted_tasks_tbl IN l_impacted_task_in_tbl_typ
6380: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6381: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
6382: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895