APPS.AMS_DEL_DISABLED_LIST_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 47

   CURSOR c_list_entries_deleted IS
   SELECT LIST_ENTRY_ROW_ID, LIST_HEADER_ID, ROWID PURGE_ROWID
   FROM AMS_LIST_ENTRIES_PURGE;

Line: 58

   l_api_name      VARCHAR2(50) := 'Delete_Disabled_List_Entries';

Line: 79

      INSERT INTO AMS_LIST_ENTRIES_PURGE (LIST_HEADER_ID,LIST_ENTRY_ROW_ID)
        SELECT ale.list_header_id list_header_id, ale.rowid list_entry_row_id
          FROM AMS_LIST_ENTRIES ale
         WHERE ale.list_header_id = p_list_name
           AND ale.enabled_flag = 'N' ;

Line: 87

       FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inserted into AMS_LIST_ENTRIES_PURGE ' );

Line: 98

	 FND_FILE.PUT_LINE(FND_FILE.LOG, ' OPEN cursor c_list_entries_deleted' );

Line: 99

         OPEN  c_list_entries_deleted;

Line: 100

         FETCH c_list_entries_deleted
           BULK COLLECT INTO l_list_rec.tbl_rowid,
                             l_list_rec.list_header_id,
                             l_list_rec.purge_rowid
           LIMIT l_cursor_limit;

Line: 105

         CLOSE c_list_entries_deleted;

Line: 108

              IF c_list_entries_deleted%ISOPEN THEN
                  CLOSE c_list_entries_deleted;

Line: 111

              FND_FILE.PUT_LINE(FND_FILE.LOG, ' Others Exception in OPEN c_list_entries_deleted ' );

Line: 112

 	      errbuf  := 'Error in cursor c_list_entries_deleted ' || SQLERRM;

Line: 121

	-- Delete from tables
         FND_FILE.PUT_LINE(FND_FILE.LOG, ' Delete list_entries from AMS_LIST_ENTRIES ' );

Line: 152

		 DELETE FROM AMS_LIST_ENTRIES
                  WHERE rowid = l_list_rec.tbl_rowid(i);

Line: 155

		 DELETE FROM AMS_LIST_ENTRIES_PURGE
		  WHERE rowid = l_list_rec.purge_rowid(i);

Line: 159

	      FND_FILE.PUT_LINE(FND_FILE.LOG, ' Records deleted: ' || l_first ||'-'|| l_last );