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 3036: FROM pa_proj_elem_ver_structure

3032: --bug 4296915
3033: CURSOR check_child_pub
3034: IS
3035: SELECT 'x'
3036: FROM pa_proj_elem_ver_structure
3037: WHERE project_id=p_dest_proj_id
3038: AND element_version_id = p_dest_struc_elem_ver_id
3039: AND status_code = 'STRUCTURE_PUBLISHED'
3040: ;

Line 4539: from pa_proj_elem_ver_structure

4535: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
4536:
4537: cursor check_child_pub (c_dest_proj_id NUMBER, c_dest_struc_elem_ver_id NUMBER) is
4538: select 'x'
4539: from pa_proj_elem_ver_structure
4540: where project_id = c_dest_proj_id
4541: and element_version_id = c_dest_struc_elem_ver_id
4542: and status_code = 'STRUCTURE_PUBLISHED';
4543:

Line 5187: Select 1 from pa_proj_element_versions a, pa_proj_elem_ver_structure b

5183: l_pub_str_ver_enable VARCHAR2(1);
5184: l_upd_prog_grp_status NUMBER:=0;
5185: --
5186: CURSOR get_working_ver(c_ver_id NUMBER) IS
5187: Select 1 from pa_proj_element_versions a, pa_proj_elem_ver_structure b
5188: where a.element_version_id = c_ver_id
5189: and a.project_id = b.project_id
5190: and a.parent_structure_version_id = b.element_version_id
5191: and b.status_code <> 'STRUCTURE_PUBLISHED';

Line 5608: UPDATE pa_proj_elem_ver_structure

5604: 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);
5605: END IF;
5606:
5607: FOR cur_obj_rel_rec in cur_obj_rel LOOP
5608: UPDATE pa_proj_elem_ver_structure
5609: SET PROCESS_UPDATE_WBS_FLAG = 'Y',
5610: process_code = 'CPI'
5611: WHERE project_id = cur_obj_rel_rec.object_id_from2
5612: AND element_version_id=(select parent_structure_version_id