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;