DBA Data[Home] [Help]

APPS.AR_TRX_SUMMARY_PKG dependencies on AR_CONC_PROCESS_REQUESTS

Line 1350: INSERT INTO AR_CONC_PROCESS_REQUESTS

1346: END IF;
1347:
1348: IF p_action = 'BLOCK'
1349: THEN
1350: INSERT INTO AR_CONC_PROCESS_REQUESTS
1351: (CONCURRENT_PROGRAM_NAME, REQUEST_ID)
1352: VALUES ('ARSUMREF',p_request_id);
1353: ELSIF p_action = 'UNBLOCK'
1354: THEN

Line 1355: DELETE FROM AR_CONC_PROCESS_REQUESTS

1351: (CONCURRENT_PROGRAM_NAME, REQUEST_ID)
1352: VALUES ('ARSUMREF',p_request_id);
1353: ELSIF p_action = 'UNBLOCK'
1354: THEN
1355: DELETE FROM AR_CONC_PROCESS_REQUESTS
1356: WHERE CONCURRENT_PROGRAM_NAME = 'ARSUMREF'
1357: AND REQUEST_ID = p_request_id;
1358: ELSE
1359: IF PG_DEBUG in ('Y','C')

Line 2624: DELETE FROM AR_CONC_PROCESS_REQUESTS

2620:
2621: /* Delete any remaining rows (for refresh) from conc table
2622: This is really just precautionary in that (in theory), no events
2623: should be held at this point. */
2624: DELETE FROM AR_CONC_PROCESS_REQUESTS
2625: WHERE CONCURRENT_PROGRAM_NAME = 'ARSUMREF';
2626:
2627: COMMIT;
2628: