DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE1 dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 5849: /* Now update back the attributes column in pa_proj_elements and pa_proj_element_versions with actual data from source project */

5845: END ; */
5846:
5847: /* This code is moved to Copy_Project API for bug 4200168 so that BF can use attribute15 to access source task id in copy finplan API*/
5848:
5849: /* Now update back the attributes column in pa_proj_elements and pa_proj_element_versions with actual data from source project */
5850: UPDATE pa_proj_elements ppe1
5851: SET attribute15 = ( SELECT attribute15 FROM pa_proj_elements ppe2
5852: WHERE ppe2.project_id = x_orig_project_id
5853: AND ppe2.proj_element_id = ppe1.attribute15 )

Line 5856: UPDATE pa_proj_element_versions ppevs1

5852: WHERE ppe2.project_id = x_orig_project_id
5853: AND ppe2.proj_element_id = ppe1.attribute15 )
5854: WHERE project_id = x_new_project_id ;
5855:
5856: UPDATE pa_proj_element_versions ppevs1
5857: SET attribute15 = ( SELECT attribute15 FROM pa_proj_element_versions ppevs2
5858: WHERE ppevs2.project_id = x_orig_project_id
5859: AND ppevs2.element_version_id = ppevs1.attribute15 )
5860: WHERE project_id = x_new_project_id ;

Line 5857: SET attribute15 = ( SELECT attribute15 FROM pa_proj_element_versions ppevs2

5853: AND ppe2.proj_element_id = ppe1.attribute15 )
5854: WHERE project_id = x_new_project_id ;
5855:
5856: UPDATE pa_proj_element_versions ppevs1
5857: SET attribute15 = ( SELECT attribute15 FROM pa_proj_element_versions ppevs2
5858: WHERE ppevs2.project_id = x_orig_project_id
5859: AND ppevs2.element_version_id = ppevs1.attribute15 )
5860: WHERE project_id = x_new_project_id ;
5861:

Line 6168: FROM pa_proj_element_versions ppev,

6164: --Cursor to retrieve all workplan versions from the source project
6165: CURSOR cur_get_wp_versions IS
6166: SELECT ppev.element_version_id, ppevs.status_code,
6167: ppevs.latest_eff_published_flag, ppevs.current_flag, ppevs.current_working_flag
6168: FROM pa_proj_element_versions ppev,
6169: pa_proj_structure_types ppst,
6170: pa_structure_types pst,
6171: pa_proj_elem_ver_structure ppevs
6172: WHERE ppev.project_id = p_src_project_id