70: X_LAST_UPDATE_LOGIN
71: );
72:
73: -- Added for Function Security Cache Invalidation Project
74: fnd_function_security_cache.insert_resp(X_RESPONSIBILITY_ID, X_APPLICATION_ID);
75:
76: insert into FND_RESPONSIBILITY_TL (
77: APPLICATION_ID,
78: RESPONSIBILITY_ID,
449: if (sql%notfound) then
450: raise no_data_found;
451: else
452: -- Added for Function Security Cache Invalidation Project
453: fnd_function_security_cache.update_resp(X_RESPONSIBILITY_ID,
454: X_APPLICATION_ID);
455:
456: end if;
457:
493: if (sql%notfound) then
494: raise no_data_found;
495: else
496: -- Added for Function Security Cache Invalidation Project
497: fnd_function_security_cache.delete_resp(X_RESPONSIBILITY_ID, X_APPLICATION_ID);
498:
499: end if;
500:
501: delete from FND_RESPONSIBILITY_TL