APPS.PA_RELATIONSHIP_PVT dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 125: pa_proj_elem_ver_structure pevs

121: select pevs.element_version_id
122: from pa_proj_structure_types s,
123: pa_structure_types t,
124: pa_proj_elements pe,
125: pa_proj_elem_ver_structure pevs
126: where pe.object_type = 'PA_STRUCTURES'
127: and pe.project_id = c_project_id
128: and pe.proj_element_id = s.proj_element_id
129: and s.structure_type_id = t.structure_type_id

Line 1100: pa_proj_elem_ver_structure ppevs

1096: CURSOR get_src_str_status
1097: IS
1098: SELECT status_code
1099: FROM pa_proj_element_versions ppev,
1100: pa_proj_elem_ver_structure ppevs
1101: WHERE ppev.project_id = p_src_proj_id
1102: AND ppev.element_version_id = p_src_task_ver_id
1103: AND ppev.parent_structure_version_id = ppevs.element_version_id
1104: AND ppevs.project_id = ppev.project_id

Line 1111: pa_proj_elem_ver_structure str,

1107: CURSOR get_dest_task_ver_id
1108: IS
1109: SELECT pev2.element_version_id, 'STRUCTURE_WORKING' status_code
1110: FROM pa_proj_element_versions pev,
1111: pa_proj_elem_ver_structure str,
1112: pa_proj_element_versions pev2
1113: WHERE pev.proj_element_id = pev2.proj_element_id
1114: AND pev.project_id = pev2.project_id
1115: AND pev2.parent_structure_version_id = str.element_version_id

Line 1123: pa_proj_elem_ver_structure str,

1119: AND pev.element_version_id = p_dest_task_ver_id
1120: UNION ALL
1121: SELECT pev2.element_version_id, 'STRUCTURE_PUBLISHED' status_code
1122: FROM pa_proj_element_versions pev,
1123: pa_proj_elem_ver_structure str,
1124: pa_proj_element_versions pev2
1125: WHERE pev.proj_element_id = pev2.proj_element_id
1126: AND pev.project_id = pev2.project_id
1127: AND pev2.parent_structure_version_id = str.element_version_id

Line 3024: FROM pa_proj_elem_ver_structure

3020: --bug 4296915
3021: CURSOR check_child_pub
3022: IS
3023: SELECT 'x'
3024: FROM pa_proj_elem_ver_structure
3025: WHERE project_id=p_dest_proj_id
3026: AND element_version_id = p_dest_struc_elem_ver_id
3027: AND status_code = 'STRUCTURE_PUBLISHED'
3028: ;

Line 4521: from pa_proj_elem_ver_structure

4517: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
4518:
4519: cursor check_child_pub (c_dest_proj_id NUMBER, c_dest_struc_elem_ver_id NUMBER) is
4520: select 'x'
4521: from pa_proj_elem_ver_structure
4522: where project_id = c_dest_proj_id
4523: and element_version_id = c_dest_struc_elem_ver_id
4524: and status_code = 'STRUCTURE_PUBLISHED';
4525:

Line 5165: Select 1 from pa_proj_element_versions a, pa_proj_elem_ver_structure b

5161: l_pub_str_ver_enable VARCHAR2(1);
5162: l_upd_prog_grp_status NUMBER:=0;
5163: --
5164: CURSOR get_working_ver(c_ver_id NUMBER) IS
5165: Select 1 from pa_proj_element_versions a, pa_proj_elem_ver_structure b
5166: where a.element_version_id = c_ver_id
5167: and a.project_id = b.project_id
5168: and a.parent_structure_version_id = b.element_version_id
5169: and b.status_code <> 'STRUCTURE_PUBLISHED';

Line 5586: UPDATE pa_proj_elem_ver_structure

5582: pa_debug.write(x_Module=>'PA_RELATIONSHIP_PVT.UPDATE_PARENT_WBS_FLAG_DIRTY', x_Msg => 'p_structure_version_id: '||p_structure_version_id, x_Log_Level=> 3);
5583: END IF;
5584:
5585: FOR cur_obj_rel_rec in cur_obj_rel LOOP
5586: UPDATE pa_proj_elem_ver_structure
5587: SET PROCESS_UPDATE_WBS_FLAG = 'Y',
5588: process_code = 'CPI'
5589: WHERE project_id = cur_obj_rel_rec.object_id_from2
5590: AND element_version_id=(select parent_structure_version_id