APPS.PA_TASKS_MAINT_UTILS dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 2015: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure

2011: IF p_validate_only <> FND_API.G_TRUE
2012: THEN
2013: BEGIN
2014: SELECT 'x' INTO l_dummy_char
2015: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
2016: FROM pa_proj_elem_ver_structure
2017: WHERE project_id = p_project_id
2018: AND wbs_record_version_number = p_wbs_record_version_number
2019: FOR UPDATE OF record_version_number NOWAIT;

Line 2016: FROM pa_proj_elem_ver_structure

2012: THEN
2013: BEGIN
2014: SELECT 'x' INTO l_dummy_char
2015: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
2016: FROM pa_proj_elem_ver_structure
2017: WHERE project_id = p_project_id
2018: AND wbs_record_version_number = p_wbs_record_version_number
2019: FOR UPDATE OF record_version_number NOWAIT;
2020:

Line 2051: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure

2047: END;
2048: ELSE
2049: BEGIN
2050: SELECT 'x' INTO l_dummy_char
2051: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
2052: FROM pa_proj_elem_ver_structure
2053: WHERE project_id = p_project_id
2054: AND wbs_record_version_number = p_wbs_record_version_number;
2055: EXCEPTION

Line 2052: FROM pa_proj_elem_ver_structure

2048: ELSE
2049: BEGIN
2050: SELECT 'x' INTO l_dummy_char
2051: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
2052: FROM pa_proj_elem_ver_structure
2053: WHERE project_id = p_project_id
2054: AND wbs_record_version_number = p_wbs_record_version_number;
2055: EXCEPTION
2056: WHEN NO_DATA_FOUND THEN

Line 2102: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure

2098: BEGIN
2099: x_return_status := 'S';
2100:
2101: /* increment wbs_record_version_number for project id */
2102: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
2103: UPDATE pa_proj_elem_ver_structure
2104: SET wbs_record_version_number = NVL( wbs_record_version_number, 0 ) + 1
2105: WHERE project_id = p_project_id
2106: AND wbs_record_version_number = p_wbs_record_version_number;

Line 2103: UPDATE pa_proj_elem_ver_structure

2099: x_return_status := 'S';
2100:
2101: /* increment wbs_record_version_number for project id */
2102: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
2103: UPDATE pa_proj_elem_ver_structure
2104: SET wbs_record_version_number = NVL( wbs_record_version_number, 0 ) + 1
2105: WHERE project_id = p_project_id
2106: AND wbs_record_version_number = p_wbs_record_version_number;
2107: