DBA Data[Home] [Help]

APPS.HR_SEC3_UPDATE dependencies on FND_PROFILE

Line 125: from FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V

121: option_value out nocopy varchar2 ,
122: defined out nocopy boolean ) is
123: cursor c1 is
124: select V.PROFILE_OPTION_VALUE
125: from FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V
126: where O.PROFILE_OPTION_NAME = option_name
127: and V.LEVEL_ID = 10003 and V.LEVEL_VALUE = to_char(resp_id)
128: and V.LEVEL_VALUE_APPLICATION_ID = to_char(appl_id)
129: and O.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID

Line 206: if NOT fnd_profile.save ( 'PER_SECURITY_PROFILE_ID',

202: --
203: output_line( 'Setting Security Profile for Resp '||
204: rpad(resp.responsibility_name,30),true) ;
205: --
206: if NOT fnd_profile.save ( 'PER_SECURITY_PROFILE_ID',
207: l_sp_id,
208: 'RESP',
209: resp.responsibility_id,
210: resp.application_id )

Line 222: if NOT fnd_profile.save ( 'PER_BUSINESS_GROUP_ID',

218: output_line( 'Removing Business Group Profile for Resp '||
219: rpad(resp.responsibility_name,30),true) ;
220: --
221: --
222: if NOT fnd_profile.save ( 'PER_BUSINESS_GROUP_ID',
223: null,
224: 'RESP',
225: resp.responsibility_id,
226: resp.application_id )