APPS.PA_ADW_COLLECT_FACTS dependencies on PA_ADW_INTERFACED_TASKS

Line 742: UPDATE PA_ADW_INTERFACED_TASKS PTH

738: -- and the task which are not refreshed earlier by the project refresh
739: -- cursor
740:
741:
742: UPDATE PA_ADW_INTERFACED_TASKS PTH
743: SET
744: ADW_NOTIFY_FLAG = 'S'
745: WHERE
746: ADW_INTERFACE_FLAG = 'Y'

Line 771: UPDATE PA_ADW_INTERFACED_TASKS PTH

767: pa_debug.debug('Marked ' || TO_CHAR(SQL%ROWCOUNT) || ' Task Rows for Service Type Change');
768:
769: -- Mark the other tasks with this service type for refresh too
770:
771: UPDATE PA_ADW_INTERFACED_TASKS PTH
772: SET
773: ADW_NOTIFY_FLAG = 'P'
774: WHERE
775: ADW_INTERFACE_FLAG = 'Y'

Line 780: FROM PA_ADW_INTERFACED_TASKS PTHL

776: AND ADW_NOTIFY_FLAG <> 'S'
777: AND PROJECT_ID = sel_prjs_r.project_id
778: AND EXISTS
779: ( SELECT 'Yes'
780: FROM PA_ADW_INTERFACED_TASKS PTHL
781: WHERE PTHL.TASK_ID <> PTH.TASK_ID
782: AND (
783: PTHL.SERVICE_TYPE_CODE = PTH.SERVICE_TYPE_CODE or
784: PTHL.CARRYING_OUT_ORGANIZATION_ID = PTH.CARRYING_OUT_ORGANIZATION_ID -- fix for bug 1233570, created by DMPOTAPO

Line 800: UPDATE PA_ADW_INTERFACED_TASKS PTH

796: pa_debug.debug('Marked ' || TO_CHAR(SQL%ROWCOUNT) || ' Task Rows for Service Type Change at other tasks');
797:
798: -- Update all lowest level tasks if any top task got changed
799:
800: UPDATE PA_ADW_INTERFACED_TASKS PTH
801: SET
802: ADW_NOTIFY_FLAG = 'P'
803: WHERE
804: ADW_INTERFACE_FLAG = 'Y'