DBA Data[Home] [Help]

APPS.WF_OID dependencies on FND_USER

Line 174: l_apps_username_key := fnd_oid_util.get_fnd_user(p_user_name => l_entity_changes_rec.entity_key_value);

170: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
171: 'l_entity_changes_rec = ' ||
172: fnd_oid_util.GET_ENTITY_CHANGES_REC_STR(l_entity_changes_rec));
173: end if;
174: l_apps_username_key := fnd_oid_util.get_fnd_user(p_user_name => l_entity_changes_rec.entity_key_value);
175: fnd_profile.get_specific(
176: name_z => 'APPS_SSO_LOCAL_LOGIN',
177: user_id_z => l_apps_username_key.user_id,
178: val_z => l_local_login,

Line 300: update fnd_user

296: if (event_status.error_disposition = wf_oid.EVENT_SUCCESS)
297: then
298: -- OID sometimes sends dummy event with user_name=guid
299: if l_entity_key_value <> '' || event_status.orclguid then
300: update fnd_user
301: set user_guid = event_status.orclguid
302: where user_name = l_entity_key_value;
303: else
304: return;

Line 309: , 'Update FND_USER where user_name = ' || l_entity_key_value ||

305: end if;
306: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
307: then
308: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
309: , 'Update FND_USER where user_name = ' || l_entity_key_value ||
310: ' with user_guid = ' || event_status.orclguid);
311: end if;
312:
313: l_profiles := fnd_ldap_mapper.MAP_SSO_USER_PROFILES(l_entity_key_value);

Line 317: update fnd_user

313: l_profiles := fnd_ldap_mapper.MAP_SSO_USER_PROFILES(l_entity_key_value);
314:
315: if (l_profiles.local_login = 'SSO')
316: then
317: update fnd_user
318: set encrypted_user_password = fnd_oid_util.G_EXTERNAL
319: where user_name = l_entity_key_value;
320: end if;
321: