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.AMS_LIST_PURGE_PVT dependencies on AMS_PARTY_SOURCES

Line 299: -- Delete from ams_party_sources

295: IF (AMS_DEBUG_HIGH_ON) THEN
296: AMS_Utility_PVT.debug_message(l_api_name||': force purge expiry_date passed count of ams_imp_source_lines_deleted:'||sql%rowcount);
297: END IF;
298:
299: -- Delete from ams_party_sources
300: DELETE FROM ams_party_sources
301: WHERE import_list_header_id = l_import_list_header_id
302: AND used_flag = 'N';
303: IF (AMS_DEBUG_HIGH_ON) THEN

Line 300: DELETE FROM ams_party_sources

296: AMS_Utility_PVT.debug_message(l_api_name||': force purge expiry_date passed count of ams_imp_source_lines_deleted:'||sql%rowcount);
297: END IF;
298:
299: -- Delete from ams_party_sources
300: DELETE FROM ams_party_sources
301: WHERE import_list_header_id = l_import_list_header_id
302: AND used_flag = 'N';
303: IF (AMS_DEBUG_HIGH_ON) THEN
304: AMS_Utility_PVT.debug_message(l_api_name||': force purge expiry_date passed count of ams_party_sources:'||sql%rowcount);

Line 304: AMS_Utility_PVT.debug_message(l_api_name||': force purge expiry_date passed count of ams_party_sources:'||sql%rowcount);

300: DELETE FROM ams_party_sources
301: WHERE import_list_header_id = l_import_list_header_id
302: AND used_flag = 'N';
303: IF (AMS_DEBUG_HIGH_ON) THEN
304: AMS_Utility_PVT.debug_message(l_api_name||': force purge expiry_date passed count of ams_party_sources:'||sql%rowcount);
305: END IF;
306: ELSIF l_usage IS NOT NULL THEN -- check usage
307: IF (AMS_DEBUG_HIGH_ON) THEN
308: AMS_Utility_PVT.Debug_Message(l_api_name||': ' || l_import_list_header_id || ': usage is ' ||l_usage);

Line 426: AMS_Utility_PVT.debug_message(l_api_name||': deleting from ams_party_sources');

422: WHERE list_header_id = l_list_header_tbl(i);
423: END IF;
424:
425: IF (AMS_DEBUG_HIGH_ON) THEN
426: AMS_Utility_PVT.debug_message(l_api_name||': deleting from ams_party_sources');
427: END IF;
428:
429: -- Delete from ams_party_sources
430: DELETE FROM ams_party_sources

Line 429: -- Delete from ams_party_sources

425: IF (AMS_DEBUG_HIGH_ON) THEN
426: AMS_Utility_PVT.debug_message(l_api_name||': deleting from ams_party_sources');
427: END IF;
428:
429: -- Delete from ams_party_sources
430: DELETE FROM ams_party_sources
431: WHERE used_flag = 'N'
432: AND import_source_line_id IN (
433: SELECT import_source_line_id

Line 430: DELETE FROM ams_party_sources

426: AMS_Utility_PVT.debug_message(l_api_name||': deleting from ams_party_sources');
427: END IF;
428:
429: -- Delete from ams_party_sources
430: DELETE FROM ams_party_sources
431: WHERE used_flag = 'N'
432: AND import_source_line_id IN (
433: SELECT import_source_line_id
434: FROM ams_imp_source_lines

Line 438: AMS_Utility_PVT.debug_message(l_api_name||': count of ams_party_sources deleted:'||sql%rowcount);

434: FROM ams_imp_source_lines
435: WHERE import_list_header_id = l_import_list_header_id
436: AND current_usage >= l_usage);
437: IF (AMS_DEBUG_HIGH_ON) THEN
438: AMS_Utility_PVT.debug_message(l_api_name||': count of ams_party_sources deleted:'||sql%rowcount);
439: END IF;
440:
441: IF (AMS_DEBUG_HIGH_ON) THEN
442: AMS_Utility_PVT.debug_message(l_api_name||': deleting from ams_imp_source_lines');