APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_PROJ_ELEM_VER_STRUCTURE_S

Line 6880: pa_proj_elem_ver_structure_s.nextval

6876: ,source_object_id
6877: ,source_object_type
6878: )
6879: SELECT
6880: pa_proj_elem_ver_structure_s.nextval
6881: ,ppev.element_version_id
6882: ,ppevs.version_number
6883: ,ppevs.name
6884: ,p_dest_project_id

Line 9057: pa_proj_elem_ver_structure_s.nextval

9053: ,source_object_id
9054: ,source_object_type
9055: )
9056: SELECT
9057: pa_proj_elem_ver_structure_s.nextval
9058: ,rec_dest_wp_struc_versions.element_version_id
9059: --,ppevs.version_number --bug 3907862, insert the new version number, intead of coying the old.
9060: ,l_struct_version_number
9061: ,ppevs.name

Line 9256: pa_proj_elem_ver_structure_s.nextval

9252: ,source_object_id
9253: ,source_object_type
9254: )
9255: SELECT
9256: pa_proj_elem_ver_structure_s.nextval
9257: ,l_new_wp_ver_id
9258: ,ppevs.version_number
9259: ,substr(l_prefix||ppevs.name, 1, 240)
9260: ,ppevs.project_id

Line 10156: pa_proj_elem_ver_structure_s.nextval

10152: ,CURRENT_WORKING_FLAG
10153: ,SOURCE_OBJECT_ID
10154: ,source_object_type)
10155: VALUES (
10156: pa_proj_elem_ver_structure_s.nextval
10157: ,l_new_wp_ver_id
10158: ,l_struc_ver_number
10159: ,substr(p_dest_project_name||l_append||l_suffix, 1, 240)
10160: ,p_dest_project_id

Line 11785: pa_proj_elem_ver_structure_s.nextval

11781: ,source_object_id
11782: ,source_object_type
11783: )
11784: SELECT
11785: pa_proj_elem_ver_structure_s.nextval
11786: ,l_struc_version_id
11787: ,1
11788: --,ppevs.name, rtarway, 3655698, replaced ppevs.name with ppe.name
11789: ,ppe.name

Line 12900: pa_proj_elem_ver_structure_s.nextval

12896: ,source_object_id
12897: ,source_object_type
12898: )
12899: SELECT
12900: pa_proj_elem_ver_structure_s.nextval
12901: ,l_struc_version_id
12902: ,ppevs.version_number --replaced k with source version_number bug 2829385
12903: --,ppevs.name 3717026, replaced ppevs.name with ppe.name
12904: ,ppe.name

Line 13792: l_str_status_code pa_proj_elem_ver_structure.status_code%TYPE;

13788: l_task_unpub_ver_status_code pa_proj_element_versions.task_unpub_ver_status_code%TYPE;
13789: l_add_task_security VARCHAR2(1);
13790: l_default_task_type_id pa_proj_elements.type_id%TYPE;
13791: l_update_task_security VARCHAR2(1);
13792: l_str_status_code pa_proj_elem_ver_structure.status_code%TYPE;
13793: l_amg_segment1 pa_projects_all.segment1%TYPE;
13794:
13795: -- Bug 3075609
13796: l_maintain_weightages VARCHAR2(1); -- We need not maintain weightages during code flow always. This var will track it.