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:
498: if (sql%notfound) then
499: raise no_data_found;
500: else
501: -- Added for Function Security Cache Invalidation Project
502: fnd_function_security_cache.delete_resp(X_RESPONSIBILITY_ID, X_APPLICATION_ID);
503:
504: end if;
505:
506: delete from FND_RESPONSIBILITY_TL