DBA Data[Home] [Help]

APPS.PA_PROJECT_INTEGRATION_PUB dependencies on PA_TASKS

Line 718: and a.object_type = 'PA_TASKS'

714: pa_proj_structure_types PPST, pa_integration_settings pis
715: where s.project_id = L_PROJECT_OUT_OBJ.PA_PROJECT_ID
716: and s.project_id = a.project_id
717: and a.parent_structure_version_id = s.element_version_id
718: and a.object_type = 'PA_TASKS'
719: and ( ( s.status_code = 'STRUCTURE_WORKING' AND
720: exists ( select 'x' from pa_proj_workplan_attr w1
721: where w1.project_id = s.project_id
722: and w1.wp_enable_version_flag = 'Y' ) )

Line 2447: update pa_tasks a

2443: where b.task_id = a.proj_element_id )
2444: where exists
2445: ( select 'x' from pa_wbs_seq_tmp c where c.task_id = a.proj_element_id ) ;
2446:
2447: update pa_tasks a
2448: set ( pm_task_reference, pm_product_code ) =
2449: ( select b.task_ref, 'PRIMAVERA'
2450: from pa_wbs_seq_tmp b
2451: where b.task_id = a.task_id )

Line 2461: and a.object_type = 'PA_TASKS'

2457: bulk collect into X_DELETE_TASK_ID_TBL, X_DELETE_TASK_VER_ID_TBL
2458: from PA_PROJ_ELEMENT_VERSIONS a , pa_proj_elements c
2459: where a.project_id = P_PROJECT_IN_REC.pa_project_id
2460: and a.parent_structure_version_id = P_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID
2461: and a.object_type = 'PA_TASKS'
2462: and a.proj_element_id = c.proj_element_id
2463: and
2464: ( not exists
2465: ( select 'x'