eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XDP_PURGE dependencies on XDP_DEBUG

Line 1343: CURSOR c_xdp_debug(p_time_from IN DATE,p_time_to IN DATE) IS

1339: p_run_mode IN VARCHAR2 DEFAULT 'VERIFY',
1340: p_rollback_segment IN VARCHAR2 DEFAULT NULL
1341: ) IS
1342:
1343: CURSOR c_xdp_debug(p_time_from IN DATE,p_time_to IN DATE) IS
1344: SELECT DEBUG_TYPE FROM XDP_DEBUG
1345: WHERE LAST_UPDATE_DATE < p_time_to
1346: AND LAST_UPDATE_DATE > p_time_from FOR UPDATE OF DEBUG_TYPE NOWAIT;
1347:

Line 1344: SELECT DEBUG_TYPE FROM XDP_DEBUG

1340: p_rollback_segment IN VARCHAR2 DEFAULT NULL
1341: ) IS
1342:
1343: CURSOR c_xdp_debug(p_time_from IN DATE,p_time_to IN DATE) IS
1344: SELECT DEBUG_TYPE FROM XDP_DEBUG
1345: WHERE LAST_UPDATE_DATE < p_time_to
1346: AND LAST_UPDATE_DATE > p_time_from FOR UPDATE OF DEBUG_TYPE NOWAIT;
1347:
1348: CURSOR c_xdp_errors(p_time_from IN DATE,p_time_to IN DATE) IS

Line 1359: l_xdp_debug_type XDP_DEBUG.DEBUG_TYPE%TYPE;

1355: SELECT DEBUG_ID FROM XNP_DEBUG
1356: WHERE LAST_UPDATE_DATE < p_time_to
1357: AND LAST_UPDATE_DATE > p_time_from FOR UPDATE OF DEBUG_ID NOWAIT;
1358:
1359: l_xdp_debug_type XDP_DEBUG.DEBUG_TYPE%TYPE;
1360: l_xdp_error_id XDP_ERROR_LOG.ERROR_ID%TYPE;
1361: l_xnp_debug_id XNP_DEBUG.DEBUG_ID%TYPE;
1362:
1363: l_counter NUMBER := 0;

Line 1376: SELECT COUNT(*) INTO l_no_reords FROM XDP_DEBUG

1372: IF(p_run_mode = 'PURGE') THEN
1373: l_rec_name := 'XDP_PURGE_REC';
1374: END IF;
1375:
1376: SELECT COUNT(*) INTO l_no_reords FROM XDP_DEBUG
1377: WHERE LAST_UPDATE_DATE < p_time_to
1378: AND LAST_UPDATE_DATE > p_time_from;
1379:
1380: RECORDS_PURGED_MSGS(l_no_reords,'XDP_DEBUG',l_rec_name,0);

Line 1380: RECORDS_PURGED_MSGS(l_no_reords,'XDP_DEBUG',l_rec_name,0);

1376: SELECT COUNT(*) INTO l_no_reords FROM XDP_DEBUG
1377: WHERE LAST_UPDATE_DATE < p_time_to
1378: AND LAST_UPDATE_DATE > p_time_from;
1379:
1380: RECORDS_PURGED_MSGS(l_no_reords,'XDP_DEBUG',l_rec_name,0);
1381: l_user_rollback := USER_ROLLBACK_CTRL(p_rollback_segment);
1382: IF p_run_mode = 'PURGE' THEN
1383: <>
1384: LOOP

Line 1386: OPEN c_xdp_debug(p_time_from,p_time_to);

1382: IF p_run_mode = 'PURGE' THEN
1383: <>
1384: LOOP
1385: -- REOPEN IT AFTER COMMIT
1386: OPEN c_xdp_debug(p_time_from,p_time_to);
1387: <>
1388: LOOP
1389: FETCH c_xdp_debug INTO l_xdp_debug_type;
1390:

Line 1389: FETCH c_xdp_debug INTO l_xdp_debug_type;

1385: -- REOPEN IT AFTER COMMIT
1386: OPEN c_xdp_debug(p_time_from,p_time_to);
1387: <>
1388: LOOP
1389: FETCH c_xdp_debug INTO l_xdp_debug_type;
1390:
1391: -- IF NO DATA FOUND, THEN EXIT
1392: IF c_xdp_debug%notfound THEN
1393: EXIT OUTER_LOOP;

Line 1392: IF c_xdp_debug%notfound THEN

1388: LOOP
1389: FETCH c_xdp_debug INTO l_xdp_debug_type;
1390:
1391: -- IF NO DATA FOUND, THEN EXIT
1392: IF c_xdp_debug%notfound THEN
1393: EXIT OUTER_LOOP;
1394: END IF;
1395:
1396: DELETE FROM XDP_DEBUG WHERE CURRENT OF c_xdp_debug;

Line 1396: DELETE FROM XDP_DEBUG WHERE CURRENT OF c_xdp_debug;

1392: IF c_xdp_debug%notfound THEN
1393: EXIT OUTER_LOOP;
1394: END IF;
1395:
1396: DELETE FROM XDP_DEBUG WHERE CURRENT OF c_xdp_debug;
1397:
1398: l_counter:=l_counter+1;
1399: IF (l_counter > g_max_rows_before_commit) AND (NOT l_user_rollback) THEN
1400: l_counter := 0;

Line 1407: IF (c_xdp_debug%ISOPEN) THEN

1403: END IF;
1404:
1405: END LOOP INNER_LOOP;
1406:
1407: IF (c_xdp_debug%ISOPEN) THEN
1408: CLOSE c_xdp_debug;
1409: END IF;
1410: END LOOP OUTER_LOOP;
1411: END IF;

Line 1408: CLOSE c_xdp_debug;

1404:
1405: END LOOP INNER_LOOP;
1406:
1407: IF (c_xdp_debug%ISOPEN) THEN
1408: CLOSE c_xdp_debug;
1409: END IF;
1410: END LOOP OUTER_LOOP;
1411: END IF;
1412: