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_FAILURES

Line 323: SELECT COUNT(*) INTO l_no_records FROM XNP_SV_FAILURES

319:
320: RECORDS_PURGED_MSGS(l_no_records,'XNP_SV_SOA_JN WHERE SV_SOA_ID ='
321: ||l_sv_soa.SV_SOA_ID,'XDP_FOUND_REC',1);
322:
323: SELECT COUNT(*) INTO l_no_records FROM XNP_SV_FAILURES
324: WHERE SV_SOA_ID = l_sv_soa.SV_SOA_ID;
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);

Line 326: RECORDS_PURGED_MSGS(l_no_records,'XNP_SV_FAILURES WHERE SV_SOA_ID ='

322:
323: SELECT COUNT(*) INTO l_no_records FROM XNP_SV_FAILURES
324: WHERE SV_SOA_ID = l_sv_soa.SV_SOA_ID;
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;

Line 346: SELECT COUNT(*) INTO l_no_records FROM XNP_SV_FAILURES

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 ='
349: ||p_sv_soa_id,'XDP_FOUND_REC',0);
350: SELECT COUNT(*) INTO l_no_records FROM XNP_SV_SOA_JN

Line 348: RECORDS_PURGED_MSGS(l_no_records,'XNP_SV_FAILURES WHERE 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 ='
349: ||p_sv_soa_id,'XDP_FOUND_REC',0);
350: SELECT COUNT(*) INTO l_no_records FROM XNP_SV_SOA_JN
351: WHERE SV_SOA_ID = p_sv_soa_id;
352: RECORDS_PURGED_MSGS(l_no_records,'XNP_SV_SOA_JN WHERE SV_SOA_ID ='

Line 1256: SELECT COUNT(*) INTO l_temp FROM XNP_SV_FAILURES

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 ='
1259: ||l_xnp_soa.sv_soa_id,l_rec_name,0);
1260: SELECT COUNT(*) INTO l_temp FROM XNP_SV_SOA_JN

Line 1258: RECORDS_PURGED_MSGS(l_temp,'XNP_SV_FAILURES WHERE 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 ='
1259: ||l_xnp_soa.sv_soa_id,l_rec_name,0);
1260: SELECT COUNT(*) INTO l_temp FROM XNP_SV_SOA_JN
1261: WHERE SV_SOA_ID = l_xnp_soa.sv_soa_id;
1262: RECORDS_PURGED_MSGS(l_temp,'XNP_SV_SOA_JN WHERE SV_SOA_ID ='

Line 1286: DELETE FROM XNP_SV_FAILURES WHERE

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
1289: SV_SOA_ID = l_xnp_soa_id;
1290: DELETE FROM XNP_SV_SOA WHERE CURRENT OF c_xnp_soa;