APPS.PA_TASKS_MAINT_UTILS dependencies on PA_PROJ_ELEM_VER_STRUCTURE

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

2062: IF p_validate_only <> FND_API.G_TRUE
2063: THEN
2064: BEGIN
2065: SELECT 'x' INTO l_dummy_char
2066: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
2067: FROM pa_proj_elem_ver_structure
2068: WHERE project_id = p_project_id
2069: AND wbs_record_version_number = p_wbs_record_version_number
2070: FOR UPDATE OF record_version_number NOWAIT;

Line 2067: FROM pa_proj_elem_ver_structure

2063: THEN
2064: BEGIN
2065: SELECT 'x' INTO l_dummy_char
2066: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
2067: FROM pa_proj_elem_ver_structure
2068: WHERE project_id = p_project_id
2069: AND wbs_record_version_number = p_wbs_record_version_number
2070: FOR UPDATE OF record_version_number NOWAIT;
2071:

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

2098: END;
2099: ELSE
2100: BEGIN
2101: SELECT 'x' INTO l_dummy_char
2102: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
2103: FROM pa_proj_elem_ver_structure
2104: WHERE project_id = p_project_id
2105: AND wbs_record_version_number = p_wbs_record_version_number;
2106: EXCEPTION

Line 2103: FROM pa_proj_elem_ver_structure

2099: ELSE
2100: BEGIN
2101: SELECT 'x' INTO l_dummy_char
2102: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
2103: FROM pa_proj_elem_ver_structure
2104: WHERE project_id = p_project_id
2105: AND wbs_record_version_number = p_wbs_record_version_number;
2106: EXCEPTION
2107: WHEN NO_DATA_FOUND THEN

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

2149: BEGIN
2150: x_return_status := 'S';
2151:
2152: /* increment wbs_record_version_number for project id */
2153: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
2154: UPDATE pa_proj_elem_ver_structure
2155: SET wbs_record_version_number = NVL( wbs_record_version_number, 0 ) + 1
2156: WHERE project_id = p_project_id
2157: AND wbs_record_version_number = p_wbs_record_version_number;

Line 2154: UPDATE pa_proj_elem_ver_structure

2150: x_return_status := 'S';
2151:
2152: /* increment wbs_record_version_number for project id */
2153: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
2154: UPDATE pa_proj_elem_ver_structure
2155: SET wbs_record_version_number = NVL( wbs_record_version_number, 0 ) + 1
2156: WHERE project_id = p_project_id
2157: AND wbs_record_version_number = p_wbs_record_version_number;
2158: