[Home] [Help]
282: l_append VARCHAR2(250);
283:
284: CURSOR cur_elem_ver_seq
285: IS
286: SELECT pa_proj_element_versions_s.nextval
287: FROM sys.dual;
288:
289: BEGIN
290:
4953: select segment1, name from pa_projects_all
4954: where project_id = p_project_id;
4955:
4956: CURSOR cur_elem_ver_seq IS
4957: SELECT pa_proj_element_versions_s.nextval
4958: FROM sys.dual;
4959:
4960: cursor get_working_ver_num(c_project_id NUMBER, c_proj_element_id NUMBER) IS
4961: select nvl(max(version_number),0)+1
5226: and proj_element_id = c_proj_elem_id
5227: and status_code <> 'STRUCTURE_PUBLISHED';
5228:
5229: CURSOR cur_elem_ver_seq IS
5230: SELECT pa_proj_element_versions_s.nextval
5231: FROM sys.dual;
5232:
5233: cursor get_working_ver_num(c_project_id NUMBER, c_proj_element_id NUMBER) IS
5234: select nvl(max(version_number),0)+1
6769: ,source_object_id
6770: ,source_object_type
6771: )
6772: SELECT
6773: pa_proj_element_versions_s.nextval
6774: ,p_dest_fn_structure_id --This would be the WP/FIN structure id in shared case and FIN structure id in split case
6775: ,ppev.object_type
6776: ,p_dest_project_id
6777: ,pa_proj_element_versions_s.nextval --nextval occuring twice in the same select returns the same value
6773: pa_proj_element_versions_s.nextval
6774: ,p_dest_fn_structure_id --This would be the WP/FIN structure id in shared case and FIN structure id in split case
6775: ,ppev.object_type
6776: ,p_dest_project_id
6777: ,pa_proj_element_versions_s.nextval --nextval occuring twice in the same select returns the same value
6778: ,ppev.DISPLAY_SEQUENCE
6779: ,ppev.WBS_LEVEL
6780: ,ppev.WBS_NUMBER
6781: ,SYSDATE ------CREATION_DATE
7425: ,source_object_id
7426: ,source_object_type
7427: )
7428: SELECT
7429: pa_proj_element_versions_s.nextval
7430: ,ppe.proj_element_id
7431: ,ppev.object_type
7432: ,p_dest_project_id
7433: ,ppev2.element_version_id
8744: ,source_object_id
8745: ,source_object_type
8746: )
8747: SELECT
8748: pa_proj_element_versions_s.nextval
8749: ,l_dest_wp_structure_id
8750: ,ppev.object_type
8751: ,p_dest_project_id
8752: ,pa_proj_element_versions_s.nextval --nextval occuring twice in the same select returns the same value
8748: pa_proj_element_versions_s.nextval
8749: ,l_dest_wp_structure_id
8750: ,ppev.object_type
8751: ,p_dest_project_id
8752: ,pa_proj_element_versions_s.nextval --nextval occuring twice in the same select returns the same value
8753: ,ppev.DISPLAY_SEQUENCE
8754: ,ppev.WBS_LEVEL
8755: ,ppev.WBS_NUMBER
8756: ,SYSDATE ------CREATION_DATE
9126:
9127: --If it is a shared structure and the only WP version selected is Publish Upon Creation, then
9128: --create a working copy of the Published version
9129: IF l_shared_make_working_copy IS NOT NULL THEN
9130: SELECT pa_proj_element_versions_s.nextval INTO l_new_wp_ver_id
9131: FROM dual;
9132:
9133: SELECT meaning INTO l_prefix
9134: FROM pa_lookups
9637: ,source_object_id
9638: ,source_object_type
9639: )
9640: SELECT
9641: pa_proj_element_versions_s.nextval
9642: ,ppe.proj_element_id
9643: ,ppev.object_type
9644: ,p_dest_project_id
9645: ,ppev2.element_version_id
10076: --bug 3912603, Satish, this flag is for using this same condition below.
10077: check_str_sel_flag := 'Y';
10078:
10079: --Create new default WP structure version
10080: SELECT pa_proj_element_versions_s.nextval INTO l_new_wp_ver_id
10081: FROM dual;
10082:
10083: INSERT INTO pa_proj_element_versions(
10084: ELEMENT_VERSION_ID
10955: and pst.structure_type in ('WORKPLAN','FINANCIAL');
10956:
10957: CURSOR cur_elem_ver_seq
10958: IS
10959: SELECT pa_proj_element_versions_s.nextval
10960: FROM sys.dual;
10961:
10962: l_get_structure_attr_csr_rec l_get_structure_attr_csr%ROWTYPE;
10963: l_get_structure_attr_csr_rec2 l_get_structure_attr_csr2%ROWTYPE;
12646: ,source_object_type
12647: ,financial_task_flag --Bug no 3651255
12648: )
12649: SELECT
12650: pa_proj_element_versions_s.nextval
12651: ,ppe.proj_element_id
12652: ,ppev.object_type
12653: ,p_dest_project_id
12654: ,l_struc_version_id --from previous sql