DBA Data[Home] [Help]

APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_PROJECTS_ALL

Line 38: ,p_project_id IN Pa_projects_all.project_id%TYPE

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

Line 252: ,p_src_project_id IN pa_projects_all.project_id%TYPE

248: PROCEDURE copy_planning_transactions
249: (
250: p_context IN VARCHAR2
251: ,p_copy_external_flag IN VARCHAR2
252: ,p_src_project_id IN pa_projects_all.project_id%TYPE
253: ,p_target_project_id IN pa_projects_all.project_id%TYPE
254: ,p_src_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
255: ,p_targ_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
256: ,p_src_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 253: ,p_target_project_id IN pa_projects_all.project_id%TYPE

249: (
250: p_context IN VARCHAR2
251: ,p_copy_external_flag IN VARCHAR2
252: ,p_src_project_id IN pa_projects_all.project_id%TYPE
253: ,p_target_project_id IN pa_projects_all.project_id%TYPE
254: ,p_src_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
255: ,p_targ_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
256: ,p_src_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
257: ,p_targ_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 341: p_src_project_id IN pa_projects_all.project_id%TYPE

337: IN 1)p_project_id IN SYSTEM.PA_NUM_TBL_TYPE
338: =======================================================================*/
339: PROCEDURE add_wp_plan_type
340: (
341: p_src_project_id IN pa_projects_all.project_id%TYPE
342: ,p_targ_project_id IN pa_projects_all.project_id%TYPE
343: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
344: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
345: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 342: ,p_targ_project_id IN pa_projects_all.project_id%TYPE

338: =======================================================================*/
339: PROCEDURE add_wp_plan_type
340: (
341: p_src_project_id IN pa_projects_all.project_id%TYPE
342: ,p_targ_project_id IN pa_projects_all.project_id%TYPE
343: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
344: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
345: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
346: );

Line 369: p_project_id IN Pa_projects_all.project_id%TYPE

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

Line 458: p_project_id IN pa_projects_all.project_id%TYPE

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

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

469: FUNCTION DUP_EXISTS
470: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
471: ,p_task_id IN pa_tasks.task_id%TYPE
472: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE
473: ,p_project_id IN pa_projects_all.project_id%TYPE)
474: RETURN VARCHAR2;
475:
476: END PA_FP_PLANNING_TRANSACTION_PUB;
477: