APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_PROJ_ELEM_VER_STRUCTURE_S

Line 6631: pa_proj_elem_ver_structure_s.nextval

6627: ,source_object_id
6628: ,source_object_type
6629: )
6630: SELECT
6631: pa_proj_elem_ver_structure_s.nextval
6632: ,ppev.element_version_id
6633: ,ppevs.version_number
6634: ,ppevs.name
6635: ,p_dest_project_id

Line 8790: pa_proj_elem_ver_structure_s.nextval

8786: ,source_object_id
8787: ,source_object_type
8788: )
8789: SELECT
8790: pa_proj_elem_ver_structure_s.nextval
8791: ,rec_dest_wp_struc_versions.element_version_id
8792: --,ppevs.version_number --bug 3907862, insert the new version number, intead of coying the old.
8793: ,l_struct_version_number
8794: ,ppevs.name

Line 8964: pa_proj_elem_ver_structure_s.nextval

8960: ,source_object_id
8961: ,source_object_type
8962: )
8963: SELECT
8964: pa_proj_elem_ver_structure_s.nextval
8965: ,l_new_wp_ver_id
8966: ,ppevs.version_number
8967: ,substr(l_prefix||ppevs.name, 1, 240)
8968: ,ppevs.project_id

Line 9862: pa_proj_elem_ver_structure_s.nextval

9858: ,CURRENT_WORKING_FLAG
9859: ,SOURCE_OBJECT_ID
9860: ,source_object_type)
9861: VALUES (
9862: pa_proj_elem_ver_structure_s.nextval
9863: ,l_new_wp_ver_id
9864: ,l_struc_ver_number
9865: ,substr(p_dest_project_name||l_append||l_suffix, 1, 240)
9866: ,p_dest_project_id

Line 11470: pa_proj_elem_ver_structure_s.nextval

11466: ,source_object_id
11467: ,source_object_type
11468: )
11469: SELECT
11470: pa_proj_elem_ver_structure_s.nextval
11471: ,l_struc_version_id
11472: ,1
11473: --,ppevs.name, rtarway, 3655698, replaced ppevs.name with ppe.name
11474: ,ppe.name

Line 12573: pa_proj_elem_ver_structure_s.nextval

12569: ,source_object_id
12570: ,source_object_type
12571: )
12572: SELECT
12573: pa_proj_elem_ver_structure_s.nextval
12574: ,l_struc_version_id
12575: ,ppevs.version_number --replaced k with source version_number bug 2829385
12576: --,ppevs.name 3717026, replaced ppevs.name with ppe.name
12577: ,ppe.name

Line 13445: l_str_status_code pa_proj_elem_ver_structure.status_code%TYPE;

13441: l_task_unpub_ver_status_code pa_proj_element_versions.task_unpub_ver_status_code%TYPE;
13442: l_add_task_security VARCHAR2(1);
13443: l_default_task_type_id pa_proj_elements.type_id%TYPE;
13444: l_update_task_security VARCHAR2(1);
13445: l_str_status_code pa_proj_elem_ver_structure.status_code%TYPE;
13446: l_amg_segment1 pa_projects_all.segment1%TYPE;
13447:
13448: -- Bug 3075609
13449: l_maintain_weightages VARCHAR2(1); -- We need not maintain weightages during code flow always. This var will track it.