APPS.PA_WORKPLAN_ATTR_PVT dependencies on PA_PROJ_ELEMENTS

Line 762: UPDATE PA_PROJ_ELEMENTS

758: -- END mrajput
759:
760: --LDENG
761: IF (l_clear_phase_flag = 'Y') THEN
762: UPDATE PA_PROJ_ELEMENTS
763: SET phase_version_id = null
764: WHERE project_id = p_project_id
765: AND phase_version_id IS NOT NULL;
766: end if;

Line 858: FROM pa_proj_elements

854:
855: if p_validate_only <> FND_API.G_TRUE then
856: BEGIN
857: SELECT 'x' INTO l_dummy
858: FROM pa_proj_elements
859: WHERE proj_element_id = p_proj_element_id
860: FOR UPDATE OF record_version_number NOWAIT;
861: EXCEPTION
862: when TIMEOUT_ON_RESOURCE then

Line 888: FROM pa_proj_elements

884: END;
885: else
886: BEGIN
887: SELECT 'x' INTO l_dummy
888: FROM pa_proj_elements
889: WHERE proj_element_id = p_proj_element_id;
890: EXCEPTION
891: when NO_DATA_FOUND then
892: if p_calling_module = 'FORM' then

Line 916: UPDATE PA_PROJ_ELEMENTS

912: raise FND_API.G_EXC_ERROR;
913: end if;
914:
915: if p_validate_only <> FND_API.G_TRUE then
916: UPDATE PA_PROJ_ELEMENTS
917: SET name = p_structure_name,
918: record_version_number = record_version_number + 1,
919: last_update_date = SYSDATE,
920: last_updated_by = FND_GLOBAL.USER_ID,