APPS.ASG_CONS_QPKG dependencies on ASG_SYSTEM_DIRTY_QUEUE

Line 1248: FROM asg_system_dirty_queue

1244: last_update_date,
1245: last_updated_by)
1246: SELECT p_user_name, p_pubitem, p_upload_tranid, access_id, l_client_wins,
1247: sysdate, 1, sysdate, 1
1248: FROM asg_system_dirty_queue
1249: WHERE client_id = p_user_name AND
1250: pub_item = p_pubitem AND
1251: transaction_id = l_download_tranid AND
1252: download_flag = 'Y' AND

Line 1340: UPDATE asg_system_dirty_queue

1336: END IF;
1337:
1338: -- Ok, all the conflict rows are processed. We need to
1339: -- reset download flag for those rows where client wins applies
1340: UPDATE asg_system_dirty_queue
1341: SET download_flag = NULL
1342: WHERE client_id = p_user_name AND
1343: pub_item = p_pubitem AND
1344: transaction_id = l_download_tranid AND