[Home] [Help]
75: ur.description
76: from fnd_user u,
77: fnd_user_resp_groups ur,
78: fnd_application_vl a,
79: fnd_responsibility_vl r,
80: fnd_security_groups_vl s
81: where u.user_name = upper(p_template_user)
82: and ur.user_id = u.user_id
83: and ur.responsibility_id = r.responsibility_id
224: end;
225:
226: begin
227: select responsibility_id into respid
228: from fnd_responsibility
229: where application_id = appid
230: and responsibility_key = x_responsibility;
231: exception
232: when no_data_found then
346: end;
347:
348: begin
349: select responsibility_id into respid
350: from fnd_responsibility
351: where application_id = appid
352: and responsibility_id = x_responsibility_id;
353: exception
354: when no_data_found then
444: from fnd_security_groups
445: where security_group_key = x_security_group;
446:
447: select responsibility_id into respid
448: from fnd_responsibility
449: where application_id = appid
450: and responsibility_key = x_responsibility;
451:
452: user_group_clause :=
510: from fnd_security_groups
511: where security_group_key = x_security_group;
512:
513: -- There was this upgrade script afpnls01.sql which deleted all the
514: -- 107 responsibility from fnd_responsibility table. So, we have to
515: -- skip this validation for that sake.
516: -- Although the 107 responsibility got deleted from the table but
517: -- all the assignments are still in fnd_user_resp_group table.
518: /*
516: -- Although the 107 responsibility got deleted from the table but
517: -- all the assignments are still in fnd_user_resp_group table.
518: /*
519: select responsibility_id into respid
520: from fnd_responsibility
521: where application_id = appid
522: and responsibility_id = x_responsibility_id;
523: */
524: respid := x_responsibility_id;