The following lines contain the word 'select', 'insert', 'update' or 'delete':
pv_wi_param_list.delete;
pv_fa_param_list.delete;
p_update_db in varchar2 default 'Y')
is
l_index number;
-- If so the cache is updated
-- Else the Parameter Configuratio is added
l_index := get_param_index(g_WIParam, p_param_name);
-- Parameter already found. Update required
-- dbms_output.put_line(' -- Need to Update the cache:(WI) ' || p_param_name);
p_update_db in varchar2 default 'Y')
is
l_index number;
-- If so the cache is updated
-- Else the Parameter Configuratio is added
l_index := get_param_index(g_FAParam, p_param_name);
-- Paramter already exists in the Cache. Needs an update
-- dbms_output.put_line(' -- Need to Update the cache: (FA) ' || p_param_name);
-- get the index to be deleted
l_index := get_param_index(p_param_type, p_param_name);
-- delete the entry from the cache
if p_param_type = g_WIParam then
-- dbms_output.put_line('removing.. ' || l_index);
pv_wi_param_list.delete(l_index);
pv_fa_param_list.delete(l_index);
p_update_db => 'N');
p_update_db => 'N');
p_update_db => 'N');