[Home] [Help]
283: l_dummy VARCHAR2(1);
284:
285: cursor c1 is
286: select '1'
287: from pa_proj_structure_types p, pa_proj_elements e, pa_structure_types t
288: where e.project_id = p_project_id
289: and e.proj_element_id = p.proj_element_id
290: and p.structure_type_id = t.structure_type_id
291: and t.structure_type_class_code = p_structure_type
347: l_dummy VARCHAR2(1);
348:
349: cursor c1 is
350: select '1'
351: from pa_proj_structure_types p,
352: pa_structure_types t
353: where p.proj_element_id = p_structure_id
354: and p.structure_type_id = t.structure_type_id
355: and t.structure_type_class_code = p_structure_type
404: l_dummy VARCHAR2(1);
405:
406: cursor c1 is
407: select '1'
408: from pa_proj_structure_types p, pa_proj_elements e,
409: pa_structure_types t, pa_proj_element_versions v
410: where v.element_version_id = p_structure_version_id
411: and v.proj_element_id = e.proj_element_id
412: and e.proj_element_id = p.proj_element_id
1090:
1091: CURSOR c1 IS
1092: select wp_approval_reqd_flag, wp_auto_publish_flag
1093: from pa_proj_workplan_attr ppw
1094: ,pa_proj_structure_types ppst
1095: ,pa_structure_types pst
1096: where ppw.project_id = p_project_id
1097: and ppw.proj_element_id = ppst.proj_element_id
1098: and ppst.structure_type_id = pst.structure_type_id
1416: /* Commented the following query for Performance Bug fix : 3968091
1417: select c.element_version_id
1418: from pa_proj_element_versions c,
1419: pa_proj_elements b,
1420: pa_proj_structure_types a,
1421: pa_structure_types d
1422: where d.structure_type_class_code = 'WORKPLAN'
1423: and d.structure_type_id = a.structure_type_id
1424: and a.proj_element_id = b.proj_element_id
1428: and c.object_type = 'PA_STRUCTURES';
1429: */
1430: select c.element_version_id /*New Query with improved Performance : 3968091 */
1431: from pa_proj_element_versions c,
1432: pa_proj_structure_types a,
1433: pa_structure_types d
1434: where d.structure_type_class_code = 'WORKPLAN'
1435: and d.structure_type_id = a.structure_type_id
1436: and a.proj_element_id = c.proj_element_id
1482: /*Commented the following Query for Performance Bug fix : 3968091
1483: select c.element_version_id
1484: from pa_proj_element_versions c,
1485: pa_proj_elements b,
1486: pa_proj_structure_types a,
1487: pa_structure_types d
1488: where d.structure_type_class_code = 'FINANCIAL'
1489: and d.structure_type_id = a.structure_type_id
1490: and a.proj_element_id = b.proj_element_id
1494: and c.object_type = 'PA_STRUCTURES';
1495: */
1496: select c.element_version_id /*New Query with improved Performance : 3968091 */
1497: from pa_proj_element_versions c,
1498: pa_proj_structure_types a,
1499: pa_structure_types d
1500: where d.structure_type_class_code = 'FINANCIAL'
1501: and d.structure_type_id = a.structure_type_id
1502: and a.proj_element_id = c.proj_element_id
1774: IS
1775: CURSOR c1 IS
1776: SELECT 'Y'
1777: FROM pa_proj_elements a,
1778: pa_proj_structure_types b,
1779: pa_structure_types c
1780: WHERE c.structure_type_class_code = 'WORKPLAN'
1781: AND c.structure_type_id = b.structure_type_id
1782: AND b.proj_element_id = a.proj_element_id
1813: IS
1814: CURSOR c1 IS
1815: SELECT 'Y'
1816: FROM pa_proj_elements a,
1817: pa_proj_structure_types b,
1818: pa_structure_types c
1819: WHERE c.structure_type_class_code = 'FINANCIAL'
1820: AND c.structure_type_id = b.structure_type_id
1821: AND b.proj_element_id = a.proj_element_id
1853: IS
1854: CURSOR c1 IS
1855: SELECT 'Y'
1856: FROM pa_proj_elements a,
1857: pa_proj_structure_types b,
1858: pa_structure_types c,
1859: pa_proj_structure_types d,
1860: pa_structure_types e
1861: WHERE c.structure_type_class_code = 'WORKPLAN'
1855: SELECT 'Y'
1856: FROM pa_proj_elements a,
1857: pa_proj_structure_types b,
1858: pa_structure_types c,
1859: pa_proj_structure_types d,
1860: pa_structure_types e
1861: WHERE c.structure_type_class_code = 'WORKPLAN'
1862: AND e.structure_type_class_code = 'FINANCIAL'
1863: AND c.structure_type_id = b.structure_type_id
1993:
1994: CURSOR get_wp_id IS
1995: SELECT ppe.proj_element_id
1996: from pa_proj_elements ppe,
1997: pa_proj_structure_types ppst,
1998: pa_structure_types pst
1999: where ppe.project_id = p_project_id
2000: and ppe.proj_element_id = ppst.proj_element_id
2001: and ppst.structure_type_id = pst.structure_type_id
2071:
2072: CURSOR get_wp_id IS
2073: SELECT ppe.proj_element_id
2074: from pa_proj_elements ppe,
2075: pa_proj_structure_types ppst,
2076: pa_structure_types pst
2077: where ppe.project_id = p_project_id
2078: and ppe.proj_element_id = ppst.proj_element_id
2079: and ppst.structure_type_id = pst.structure_type_id
2590: IS
2591: CURSOR c1 IS
2592: select ppe.proj_element_id
2593: from pa_proj_elements ppe,
2594: pa_proj_structure_types ppst,
2595: pa_structure_types pst
2596: where ppe.project_id = p_project_id
2597: and ppe.proj_element_id = ppst.proj_element_id
2598: and ppst.structure_type_id = pst.structure_type_id
2626: IS
2627: CURSOR c1 IS
2628: select ppevs.element_version_id
2629: from pa_proj_elements ppe,
2630: pa_proj_structure_types ppst,
2631: pa_structure_types pst,
2632: pa_proj_elem_ver_structure ppevs
2633: where ppe.project_id = p_project_id
2634: and ppe.proj_element_id = ppst.proj_element_id
2646:
2647: CURSOR c2 IS
2648: select ppevs.element_version_id
2649: from pa_proj_elements ppe,
2650: pa_proj_structure_types ppst,
2651: pa_structure_types pst,
2652: pa_proj_elem_ver_structure ppevs
2653: where ppe.project_id = p_project_id
2654: and ppe.proj_element_id = ppst.proj_element_id
2729: IS
2730: CURSOR c1 IS
2731: select ppevs.element_version_id
2732: from pa_proj_elements ppe,
2733: pa_proj_structure_types ppst,
2734: pa_structure_types pst,
2735: pa_proj_elem_ver_structure ppevs
2736: where ppe.project_id = p_project_id
2737: and ppe.proj_element_id = ppst.proj_element_id
3403: c_structure_type pa_structure_types.structure_type%TYPE)
3404: is
3405: select vs.process_code
3406: from pa_proj_elem_ver_structure vs,
3407: pa_proj_structure_types pst,
3408: pa_structure_types st
3409: where
3410: vs.project_id = c_project_id
3411: and vs.process_code in ('WUP','WUE')
3435: cursor getFinOnlyStrucVer(c_project_id NUMBER) IS
3436: /*Commented the Following SQL Query for Performance Bug fix : 3968091
3437: select pev.element_version_id
3438: from pa_proj_element_versions pev, pa_proj_elements pe,
3439: pa_proj_structure_types pst
3440: where pe.project_id = c_project_id
3441: and pe.project_id = pev.project_id
3442: and pe.proj_element_id = pev.proj_element_id
3443: and pe.object_type = 'PA_STRUCTURES'
3445: and pst.structure_type_id = 6;
3446: */
3447: select pev.element_version_id /*New Query with improved Performance : 3968091 */
3448: from pa_proj_element_versions pev,
3449: pa_proj_structure_types pst
3450: where pev.project_id = c_project_id
3451: and pev.object_type = 'PA_STRUCTURES'
3452: and pev.proj_element_id = pst.proj_element_id
3453: and pst.structure_type_id = 6;
3534: c_structure_type pa_structure_types.structure_type%TYPE)
3535: IS
3536: select vs.conc_request_id, vs.process_code, vs.element_version_id
3537: from pa_proj_elem_ver_structure vs,
3538: pa_proj_structure_types pst,
3539: pa_structure_types st
3540: where vs.project_id = c_project_id
3541: and vs.process_code in ('WUP','WUE')
3542: and pst.PROJ_ELEMENT_ID = vs.proj_element_id
3691: c_structure_type pa_structure_types.structure_type%TYPE)
3692: IS
3693: select vs.conc_request_id
3694: from pa_proj_elem_ver_structure vs,
3695: pa_proj_structure_types pst,
3696: pa_structure_types st
3697: where vs.project_id = c_project_id
3698: and vs.process_code in ('WUP','WUE')
3699: and pst.PROJ_ELEMENT_ID = vs.proj_element_id
3755: IS
3756: CURSOR c1 IS
3757: SELECT 'Y'
3758: FROM pa_proj_elem_ver_structure a, -- Bug 16325665
3759: pa_proj_structure_types b,
3760: pa_structure_types c
3761: WHERE c.structure_type_class_code = 'DELIVERABLE'
3762: AND c.structure_type_id = b.structure_type_id
3763: AND b.proj_element_id = a.proj_element_id
3782: CURSOR cur_cwv
3783: IS
3784: SELECT ppevs.element_version_id
3785: FROM pa_proj_elements ppe,
3786: pa_proj_structure_types ppst,
3787: pa_structure_types pst,
3788: pa_proj_elem_ver_structure ppevs
3789: WHERE ppe.project_id = p_project_id
3790: AND ppe.proj_element_id = ppst.proj_element_id
3798: CURSOR get_struct_version_id
3799: IS
3800: SELECT pev.element_version_id
3801: FROM pa_proj_element_versions pev ,
3802: pa_proj_structure_types pst
3803: WHERE pev.project_id = p_project_id
3804: AND pev.object_type = 'PA_STRUCTURES'
3805: AND pev.proj_element_id = pst.proj_element_id
3806: AND pst.structure_type_id = 1; -- WORKPLAN
3917: IS
3918: cursor get_third_party_flag IS
3919: Select ppwa.SCHEDULE_THIRD_PARTY_FLAG
3920: from pa_proj_workplan_attr ppwa,
3921: pa_proj_structure_types ppst,
3922: pa_structure_types pst
3923: where p_project_id = ppwa.project_id
3924: and ppwa.proj_element_id = ppst.proj_element_id
3925: and ppst.structure_type_id = pst.structure_type_id
3942: IS
3943: cursor get_lowest_tsk_dep_flag IS
3944: Select ppwa.ALLOW_LOWEST_TSK_DEP_FLAG
3945: from pa_proj_workplan_attr ppwa,
3946: pa_proj_structure_types ppst,
3947: pa_structure_types pst
3948: where p_project_id = ppwa.project_id
3949: and ppwa.proj_element_id = ppst.proj_element_id
3950: and ppst.structure_type_id = pst.structure_type_id
4031: SELECT ppev.element_version_id
4032: FROM pa_proj_elements ppe,
4033: pa_proj_element_versions ppev,
4034: pa_proj_elem_ver_structure ppevs,
4035: pa_proj_structure_types ppst,
4036: pa_structure_types pst
4037: WHERE ppe.proj_element_id = ppev.proj_element_id
4038: AND ppe.project_id = ppev.project_id
4039: AND ppe.project_id = cp_proj_id
4048: SELECT ppev.element_version_id
4049: FROM pa_proj_elements ppe,
4050: pa_proj_element_versions ppev,
4051: pa_proj_elem_ver_structure ppevs,
4052: pa_proj_structure_types ppst,
4053: pa_structure_types pst
4054: WHERE ppe.proj_element_id = ppev.proj_element_id
4055: AND ppe.project_id = ppev.project_id
4056: AND ppe.project_id = cp_proj_id
4307: cursor cur_proc_ver(c_project_id pa_projects_all.project_id%TYPE
4308: , c_structure_type pa_structure_types.structure_type%TYPE) is
4309: select vs.process_code, vs.element_version_id, vs.conc_request_id
4310: from pa_proj_elem_ver_structure vs
4311: , pa_proj_structure_types pst
4312: , pa_structure_types st
4313: where vs.project_id = c_project_id
4314: and pst.PROJ_ELEMENT_ID = vs.proj_element_id
4315: and pst.structure_type_id = st.structure_type_id
4630: l_str_sharing_code VARCHAR2(30) := null;
4631:
4632: cursor cur_proc_upd_flag(c_project_id NUMBER, c_structure_version_id VARCHAR2) is
4633: select ppevs.process_update_wbs_flag, ppevs.process_code
4634: from pa_proj_elem_ver_structure ppevs, pa_proj_structure_types ppst, pa_structure_types pst
4635: where ppevs.proj_element_id = ppst.proj_element_id
4636: and ppst.structure_type_id = pst.structure_type_id
4637: and ppevs.project_id = c_project_id
4638: and ppevs.element_version_id = c_structure_version_id;
5273: CURSOR get_structure_id
5274: IS
5275: SELECT a.proj_element_id
5276: FROM pa_proj_elements a,
5277: pa_proj_structure_types b,
5278: pa_structure_types c
5279: WHERE a.proj_element_id = b.proj_element_id
5280: AND a.object_type = 'PA_STRUCTURES'
5281: AND a.project_id = p_project_id