[Home] [Help]
955:
956: CURSOR cur_proj_wrk_attr
957: IS
958: select AUTO_PUB_UPON_CREATION_FLAG
959: from pa_proj_workplan_attr
960: where project_id = p_project_id;
961: l_auto_pub_flag VARCHAR2(1);
962: --proj conn
963: --bug 2736392
3749: DELETE FROM pa_proj_elem_ver_schedule where project_id = p_project_id;
3750: DELETE FROM pa_proj_elem_ver_structure where project_id = p_project_id;
3751:
3752: /* Code to delete project records from tables: pa_progress_rollup, pa_proj_progress_attr
3753: and pa_proj_workplan_attr. */
3754:
3755: BEGIN
3756:
3757: PA_PROGRESS_PUB.delete_working_wp_progress (
4995: and c.structure_type = p_structure_type;
4996:
4997: cursor c3 is
4998: select wp_enable_version_flag
4999: from pa_proj_workplan_attr
5000: where project_id = p_project_id;
5001:
5002: cursor c4(c_proj_elem_id NUMBER) is
5003: select '1' from pa_proj_elem_ver_structure
6339: ) IS
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
7603:
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
7815:
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
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
8278: ,PROJECT_ID
8279: ,LAST_UPDATE_DATE
8280: ,LAST_UPDATED_BY
8328: ,ppwa.THIRD_PARTY_SCHEDULE_CODE
8329: ,ppe.PROJECT_ID
8330: ,'PA_PROJECTS'
8331: FROM pa_proj_elements ppe,
8332: pa_proj_workplan_attr ppwa
8333: WHERE ppwa.project_id = p_src_project_id
8334: AND ppe.attribute15 = ppwa.proj_element_id
8335: AND PA_PROJ_ELEMENTS_UTILS.check_fin_or_wp_structure( ppe.proj_element_id ) = 'Y'
8336: AND ppe.project_id = p_dest_project_id --bug 3939786
10590:
10591: /*bug 3737444 : The below code commented */
10592: /* CURSOR get_wp_attr IS
10593: select *
10594: from pa_proj_workplan_attr
10595: where project_id = p_src_project_id; */
10596:
10597: /* Code Addition starts for bug 3737444 */
10598: CURSOR get_wp_attr IS
10595: where project_id = p_src_project_id; */
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);
11524: AND pst.structure_type in ('WORKPLAN','FINANCIAL'));
11525: --Added by rtarway for BUG 3951701
11526: --Copy workplan attributes for financial only structures
11527:
11528: INSERT INTO pa_proj_workplan_attr(
11529: PROJ_ELEMENT_ID
11530: ,PROJECT_ID
11531: ,LAST_UPDATE_DATE
11532: ,LAST_UPDATED_BY
11578: ,ppwa.THIRD_PARTY_SCHEDULE_CODE
11579: ,ppe.PROJECT_ID
11580: ,'PA_PROJECTS'
11581: FROM pa_proj_elements ppe,
11582: pa_proj_workplan_attr ppwa
11583: WHERE ppwa.project_id = p_src_project_id
11584: AND ppe.attribute15 = ppwa.proj_element_id
11585: AND ppe.project_id = p_dest_project_id
11586: AND ppe.object_type='PA_STRUCTURES';
12010: WHERE proj_element_id = ppe.proj_element_id
12011: AND structure_type_id = 1 );
12012: END IF;
12013:
12014: INSERT INTO pa_proj_workplan_attr(
12015: PROJ_ELEMENT_ID
12016: ,PROJECT_ID
12017: ,LAST_UPDATE_DATE
12018: ,LAST_UPDATED_BY
12066: ,ppwa.THIRD_PARTY_SCHEDULE_CODE
12067: ,ppe.PROJECT_ID
12068: ,'PA_PROJECTS'
12069: /*FROM pa_proj_elements ppe,
12070: pa_proj_workplan_attr ppwa
12071: WHERE ppe.project_id = p_dest_project_id
12072: and object_type = 'PA_STRUCTURES'
12073: and ppwa.project_id = p_src_project_id
12074: and ppwa.proj_element_id = ppe.attribute15;*//*Commented below query and following criteria by SMUKKA */
12072: and object_type = 'PA_STRUCTURES'
12073: and ppwa.project_id = p_src_project_id
12074: and ppwa.proj_element_id = ppe.attribute15;*//*Commented below query and following criteria by SMUKKA */
12075: FROM pa_proj_elements ppe,
12076: pa_proj_workplan_attr ppwa
12077: WHERE ppwa.project_id = p_src_project_id
12078: AND ppe.project_id = p_dest_project_id
12079: AND ppe.object_type ='PA_STRUCTURES'
12080: AND ppe.attribute15 = ppwa.proj_element_id
13292: /* Bug 2955589. This cursor is no longer used.
13293: CURSOR cur_auto_pub_flag(c_project_id pa_projects_all.project_id%TYPE)
13294: IS
13295: SELECT AUTO_PUB_UPON_CREATION_FLAG
13296: FROM pa_proj_workplan_attr
13297: WHERE project_id = c_project_id;
13298: */
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
21340: ppwa.wp_approver_source_type,
21341: ppwa.record_version_number,
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