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,
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,
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,