DBA Data[Home] [Help]

APPS.AME_MIGRATION_PKG dependencies on FND_USER

Line 166: from fnd_user_resp_groups userresp

162: ,users.user_name
163: ,userresp.security_group_id
164: ,appl.application_short_name
165: ,sec.security_group_key
166: from fnd_user_resp_groups userresp
167: ,fnd_responsibility_vl resp
168: ,fnd_user users
169: ,fnd_application appl
170: ,fnd_security_groups sec

Line 168: ,fnd_user users

164: ,appl.application_short_name
165: ,sec.security_group_key
166: from fnd_user_resp_groups userresp
167: ,fnd_responsibility_vl resp
168: ,fnd_user users
169: ,fnd_application appl
170: ,fnd_security_groups sec
171: where resp.responsibility_id = userresp.responsibility_id
172: and resp.responsibility_key in ('AMELIMUSER'

Line 246: fnd_user_pkg.DelResp(username => rec.user_name,

242: ,p_requested_for_user_id => rec.user_id);
243: --+
244: grant_all_rows(p_user_name => rec.user_name);
245: --+
246: fnd_user_pkg.DelResp(username => rec.user_name,
247: resp_app => rec.application_short_name,
248: resp_key =>rec.responsibility_key,
249: security_group => rec.security_group_key);
250: commit;

Line 276: fnd_user_pkg.DelResp (username => rec.user_name,

272: --+
273: l_current_user_id := rec.user_id;
274: end if;
275: --+
276: fnd_user_pkg.DelResp (username => rec.user_name,
277: resp_app => rec.application_short_name,
278: resp_key =>rec.responsibility_key,
279: security_group => rec.security_group_key);
280: commit;

Line 316: fnd_user_pkg.DelResp (username => rec.user_name,

312: end loop;
313: l_current_user_id := rec.user_id;
314: end if;
315: --+
316: fnd_user_pkg.DelResp (username => rec.user_name,
317: resp_app => rec.application_short_name,
318: resp_key =>rec.responsibility_key,
319: security_group => rec.security_group_key);
320: commit;