DBA Data[Home] [Help]

APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 3676: ,p_project_structure_version_id => PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(p_project_id => p_project_id )

3672: -- Bug 3793623 - Added new params p_planning_start_date_tbl and p_planning_end_date_tbl
3673: PA_PLANNING_TRANSACTION_UTILS.get_default_planning_dates
3674: ( p_project_id => p_project_id
3675: ,p_element_version_id_tbl => p_task_elem_version_id_tbl
3676: ,p_project_structure_version_id => PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(p_project_id => p_project_id )
3677: ,p_planning_start_date_tbl => p_planning_start_date_tbl
3678: ,p_planning_end_date_tbl => p_planning_end_date_tbl
3679: ,x_planning_start_date_tbl => l_start_date_tbl
3680: ,x_planning_end_date_tbl => l_compl_date_tbl

Line 5108: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(p_project_id)

5104:
5105: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
5106: ( p_calling_context => 'ASGMT_PLAN_CHANGE'
5107: ,p_project_id => p_project_id
5108: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(p_project_id)
5109: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(p_project_id)
5110: ,x_return_status => l_return_status
5111: ,x_msg_count => l_msg_count
5112: ,x_msg_data => l_msg_data);

Line 5109: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(p_project_id)

5105: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
5106: ( p_calling_context => 'ASGMT_PLAN_CHANGE'
5107: ,p_project_id => p_project_id
5108: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(p_project_id)
5109: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(p_project_id)
5110: ,x_return_status => l_return_status
5111: ,x_msg_count => l_msg_count
5112: ,x_msg_data => l_msg_data);
5113:

Line 8326: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(p_target_project_id)

8322:
8323: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
8324: ( p_calling_context => 'ASGMT_PLAN_CHANGE'
8325: ,p_project_id => p_target_project_id
8326: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(p_target_project_id)
8327: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(p_target_project_id)
8328: ,x_return_status => x_return_status
8329: ,x_msg_data => x_msg_data
8330: ,x_msg_count => x_msg_count );

Line 8327: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(p_target_project_id)

8323: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
8324: ( p_calling_context => 'ASGMT_PLAN_CHANGE'
8325: ,p_project_id => p_target_project_id
8326: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(p_target_project_id)
8327: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(p_target_project_id)
8328: ,x_return_status => x_return_status
8329: ,x_msg_data => x_msg_data
8330: ,x_msg_count => x_msg_count );
8331:

Line 9913: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(l_project_id)

9909:
9910: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
9911: ( p_calling_context => 'ASGMT_PLAN_CHANGE'
9912: ,p_project_id => l_project_id
9913: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(l_project_id)
9914: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(l_project_id)
9915: ,x_return_status => x_return_status
9916: ,x_msg_data => x_msg_data
9917: ,x_msg_count => x_msg_count );

Line 9914: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(l_project_id)

9910: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
9911: ( p_calling_context => 'ASGMT_PLAN_CHANGE'
9912: ,p_project_id => l_project_id
9913: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(l_project_id)
9914: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(l_project_id)
9915: ,x_return_status => x_return_status
9916: ,x_msg_data => x_msg_data
9917: ,x_msg_count => x_msg_count );
9918:

Line 11320: ,PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) STRUCTURE_VERSION_ID --Bug 3546208

11316: -- End of variables used for debugging purpose
11317:
11318: CURSOR version_info_cur (c_budget_version_id number) is
11319: select bv.project_id
11320: ,PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) STRUCTURE_VERSION_ID --Bug 3546208
11321: ,bv.fin_plan_type_id
11322: ,Decode(bv.version_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.cost_fin_plan_level_code
11323: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,pfo.revenue_fin_plan_level_code
11324: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,pfo.all_fin_plan_level_code) plan_level_code

Line 11946: OR nvl(PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id),'N') = 'Y')) THEN

11942: with negative values of budget lines */
11943: IF nvl(p_resource_list_change, 'N') = 'Y' OR nvl(p_time_phase_change, 'N') = 'Y'
11944: OR nvl(p_track_costs_flag_change, 'N') = 'Y' OR (nvl(p_rbs_version_change, 'N') = 'Y' AND
11945: (nvl(PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id),'N') = 'N'
11946: OR nvl(PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id),'N') = 'Y')) THEN
11947:
11948: IF l_debug_mode = 'Y' THEN
11949: pa_debug.g_err_stage:='About to insert negative lines';
11950: pa_debug.write('REFRESH_WP_SETTINGS: ' || g_module_name,pa_debug.g_err_stage,5);

Line 12320: OR nvl(PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id),'N') = 'Y') -- Jun-28-2004 Bug 3725414

12316: -- workplan versions even though versioning is enbled but shared structure
12317:
12318: IF nvl(p_rbs_version_change, 'N') = 'Y' AND
12319: (nvl(PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id),'N') = 'N' -- Jun-15-2004 Bug 3619687
12320: OR nvl(PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id),'N') = 'Y') -- Jun-28-2004 Bug 3725414
12321: THEN
12322: /** Bug 3725414
12323: -- Fetch all the workplan versions
12324: OPEN all_workplan_versions_cur;

Line 12457: OR nvl(PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id),'N') = 'Y')) THEN

12453: with positive values of budget lines */
12454: IF nvl(p_resource_list_change, 'N') = 'Y' OR nvl(p_time_phase_change, 'N') = 'Y'
12455: OR nvl(p_track_costs_flag_change, 'N') = 'Y' OR ( nvl(p_rbs_version_change, 'N') = 'Y' AND
12456: (nvl(PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id),'N') = 'N'
12457: OR nvl(PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id),'N') = 'Y')) THEN
12458: IF l_debug_mode = 'Y' THEN
12459: pa_debug.g_err_stage:='About to insert positive values with new rbs element ids';
12460: pa_debug.write( g_module_name,pa_debug.g_err_stage,5);
12461: END IF;