APPS.FND_SEC_BULK dependencies on FND_USER_RESP_GROUPS

Line 77: fnd_user_resp_groups ur,

73: to_char(ur.start_date, 'YYYY/MM/DD') start_date,
74: to_char(ur.end_date, 'YYYY/MM/DD') end_date,
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)

Line 99: fnd_user_resp_groups_api.load_row(

95: null;
96: end;
97:
98: for rgx in resp_groups loop
99: fnd_user_resp_groups_api.load_row(
100: x_user_name => upper(p_new_user),
101: x_resp_key => rgx.resp,
102: x_app_short_name => rgx.app,
103: x_security_group => rgx.sg,

Line 265: fnd_user_resp_groups_api.UPLOAD_ASSIGNMENT(

261:
262: EXIT WHEN c%NOTFOUND;
263:
264: -- process each row (user)
265: fnd_user_resp_groups_api.UPLOAD_ASSIGNMENT(
266: USER_ID => uid,
267: RESPONSIBILITY_ID => respid,
268: RESPONSIBILITY_APPLICATION_ID => appid,
269: SECURITY_GROUP_ID => secid,

Line 385: fnd_user_resp_groups_api.UPLOAD_ASSIGNMENT(

381:
382: EXIT WHEN c%NOTFOUND;
383:
384: -- process each row (user)
385: fnd_user_resp_groups_api.UPLOAD_ASSIGNMENT(
386: USER_ID => uid,
387: RESPONSIBILITY_ID => respid,
388: RESPONSIBILITY_APPLICATION_ID => appid,
389: SECURITY_GROUP_ID => secid,

Line 454: 'from fnd_user_resp_groups r '||

450: and responsibility_key = x_responsibility;
451:
452: user_group_clause :=
453: 'select r.user_id, r.security_group_id ' ||
454: 'from fnd_user_resp_groups r '||
455: 'where r.responsibility_id = '||respid||
456: ' and r.security_group_id = '||secid||
457: ' and r.responsibility_application_id = '||appid;
458:

Line 530: 'from fnd_user_resp_groups r '||

526:
527:
528: user_group_clause :=
529: 'select r.user_id, r.security_group_id '||
530: 'from fnd_user_resp_groups r '||
531: 'where r.responsibility_id = '||respid||
532: ' and r.security_group_id = '||secid||
533: ' and r.responsibility_application_id = '||appid;
534: