APPS.PA_ADW_COLLECT_FACTS dependencies on PA_TASK_HISTORY

Line 717: -- Mark the PA_TASK_HISTORY rows for latest service_type

713: -- Process all projects one one by one
714:
715: FOR sel_prjs_r IN sel_prjs LOOP
716:
717: -- Mark the PA_TASK_HISTORY rows for latest service_type
718: -- These are the task for which the service type is latest
719:
720: pa_debug.debug('Processing project_id ' || to_char(sel_prjs_r.project_id) || ' Project Number' || sel_prjs_r.segment1 );
721:

Line 723: PA_TASK_HISTORY PTH

719:
720: pa_debug.debug('Processing project_id ' || to_char(sel_prjs_r.project_id) || ' Project Number' || sel_prjs_r.segment1 );
721:
722: UPDATE
723: PA_TASK_HISTORY PTH
724: SET
725: ADW_NOTIFY_FLAG = 'Y'
726: WHERE
727: PROJECT_ID = sel_prjs_r.project_id

Line 730: FROM PA_TASK_HISTORY PTHL

726: WHERE
727: PROJECT_ID = sel_prjs_r.project_id
728: AND TASK_HISTORY_ID IN
729: ( SELECT MAX(TASK_HISTORY_ID)
730: FROM PA_TASK_HISTORY PTHL
731: WHERE PTHL.TASK_ID = PTH.TASK_ID
732: );
733:
734: pa_debug.debug('Marked ' || TO_CHAR(SQL%ROWCOUNT) || ' Task Rows for Transfer');

Line 750: FROM PA_TASK_HISTORY PTHL

746: ADW_INTERFACE_FLAG = 'Y'
747: AND PROJECT_ID = sel_prjs_r.project_id
748: AND EXISTS
749: ( SELECT 'Yes'
750: FROM PA_TASK_HISTORY PTHL
751: WHERE PTHL.TASK_ID = PTH.TASK_ID
752: AND (
753: PTHL.SERVICE_TYPE_CODE <> PTH.SERVICE_TYPE_CODE or
754: PTHL.CARRYING_OUT_ORGANIZATION_ID <> PTH.CARRYING_OUT_ORGANIZATION_ID -- fix for bug 1233570, created by DMPOTAPO

Line 809: FROM PA_TASK_HISTORY PTHL

805: AND ADW_NOTIFY_FLAG <> 'S'
806: AND PROJECT_ID = sel_prjs_r.project_id
807: AND EXISTS
808: ( SELECT 'Yes'
809: FROM PA_TASK_HISTORY PTHL
810: WHERE PTHL.TASK_ID = PTH.TOP_TASK_ID
811: AND PTHL.ADW_NOTIFY_FLAG = 'S'
812: )
813: AND NOT EXISTS

Line 1171: FROM PA_TASK_HISTORY PTH

1167: SET ADW_NOTIFY_FLAG = 'Y'
1168: WHERE
1169: TASK_ID IN
1170: (SELECT TASK_ID
1171: FROM PA_TASK_HISTORY PTH
1172: WHERE PTH.TASK_ID = PTA.TASK_ID
1173: AND PTH.ADW_NOTIFY_FLAG IN ('S','P')
1174: );
1175:

Line 1179: PA_TASK_HISTORY

1175:
1176: pa_debug.debug('Marked '||TO_CHAR(SQL%ROWCOUNT)||' Txn Accum rows for re-transfer due to service type change alone');
1177:
1178: UPDATE
1179: PA_TASK_HISTORY
1180: SET
1181: ADW_NOTIFY_FLAG = 'N'
1182: WHERE
1183: ADW_NOTIFY_FLAG = 'S';

Line 1186: PA_TASK_HISTORY

1182: WHERE
1183: ADW_NOTIFY_FLAG = 'S';
1184:
1185: UPDATE
1186: PA_TASK_HISTORY
1187: SET
1188: ADW_NOTIFY_FLAG = 'Y'
1189: WHERE
1190: ADW_NOTIFY_FLAG = 'P';

Line 1381: -- Mark the PA_TASK_HISTORY rows which were transferred

1377: x_err_code);
1378:
1379: END LOOP; -- FOR prj_act_cmts_r IN sel_prj_act_cmts
1380:
1381: -- Mark the PA_TASK_HISTORY rows which were transferred
1382: -- Both for Low level task as well as top level tasks
1383:
1384: UPDATE
1385: PA_TASK_HISTORY PTH

Line 1385: PA_TASK_HISTORY PTH

1381: -- Mark the PA_TASK_HISTORY rows which were transferred
1382: -- Both for Low level task as well as top level tasks
1383:
1384: UPDATE
1385: PA_TASK_HISTORY PTH
1386: SET
1387: ADW_INTERFACE_FLAG = 'Y'
1388: WHERE
1389: ADW_NOTIFY_FLAG = 'Y'

Line 1402: PA_TASK_HISTORY PTH

1398: );
1399: pa_debug.debug('Marked '||TO_CHAR(SQL%ROWCOUNT)||' task rows transferred to interface table');
1400:
1401: UPDATE
1402: PA_TASK_HISTORY PTH
1403: SET
1404: ADW_INTERFACE_FLAG = 'Y'
1405: WHERE
1406: ADW_NOTIFY_FLAG = 'Y'

Line 1408: (SELECT TOP_TASK_ID FROM PA_TASK_HISTORY PTHT

1404: ADW_INTERFACE_FLAG = 'Y'
1405: WHERE
1406: ADW_NOTIFY_FLAG = 'Y'
1407: AND PTH.TASK_ID IN
1408: (SELECT TOP_TASK_ID FROM PA_TASK_HISTORY PTHT
1409: WHERE
1410: PTHT.ADW_NOTIFY_FLAG = 'Y'
1411: AND PTHT.TASK_ID IN
1412: (SELECT TASK_ID

Line 1442: UPDATE PA_TASK_HISTORY PTH

1438: ADW_NOTIFY_FLAG = 'S';
1439:
1440: END IF; -- IF (txn_count <> 0 OR res_count <> 0)
1441:
1442: UPDATE PA_TASK_HISTORY PTH
1443: SET ADW_NOTIFY_FLAG = 'N'
1444: WHERE
1445: ADW_NOTIFY_FLAG = 'Y';
1446: