[Home] [Help]
66: l_append VARCHAR2(250);
67:
68: CURSOR cur_elem_ver_seq
69: IS
70: SELECT pa_proj_element_versions_s.nextval
71: FROM sys.dual;
72:
73: BEGIN
74:
4732: select segment1, name from pa_projects_all
4733: where project_id = p_project_id;
4734:
4735: CURSOR cur_elem_ver_seq IS
4736: SELECT pa_proj_element_versions_s.nextval
4737: FROM sys.dual;
4738:
4739: cursor get_working_ver_num(c_project_id NUMBER, c_proj_element_id NUMBER) IS
4740: select nvl(max(version_number),0)+1
5005: and proj_element_id = c_proj_elem_id
5006: and status_code <> 'STRUCTURE_PUBLISHED';
5007:
5008: CURSOR cur_elem_ver_seq IS
5009: SELECT pa_proj_element_versions_s.nextval
5010: FROM sys.dual;
5011:
5012: cursor get_working_ver_num(c_project_id NUMBER, c_proj_element_id NUMBER) IS
5013: select nvl(max(version_number),0)+1
6520: ,source_object_id
6521: ,source_object_type
6522: )
6523: SELECT
6524: pa_proj_element_versions_s.nextval
6525: ,p_dest_fn_structure_id --This would be the WP/FIN structure id in shared case and FIN structure id in split case
6526: ,ppev.object_type
6527: ,p_dest_project_id
6528: ,pa_proj_element_versions_s.nextval --nextval occuring twice in the same select returns the same value
6524: pa_proj_element_versions_s.nextval
6525: ,p_dest_fn_structure_id --This would be the WP/FIN structure id in shared case and FIN structure id in split case
6526: ,ppev.object_type
6527: ,p_dest_project_id
6528: ,pa_proj_element_versions_s.nextval --nextval occuring twice in the same select returns the same value
6529: ,ppev.DISPLAY_SEQUENCE
6530: ,ppev.WBS_LEVEL
6531: ,ppev.WBS_NUMBER
6532: ,SYSDATE ------CREATION_DATE
7176: ,source_object_id
7177: ,source_object_type
7178: )
7179: SELECT
7180: pa_proj_element_versions_s.nextval
7181: ,ppe.proj_element_id
7182: ,ppev.object_type
7183: ,p_dest_project_id
7184: ,ppev2.element_version_id
8477: ,source_object_id
8478: ,source_object_type
8479: )
8480: SELECT
8481: pa_proj_element_versions_s.nextval
8482: ,l_dest_wp_structure_id
8483: ,ppev.object_type
8484: ,p_dest_project_id
8485: ,pa_proj_element_versions_s.nextval --nextval occuring twice in the same select returns the same value
8481: pa_proj_element_versions_s.nextval
8482: ,l_dest_wp_structure_id
8483: ,ppev.object_type
8484: ,p_dest_project_id
8485: ,pa_proj_element_versions_s.nextval --nextval occuring twice in the same select returns the same value
8486: ,ppev.DISPLAY_SEQUENCE
8487: ,ppev.WBS_LEVEL
8488: ,ppev.WBS_NUMBER
8489: ,SYSDATE ------CREATION_DATE
8834:
8835: --If it is a shared structure and the only WP version selected is Publish Upon Creation, then
8836: --create a working copy of the Published version
8837: IF l_shared_make_working_copy IS NOT NULL THEN
8838: SELECT pa_proj_element_versions_s.nextval INTO l_new_wp_ver_id
8839: FROM dual;
8840:
8841: SELECT meaning INTO l_prefix
8842: FROM pa_lookups
9345: ,source_object_id
9346: ,source_object_type
9347: )
9348: SELECT
9349: pa_proj_element_versions_s.nextval
9350: ,ppe.proj_element_id
9351: ,ppev.object_type
9352: ,p_dest_project_id
9353: ,ppev2.element_version_id
9782: --bug 3912603, Satish, this flag is for using this same condition below.
9783: check_str_sel_flag := 'Y';
9784:
9785: --Create new default WP structure version
9786: SELECT pa_proj_element_versions_s.nextval INTO l_new_wp_ver_id
9787: FROM dual;
9788:
9789: INSERT INTO pa_proj_element_versions(
9790: ELEMENT_VERSION_ID
10640: and pst.structure_type in ('WORKPLAN','FINANCIAL');
10641:
10642: CURSOR cur_elem_ver_seq
10643: IS
10644: SELECT pa_proj_element_versions_s.nextval
10645: FROM sys.dual;
10646:
10647: l_get_structure_attr_csr_rec l_get_structure_attr_csr%ROWTYPE;
10648: l_get_structure_attr_csr_rec2 l_get_structure_attr_csr2%ROWTYPE;
12319: ,source_object_type
12320: ,financial_task_flag --Bug no 3651255
12321: )
12322: SELECT
12323: pa_proj_element_versions_s.nextval
12324: ,ppe.proj_element_id
12325: ,ppev.object_type
12326: ,p_dest_project_id
12327: ,l_struc_version_id --from previous sql