171: select generation_type into l_gen_type
172: from ams_list_headers_all
173: where list_header_id = p_list_header_id;
174:
175: -- If p_listheader_rec.generation_type = 'STANDARD' then
176: If l_gen_type = 'STANDARD' then
177:
178: DELETE FROM ams_list_entries
179: WHERE list_header_id = p_list_header_id;
172: from ams_list_headers_all
173: where list_header_id = p_list_header_id;
174:
175: -- If p_listheader_rec.generation_type = 'STANDARD' then
176: If l_gen_type = 'STANDARD' then
177:
178: DELETE FROM ams_list_entries
179: WHERE list_header_id = p_list_header_id;
180:
204: else
205: AMS_LISTGENERATION_PKG.write_to_act_log('Entries deleted succesfully in remote instance','LIST', p_list_header_id,'LOW');
206: end if;
207: end if; --g_remote_gen = 'Y'
208: End if; -- STANDARD
209:
210: AMS_LISTGENERATION_PKG.write_to_act_log('Deleting entries from list src type usages tables.', 'LIST', p_list_header_id,'LOW');
211:
212: DELETE FROM ams_list_src_type_usages