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 XNP_SV_EVENT_HISTORY

Line 329: SELECT COUNT(*) INTO l_no_records FROM XNP_SV_EVENT_HISTORY

325:
326: RECORDS_PURGED_MSGS(l_no_records,'XNP_SV_FAILURES WHERE SV_SOA_ID ='
327: ||l_sv_soa.SV_SOA_ID,'XDP_FOUND_REC',1);
328:
329: SELECT COUNT(*) INTO l_no_records FROM XNP_SV_EVENT_HISTORY
330: WHERE SV_SOA_ID = l_sv_soa.SV_SOA_ID;
331:
332: RECORDS_PURGED_MSGS(l_no_records,'XNP_SV_EVENT_HISTORY WHERE SV_SOA_ID ='
333: ||l_sv_soa.SV_SOA_ID,'XDP_FOUND_REC',1);

Line 332: RECORDS_PURGED_MSGS(l_no_records,'XNP_SV_EVENT_HISTORY WHERE SV_SOA_ID ='

328:
329: SELECT COUNT(*) INTO l_no_records FROM XNP_SV_EVENT_HISTORY
330: WHERE SV_SOA_ID = l_sv_soa.SV_SOA_ID;
331:
332: RECORDS_PURGED_MSGS(l_no_records,'XNP_SV_EVENT_HISTORY WHERE SV_SOA_ID ='
333: ||l_sv_soa.SV_SOA_ID,'XDP_FOUND_REC',1);
334: END LOOP;
335: RETURN;
336: END IF;

Line 342: SELECT COUNT(*) INTO l_no_records FROM XNP_SV_EVENT_HISTORY

338: SELECT COUNT(*) INTO l_no_records FROM XNP_SV_SOA WHERE SV_SOA_ID = p_sv_soa_id;
339: RECORDS_PURGED_MSGS(l_no_records,'XNP_SV_SOA WHERE SV_SOA_ID ='
340: ||p_sv_soa_id,'XDP_FOUND_REC',0);
341:
342: SELECT COUNT(*) INTO l_no_records FROM XNP_SV_EVENT_HISTORY
343: WHERE SV_SOA_ID = p_sv_soa_id;
344: RECORDS_PURGED_MSGS(l_no_records,'XNP_SV_EVENT_HISTORY WHERE SV_SOA_ID ='
345: ||p_sv_soa_id,'XDP_FOUND_REC',0);
346: SELECT COUNT(*) INTO l_no_records FROM XNP_SV_FAILURES

Line 344: RECORDS_PURGED_MSGS(l_no_records,'XNP_SV_EVENT_HISTORY WHERE SV_SOA_ID ='

340: ||p_sv_soa_id,'XDP_FOUND_REC',0);
341:
342: SELECT COUNT(*) INTO l_no_records FROM XNP_SV_EVENT_HISTORY
343: WHERE SV_SOA_ID = p_sv_soa_id;
344: RECORDS_PURGED_MSGS(l_no_records,'XNP_SV_EVENT_HISTORY WHERE SV_SOA_ID ='
345: ||p_sv_soa_id,'XDP_FOUND_REC',0);
346: SELECT COUNT(*) INTO l_no_records FROM XNP_SV_FAILURES
347: WHERE SV_SOA_ID = p_sv_soa_id;
348: RECORDS_PURGED_MSGS(l_no_records,'XNP_SV_FAILURES WHERE SV_SOA_ID ='

Line 1252: SELECT COUNT(*) INTO l_temp FROM XNP_SV_EVENT_HISTORY

1248: PURGE_ERRORS('==== '||p_run_mode||' SOA '||l_xnp_soa.sv_soa_id ||' ===================');
1249: IF p_run_mode = 'CHECK' THEN
1250: XDP_CHECK_SOA(l_xnp_soa.sv_soa_id);
1251: ELSE IF ((bAudit = 'TRUE') AND (p_run_mode = 'PURGE')) or (p_run_mode = 'VERIFY') THEN
1252: SELECT COUNT(*) INTO l_temp FROM XNP_SV_EVENT_HISTORY
1253: WHERE SV_SOA_ID = l_xnp_soa.sv_soa_id;
1254: RECORDS_PURGED_MSGS(l_temp,'XNP_SV_EVENT_HISTORY WHERE SV_SOA_ID ='
1255: ||l_xnp_soa.sv_soa_id,l_rec_name,0);
1256: SELECT COUNT(*) INTO l_temp FROM XNP_SV_FAILURES

Line 1254: RECORDS_PURGED_MSGS(l_temp,'XNP_SV_EVENT_HISTORY WHERE SV_SOA_ID ='

1250: XDP_CHECK_SOA(l_xnp_soa.sv_soa_id);
1251: ELSE IF ((bAudit = 'TRUE') AND (p_run_mode = 'PURGE')) or (p_run_mode = 'VERIFY') THEN
1252: SELECT COUNT(*) INTO l_temp FROM XNP_SV_EVENT_HISTORY
1253: WHERE SV_SOA_ID = l_xnp_soa.sv_soa_id;
1254: RECORDS_PURGED_MSGS(l_temp,'XNP_SV_EVENT_HISTORY WHERE SV_SOA_ID ='
1255: ||l_xnp_soa.sv_soa_id,l_rec_name,0);
1256: SELECT COUNT(*) INTO l_temp FROM XNP_SV_FAILURES
1257: WHERE SV_SOA_ID = l_xnp_soa.sv_soa_id;
1258: RECORDS_PURGED_MSGS(l_temp,'XNP_SV_FAILURES WHERE SV_SOA_ID ='

Line 1284: DELETE FROM XNP_SV_EVENT_HISTORY WHERE

1280: IF c_xnp_soa%notfound THEN
1281: EXIT OUTER_XNP_SOA; -- we are done
1282: END IF;
1283:
1284: DELETE FROM XNP_SV_EVENT_HISTORY WHERE
1285: SV_SOA_ID = l_xnp_soa_id;
1286: DELETE FROM XNP_SV_FAILURES WHERE
1287: SV_SOA_ID = l_xnp_soa_id;
1288: DELETE FROM XNP_SV_SOA_JN WHERE