DBA Data[Home] [Help]

APPS.PA_PROJECT_STRUCTURE_PUB1 dependencies on PA_PROJ_WORKPLAN_ATTR

Line 1408: from pa_proj_workplan_attr

1404: and r.object_type_from = 'PA_STRUCTURES';
1405:
1406: cursor sel_wp_attr(c_proj_element_id NUMBER) IS
1407: select record_version_number
1408: from pa_proj_workplan_attr
1409: where proj_element_id = c_proj_element_id;
1410:
1411: l_project_id PA_PROJ_ELEMENT_VERSIONS.PROJECT_ID%TYPE;
1412: l_proj_element_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE;

Line 1424: l_wp_attr_rvn PA_PROJ_WORKPLAN_ATTR.RECORD_VERSION_NUMBER%TYPE;

1420: l_pevsh_rowid VARCHAR2(255);
1421:
1422: l_task_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
1423: l_task_rvn PA_PROJ_ELEMENT_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
1424: l_wp_attr_rvn PA_PROJ_WORKPLAN_ATTR.RECORD_VERSION_NUMBER%TYPE;
1425:
1426: l_parent_struc_ver_id PA_PROJ_ELEMENT_VERSIONS.PARENT_STRUCTURE_VERSION_ID%TYPE;
1427: l_structure_type pa_structure_types.STRUCTURE_TYPE_CLASS_CODE%TYPE; --Amit
1428:

Line 3432: from pa_proj_workplan_attr

3428: IF (l_check_sharing_enabled <> 'Y') THEN
3429:
3430: select record_version_number
3431: INTO l_record_version_number
3432: from pa_proj_workplan_attr
3433: where proj_element_id = l_parent_structure_id;
3434:
3435: PA_WORKPLAN_ATTR_PVT.DELETE_PROJ_WORKPLAN_ATTRS(p_validate_only => FND_API.G_FALSE,
3436: p_project_id => p_project_id,