DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE1 dependencies on PA_PROJ_ELEMENTS

Line 5755: from pa_proj_elements orig, pa_proj_elements new

5751: Declare
5752: cursor c_attach_tasks is
5753: select orig.proj_element_id orig_task_id,
5754: new.proj_element_id new_task_id
5755: from pa_proj_elements orig, pa_proj_elements new
5756: where orig.project_id = x_orig_project_id
5757: and new.element_number = orig.element_number
5758: and new.project_id = x_new_project_id
5759: and new.object_type = 'PA_TASKS'

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

5913: END ; */
5914:
5915: /* 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*/
5916:
5917: /* Now update back the attributes column in pa_proj_elements and pa_proj_element_versions with actual data from source project */
5918: UPDATE pa_proj_elements ppe1
5919: SET attribute15 = ( SELECT attribute15 FROM pa_proj_elements ppe2
5920: WHERE ppe2.project_id = x_orig_project_id
5921: AND ppe2.proj_element_id = ppe1.attribute15 )

Line 5918: UPDATE pa_proj_elements ppe1

5914:
5915: /* 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*/
5916:
5917: /* Now update back the attributes column in pa_proj_elements and pa_proj_element_versions with actual data from source project */
5918: UPDATE pa_proj_elements ppe1
5919: SET attribute15 = ( SELECT attribute15 FROM pa_proj_elements ppe2
5920: WHERE ppe2.project_id = x_orig_project_id
5921: AND ppe2.proj_element_id = ppe1.attribute15 )
5922: WHERE project_id = x_new_project_id ;

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

5915: /* 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*/
5916:
5917: /* Now update back the attributes column in pa_proj_elements and pa_proj_element_versions with actual data from source project */
5918: UPDATE pa_proj_elements ppe1
5919: SET attribute15 = ( SELECT attribute15 FROM pa_proj_elements ppe2
5920: WHERE ppe2.project_id = x_orig_project_id
5921: AND ppe2.proj_element_id = ppe1.attribute15 )
5922: WHERE project_id = x_new_project_id ;
5923: