DBA Data[Home] [Help]

APPS.FND_SEC_BULK dependencies on FND_PROFILE

Line 125: from fnd_profile_option_values pov,

121: cursor profile_values is
122: select pov.application_id appid,
123: p.profile_option_name proname,
124: pov.profile_option_value val
125: from fnd_profile_option_values pov,
126: fnd_profile_options p,
127: fnd_user u
128: where pov.level_id = 10004
129: and pov.level_value = u.user_id

Line 126: fnd_profile_options p,

122: select pov.application_id appid,
123: p.profile_option_name proname,
124: pov.profile_option_value val
125: from fnd_profile_option_values pov,
126: fnd_profile_options p,
127: fnd_user u
128: where pov.level_id = 10004
129: and pov.level_value = u.user_id
130: and pov.profile_option_id = p.profile_option_id

Line 144: ret := fnd_profile.save(pvx.proname, pvx.val, 'USER', new_userid, '');

140: null;
141: end;
142:
143: for pvx in profile_values loop
144: ret := fnd_profile.save(pvx.proname, pvx.val, 'USER', new_userid, '');
145: end loop;
146: end;
147:
148: --------------------------------------------------------------------------