[Home] [Help]
305:
306: CURSOR cur_pa_proj_elem_vers2( c_strcu_ver_id NUMBER )
307: IS
308: SELECT 'x'
309: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
310: WHERE c.project_id = p_project_id
311: AND a.structure_type_id = b.structure_type_id
312: AND b.proj_element_id = c.proj_element_id
313: AND a.structure_type = 'WORKPLAN'
326: --hsiu added for parent_structure_id column
327: CURSOR get_structure(c_project_id NUMBER, c_struc_type VARCHAR2) IS
328: select a.proj_element_id
329: from pa_proj_elements a,
330: pa_proj_structure_types b,
331: pa_structure_types c
332: where a.project_id = c_project_id
333: and c.structure_type_class_code = c_struc_type
334: and c.structure_type_id = b.structure_type_id
359: CURSOR cur_proj_elem_vers
360: IS
361: SELECT ppev.element_version_id
362: FROM pa_proj_element_versions ppev,
363: pa_proj_structure_types ppst,
364: pa_structure_types pst
365: WHERE ppev.project_id = p_project_id
366: AND ppev.object_type = 'PA_STRUCTURES'
367: AND ppev.proj_element_id = ppst.proj_element_id
825:
826: CURSOR cur_pa_proj_elem_vers2( c_task_version_id NUMBER )
827: IS
828: SELECT 'x'
829: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
830: WHERE c.project_id = p_project_id
831: AND a.structure_type_id = b.structure_type_id
832: AND b.proj_element_id = c.proj_element_id
833: AND a.structure_type = 'WORKPLAN'
879:
880: CURSOR cur_struc_ver_fin
881: IS
882: SELECT c.element_version_id
883: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
884: ,pa_proj_elem_ver_structure d
885: WHERE c.project_id = p_project_id
886: AND a.structure_type_id = b.structure_type_id
887: AND b.proj_element_id = c.proj_element_id
897:
898: CURSOR cur_struc_ver_wp
899: IS
900: SELECT c.element_version_id
901: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
902: ,pa_proj_elem_ver_structure d
903: WHERE c.project_id = p_project_id
904: AND a.structure_type_id = b.structure_type_id
905: AND b.proj_element_id = c.proj_element_id
912: --hsiu added for parent_structure_id column
913: CURSOR get_structure(c_project_id NUMBER, c_struc_type VARCHAR2) IS
914: select a.proj_element_id
915: from pa_proj_elements a,
916: pa_proj_structure_types b,
917: pa_structure_types c
918: where a.project_id = c_project_id
919: and c.structure_type_class_code = c_struc_type
920: and c.structure_type_id = b.structure_type_id
968: /* Bug 2736392 Begin */
969: CURSOR cur_struc_ver_wp2
970: IS
971: SELECT c.element_version_id
972: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
973: ,pa_proj_elem_ver_structure d
974: WHERE c.project_id = p_project_id
975: AND a.structure_type_id = b.structure_type_id
976: AND b.proj_element_id = c.proj_element_id
1120: join in the following cursor*/
1121:
1122: CURSOR c1 is
1123: SELECT c.element_version_id
1124: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
1125: ,pa_proj_elem_ver_structure d
1126: WHERE c.project_id = p_project_id
1127: AND a.structure_type_id = b.structure_type_id
1128: AND b.proj_element_id = c.proj_element_id
2272:
2273: CURSOR cur_struc_ver_fin
2274: IS
2275: SELECT c.element_version_id
2276: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
2277: ,pa_proj_elem_ver_structure d
2278: WHERE c.project_id = p_project_id
2279: AND a.structure_type_id = b.structure_type_id
2280: AND b.proj_element_id = c.proj_element_id
2291:
2292: CURSOR cur_struc_ver_wp
2293: IS
2294: SELECT c.element_version_id
2295: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
2296: ,pa_proj_elem_ver_structure d
2297: WHERE c.project_id = p_project_id
2298: AND a.structure_type_id = b.structure_type_id
2299: AND b.proj_element_id = c.proj_element_id
2359:
2360: CURSOR cur_pa_proj_elem_vers2( c_task_version_id NUMBER )
2361: IS
2362: SELECT 'x'
2363: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
2364: WHERE c.project_id = p_project_id
2365: AND a.structure_type_id = b.structure_type_id
2366: AND b.proj_element_id = c.proj_element_id
2367: AND a.structure_type = 'WORKPLAN'
2397: /* Bug 2736392 Begin */
2398: CURSOR cur_struc_ver_wp2
2399: IS
2400: SELECT c.element_version_id
2401: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
2402: ,pa_proj_elem_ver_structure d
2403: WHERE c.project_id = p_project_id
2404: AND a.structure_type_id = b.structure_type_id
2405: AND b.proj_element_id = c.proj_element_id
3739:
3740: END LOOP;
3741:
3742: FOR cur_proj_elems_rec IN cur_proj_elems LOOP
3743: DELETE FROM pa_proj_structure_types
3744: WHERE proj_element_id = cur_proj_elems_rec.proj_element_id;
3745:
3746: PA_PROJ_ELEMENTS_PKG.DELETE_ROW( cur_proj_elems_rec.rowid );
3747: END LOOP;
3817:
3818: CURSOR cur_pub_versions is
3819: select 'Y'
3820: from pa_proj_elem_ver_structure ppevs,
3821: pa_proj_structure_types ppst,
3822: pa_structure_types pst
3823: where ppevs.project_id = p_project_id
3824: and ppevs.STATUS_CODE = 'STRUCTURE_PUBLISHED'
3825: and ppevs.proj_element_id = ppst.proj_element_id
3997:
3998: CURSOR cur_pa_proj_elem_vers2
3999: IS
4000: SELECT element_version_id
4001: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
4002: WHERE c.project_id = p_project_id
4003: AND a.structure_type_id = b.structure_type_id
4004: AND b.proj_element_id = c.proj_element_id
4005: AND a.structure_type = 'WORKPLAN';
4150: THEN
4151: OPEN cur_struc_type_id;
4152: FETCH cur_struc_type_id INTO l_structure_type_id;
4153: CLOSE cur_struc_type_id;
4154: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
4155: X_ROWID => l_rowid
4156: , X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
4157: , X_PROJ_ELEMENT_ID => cur_pa_proj_elems_rec.proj_element_id
4158: , X_STRUCTURE_TYPE_ID => l_structure_type_id
4405:
4406: CURSOR cur_pa_proj_elem_vers
4407: IS
4408: SELECT element_version_id
4409: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
4410: WHERE c.project_id = p_project_id
4411: AND a.structure_type_id = b.structure_type_id
4412: AND b.proj_element_id = c.proj_element_id
4413: AND a.structure_type = 'FINANCIAL';
4985: x_pev_schedule_id NUMBER;
4986:
4987: cursor c2 is
4988: select b.proj_element_id
4989: from pa_proj_elements a, pa_proj_structure_types b,
4990: pa_structure_types c
4991: where a.project_id = p_project_id
4992: and a.object_type = 'PA_STRUCTURES'
4993: and a.proj_element_id = b.proj_element_id
5738: WHERE project_id = p_project_id
5739: AND object_type = 'PA_STRUCTURES';
5740: */
5741: SELECT 'x'
5742: FROM pa_proj_elements ppe, pa_proj_structure_types ppst
5743: WHERE ppe.project_id = p_project_id
5744: AND ppe.object_type = 'PA_STRUCTURES'
5745: AND ppe.proj_element_id = ppst.proj_element_id
5746: AND ppst.structure_type_id = 1; --'WORKPLAN'
5778: ) RETURN VARCHAR2 IS
5779: CURSOR cur_pa_proj_elems
5780: IS
5781: SELECT ppe.proj_element_id
5782: FROM pa_proj_elements ppe, pa_proj_structure_types ppst
5783: WHERE ppe.project_id = p_project_id
5784: AND ppe.object_type = 'PA_STRUCTURES'
5785: AND ppe.proj_element_id = ppst.proj_element_id
5786: AND ppst.structure_type_id = 1; --'WORKPLAN'
5865: FROM pa_proj_elements pelem
5866: WHERE project_id = c_project_id
5867: AND pm_source_reference = c_pm_source_reference
5868: AND exists(select 1
5869: from pa_proj_structure_types pstype, pa_structure_types types
5870: where pstype.proj_element_id = pelem.parent_structure_id
5871: and pstype.structure_type_id = types.structure_type_id
5872: and types.structure_type = p_structure_type);
5873: --End Added by rtarway for BUG 3990873
6340: --This cursor fetches the workplan structure attributes
6341: CURSOR cur_get_wp_attr IS
6342: SELECT ppwa.WP_ENABLE_VERSION_FLAG
6343: FROM pa_proj_workplan_attr ppwa
6344: ,pa_proj_structure_types ppst
6345: ,pa_structure_types pst
6346: WHERE ppwa.project_id = p_src_project_id
6347: AND ppwa.proj_element_id = ppst.proj_element_id
6348: AND ppst.structure_type_id = pst.structure_type_id
6373: --This cursor retrieves the version for the financial structure form the source project
6374: CURSOR cur_get_split_fin_ver IS
6375: SELECT ppev.element_version_id
6376: FROM pa_proj_element_versions ppev,
6377: pa_proj_structure_types ppst,
6378: pa_structure_types pst
6379: WHERE ppev.project_id = p_src_project_id
6380: AND ppev.object_type = 'PA_STRUCTURES'
6381: AND ppev.proj_element_id = ppst.proj_element_id
6789: --This cursor retrieves the version for the financial structure form the source project
6790: CURSOR cur_get_split_fin_ver IS
6791: SELECT ppev.element_version_id
6792: FROM pa_proj_element_versions ppev,
6793: pa_proj_structure_types ppst,
6794: pa_structure_types pst
6795: WHERE ppev.project_id = p_src_project_id
6796: AND ppev.object_type = 'PA_STRUCTURES'
6797: AND ppev.proj_element_id = ppst.proj_element_id
7604: --This cursor fetches the workplan structure attributes
7605: CURSOR cur_get_wp_attr IS
7606: SELECT ppwa.WP_ENABLE_VERSION_FLAG
7607: FROM pa_proj_workplan_attr ppwa
7608: ,pa_proj_structure_types ppst
7609: ,pa_structure_types pst
7610: WHERE ppwa.project_id = p_src_project_id
7611: AND ppwa.proj_element_id = ppst.proj_element_id
7612: AND ppst.structure_type_id = pst.structure_type_id
7631: CURSOR cur_get_dest_structure_id( c_structure_type IN VARCHAR2 ) IS
7632: SELECT ppe.proj_element_id,
7633: ppe.attribute15
7634: FROM pa_proj_elements ppe,
7635: pa_proj_structure_types ppst,
7636: pa_structure_types pst
7637: WHERE ppe.project_id = p_dest_project_id
7638: AND ppe.object_type = 'PA_STRUCTURES'
7639: AND ppe.proj_element_id = ppst.proj_element_id
7717:
7718: CURSOR c_only_wp_ver_id(l_proj_id IN NUMBER) IS
7719: SELECT ppv.element_version_id
7720: FROM pa_proj_element_versions ppv ,
7721: pa_proj_structure_types pps,
7722: pa_structure_types pst
7723: WHERE ppv.proj_element_id = pps.proj_element_id
7724: AND ppv.object_type = 'PA_STRUCTURES'
7725: AND pps.structure_type_id = pst.structure_type_id
7816: --3916763 Begin
7817: CURSOR c_get_approval_options IS
7818: SELECT wp_approval_reqd_flag, wp_auto_publish_flag, wp_approver_source_id
7819: FROM PA_PROJ_WORKPLAN_ATTR ppwa
7820: , PA_PROJ_STRUCTURE_TYPES ppst
7821: , PA_STRUCTURE_TYPES pst
7822: WHERE ppwa.PROJECT_ID = p_src_project_id
7823: AND ppwa.PROJ_ELEMENT_ID = ppst.PROJ_ELEMENT_ID
7824: AND ppst.structure_type_id = pst.structure_type_id
8207: WHERE ppe.project_id = p_src_project_id
8208: AND ppe.proj_element_id IN
8209: ( SELECT ppe2.proj_element_id
8210: FROM pa_proj_elements ppe2
8211: ,pa_proj_structure_types ppst
8212: ,pa_structure_types pst
8213: WHERE ppe2.project_id = p_src_project_id
8214: AND ppe2.object_type = 'PA_STRUCTURES'
8215: AND ppe2.proj_element_id = ppst.proj_element_id
8230: UPDATE pa_proj_elements ppe
8231: SET name = substr(p_dest_project_name||l_append||l_suffix, 1, 240)
8232: WHERE project_id = p_dest_project_id
8233: AND object_type = 'PA_STRUCTURES'
8234: AND EXISTS ( SELECT proj_element_id FROM pa_proj_structure_types
8235: WHERE proj_element_id = ppe.proj_element_id
8236: AND structure_type_id = 1 );
8237: END IF;
8238:
8235: WHERE proj_element_id = ppe.proj_element_id
8236: AND structure_type_id = 1 );
8237: END IF;
8238:
8239: --Copy entries in pa_proj_structure_types for financial and workplan structures
8240: INSERT INTO PA_PROJ_STRUCTURE_TYPES(
8241: PROJ_STRUCTURE_TYPE_ID
8242: ,PROJ_ELEMENT_ID
8243: ,STRUCTURE_TYPE_ID
8236: AND structure_type_id = 1 );
8237: END IF;
8238:
8239: --Copy entries in pa_proj_structure_types for financial and workplan structures
8240: INSERT INTO PA_PROJ_STRUCTURE_TYPES(
8241: PROJ_STRUCTURE_TYPE_ID
8242: ,PROJ_ELEMENT_ID
8243: ,STRUCTURE_TYPE_ID
8244: ,CREATION_DATE
8247: ,LAST_UPDATED_BY
8248: ,LAST_UPDATE_LOGIN
8249: ,RECORD_VERSION_NUMBER )
8250: SELECT
8251: pa_proj_structure_types_s.nextval
8252: ,ppe.proj_element_id
8253: ,ppst.structure_type_id --structure type
8254: ,sysdate
8255: ,l_user_id
8257: ,l_user_id
8258: ,l_login_id
8259: ,1
8260: FROM pa_proj_elements ppe,
8261: pa_proj_structure_types ppst
8262: WHERE ppe.project_id = p_dest_project_id
8263: AND ppe.attribute15 IN --DoNot use PA_PROJ_ELEMENTS_UTILS.check_fin_or_wp_structure( ppe.attribute15 ) = 'Y'
8264: ( SELECT ppe2.proj_element_id
8265: FROM pa_proj_elements ppe2
8262: WHERE ppe.project_id = p_dest_project_id
8263: AND ppe.attribute15 IN --DoNot use PA_PROJ_ELEMENTS_UTILS.check_fin_or_wp_structure( ppe.attribute15 ) = 'Y'
8264: ( SELECT ppe2.proj_element_id
8265: FROM pa_proj_elements ppe2
8266: ,pa_proj_structure_types ppst
8267: ,pa_structure_types pst
8268: WHERE ppe2.project_id = p_src_project_id
8269: AND ppe2.object_type = 'PA_STRUCTURES'
8270: AND ppe2.proj_element_id = ppst.proj_element_id
8269: AND ppe2.object_type = 'PA_STRUCTURES'
8270: AND ppe2.proj_element_id = ppst.proj_element_id
8271: AND ppst.structure_type_id = pst.structure_type_id
8272: AND pst.structure_type IN ('WORKPLAN','FINANCIAL') )
8273: AND ppe.attribute15 = ppst.proj_element_id ; --proj_element_id is unique in pa_proj_structure_types
8274:
8275: --Copy workplan attributes for financial and workplan structures
8276: INSERT INTO pa_proj_workplan_attr(
8277: PROJ_ELEMENT_ID
10016: AND ppev.proj_element_id = ppe.proj_element_id
10017: AND ppev.parent_structure_version_id =
10018: ( SELECT ppevst.element_version_id --Changed the inner query for bug 4215666.
10019: FROM pa_proj_elem_ver_structure ppevst,
10020: pa_proj_structure_types struc,
10021: pa_structure_types stype
10022: WHERE ppevst.project_id = p_dest_project_id
10023: AND ppevst.current_flag = 'Y'
10024: AND ppevst.status_code = 'STRUCTURE_PUBLISHED'
10033: UPDATE pa_projects_all
10034: SET ( BASELINE_START_DATE ,BASELINE_FINISH_DATE, baseline_duration, baseline_as_of_date ) =
10035: ( SELECT BASELINE_START_DATE ,BASELINE_FINISH_DATE, baseline_duration,
10036: decode( BASELINE_START_DATE, null, null, sysdate)
10037: FROM pa_proj_elements ppe, pa_proj_structure_types ppst
10038: WHERE project_id = p_dest_project_id
10039: AND object_type = 'PA_STRUCTURES'
10040: AND ppe.proj_element_id = ppst.proj_element_id
10041: AND ppst.structure_type_id = 1
10596:
10597: /* Code Addition starts for bug 3737444 */
10598: CURSOR get_wp_attr IS
10599: select * from pa_proj_workplan_attr pppa where pppa.project_id=p_src_project_id
10600: and exists (select null from pa_proj_structure_types pst, pa_structure_types ps
10601: where pst.structure_type_id=ps.structure_type_id
10602: and ps. STRUCTURE_TYPE ='WORKPLAN'
10603: and pst.proj_element_id=pppa.proj_element_id);
10604:
10615: FROM PA_PROJ_ELEM_ver_structure ppevs
10616: WHERE project_id = p_src_project_id;*//*Commented below query and following criteria by SMUKKA */
10617: select ppevs.*
10618: from pa_structure_types pst,
10619: pa_proj_structure_types ppst,
10620: pa_proj_elem_ver_structure ppevs
10621: where ppevs.project_id = p_src_project_id
10622: and ppevs.proj_element_id= ppst.proj_element_id
10623: and ppst.structure_type_id = pst.structure_type_id
10627: IS
10628: SELECT ppevs.element_version_id, ppevs.status_code, ppevs.LATEST_EFF_PUBLISHED_FLAG, ppevs.current_flag,
10629: ppst.structure_type_id
10630: /* FROM PA_PROJ_ELEM_ver_structure ppevs,
10631: pa_proj_structure_types ppst
10632: WHERE project_id = p_src_project_id
10633: AND ppst.proj_element_id(+) = ppevs.proj_element_id;*//*Commented below query and following criteria by SMUKKA */
10634: from pa_proj_elem_ver_structure ppevs,
10635: pa_proj_structure_types ppst,
10631: pa_proj_structure_types ppst
10632: WHERE project_id = p_src_project_id
10633: AND ppst.proj_element_id(+) = ppevs.proj_element_id;*//*Commented below query and following criteria by SMUKKA */
10634: from pa_proj_elem_ver_structure ppevs,
10635: pa_proj_structure_types ppst,
10636: pa_structure_types pst
10637: where project_id = p_src_project_id
10638: and ppst.proj_element_id(+) = ppevs.proj_element_id
10639: and ppst.structure_type_id = pst.structure_type_id
10740: --bug 3138959
10741:
10742: CURSOR cur_pa_struct IS
10743: SELECT ppe.proj_element_id, ppe.attribute15, ppst.structure_type_id
10744: /* FROM pa_proj_elements ppe, pa_proj_structure_types ppst
10745: WHERE ppe.proj_element_id = ppst.proj_element_id
10746: AND ppe.project_id = p_dest_project_id
10747: AND ppe.object_type = 'PA_STRUCTURES';*//*Commented below query and following criteria by SMUKKA */
10748: from pa_proj_elements ppe,
10745: WHERE ppe.proj_element_id = ppst.proj_element_id
10746: AND ppe.project_id = p_dest_project_id
10747: AND ppe.object_type = 'PA_STRUCTURES';*//*Commented below query and following criteria by SMUKKA */
10748: from pa_proj_elements ppe,
10749: pa_proj_structure_types ppst,
10750: pa_structure_types pst
10751: where ppe.proj_element_id =ppst.proj_element_id
10752: and ppe.project_id = p_dest_project_id
10753: and ppe.object_type = 'PA_STRUCTURES'
10789: /* from pa_proj_elements
10790: where project_id = p_dest_project_id
10791: and object_type = 'PA_STRUCTURES';*//*Commented below query and following criteria by SMUKKA */
10792: from pa_proj_elements ppe,
10793: pa_proj_structure_types ppst,
10794: pa_structure_types pst
10795: where project_id = p_dest_project_id
10796: and object_type = 'PA_STRUCTURES'
10797: and ppe.proj_element_id =ppst.proj_element_id
11023: where ppe.project_id = p_src_project_id
11024: and ppe.object_type = 'PA_STRUCTURES'
11025: and ppe.proj_element_id IN (select ppe2.proj_element_id
11026: from pa_proj_elements ppe2,
11027: pa_proj_structure_types ppst,
11028: pa_structure_types pst
11029: where ppe2.project_id = p_src_project_id
11030: and ppe2.object_type = 'PA_STRUCTURES'
11031: and ppe2.proj_element_id = ppst.proj_element_id
11040: AND object_type = 'PA_STRUCTURES'
11041: ;
11042:
11043:
11044: --Copy pa_proj_structure_types
11045:
11046: INSERT INTO PA_PROJ_STRUCTURE_TYPES(
11047: PROJ_STRUCTURE_TYPE_ID
11048: ,PROJ_ELEMENT_ID
11042:
11043:
11044: --Copy pa_proj_structure_types
11045:
11046: INSERT INTO PA_PROJ_STRUCTURE_TYPES(
11047: PROJ_STRUCTURE_TYPE_ID
11048: ,PROJ_ELEMENT_ID
11049: ,STRUCTURE_TYPE_ID
11050: ,CREATION_DATE
11053: ,LAST_UPDATED_BY
11054: ,LAST_UPDATE_LOGIN
11055: ,RECORD_VERSION_NUMBER )
11056: SELECT
11057: pa_proj_structure_types_s.nextval
11058: , ppe.proj_element_id
11059: , ppst.structure_type_id --structure type
11060: , sysdate
11061: , l_user_id
11062: , sysdate
11063: , l_user_id
11064: , l_login_id
11065: , 1
11066: /*from pa_proj_elements ppe, pa_proj_structure_types ppst
11067: where ppe.project_id = p_dest_project_id
11068: and ppe.attribute15 = ppst.proj_element_id ---join with copy_from_proj_element_id to get the structure types
11069: and ppe.object_type = 'PA_STRUCTURES';*//*Commented below query and following criteria by SMUKKA */
11070: from pa_proj_elements ppe,
11067: where ppe.project_id = p_dest_project_id
11068: and ppe.attribute15 = ppst.proj_element_id ---join with copy_from_proj_element_id to get the structure types
11069: and ppe.object_type = 'PA_STRUCTURES';*//*Commented below query and following criteria by SMUKKA */
11070: from pa_proj_elements ppe,
11071: pa_proj_structure_types ppst,
11072: pa_structure_types pst
11073: where ppe.project_id = p_dest_project_id
11074: and ppe.attribute15 = ppst.proj_element_id
11075: and ppe.object_type = 'PA_STRUCTURES'
11398: and ppev.object_type = 'PA_STRUCTURES'
11399: and ppe.proj_element_id IN
11400: (select ppe2.proj_element_id
11401: from pa_proj_elements ppe2,
11402: pa_proj_structure_types ppst,
11403: pa_structure_types pst
11404: -- where ppe2.project_id = p_src_project_id
11405: where ppe2.project_id = p_dest_project_id --Bug 3585699 SMukka Replaced p_src_project_id by p_dest_project_id
11406: and ppe2.object_type = 'PA_STRUCTURES'
11418: WHERE project_id = p_src_project_id
11419: AND object_type = 'PA_STRUCTURES'
11420: and proj_element_id IN (select ppe2.proj_element_id
11421: from pa_proj_elements ppe2,
11422: pa_proj_structure_types ppst,
11423: pa_structure_types pst
11424: where ppe2.project_id = p_src_project_id
11425: and ppe2.object_type = 'PA_STRUCTURES'
11426: and ppe2.proj_element_id = ppst.proj_element_id
11514: and ppevs.proj_element_id = ppe.attribute15
11515: AND ppe.object_type = 'PA_STRUCTURES'
11516: and ppe.proj_element_id IN (SELECT ppe2.proj_element_id
11517: FROM pa_proj_elements ppe2,
11518: pa_proj_structure_types ppst,
11519: pa_structure_types pst
11520: WHERE ppe2.project_id = p_dest_project_id
11521: AND ppe2.object_type = 'PA_STRUCTURES'
11522: AND ppe2.proj_element_id = ppst.proj_element_id
12005: UPDATE pa_proj_elements ppe
12006: set name = substr(l_project_name||l_append||l_suffix, 1, 240)
12007: WHERE project_id = p_dest_project_id
12008: AND object_type = 'PA_STRUCTURES'
12009: AND EXISTS ( SELECT proj_element_id FROM pa_proj_structure_types
12010: WHERE proj_element_id = ppe.proj_element_id
12011: AND structure_type_id = 1 );
12012: END IF;
12013:
12799: and ppevs.element_version_id = ppevst.element_version_id
12800: )
12801: WHERE project_id = p_dest_project_id;
12802: -- and object_type = 'PA_STRUCTURES'
12803: -- and EXISTS ( SELECT proj_element_id FROM pa_proj_structure_types
12804: -- WHERE proj_element_id = ppe.proj_element_id
12805: -- AND structure_type_id = 1 );
12806:
12807: --updating projects dates
12808: update pa_projects_all
12809: set ( BASELINE_START_DATE ,BASELINE_FINISH_DATE, baseline_duration, baseline_as_of_date) =
12810: ( SELECT BASELINE_START_DATE ,BASELINE_FINISH_DATE, baseline_duration,
12811: decode(BASELINE_START_DATE, null, null, sysdate)
12812: FROM pa_proj_elements ppe, pa_proj_structure_types ppst
12813: WHERE project_id = p_dest_project_id
12814: and object_type = 'PA_STRUCTURES'
12815: and ppe.proj_element_id = ppst.proj_element_id
12816: and ppst.structure_type_id = 1 )
12926:
12927: CURSOR cur_strs_n_types
12928: IS
12929: SELECT ppe.proj_element_id, ppst.structure_type_id
12930: FROM pa_proj_elements ppe, pa_proj_structure_types ppst
12931: WHERE ppe.project_id = p_dest_project_id
12932: AND ppe.object_type = 'PA_STRUCTURES'
12933: AND ppe.proj_element_id = ppst.proj_element_id
12934: ;
13299: -- This cursor is used to get the structure id given the structure type and project_id
13300: CURSOR get_structure(c_project_id pa_projects_all.project_id%TYPE, c_struc_type pa_structure_types.structure_type_class_code%TYPE) IS
13301: select pelem.proj_element_id
13302: from pa_proj_elements pelem,
13303: pa_proj_structure_types ppstr,
13304: pa_structure_types pstr
13305: where pelem.project_id = c_project_id
13306: and pstr.structure_type_class_code = c_struc_type
13307: and pstr.structure_type_id = ppstr.structure_type_id
13573: FROM pa_proj_elements pelem
13574: WHERE project_id = c_project_id
13575: AND pm_source_reference = c_pm_source_reference
13576: AND exists(select 1
13577: from pa_proj_structure_types pstype, pa_structure_types types
13578: where pstype.proj_element_id = pelem.parent_structure_id
13579: and pstype.structure_type_id = types.structure_type_id
13580: and types.structure_type = p_structure_type);
13581: -- Amit Bug 3964548 End
13654: -- Bug 6717386
13655: CURSOR cur_struc_ver_wp(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)
13656: IS
13657: SELECT c.element_version_id
13658: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
13659: ,pa_proj_elem_ver_structure d
13660: WHERE c.project_id = c_project_id
13661: AND a.structure_type_id = b.structure_type_id
13662: AND b.proj_element_id = c.proj_element_id
14225: FROM pa_proj_elements pelem
14226: WHERE project_id = c_project_id
14227: AND pm_source_reference = c_pm_source_reference
14228: AND exists(select 1
14229: from pa_proj_structure_types pstype, pa_structure_types types
14230: where pstype.proj_element_id = pelem.parent_structure_id
14231: and pstype.structure_type_id = types.structure_type_id
14232: and types.structure_type = p_structure_type);
14233: BEGIN
17762: c_structure_type pa_structure_types.structure_type%TYPE)
17763: IS
17764: select 'Y'
17765: from pa_proj_element_versions ver,
17766: pa_proj_structure_types pst,
17767: pa_structure_types st
17768: where ver.element_version_id = c_structure_version_id
17769: and ver.project_id = c_project_id
17770: and pst.proj_element_id = ver.proj_element_id
18457: c_structure_type pa_structure_types.structure_type%TYPE)
18458: IS
18459: SELECT 'Y'
18460: FROM pa_proj_element_versions ver,
18461: pa_proj_structure_types pst,
18462: pa_structure_types st
18463: WHERE ver.element_version_id = c_structure_version_id
18464: AND ver.project_id = c_project_id
18465: AND pst.proj_element_id = ver.proj_element_id
21116:
21117: CURSOR cur_strs_n_types
21118: IS
21119: SELECT ppe.proj_element_id, ppst.structure_type_id
21120: FROM pa_proj_elements ppe, pa_proj_structure_types ppst, pa_structure_types pst
21121: WHERE ppe.project_id = p_dest_project_id
21122: AND ppe.object_type = 'PA_STRUCTURES'
21123: AND ppe.proj_element_id = ppst.proj_element_id
21124: and ppst.structure_type_id = pst.structure_type_id
21342: ppwa.txn_date_sync_buf_days,
21343: ppwa.lifecycle_version_id
21344: from pa_proj_workplan_attr ppwa,
21345: pa_proj_elements ppe,
21346: pa_proj_structure_types ppst
21347: where ppwa.project_id = c_project_id
21348: and ppwa.project_id = ppe.project_id
21349: and ppwa.proj_element_id = ppe.proj_element_id
21350: and ppe.proj_element_id = ppst.proj_element_id