APPS.AMS_LISTGENERATION_UTIL_PKG dependencies on AMS_LIST_ENTRIES

Line 178: DELETE FROM ams_list_entries

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:
181: AMS_LISTGENERATION_PKG.write_to_act_log(sql%rowcount||' entries deleted from ams_list_entries in local instance.', 'LIST', p_list_header_id,'LOW');
182:

Line 181: AMS_LISTGENERATION_PKG.write_to_act_log(sql%rowcount||' entries deleted from ams_list_entries in local instance.', 'LIST', p_list_header_id,'LOW');

177:
178: DELETE FROM ams_list_entries
179: WHERE list_header_id = p_list_header_id;
180:
181: AMS_LISTGENERATION_PKG.write_to_act_log(sql%rowcount||' entries deleted from ams_list_entries in local instance.', 'LIST', p_list_header_id,'LOW');
182:
183: If g_remote_gen = 'Y' -- based on remote DS so delete remotely
184: then
185: AMS_LISTGENERATION_PKG.write_to_act_log('Calling remote procedure with process type as DELETE_LIST_ENTRIES to delete entries in remote instance', 'LIST', p_list_header_id,'LOW');

Line 353: from ams_list_entries

349: select sum(decode(enabled_flag,'N',0,1)),
350: sum(decode(enabled_flag,'Y',0,1)),
351: sum(1),
352: sum(decode(part_of_control_group_flag,'Y',1,0))
353: from ams_list_entries
354: where list_header_id = p_list_header_id ;
355:
356: cursor c_list_header_info is
357: select list_type, ctrl_gen_mode