DBA Data[Home] [Help]

APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_PROJECTS_ALL

Line 39: ,p_project_id IN Pa_projects_all.project_id%TYPE

35: ,p_extraction_type IN VARCHAR2 DEFAULT NULL -- Added for Bug 13419867
36: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
37: ,p_one_to_one_mapping_flag IN VARCHAR2 DEFAULT 'N'
38: ,p_calling_module IN VARCHAR2 DEFAULT NULL
39: ,p_project_id IN Pa_projects_all.project_id%TYPE
40: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE DEFAULT NULL
41: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
42: ,p_task_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
43: ,p_cbs_element_id_tbl IN SYSTEM.pa_num_tbl_type

Line 257: ,p_src_project_id IN pa_projects_all.project_id%TYPE

253: PROCEDURE copy_planning_transactions
254: (
255: p_context IN VARCHAR2
256: ,p_copy_external_flag IN VARCHAR2
257: ,p_src_project_id IN pa_projects_all.project_id%TYPE
258: ,p_target_project_id IN pa_projects_all.project_id%TYPE
259: ,p_src_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
260: ,p_targ_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
261: ,p_src_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 258: ,p_target_project_id IN pa_projects_all.project_id%TYPE

254: (
255: p_context IN VARCHAR2
256: ,p_copy_external_flag IN VARCHAR2
257: ,p_src_project_id IN pa_projects_all.project_id%TYPE
258: ,p_target_project_id IN pa_projects_all.project_id%TYPE
259: ,p_src_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
260: ,p_targ_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
261: ,p_src_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
262: ,p_targ_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 346: p_src_project_id IN pa_projects_all.project_id%TYPE

342: IN 1)p_project_id IN SYSTEM.PA_NUM_TBL_TYPE
343: =======================================================================*/
344: PROCEDURE add_wp_plan_type
345: (
346: p_src_project_id IN pa_projects_all.project_id%TYPE
347: ,p_targ_project_id IN pa_projects_all.project_id%TYPE
348: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
349: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
350: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 347: ,p_targ_project_id IN pa_projects_all.project_id%TYPE

343: =======================================================================*/
344: PROCEDURE add_wp_plan_type
345: (
346: p_src_project_id IN pa_projects_all.project_id%TYPE
347: ,p_targ_project_id IN pa_projects_all.project_id%TYPE
348: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
349: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
350: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
351: );

Line 374: p_project_id IN Pa_projects_all.project_id%TYPE

370: p_planned_equip_effort_tbl IN parameter has also been removed as they were not being used/referred.
371: ********************************************************************************************************/
372: PROCEDURE check_and_create_task_rec_info
373: (
374: p_project_id IN Pa_projects_all.project_id%TYPE
375: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE
376: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
377: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
378: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

Line 463: p_project_id IN pa_projects_all.project_id%TYPE

459: a different version
460: ==============================================================================*/
461:
462: PROCEDURE Refresh_rbs_for_versions(
463: p_project_id IN pa_projects_all.project_id%TYPE
464: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
465: ,p_calling_context IN VARCHAR2 Default 'ALL_CHILD_VERSIONS'
466: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE Default null
467: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 478: ,p_project_id IN pa_projects_all.project_id%TYPE)

474: FUNCTION DUP_EXISTS
475: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
476: ,p_task_id IN pa_tasks.task_id%TYPE
477: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE
478: ,p_project_id IN pa_projects_all.project_id%TYPE)
479: RETURN VARCHAR2;
480:
481: END PA_FP_PLANNING_TRANSACTION_PUB;
482: