DBA Data[Home] [Help]

APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_BUDGET_VERSIONS

Line 40: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL

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()
43: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_100_TBL_TYPE()
44: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()

Line 120: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL

116: (
117: p_context IN VARCHAR2
118: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
119: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE DEFAULT NULL
120: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
121: ,p_task_elem_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
122: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
123: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_100_TBL_TYPE()
124: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()

Line 254: ,p_src_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL

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
258: ,p_copy_people_flag IN VARCHAR2 := NULL

Line 255: ,p_targ_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL

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
258: ,p_copy_people_flag IN VARCHAR2 := NULL
259: ,p_copy_equip_flag IN VARCHAR2 := NULL

Line 398: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

394: either in planning level or resource list or rbs version.
395: ==============================================================================*/
396:
397: PROCEDURE Refresh_Plan_Txns(
398: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
399: ,p_plan_level_change IN VARCHAR2
400: ,p_resource_list_change IN VARCHAR2
401: ,p_rbs_version_change IN VARCHAR2
402: ,p_time_phase_change_flag IN VARCHAR2

Line 431: p_project_id IN pa_budget_versions.project_id%TYPE

427: be propagated to all the underlying workplan versions immediately upon save.
428: ===============================================================================*/
429:
430: PROCEDURE REFRESH_WP_SETTINGS(
431: p_project_id IN pa_budget_versions.project_id%TYPE
432: ,p_resource_list_change IN VARCHAR2 DEFAULT 'N' -- Bug 3619687
433: ,p_time_phase_change IN VARCHAR2 DEFAULT 'N' -- Bug 3619687
434: ,p_rbs_version_change IN VARCHAR2 DEFAULT 'N' -- Bug 3619687
435: ,p_track_costs_flag_change IN VARCHAR2 DEFAULT 'N' -- Bug 3619687

Line 459: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE

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
463: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 461: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE Default null

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
463: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
464: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
465:

Line 470: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

466: --This function returns 'N' if a record already exists in pa_resource_assignments
467: --for a given budget version id, task id and resource list member id
468: --Returns 'Y' if the record is not already there
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;