APPS.PA_ADW_COLLECT_FACTS dependencies on PA_TXN_ACCUM

Line 1164: -- Mark the rows in PA_TXN_ACCUM table for re-transfer

1160: x_err_code);
1161:
1162: END LOOP; -- FOR ref_prj_ser_type_act_cmts_r IN sel_ref_prj_ser_type_act_cmts
1163:
1164: -- Mark the rows in PA_TXN_ACCUM table for re-transfer
1165:
1166: UPDATE PA_TXN_ACCUM PTA
1167: SET ADW_NOTIFY_FLAG = 'Y'
1168: WHERE

Line 1166: UPDATE PA_TXN_ACCUM PTA

1162: END LOOP; -- FOR ref_prj_ser_type_act_cmts_r IN sel_ref_prj_ser_type_act_cmts
1163:
1164: -- Mark the rows in PA_TXN_ACCUM table for re-transfer
1165:
1166: UPDATE PA_TXN_ACCUM PTA
1167: SET ADW_NOTIFY_FLAG = 'Y'
1168: WHERE
1169: TASK_ID IN
1170: (SELECT TASK_ID

Line 1216: PA_TXN_ACCUM

1212:
1213: txn_count := SQL%ROWCOUNT;
1214:
1215: UPDATE
1216: PA_TXN_ACCUM
1217: SET
1218: ADW_NOTIFY_FLAG = 'S'
1219: WHERE
1220: PROJECT_ID = sel_prjs_r.project_id

Line 1396: FROM PA_TXN_ACCUM

1392: FROM PA_RESOURCE_ACCUM_DETAILS
1393: WHERE ADW_NOTIFY_FLAG = 'S'
1394: UNION
1395: SELECT TASK_ID
1396: FROM PA_TXN_ACCUM
1397: WHERE ADW_NOTIFY_FLAG = 'S'
1398: );
1399: pa_debug.debug('Marked '||TO_CHAR(SQL%ROWCOUNT)||' task rows transferred to interface table');
1400:

Line 1417: FROM PA_TXN_ACCUM

1413: FROM PA_RESOURCE_ACCUM_DETAILS
1414: WHERE ADW_NOTIFY_FLAG = 'S'
1415: UNION
1416: SELECT TASK_ID
1417: FROM PA_TXN_ACCUM
1418: WHERE ADW_NOTIFY_FLAG = 'S'
1419: )
1420: );
1421: pa_debug.debug('Marked '||TO_CHAR(SQL%ROWCOUNT)||' top task rows transferred to interface table');

Line 1434: PA_TXN_ACCUM

1430: WHERE
1431: ADW_NOTIFY_FLAG = 'S';
1432:
1433: UPDATE
1434: PA_TXN_ACCUM
1435: SET
1436: ADW_NOTIFY_FLAG = 'N'
1437: WHERE
1438: ADW_NOTIFY_FLAG = 'S';