DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE1 dependencies on PA_PROJ_ELEMENTS

Line 5687: from pa_proj_elements orig, pa_proj_elements new

5683: Declare
5684: cursor c_attach_tasks is
5685: select orig.proj_element_id orig_task_id,
5686: new.proj_element_id new_task_id
5687: from pa_proj_elements orig, pa_proj_elements new
5688: where orig.project_id = x_orig_project_id
5689: and new.element_number = orig.element_number
5690: and new.project_id = x_new_project_id
5691: and new.object_type = 'PA_TASKS'

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 5850: UPDATE pa_proj_elements ppe1

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 )
5854: WHERE project_id = x_new_project_id ;

Line 5851: SET attribute15 = ( SELECT attribute15 FROM pa_proj_elements ppe2

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 )
5854: WHERE project_id = x_new_project_id ;
5855: