APPS.XDP_PURGE dependencies on XNP_SV_SOA_JN

Line 317: SELECT COUNT(*) INTO l_no_records FROM XNP_SV_SOA_JN

313: AND b.PHASE_INDICATOR ='OLD'
314: AND a.MODIFIED_DATE < p_time_to
315: AND a.MODIFIED_DATE > p_time_from)
316: LOOP
317: SELECT COUNT(*) INTO l_no_records FROM XNP_SV_SOA_JN
318: WHERE SV_SOA_ID = l_sv_soa.SV_SOA_ID;
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);

Line 320: RECORDS_PURGED_MSGS(l_no_records,'XNP_SV_SOA_JN WHERE SV_SOA_ID ='

316: LOOP
317: SELECT COUNT(*) INTO l_no_records FROM XNP_SV_SOA_JN
318: WHERE SV_SOA_ID = l_sv_soa.SV_SOA_ID;
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;

Line 350: SELECT COUNT(*) INTO l_no_records FROM XNP_SV_SOA_JN

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 ='
353: ||p_sv_soa_id,'XDP_FOUND_REC',0);
354: COMMIT;

Line 352: RECORDS_PURGED_MSGS(l_no_records,'XNP_SV_SOA_JN WHERE 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 ='
353: ||p_sv_soa_id,'XDP_FOUND_REC',0);
354: COMMIT;
355: EXCEPTION
356: WHEN OTHERS THEN

Line 1260: SELECT COUNT(*) INTO l_temp FROM XNP_SV_SOA_JN

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 ='
1263: ||l_xnp_soa.sv_soa_id,l_rec_name,0);
1264: END IF;

Line 1262: RECORDS_PURGED_MSGS(l_temp,'XNP_SV_SOA_JN WHERE 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 ='
1263: ||l_xnp_soa.sv_soa_id,l_rec_name,0);
1264: END IF;
1265: END IF;
1266: END LOOP;

Line 1288: DELETE FROM XNP_SV_SOA_JN WHERE

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;
1291: l_no_msgs := l_no_msgs +1;
1292: l_counter := l_counter+1;