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_SOA

Line 311: FOR l_sv_soa IN (SELECT SV_SOA_ID FROM XNP_SV_SOA A, XNP_SV_STATUS_TYPES_B B

307: FND_MESSAGE.SET_TOKEN('CONDITION','XDP_CHECK_SOA');
308: PURGE_ERRORS(FND_MESSAGE.GET);
309: END IF;
310:
311: FOR l_sv_soa IN (SELECT SV_SOA_ID FROM XNP_SV_SOA A, XNP_SV_STATUS_TYPES_B B
312: WHERE a.STATUS_TYPE_CODE = b.STATUS_TYPE_CODE
313: AND b.PHASE_INDICATOR ='OLD'
314: AND a.MODIFIED_DATE < p_time_to
315: AND a.MODIFIED_DATE > p_time_from)

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 338: SELECT COUNT(*) INTO l_no_records FROM XNP_SV_SOA WHERE SV_SOA_ID = p_sv_soa_id;

334: END LOOP;
335: RETURN;
336: END IF;
337:
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

Line 339: RECORDS_PURGED_MSGS(l_no_records,'XNP_SV_SOA WHERE SV_SOA_ID ='

335: RETURN;
336: END IF;
337:
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;

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 1207: SELECT SV_SOA_ID FROM XNP_SV_SOA A, XNP_SV_STATUS_TYPES_B B

1203: p_run_mode IN VARCHAR2 DEFAULT 'VERIFY',
1204: p_rollback_segment IN VARCHAR2 DEFAULT NULL
1205: ) IS
1206: CURSOR c_xnp_soa(p_time_from IN DATE,p_time_to IN DATE) IS
1207: SELECT SV_SOA_ID FROM XNP_SV_SOA A, XNP_SV_STATUS_TYPES_B B
1208: WHERE a.STATUS_TYPE_CODE = b.STATUS_TYPE_CODE
1209: AND b.PHASE_INDICATOR ='OLD'
1210: AND a.MODIFIED_DATE < p_time_to
1211: AND a.MODIFIED_DATE > p_time_from FOR UPDATE OF A.SV_SOA_ID NOWAIT;

Line 1213: l_xnp_soa_id XNP_SV_SOA.SV_SOA_ID%TYPE;

1209: AND b.PHASE_INDICATOR ='OLD'
1210: AND a.MODIFIED_DATE < p_time_to
1211: AND a.MODIFIED_DATE > p_time_from FOR UPDATE OF A.SV_SOA_ID NOWAIT;
1212:
1213: l_xnp_soa_id XNP_SV_SOA.SV_SOA_ID%TYPE;
1214: l_counter NUMBER := 0;
1215: l_no_msgs NUMBER := 0;
1216: l_temp NUMBER := 0;
1217: l_user_rollback BOOLEAN := TRUE;

Line 1232: SELECT COUNT(*) INTO l_temp FROM XNP_SV_SOA A, XNP_SV_STATUS_TYPES_B B

1228: l_rec_name := 'XDP_PURGE_REC';
1229: END IF;
1230:
1231: IF p_run_mode ='CHECK' THEN
1232: SELECT COUNT(*) INTO l_temp FROM XNP_SV_SOA A, XNP_SV_STATUS_TYPES_B B
1233: WHERE a.STATUS_TYPE_CODE = b.STATUS_TYPE_CODE
1234: AND b.PHASE_INDICATOR ='OLD'
1235: AND a.MODIFIED_DATE < p_time_to
1236: AND a.MODIFIED_DATE > p_time_from;

Line 1240: RECORDS_PURGED_MSGS(l_temp,'XNP_SV_SOA',l_rec_name,0);

1236: AND a.MODIFIED_DATE > p_time_from;
1237:
1238: IF l_temp = 0 THEN
1239: XDP_CHECK_SOA(NULL,p_time_from,p_time_to);
1240: RECORDS_PURGED_MSGS(l_temp,'XNP_SV_SOA',l_rec_name,0);
1241: RETURN;
1242: END IF;
1243: END IF;
1244:

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;

Line 1290: DELETE FROM XNP_SV_SOA WHERE CURRENT OF c_xnp_soa;

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;
1293: IF (l_counter > g_max_rows_before_commit) AND (NOT l_user_rollback) THEN
1294: l_counter := 0;

Line 1310: RECORDS_PURGED_MSGS(l_no_msgs,'XNP_SV_SOA',l_rec_name,-1);

1306: END LOOP OUTER_XNP_SOA;
1307: END IF;
1308: COMMIT;
1309:
1310: RECORDS_PURGED_MSGS(l_no_msgs,'XNP_SV_SOA',l_rec_name,-1);
1311:
1312: COMMIT;
1313: EXCEPTION
1314: WHEN OTHERS THEN