APPS.ASG_CONS_QPKG dependencies on ASG_SYSTEM_DIRTY_QUEUE

Line 1289: FROM asg_system_dirty_queue

1285: last_update_date,
1286: last_updated_by)
1287: SELECT p_user_name, p_pubitem, p_upload_tranid, access_id, l_client_wins,
1288: sysdate, 1, sysdate, 1
1289: FROM asg_system_dirty_queue
1290: WHERE client_id = p_user_name AND
1291: pub_item = p_pubitem AND
1292: transaction_id = l_download_tranid AND
1293: download_flag = 'Y' AND

Line 1381: UPDATE asg_system_dirty_queue

1377: END IF;
1378:
1379: -- Ok, all the conflict rows are processed. We need to
1380: -- reset download flag for those rows where client wins applies
1381: UPDATE asg_system_dirty_queue
1382: SET download_flag = NULL
1383: WHERE client_id = p_user_name AND
1384: pub_item = p_pubitem AND
1385: transaction_id = l_download_tranid AND