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_LIST_ENTRIES

Line 20: -- 12/12/2001 yxliu add logic to purge ams_list_entries

16: -- Note
17: --
18: -- History
19: -- 05/18/2001 yxliu created
20: -- 12/12/2001 yxliu add logic to purge ams_list_entries
21: -- add parameter force_purge_flag
22: -- 01/10/2002 yxliu add delete cancelled imp list headers
23: -------------------------------------------------------------------------------
24: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

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 173: -- Add logic to delete from ams_list_entries

169: IF (AMS_DEBUG_HIGH_ON) THEN
170: AMS_Utility_PVT.Debug_Message(l_api_name||': ' || l_import_list_header_id ||' expiry date passed');
171: END IF;
172:
173: -- Add logic to delete from ams_list_entries
174: IF (AMS_DEBUG_HIGH_ON) THEN
175: AMS_Utility_PVT.debug_message(l_api_name||': delete from list entries');
176: END IF;
177:

Line 269: DELETE FROM ams_list_entries

265:
266: -- Do bulk delete from list entries
267: IF l_entry_iterator > 1 THEN
268: FORALL i IN l_list_entry_tbl.first .. l_list_entry_tbl.last
269: DELETE FROM ams_list_entries
270: WHERE list_entry_id = l_list_entry_tbl(i);
271: END IF;
272:
273: IF (AMS_DEBUG_HIGH_ON) THEN

Line 287: from ams_list_entries

283: , no_of_rows_active
284: , last_update_date )=(select count(1),
285: sum(decode(enabled_flag,'Y',1,0)),
286: sysdate
287: from ams_list_entries
288: where list_header_id = l_list_header_tbl(i) )
289: WHERE list_header_id = l_list_header_tbl(i);
290: END IF;
291:

Line 311: -- Add logic to delete from ams_list_entries

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);
309: END IF;
310:
311: -- Add logic to delete from ams_list_entries
312: IF (AMS_DEBUG_HIGH_ON) THEN
313: AMS_Utility_PVT.debug_message(l_api_name||': delete from list entries:' || l_force_purge_flag);
314: END IF;
315:

Line 401: DELETE FROM ams_list_entries

397: AMS_Utility_PVT.debug_message(l_api_name||': l_list_entry_tbl.count=' || l_list_entry_tbl.count);
398: END IF;
399: IF l_entry_iterator > 1 THEN
400: FORALL i IN l_list_entry_tbl.first .. l_list_entry_tbl.last
401: DELETE FROM ams_list_entries
402: WHERE list_entry_id = l_list_entry_tbl(i);
403: END IF;
404: IF (AMS_DEBUG_HIGH_ON) THEN
405: AMS_Utility_PVT.debug_message(l_api_name||': bulk update on list headers');

Line 420: from ams_list_entries

416: , no_of_rows_active
417: , last_update_date )=(select count(1),
418: sum(decode(enabled_flag,'Y',1,0)),
419: sysdate
420: from ams_list_entries
421: where list_header_id = l_list_header_tbl(i) )
422: WHERE list_header_id = l_list_header_tbl(i);
423: END IF;
424:

Line 696: -- Delete from ams_list_entries

692: IF (AMS_DEBUG_HIGH_ON) THEN
693:
694: AMS_Utility_PVT.Debug_Message(l_api_name||' Purge list header ID ' || l_list_header_id);
695: END IF;
696: -- Delete from ams_list_entries
697: DELETE FROM ams_list_entries
698: WHERE list_header_id = l_list_header_id;
699:
700: -- initialize any default values

Line 697: DELETE FROM ams_list_entries

693:
694: AMS_Utility_PVT.Debug_Message(l_api_name||' Purge list header ID ' || l_list_header_id);
695: END IF;
696: -- Delete from ams_list_entries
697: DELETE FROM ams_list_entries
698: WHERE list_header_id = l_list_header_id;
699:
700: -- initialize any default values
701:

Line 715: from ams_list_entries

711: sum(decode(enabled_flag,'Y',1,0)),
712: sum(decode(marked_as_duplicate_flag,'Y',1,0)),
713: sum(decode(enabled_flag,'Y',0,1)),
714: sysdate
715: from ams_list_entries
716: where list_header_id = l_list_header_id)
717:
718: WHERE list_header_id = l_list_header_id;*/
719:

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 1194: l_table_name VARCHAR2(30) := 'AMS_LIST_ENTRIES';

1190: , x_argument4 IN VARCHAR2) IS
1191:
1192: l_worker_id NUMBER;
1193: l_product VARCHAR2(30) := 'AMS';
1194: l_table_name VARCHAR2(30) := 'AMS_LIST_ENTRIES';
1195: l_update_name VARCHAR2(30);
1196: l_status VARCHAR2(30);
1197: l_industry VARCHAR2(30);
1198: l_restatus BOOLEAN;

Line 1246: AMS_LIST_ENTRIES entries

1242:
1243: WHILE ( l_any_rows_to_process = TRUE )
1244: LOOP
1245: DELETE /*+ rowid(entries) */
1246: AMS_LIST_ENTRIES entries
1247: WHERE list_header_id IN (select list_header_id from ams_list_headers_all
1248: where request_id = x_argument4)
1249: AND ROWID BETWEEN l_start_rowid AND l_end_rowid;
1250:

Line 1344: DELETE from ams_list_entries

1340:
1341: --l_header_id_tbl := p_list_header_id_tbl.l_list_header_id;
1342:
1343: FORALL i in 1 .. l_header_id_tbl.count
1344: DELETE from ams_list_entries
1345: WHERE list_header_id = l_header_id_tbl(i);
1346:
1347: delete_list_info(p_id_tbl => l_header_id_tbl,
1348: x_return_status => x_return_status,

Line 1538: l_table_name VARCHAR2(30) := 'AMS_LIST_ENTRIES';

1534: , x_argument4 IN VARCHAR2) IS
1535:
1536: l_worker_id NUMBER;
1537: l_product VARCHAR2(30) := 'AMS';
1538: l_table_name VARCHAR2(30) := 'AMS_LIST_ENTRIES';
1539: l_update_name VARCHAR2(30);
1540: l_status VARCHAR2(30);
1541: l_industry VARCHAR2(30);
1542: l_restatus BOOLEAN;

Line 1590: AMS_LIST_ENTRIES entries

1586:
1587: WHILE ( l_any_rows_to_process = TRUE )
1588: LOOP
1589: DELETE /*+ rowid(entries) */
1590: AMS_LIST_ENTRIES entries
1591: WHERE list_header_id IN (select list_header_id from ams_list_headers_all
1592: where request_id = x_argument4)
1593: AND ROWID BETWEEN l_start_rowid AND l_end_rowid;
1594: