[Home] [Help]
349: ( c_structure_version_id number
350: , c_project_id number
351: )IS
352: SELECT decode(status.project_system_status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N')
353: FROM pa_proj_elem_ver_structure str, pa_project_statuses status
354: where str.element_version_id = c_structure_version_id
355: AND str.project_id = c_project_id
356: AND str.status_code = status.project_status_code;
357:
4884:
4885: --cursor to get structure version id of all non-published version
4886: CURSOR cur_get_wk_ver_struct_id IS
4887: select str.element_version_id
4888: from pa_proj_elem_ver_structure str,
4889: pa_proj_elements pe,
4890: pa_proj_structure_types pst
4891: where pe.project_id = p_project_id
4892: and pe.project_id = str.project_id
4901:
4902: --cursor to get only structure version id (when version disabled)
4903: CURSOR cur_get_only_ver_struct_id IS
4904: select str.element_version_id
4905: from pa_proj_elem_ver_structure str,
4906: pa_proj_elements pe,
4907: pa_proj_structure_types pst
4908: where pe.project_id = p_project_id
4909: and pe.project_id = str.project_id
8776: -- Call of rollup future is not needed here as there will be only one record per object in working version
8777:
8778: --- END IF; -- If workplan versioning is enabled
8779:
8780: UPDATE pa_proj_elem_ver_structure
8781: set date_prog_applied_on_wver = sysdate
8782: ,schedule_dirty_flag = decode( PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(p_project_id), --bug 3844689
8783: 'Y', 'Y', schedule_dirty_flag ) --set this flag to indicate re-scheduling is required.
8784: WHERE project_id = p_project_id
8983: l_str_ver_id NUMBER;
8984: Cursor cur_Summerized_Actuals
8985: IS
8986: Select ppevs.element_version_id
8987: FROM PA_Proj_Elem_Ver_Structure ppevs,
8988: PA_Proj_Elements ppe,
8989: PA_Proj_Structure_Types ppst,
8990: PA_Structure_types pst
8991: WHERE ppevs.Project_ID = P_Project_ID
9285:
9286: CURSOR c_get_latest_pub_task_ver(c_proj_element_id NUMBER, c_project_id NUMBER)
9287: IS
9288: SELECT elemver.element_version_id, elemver.parent_structure_version_id
9289: FROM pa_proj_element_versions elemver, pa_proj_elem_ver_structure str
9290: WHERE elemver.proj_element_id = c_proj_element_id
9291: AND elemver.object_type = 'PA_TASKS'
9292: AND elemver.project_id = c_project_id
9293: AND str.project_id = c_project_id
11762: and NVL(ppr.cbs_element_id,-1)=NVL(c_cbs_element_id,-1);
11763:
11764: CURSOR get_prev_published_ver IS
11765: SELECT a.element_version_id
11766: FROM pa_proj_elem_ver_structure a
11767: WHERE a.project_id = p_project_id
11768: AND a.LATEST_EFF_PUBLISHED_FLAG <> 'Y'
11769: AND a.STATUS_CODE = 'STRUCTURE_PUBLISHED'
11770: ORDER BY published_date desc;
14385: -- Bug 6321238
14386: cursor check_pup_pue(c_project_id number,
14387: c_latest_published_version_id number) is
14388: select 'Y'
14389: from pa_proj_elem_ver_structure
14390: where project_id = c_project_id
14391: and element_version_id = c_latest_published_version_id
14392: and process_code = 'PUE';
14393:
19969:
19970: CURSOR cur_check_published_version(c_structure_version_id number, c_project_id number)
19971: IS
19972: SELECT decode(status.project_system_status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N')
19973: FROM pa_proj_elem_ver_structure str, pa_project_statuses status
19974: where str.element_version_id = c_structure_version_id
19975: AND str.project_id = c_project_id
19976: AND str.status_code = status.project_status_code;
19977:
20918:
20919: CURSOR cur_check_published_version(c_structure_version_id number, c_project_id number)
20920: IS
20921: SELECT decode(status.project_system_status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N')
20922: FROM pa_proj_elem_ver_structure str
20923: , pa_project_statuses status
20924: where str.element_version_id = c_structure_version_id
20925: AND str.project_id = c_project_id
20926: AND str.status_code = status.project_status_code;
21116:
21117: CURSOR c_get_distinct_str_ver_id IS
21118: SELECT distinct asgn.project_id project_id, asgn.structure_version_id structure_version_id
21119: FROM pa_task_asgmts_v asgn
21120: , pa_proj_elem_ver_structure str
21121: , pa_proj_progress_attr prog
21122: , pa_proj_structure_types pstype
21123: WHERE asgn.person_id = p_person_id
21124: AND asgn.structure_version_id = str.element_version_id
21131: AND prog.allow_collab_prog_entry = 'Y'
21132: UNION
21133: SELECT distinct elem.project_id project_id, str.element_version_id structure_version_id
21134: FROM pa_proj_elements elem
21135: , pa_proj_elem_ver_structure str
21136: , pa_proj_progress_attr prog
21137: , pa_proj_structure_types pstype
21138: WHERE elem.manager_person_id = p_person_id
21139: AND elem.object_type = 'PA_TASKS'
21544: ;*/
21545: --end bug 3968791
21546: Cursor cur_Summerized_Actuals IS
21547: Select count(1)
21548: FROM PA_Proj_Elem_Ver_Structure ppevs,
21549: PA_Proj_Elements ppe,
21550: PA_Proj_Structure_Types ppst,
21551: PA_Structure_types pst
21552: WHERE ppevs.Project_ID = P_Project_ID
22645:
22646: CURSOR c_get_latest_pub_task_ver(c_proj_element_id NUMBER, c_project_id NUMBER)
22647: IS
22648: SELECT elemver.element_version_id, elemver.parent_structure_version_id
22649: FROM pa_proj_element_versions elemver, pa_proj_elem_ver_structure str
22650: WHERE elemver.proj_element_id = c_proj_element_id
22651: AND elemver.object_type = 'PA_TASKS'
22652: AND elemver.project_id = c_project_id
22653: AND str.project_id = c_project_id
23706: l_structure_id := NULL;
23707:
23708: SELECT pevs.proj_element_id
23709: INTO l_structure_id
23710: FROM pa_proj_elem_ver_structure pevs
23711: WHERE pevs.element_version_id = l_structure_version_id_tbl(i)
23712: AND pevs.project_id = p_project_id_tbl(i);
23713:
23714: EXCEPTION WHEN OTHERS THEN