[Home] [Help]
521:
522: CURSOR cur_pa_proj_elem_vers2( c_strcu_ver_id NUMBER )
523: IS
524: SELECT 'x'
525: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
526: WHERE c.project_id = p_project_id
527: AND a.structure_type_id = b.structure_type_id
528: AND b.proj_element_id = c.proj_element_id
529: AND a.structure_type = 'WORKPLAN'
542: --hsiu added for parent_structure_id column
543: CURSOR get_structure(c_project_id NUMBER, c_struc_type VARCHAR2) IS
544: select a.proj_element_id
545: from pa_proj_elements a,
546: pa_proj_structure_types b,
547: pa_structure_types c
548: where a.project_id = c_project_id
549: and c.structure_type_class_code = c_struc_type
550: and c.structure_type_id = b.structure_type_id
575: CURSOR cur_proj_elem_vers
576: IS
577: SELECT ppev.element_version_id
578: FROM pa_proj_element_versions ppev,
579: pa_proj_structure_types ppst,
580: pa_structure_types pst
581: WHERE ppev.project_id = p_project_id
582: AND ppev.object_type = 'PA_STRUCTURES'
583: AND ppev.proj_element_id = ppst.proj_element_id
1041:
1042: CURSOR cur_pa_proj_elem_vers2( c_task_version_id NUMBER )
1043: IS
1044: SELECT 'x'
1045: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
1046: WHERE c.project_id = p_project_id
1047: AND a.structure_type_id = b.structure_type_id
1048: AND b.proj_element_id = c.proj_element_id
1049: AND a.structure_type = 'WORKPLAN'
1095:
1096: CURSOR cur_struc_ver_fin
1097: IS
1098: SELECT c.element_version_id
1099: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
1100: ,pa_proj_elem_ver_structure d
1101: WHERE c.project_id = p_project_id
1102: AND a.structure_type_id = b.structure_type_id
1103: AND b.proj_element_id = c.proj_element_id
1113:
1114: CURSOR cur_struc_ver_wp
1115: IS
1116: SELECT c.element_version_id
1117: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
1118: ,pa_proj_elem_ver_structure d
1119: WHERE c.project_id = p_project_id
1120: AND a.structure_type_id = b.structure_type_id
1121: AND b.proj_element_id = c.proj_element_id
1128: --hsiu added for parent_structure_id column
1129: CURSOR get_structure(c_project_id NUMBER, c_struc_type VARCHAR2) IS
1130: select a.proj_element_id
1131: from pa_proj_elements a,
1132: pa_proj_structure_types b,
1133: pa_structure_types c
1134: where a.project_id = c_project_id
1135: and c.structure_type_class_code = c_struc_type
1136: and c.structure_type_id = b.structure_type_id
1184: /* Bug 2736392 Begin */
1185: CURSOR cur_struc_ver_wp2
1186: IS
1187: SELECT c.element_version_id
1188: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
1189: ,pa_proj_elem_ver_structure d
1190: WHERE c.project_id = p_project_id
1191: AND a.structure_type_id = b.structure_type_id
1192: AND b.proj_element_id = c.proj_element_id
1336: join in the following cursor*/
1337:
1338: CURSOR c1 is
1339: SELECT c.element_version_id
1340: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
1341: ,pa_proj_elem_ver_structure d
1342: WHERE c.project_id = p_project_id
1343: AND a.structure_type_id = b.structure_type_id
1344: AND b.proj_element_id = c.proj_element_id
2489:
2490: CURSOR cur_struc_ver_fin
2491: IS
2492: SELECT c.element_version_id
2493: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
2494: ,pa_proj_elem_ver_structure d
2495: WHERE c.project_id = p_project_id
2496: AND a.structure_type_id = b.structure_type_id
2497: AND b.proj_element_id = c.proj_element_id
2508:
2509: CURSOR cur_struc_ver_wp
2510: IS
2511: SELECT c.element_version_id
2512: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
2513: ,pa_proj_elem_ver_structure d
2514: WHERE c.project_id = p_project_id
2515: AND a.structure_type_id = b.structure_type_id
2516: AND b.proj_element_id = c.proj_element_id
2576:
2577: CURSOR cur_pa_proj_elem_vers2( c_task_version_id NUMBER )
2578: IS
2579: SELECT 'x'
2580: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
2581: WHERE c.project_id = p_project_id
2582: AND a.structure_type_id = b.structure_type_id
2583: AND b.proj_element_id = c.proj_element_id
2584: AND a.structure_type = 'WORKPLAN'
2614: /* Bug 2736392 Begin */
2615: CURSOR cur_struc_ver_wp2
2616: IS
2617: SELECT c.element_version_id
2618: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
2619: ,pa_proj_elem_ver_structure d
2620: WHERE c.project_id = p_project_id
2621: AND a.structure_type_id = b.structure_type_id
2622: AND b.proj_element_id = c.proj_element_id
3960:
3961: END LOOP;
3962:
3963: FOR cur_proj_elems_rec IN cur_proj_elems LOOP
3964: DELETE FROM pa_proj_structure_types
3965: WHERE proj_element_id = cur_proj_elems_rec.proj_element_id;
3966:
3967: PA_PROJ_ELEMENTS_PKG.DELETE_ROW( cur_proj_elems_rec.rowid );
3968: END LOOP;
4038:
4039: CURSOR cur_pub_versions is
4040: select 'Y'
4041: from pa_proj_elem_ver_structure ppevs,
4042: pa_proj_structure_types ppst,
4043: pa_structure_types pst
4044: where ppevs.project_id = p_project_id
4045: and ppevs.STATUS_CODE = 'STRUCTURE_PUBLISHED'
4046: and ppevs.proj_element_id = ppst.proj_element_id
4218:
4219: CURSOR cur_pa_proj_elem_vers2
4220: IS
4221: SELECT element_version_id
4222: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
4223: WHERE c.project_id = p_project_id
4224: AND a.structure_type_id = b.structure_type_id
4225: AND b.proj_element_id = c.proj_element_id
4226: AND a.structure_type = 'WORKPLAN';
4371: THEN
4372: OPEN cur_struc_type_id;
4373: FETCH cur_struc_type_id INTO l_structure_type_id;
4374: CLOSE cur_struc_type_id;
4375: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
4376: X_ROWID => l_rowid
4377: , X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
4378: , X_PROJ_ELEMENT_ID => cur_pa_proj_elems_rec.proj_element_id
4379: , X_STRUCTURE_TYPE_ID => l_structure_type_id
4626:
4627: CURSOR cur_pa_proj_elem_vers
4628: IS
4629: SELECT element_version_id
4630: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
4631: WHERE c.project_id = p_project_id
4632: AND a.structure_type_id = b.structure_type_id
4633: AND b.proj_element_id = c.proj_element_id
4634: AND a.structure_type = 'FINANCIAL';
5206: x_pev_schedule_id NUMBER;
5207:
5208: cursor c2 is
5209: select b.proj_element_id
5210: from pa_proj_elements a, pa_proj_structure_types b,
5211: pa_structure_types c
5212: where a.project_id = p_project_id
5213: and a.object_type = 'PA_STRUCTURES'
5214: and a.proj_element_id = b.proj_element_id
5959: WHERE project_id = p_project_id
5960: AND object_type = 'PA_STRUCTURES';
5961: */
5962: SELECT 'x'
5963: FROM pa_proj_elements ppe, pa_proj_structure_types ppst
5964: WHERE ppe.project_id = p_project_id
5965: AND ppe.object_type = 'PA_STRUCTURES'
5966: AND ppe.proj_element_id = ppst.proj_element_id
5967: AND ppst.structure_type_id = 1; --'WORKPLAN'
5999: ) RETURN VARCHAR2 IS
6000: CURSOR cur_pa_proj_elems
6001: IS
6002: SELECT ppe.proj_element_id
6003: FROM pa_proj_elements ppe, pa_proj_structure_types ppst
6004: WHERE ppe.project_id = p_project_id
6005: AND ppe.object_type = 'PA_STRUCTURES'
6006: AND ppe.proj_element_id = ppst.proj_element_id
6007: AND ppst.structure_type_id = 1; --'WORKPLAN'
6089: FROM pa_proj_elements pelem
6090: WHERE project_id = c_project_id
6091: AND pm_source_reference = c_pm_source_reference
6092: AND exists(select 1
6093: from pa_proj_structure_types pstype, pa_structure_types types
6094: where pstype.proj_element_id = pelem.parent_structure_id
6095: and pstype.structure_type_id = types.structure_type_id
6096: and types.structure_type = p_structure_type);
6097: --End Added by rtarway for BUG 3990873
6589: --This cursor fetches the workplan structure attributes
6590: CURSOR cur_get_wp_attr IS
6591: SELECT ppwa.WP_ENABLE_VERSION_FLAG
6592: FROM pa_proj_workplan_attr ppwa
6593: ,pa_proj_structure_types ppst
6594: ,pa_structure_types pst
6595: WHERE ppwa.project_id = p_src_project_id
6596: AND ppwa.proj_element_id = ppst.proj_element_id
6597: AND ppst.structure_type_id = pst.structure_type_id
6622: --This cursor retrieves the version for the financial structure form the source project
6623: CURSOR cur_get_split_fin_ver IS
6624: SELECT ppev.element_version_id
6625: FROM pa_proj_element_versions ppev,
6626: pa_proj_structure_types ppst,
6627: pa_structure_types pst
6628: WHERE ppev.project_id = p_src_project_id
6629: AND ppev.object_type = 'PA_STRUCTURES'
6630: AND ppev.proj_element_id = ppst.proj_element_id
7038: --This cursor retrieves the version for the financial structure form the source project
7039: CURSOR cur_get_split_fin_ver IS
7040: SELECT ppev.element_version_id
7041: FROM pa_proj_element_versions ppev,
7042: pa_proj_structure_types ppst,
7043: pa_structure_types pst
7044: WHERE ppev.project_id = p_src_project_id
7045: AND ppev.object_type = 'PA_STRUCTURES'
7046: AND ppev.proj_element_id = ppst.proj_element_id
7853: --This cursor fetches the workplan structure attributes
7854: CURSOR cur_get_wp_attr IS
7855: SELECT ppwa.WP_ENABLE_VERSION_FLAG
7856: FROM pa_proj_workplan_attr ppwa
7857: ,pa_proj_structure_types ppst
7858: ,pa_structure_types pst
7859: WHERE ppwa.project_id = p_src_project_id
7860: AND ppwa.proj_element_id = ppst.proj_element_id
7861: AND ppst.structure_type_id = pst.structure_type_id
7880: CURSOR cur_get_dest_structure_id( c_structure_type IN VARCHAR2 ) IS
7881: SELECT ppe.proj_element_id,
7882: ppe.attribute15
7883: FROM pa_proj_elements ppe,
7884: pa_proj_structure_types ppst,
7885: pa_structure_types pst
7886: WHERE ppe.project_id = p_dest_project_id
7887: AND ppe.object_type = 'PA_STRUCTURES'
7888: AND ppe.proj_element_id = ppst.proj_element_id
7966:
7967: CURSOR c_only_wp_ver_id(l_proj_id IN NUMBER) IS
7968: SELECT ppv.element_version_id
7969: FROM pa_proj_element_versions ppv ,
7970: pa_proj_structure_types pps,
7971: pa_structure_types pst
7972: WHERE ppv.proj_element_id = pps.proj_element_id
7973: AND ppv.object_type = 'PA_STRUCTURES'
7974: AND pps.structure_type_id = pst.structure_type_id
8065: --3916763 Begin
8066: CURSOR c_get_approval_options IS
8067: SELECT wp_approval_reqd_flag, wp_auto_publish_flag, wp_approver_source_id
8068: FROM PA_PROJ_WORKPLAN_ATTR ppwa
8069: , PA_PROJ_STRUCTURE_TYPES ppst
8070: , PA_STRUCTURE_TYPES pst
8071: WHERE ppwa.PROJECT_ID = p_src_project_id
8072: AND ppwa.PROJ_ELEMENT_ID = ppst.PROJ_ELEMENT_ID
8073: AND ppst.structure_type_id = pst.structure_type_id
8468: WHERE ppe.project_id = p_src_project_id
8469: AND ppe.proj_element_id IN
8470: ( SELECT ppe2.proj_element_id
8471: FROM pa_proj_elements ppe2
8472: ,pa_proj_structure_types ppst
8473: ,pa_structure_types pst
8474: WHERE ppe2.project_id = p_src_project_id
8475: AND ppe2.object_type = 'PA_STRUCTURES'
8476: AND ppe2.proj_element_id = ppst.proj_element_id
8491: UPDATE pa_proj_elements ppe
8492: SET name = substr(p_dest_project_name||l_append||l_suffix, 1, 240)
8493: WHERE project_id = p_dest_project_id
8494: AND object_type = 'PA_STRUCTURES'
8495: AND EXISTS ( SELECT proj_element_id FROM pa_proj_structure_types
8496: WHERE proj_element_id = ppe.proj_element_id
8497: AND structure_type_id = 1 );
8498: END IF;
8499:
8496: WHERE proj_element_id = ppe.proj_element_id
8497: AND structure_type_id = 1 );
8498: END IF;
8499:
8500: --Copy entries in pa_proj_structure_types for financial and workplan structures
8501: INSERT INTO PA_PROJ_STRUCTURE_TYPES(
8502: PROJ_STRUCTURE_TYPE_ID
8503: ,PROJ_ELEMENT_ID
8504: ,STRUCTURE_TYPE_ID
8497: AND structure_type_id = 1 );
8498: END IF;
8499:
8500: --Copy entries in pa_proj_structure_types for financial and workplan structures
8501: INSERT INTO PA_PROJ_STRUCTURE_TYPES(
8502: PROJ_STRUCTURE_TYPE_ID
8503: ,PROJ_ELEMENT_ID
8504: ,STRUCTURE_TYPE_ID
8505: ,CREATION_DATE
8508: ,LAST_UPDATED_BY
8509: ,LAST_UPDATE_LOGIN
8510: ,RECORD_VERSION_NUMBER )
8511: SELECT
8512: pa_proj_structure_types_s.nextval
8513: ,ppe.proj_element_id
8514: ,ppst.structure_type_id --structure type
8515: ,sysdate
8516: ,l_user_id
8518: ,l_user_id
8519: ,l_login_id
8520: ,1
8521: FROM pa_proj_elements ppe,
8522: pa_proj_structure_types ppst
8523: WHERE ppe.project_id = p_dest_project_id
8524: AND ppe.attribute15 IN --DoNot use PA_PROJ_ELEMENTS_UTILS.check_fin_or_wp_structure( ppe.attribute15 ) = 'Y'
8525: ( SELECT ppe2.proj_element_id
8526: FROM pa_proj_elements ppe2
8523: WHERE ppe.project_id = p_dest_project_id
8524: AND ppe.attribute15 IN --DoNot use PA_PROJ_ELEMENTS_UTILS.check_fin_or_wp_structure( ppe.attribute15 ) = 'Y'
8525: ( SELECT ppe2.proj_element_id
8526: FROM pa_proj_elements ppe2
8527: ,pa_proj_structure_types ppst
8528: ,pa_structure_types pst
8529: WHERE ppe2.project_id = p_src_project_id
8530: AND ppe2.object_type = 'PA_STRUCTURES'
8531: AND ppe2.proj_element_id = ppst.proj_element_id
8530: AND ppe2.object_type = 'PA_STRUCTURES'
8531: AND ppe2.proj_element_id = ppst.proj_element_id
8532: AND ppst.structure_type_id = pst.structure_type_id
8533: AND pst.structure_type IN ('WORKPLAN','FINANCIAL') )
8534: AND ppe.attribute15 = ppst.proj_element_id ; --proj_element_id is unique in pa_proj_structure_types
8535:
8536: --Copy workplan attributes for financial and workplan structures
8537: INSERT INTO pa_proj_workplan_attr(
8538: PROJ_ELEMENT_ID
10310: AND ppev.proj_element_id = ppe.proj_element_id
10311: AND ppev.parent_structure_version_id =
10312: ( SELECT ppevst.element_version_id --Changed the inner query for bug 4215666.
10313: FROM pa_proj_elem_ver_structure ppevst,
10314: pa_proj_structure_types struc,
10315: pa_structure_types stype
10316: WHERE ppevst.project_id = p_dest_project_id
10317: AND ppevst.current_flag = 'Y'
10318: AND ppevst.status_code = 'STRUCTURE_PUBLISHED'
10327: UPDATE pa_projects_all
10328: SET ( BASELINE_START_DATE ,BASELINE_FINISH_DATE, baseline_duration, baseline_as_of_date ) =
10329: ( SELECT BASELINE_START_DATE ,BASELINE_FINISH_DATE, baseline_duration,
10330: decode( BASELINE_START_DATE, null, null, sysdate)
10331: FROM pa_proj_elements ppe, pa_proj_structure_types ppst
10332: WHERE project_id = p_dest_project_id
10333: AND object_type = 'PA_STRUCTURES'
10334: AND ppe.proj_element_id = ppst.proj_element_id
10335: AND ppst.structure_type_id = 1
10911:
10912: /* Code Addition starts for bug 3737444 */
10913: CURSOR get_wp_attr IS
10914: select * from pa_proj_workplan_attr pppa where pppa.project_id=p_src_project_id
10915: and exists (select null from pa_proj_structure_types pst, pa_structure_types ps
10916: where pst.structure_type_id=ps.structure_type_id
10917: and ps. STRUCTURE_TYPE ='WORKPLAN'
10918: and pst.proj_element_id=pppa.proj_element_id);
10919:
10930: FROM PA_PROJ_ELEM_ver_structure ppevs
10931: WHERE project_id = p_src_project_id;*//*Commented below query and following criteria by SMUKKA */
10932: select ppevs.*
10933: from pa_structure_types pst,
10934: pa_proj_structure_types ppst,
10935: pa_proj_elem_ver_structure ppevs
10936: where ppevs.project_id = p_src_project_id
10937: and ppevs.proj_element_id= ppst.proj_element_id
10938: and ppst.structure_type_id = pst.structure_type_id
10942: IS
10943: SELECT ppevs.element_version_id, ppevs.status_code, ppevs.LATEST_EFF_PUBLISHED_FLAG, ppevs.current_flag,
10944: ppst.structure_type_id
10945: /* FROM PA_PROJ_ELEM_ver_structure ppevs,
10946: pa_proj_structure_types ppst
10947: WHERE project_id = p_src_project_id
10948: AND ppst.proj_element_id(+) = ppevs.proj_element_id;*//*Commented below query and following criteria by SMUKKA */
10949: from pa_proj_elem_ver_structure ppevs,
10950: pa_proj_structure_types ppst,
10946: pa_proj_structure_types ppst
10947: WHERE project_id = p_src_project_id
10948: AND ppst.proj_element_id(+) = ppevs.proj_element_id;*//*Commented below query and following criteria by SMUKKA */
10949: from pa_proj_elem_ver_structure ppevs,
10950: pa_proj_structure_types ppst,
10951: pa_structure_types pst
10952: where project_id = p_src_project_id
10953: and ppst.proj_element_id(+) = ppevs.proj_element_id
10954: and ppst.structure_type_id = pst.structure_type_id
11055: --bug 3138959
11056:
11057: CURSOR cur_pa_struct IS
11058: SELECT ppe.proj_element_id, ppe.attribute15, ppst.structure_type_id
11059: /* FROM pa_proj_elements ppe, pa_proj_structure_types ppst
11060: WHERE ppe.proj_element_id = ppst.proj_element_id
11061: AND ppe.project_id = p_dest_project_id
11062: AND ppe.object_type = 'PA_STRUCTURES';*//*Commented below query and following criteria by SMUKKA */
11063: from pa_proj_elements ppe,
11060: WHERE ppe.proj_element_id = ppst.proj_element_id
11061: AND ppe.project_id = p_dest_project_id
11062: AND ppe.object_type = 'PA_STRUCTURES';*//*Commented below query and following criteria by SMUKKA */
11063: from pa_proj_elements ppe,
11064: pa_proj_structure_types ppst,
11065: pa_structure_types pst
11066: where ppe.proj_element_id =ppst.proj_element_id
11067: and ppe.project_id = p_dest_project_id
11068: and ppe.object_type = 'PA_STRUCTURES'
11104: /* from pa_proj_elements
11105: where project_id = p_dest_project_id
11106: and object_type = 'PA_STRUCTURES';*//*Commented below query and following criteria by SMUKKA */
11107: from pa_proj_elements ppe,
11108: pa_proj_structure_types ppst,
11109: pa_structure_types pst
11110: where project_id = p_dest_project_id
11111: and object_type = 'PA_STRUCTURES'
11112: and ppe.proj_element_id =ppst.proj_element_id
11338: where ppe.project_id = p_src_project_id
11339: and ppe.object_type = 'PA_STRUCTURES'
11340: and ppe.proj_element_id IN (select ppe2.proj_element_id
11341: from pa_proj_elements ppe2,
11342: pa_proj_structure_types ppst,
11343: pa_structure_types pst
11344: where ppe2.project_id = p_src_project_id
11345: and ppe2.object_type = 'PA_STRUCTURES'
11346: and ppe2.proj_element_id = ppst.proj_element_id
11355: AND object_type = 'PA_STRUCTURES'
11356: ;
11357:
11358:
11359: --Copy pa_proj_structure_types
11360:
11361: INSERT INTO PA_PROJ_STRUCTURE_TYPES(
11362: PROJ_STRUCTURE_TYPE_ID
11363: ,PROJ_ELEMENT_ID
11357:
11358:
11359: --Copy pa_proj_structure_types
11360:
11361: INSERT INTO PA_PROJ_STRUCTURE_TYPES(
11362: PROJ_STRUCTURE_TYPE_ID
11363: ,PROJ_ELEMENT_ID
11364: ,STRUCTURE_TYPE_ID
11365: ,CREATION_DATE
11368: ,LAST_UPDATED_BY
11369: ,LAST_UPDATE_LOGIN
11370: ,RECORD_VERSION_NUMBER )
11371: SELECT
11372: pa_proj_structure_types_s.nextval
11373: , ppe.proj_element_id
11374: , ppst.structure_type_id --structure type
11375: , sysdate
11376: , l_user_id
11377: , sysdate
11378: , l_user_id
11379: , l_login_id
11380: , 1
11381: /*from pa_proj_elements ppe, pa_proj_structure_types ppst
11382: where ppe.project_id = p_dest_project_id
11383: and ppe.attribute15 = ppst.proj_element_id ---join with copy_from_proj_element_id to get the structure types
11384: and ppe.object_type = 'PA_STRUCTURES';*//*Commented below query and following criteria by SMUKKA */
11385: from pa_proj_elements ppe,
11382: where ppe.project_id = p_dest_project_id
11383: and ppe.attribute15 = ppst.proj_element_id ---join with copy_from_proj_element_id to get the structure types
11384: and ppe.object_type = 'PA_STRUCTURES';*//*Commented below query and following criteria by SMUKKA */
11385: from pa_proj_elements ppe,
11386: pa_proj_structure_types ppst,
11387: pa_structure_types pst
11388: where ppe.project_id = p_dest_project_id
11389: and ppe.attribute15 = ppst.proj_element_id
11390: and ppe.object_type = 'PA_STRUCTURES'
11713: and ppev.object_type = 'PA_STRUCTURES'
11714: and ppe.proj_element_id IN
11715: (select ppe2.proj_element_id
11716: from pa_proj_elements ppe2,
11717: pa_proj_structure_types ppst,
11718: pa_structure_types pst
11719: -- where ppe2.project_id = p_src_project_id
11720: where ppe2.project_id = p_dest_project_id --Bug 3585699 SMukka Replaced p_src_project_id by p_dest_project_id
11721: and ppe2.object_type = 'PA_STRUCTURES'
11733: WHERE project_id = p_src_project_id
11734: AND object_type = 'PA_STRUCTURES'
11735: and proj_element_id IN (select ppe2.proj_element_id
11736: from pa_proj_elements ppe2,
11737: pa_proj_structure_types ppst,
11738: pa_structure_types pst
11739: where ppe2.project_id = p_src_project_id
11740: and ppe2.object_type = 'PA_STRUCTURES'
11741: and ppe2.proj_element_id = ppst.proj_element_id
11829: and ppevs.proj_element_id = ppe.attribute15
11830: AND ppe.object_type = 'PA_STRUCTURES'
11831: and ppe.proj_element_id IN (SELECT ppe2.proj_element_id
11832: FROM pa_proj_elements ppe2,
11833: pa_proj_structure_types ppst,
11834: pa_structure_types pst
11835: WHERE ppe2.project_id = p_dest_project_id
11836: AND ppe2.object_type = 'PA_STRUCTURES'
11837: AND ppe2.proj_element_id = ppst.proj_element_id
12326: UPDATE pa_proj_elements ppe
12327: set name = substr(l_project_name||l_append||l_suffix, 1, 240)
12328: WHERE project_id = p_dest_project_id
12329: AND object_type = 'PA_STRUCTURES'
12330: AND EXISTS ( SELECT proj_element_id FROM pa_proj_structure_types
12331: WHERE proj_element_id = ppe.proj_element_id
12332: AND structure_type_id = 1 );
12333: END IF;
12334:
13128: and ppevs.element_version_id = ppevst.element_version_id
13129: )
13130: WHERE project_id = p_dest_project_id;
13131: -- and object_type = 'PA_STRUCTURES'
13132: -- and EXISTS ( SELECT proj_element_id FROM pa_proj_structure_types
13133: -- WHERE proj_element_id = ppe.proj_element_id
13134: -- AND structure_type_id = 1 );
13135:
13136: --updating projects dates
13137: update pa_projects_all
13138: set ( BASELINE_START_DATE ,BASELINE_FINISH_DATE, baseline_duration, baseline_as_of_date) =
13139: ( SELECT BASELINE_START_DATE ,BASELINE_FINISH_DATE, baseline_duration,
13140: decode(BASELINE_START_DATE, null, null, sysdate)
13141: FROM pa_proj_elements ppe, pa_proj_structure_types ppst
13142: WHERE project_id = p_dest_project_id
13143: and object_type = 'PA_STRUCTURES'
13144: and ppe.proj_element_id = ppst.proj_element_id
13145: and ppst.structure_type_id = 1 )
13255:
13256: CURSOR cur_strs_n_types
13257: IS
13258: SELECT ppe.proj_element_id, ppst.structure_type_id
13259: FROM pa_proj_elements ppe, pa_proj_structure_types ppst
13260: WHERE ppe.project_id = p_dest_project_id
13261: AND ppe.object_type = 'PA_STRUCTURES'
13262: AND ppe.proj_element_id = ppst.proj_element_id
13263: ;
13642: -- This cursor is used to get the structure id given the structure type and project_id
13643: CURSOR get_structure(c_project_id pa_projects_all.project_id%TYPE, c_struc_type pa_structure_types.structure_type_class_code%TYPE) IS
13644: select pelem.proj_element_id
13645: from pa_proj_elements pelem,
13646: pa_proj_structure_types ppstr,
13647: pa_structure_types pstr
13648: where pelem.project_id = c_project_id
13649: and pstr.structure_type_class_code = c_struc_type
13650: and pstr.structure_type_id = ppstr.structure_type_id
13920: FROM pa_proj_elements pelem
13921: WHERE project_id = c_project_id
13922: AND pm_source_reference = c_pm_source_reference
13923: AND exists(select 1
13924: from pa_proj_structure_types pstype, pa_structure_types types
13925: where pstype.proj_element_id = pelem.parent_structure_id
13926: and pstype.structure_type_id = types.structure_type_id
13927: and types.structure_type = p_structure_type);
13928: -- Amit Bug 3964548 End
14123: -- Bug 6717386
14124: CURSOR cur_struc_ver_wp(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)
14125: IS
14126: SELECT c.element_version_id
14127: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
14128: ,pa_proj_elem_ver_structure d
14129: WHERE c.project_id = c_project_id
14130: AND a.structure_type_id = b.structure_type_id
14131: AND b.proj_element_id = c.proj_element_id
14730: FROM pa_proj_elements pelem
14731: WHERE project_id = c_project_id
14732: AND pm_source_reference = c_pm_source_reference
14733: AND exists(select 1
14734: from pa_proj_structure_types pstype, pa_structure_types types
14735: where pstype.proj_element_id = pelem.parent_structure_id
14736: and pstype.structure_type_id = types.structure_type_id
14737: and types.structure_type = p_structure_type);
14738: BEGIN
18498: c_structure_type pa_structure_types.structure_type%TYPE)
18499: IS
18500: select 'Y'
18501: from pa_proj_element_versions ver,
18502: pa_proj_structure_types pst,
18503: pa_structure_types st
18504: where ver.element_version_id = c_structure_version_id
18505: and ver.project_id = c_project_id
18506: and pst.proj_element_id = ver.proj_element_id
19250: c_structure_type pa_structure_types.structure_type%TYPE)
19251: IS
19252: SELECT 'Y'
19253: FROM pa_proj_element_versions ver,
19254: pa_proj_structure_types pst,
19255: pa_structure_types st
19256: WHERE ver.element_version_id = c_structure_version_id
19257: AND ver.project_id = c_project_id
19258: AND pst.proj_element_id = ver.proj_element_id
21912:
21913: CURSOR cur_strs_n_types
21914: IS
21915: SELECT ppe.proj_element_id, ppst.structure_type_id
21916: FROM pa_proj_elements ppe, pa_proj_structure_types ppst, pa_structure_types pst
21917: WHERE ppe.project_id = p_dest_project_id
21918: AND ppe.object_type = 'PA_STRUCTURES'
21919: AND ppe.proj_element_id = ppst.proj_element_id
21920: and ppst.structure_type_id = pst.structure_type_id
22141: ppwa.use_task_schedule_flag
22142: -- gboomina Bug 8586393 - end
22143: from pa_proj_workplan_attr ppwa,
22144: pa_proj_elements ppe,
22145: pa_proj_structure_types ppst
22146: where ppwa.project_id = c_project_id
22147: and ppwa.project_id = ppe.project_id
22148: and ppwa.proj_element_id = ppe.proj_element_id
22149: and ppe.proj_element_id = ppst.proj_element_id