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_IMP_SOURCE_LINES

Line 75: FROM ams_list_entries a, ams_imp_source_lines b

71: AND a.action_used_by_id = b.list_header_id;
72:
73: CURSOR c_list_entries_rec1 (c_imp_header_id NUMBER, c_list_header_id NUMBER) IS
74: SELECT a.list_header_id, a.list_entry_id
75: FROM ams_list_entries a, ams_imp_source_lines b
76: WHERE a.list_header_id = c_list_header_id
77: AND a.imp_source_line_id = b.import_source_line_id
78: AND b.import_list_header_id = c_imp_header_id
79: ORDER BY a.list_header_id;

Line 85: FROM ams_list_entries a, ams_imp_source_lines b

81: l_list_entries_rec c_list_entries_rec1%ROWTYPE;
82:
83: CURSOR c_list_entries_rec2 (c_list_header_id NUMBER, c_imp_header_id NUMBER, c_usage NUMBER) IS
84: SELECT a.list_header_id, a.list_entry_id
85: FROM ams_list_entries a, ams_imp_source_lines b
86: WHERE a.list_header_id = c_list_header_id
87: AND a.imp_source_line_id = b.import_source_line_id
88: AND b.import_list_header_id = c_imp_header_id
89: AND b.current_usage >= c_usage

Line 105: FROM ams_imp_source_lines

101: l_force_purge_flag VARCHAR2(1) := 'N'; -- default not to force purge
102:
103: CURSOR c_usage_rec ( p_imp_header_id NUMBER) IS
104: SELECT current_usage
105: FROM ams_imp_source_lines
106: WHERE import_list_header_id = p_imp_header_id;
107:
108: CURSOR c_get_usr_status (p_lookup_code VARCHAR2) IS
109: SELECT user_status_id

Line 160: -- Delete from ams_imp_source_lines

156: IF (AMS_DEBUG_HIGH_ON) THEN
157: AMS_Utility_PVT.Debug_Message(l_api_name||': ' || l_import_list_header_id ||' grace period passed');
158: END IF;
159:
160: -- Delete from ams_imp_source_lines
161: IF (AMS_DEBUG_HIGH_ON) THEN
162: AMS_Utility_PVT.debug_message(l_api_name||': delete from source lines');
163: END IF;
164: DELETE FROM ams_imp_source_lines

Line 164: DELETE FROM ams_imp_source_lines

160: -- Delete from ams_imp_source_lines
161: IF (AMS_DEBUG_HIGH_ON) THEN
162: AMS_Utility_PVT.debug_message(l_api_name||': delete from source lines');
163: END IF;
164: DELETE FROM ams_imp_source_lines
165: WHERE import_list_header_id = l_import_list_header_id;
166: END IF;
167: ELSIF l_expiry_date IS NOT NULL AND l_expiry_date <= SYSDATE THEN
168:

Line 292: -- Delete from ams_imp_source_lines

288: where list_header_id = l_list_header_tbl(i) )
289: WHERE list_header_id = l_list_header_tbl(i);
290: END IF;
291:
292: -- Delete from ams_imp_source_lines
293: DELETE FROM ams_imp_source_lines
294: WHERE import_list_header_id = l_import_list_header_id;
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);

Line 293: DELETE FROM ams_imp_source_lines

289: WHERE list_header_id = l_list_header_tbl(i);
290: END IF;
291:
292: -- Delete from ams_imp_source_lines
293: DELETE FROM ams_imp_source_lines
294: WHERE import_list_header_id = l_import_list_header_id;
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;

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

292: -- Delete from ams_imp_source_lines
293: DELETE FROM ams_imp_source_lines
294: WHERE import_list_header_id = l_import_list_header_id;
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

Line 434: FROM ams_imp_source_lines

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
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);

Line 442: AMS_Utility_PVT.debug_message(l_api_name||': deleting from ams_imp_source_lines');

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');
443: END IF;
444:
445: -- Delete from ams_imp_source_lines
446: DELETE FROM ams_imp_source_lines

Line 445: -- Delete from ams_imp_source_lines

441: IF (AMS_DEBUG_HIGH_ON) THEN
442: AMS_Utility_PVT.debug_message(l_api_name||': deleting from ams_imp_source_lines');
443: END IF;
444:
445: -- Delete from ams_imp_source_lines
446: DELETE FROM ams_imp_source_lines
447: WHERE import_list_header_id = l_import_list_header_id
448: AND current_usage >= l_usage;
449:

Line 446: DELETE FROM ams_imp_source_lines

442: AMS_Utility_PVT.debug_message(l_api_name||': deleting from ams_imp_source_lines');
443: END IF;
444:
445: -- Delete from ams_imp_source_lines
446: DELETE FROM ams_imp_source_lines
447: WHERE import_list_header_id = l_import_list_header_id
448: AND current_usage >= l_usage;
449:
450: END IF;

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

449:
450: END IF;
451:
452: IF (AMS_DEBUG_HIGH_ON) THEN
453: AMS_Utility_PVT.debug_message(l_api_name||': count of ams_imp_source_lines deleted:'||sql%rowcount);
454: AMS_Utility_PVT.Debug_Message(l_api_name||': Delete log and update ams_imp_list_headers_all ');
455: END IF;
456:
457: OPEN C_get_usr_status(l_lookup_code);

Line 474: FROM ams_imp_source_lines b

470: WHERE a.import_list_header_id = l_import_list_header_id
471: AND a.object_version_number = l_object_version
472: AND NOT EXISTS (
473: SELECT import_source_line_id
474: FROM ams_imp_source_lines b
475: WHERE b.import_list_header_id = a.import_list_header_id)
476: RETURNING status_code INTO l_upd_status_code;
477:
478: IF (AMS_DEBUG_HIGH_ON) THEN

Line 855: FROM ams_imp_source_lines lines, ams_list_entries entries

851:
852: CURSOR c_source_line_rec(p_list_header_id IN NUMBER) IS
853: SELECT lines.import_source_line_id, lines.object_version_number,
854: lines.current_usage
855: FROM ams_imp_source_lines lines, ams_list_entries entries
856: WHERE entries.list_header_id = p_list_header_id
857: AND ENTRIES.enabled_flag = 'Y'
858: AND lines.import_source_line_id = entries.imp_source_line_id;
859:

Line 914: UPDATE ams_imp_source_lines SET

910: CLOSE c_source_line_rec;
911:
912: IF l_iterator > 1 THEN
913: FORALL i IN l_source_line_id_tbl.first .. l_source_line_id_tbl.last
914: UPDATE ams_imp_source_lines SET
915: current_usage = l_current_usage_tbl(i)
916: , object_version_number = l_object_version_tbl(i)
917: , last_update_date = SYSDATE
918: , last_updated_by = FND_GLOBAL.user_id