[Home] [Help]
522: app_exception.raise_exception;
523: else
524: -- bug 8227171 relocated the user_id fetch higher up.
525: -- Added for Function Security Cache Invalidation
526: fnd_function_security_cache.update_user(l_user_id);
527: end if;
528:
529:
530: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2187: set customer_id = p_to_fk_id
2188: where customer_id = p_from_fk_id;
2189:
2190: -- Added for Function Security Cache Invalidation
2191: fnd_function_security_cache.update_user(p_from_id);
2192:
2193: end if;
2194:
2195: end MergeCustomer;
3655: app_exception.raise_exception;
3656: else
3657:
3658: -- Added for Function Security Cache Invalidation
3659: fnd_function_security_cache.delete_user(l_user_id);
3660:
3661: -- Bug 13824550
3662: -- A pending user was deleted...now need to remove this user from the WF
3663: -- tables by raising this event.
3863: into l_user_id
3864: from fnd_user
3865: where user_name = upper(x_new_user_name);
3866:
3867: fnd_function_security_cache.update_user(l_user_id);
3868:
3869: -- propagate username change to WF and entity mgr
3870: tmpbuf := 'Start calling fnd_user_pkg.user_synch('||x_new_user_name||')';
3871: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3991: set person_party_id = p_to_fk_id
3992: where person_party_id = p_from_fk_id;
3993:
3994: -- Added for Function Security Cache Invalidation
3995: fnd_function_security_cache.update_user(p_from_id);
3996:
3997: end if;
3998:
3999: end MergePartyId;
4437: -- Get the profile value at the user level for the affected user and
4438: -- encrypt accordingly. If not set at the user level, this will default to
4439: -- the site level profile value.
4440: /* Code change for bug 7043484 */
4441: isOverrideFuncAssigned := fnd_function.test('OVERRIDE_PASSWORD_POLICY_PERM','N');
4442: if(isOverrideFuncAssigned = true) then
4443: pwdCaseOpt := fnd_profile.value('SIGNON_PASSWORD_CASE');
4444: else
4445: pwdCaseOpt := fnd_profile.value_specific('SIGNON_PASSWORD_CASE', userid);