APPS.XDP_PURGE dependencies on XDP_ERROR_LOG

Line 1349: SELECT ERROR_ID FROM XDP_ERROR_LOG

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
1349: SELECT ERROR_ID FROM XDP_ERROR_LOG
1350: WHERE LAST_UPDATE_DATE < p_time_to
1351: AND LAST_UPDATE_DATE > p_time_from FOR UPDATE OF ERROR_ID NOWAIT;
1352:
1353:

Line 1360: l_xdp_error_id XDP_ERROR_LOG.ERROR_ID%TYPE;

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;
1364: l_no_reords NUMBER := 0;

Line 1415: SELECT COUNT(*) INTO l_no_reords FROM XDP_ERROR_LOG

1411: END IF;
1412:
1413: COMMIT;
1414:
1415: SELECT COUNT(*) INTO l_no_reords FROM XDP_ERROR_LOG
1416: WHERE LAST_UPDATE_DATE < p_time_to
1417: AND LAST_UPDATE_DATE > p_time_from;
1418:
1419: RECORDS_PURGED_MSGS(l_no_reords,'XDP_ERROR_LOG',l_rec_name,-1);

Line 1419: RECORDS_PURGED_MSGS(l_no_reords,'XDP_ERROR_LOG',l_rec_name,-1);

1415: SELECT COUNT(*) INTO l_no_reords FROM XDP_ERROR_LOG
1416: WHERE LAST_UPDATE_DATE < p_time_to
1417: AND LAST_UPDATE_DATE > p_time_from;
1418:
1419: RECORDS_PURGED_MSGS(l_no_reords,'XDP_ERROR_LOG',l_rec_name,-1);
1420: l_user_rollback := USER_ROLLBACK_CTRL(p_rollback_segment);
1421: l_counter := 0;
1422:
1423: IF p_run_mode = 'PURGE' THEN

Line 1437: DELETE FROM XDP_ERROR_LOG WHERE CURRENT OF c_xdp_errors;

1433: IF c_xdp_errors%notfound THEN
1434: EXIT OUTER_ERROR;
1435: END IF;
1436:
1437: DELETE FROM XDP_ERROR_LOG WHERE CURRENT OF c_xdp_errors;
1438: l_counter:=l_counter+1;
1439: IF (l_counter > g_max_rows_before_commit) AND (NOT l_user_rollback) THEN
1440: l_counter := 0;
1441: COMMIT;