DBA Data[Home] [Help]

APPS.AMS_LISTGENERATION_UTIL_PKG dependencies on STANDARD

Line 175: -- If p_listheader_rec.generation_type = 'STANDARD' then

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;

Line 176: If l_gen_type = 'STANDARD' then

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:

Line 208: End if; -- STANDARD

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