The following lines contain the word 'select', 'insert', 'update' or 'delete':
if (p_mode <> 'DELETE') then
my_entry := dbms_ldap.first_entry(p_session, p_data);
else /* 'Delete' */
wf_entity_mgr.flush_cache(p_entity, p_delkey);
wf_entity_mgr.process_changes(p_entity, p_delkey, 'LDAP', 'DELETE');
wf_entity_mgr.process_changes(p_entity, p_delkey, 'LDAP', 'DELETE');
** update_ldap - Update LDAP directory with specified user changes
*/
PROCEDURE update_ldap(p_entity_type in varchar2,
p_entity_key_value in varchar2,
p_change_source in varchar2,
p_change_type in varchar2,
p_user_base in varchar2)
is
my_session dbms_ldap.session;
select attribute_name aname,
attribute_value avalue
from wf_attribute_cache
where entity_key_value = p_entity_key_value
and entity_type = p_entity_type
and attribute_name <> 'CACHE_CHANGED';
end update_ldap;