APPS.ADX_PRF_PKG dependencies on FND_PROFILE

Line 42: old_pv_rec fnd_profile_option_values%rowtype;

38: p_update_only in boolean default FALSE,
39: p_insert_only in boolean default FALSE,
40: p_level_value2 in varchar2 default NULL)
41: IS
42: old_pv_rec fnd_profile_option_values%rowtype;
43: level_value_app_id_temp number;
44: level_name varchar2(30);
45: update_flag varchar2(1);
46: insert_flag varchar2(1);

Line 54: from fnd_profile_option_values

50: begin
51: if (p_level_value2 is NULL) then
52: select *
53: into old_pv_rec
54: from fnd_profile_option_values
55: where (application_id, profile_option_id) in (
56: select application_id, profile_option_id
57: from fnd_profile_options
58: where application_id = p_application_id

Line 57: from fnd_profile_options

53: into old_pv_rec
54: from fnd_profile_option_values
55: where (application_id, profile_option_id) in (
56: select application_id, profile_option_id
57: from fnd_profile_options
58: where application_id = p_application_id
59: and profile_option_name = p_profile_option_name)
60: and level_id = p_level_id;
61: else

Line 64: from fnd_profile_option_values

60: and level_id = p_level_id;
61: else
62: select *
63: into old_pv_rec
64: from fnd_profile_option_values
65: where (application_id, profile_option_id) in (
66: select application_id, profile_option_id
67: from fnd_profile_options
68: where application_id = p_application_id

Line 67: from fnd_profile_options

63: into old_pv_rec
64: from fnd_profile_option_values
65: where (application_id, profile_option_id) in (
66: select application_id, profile_option_id
67: from fnd_profile_options
68: where application_id = p_application_id
69: and profile_option_name = p_profile_option_name)
70: and level_id = p_level_id
71: and level_value = p_level_value

Line 199: -- fnd_profile_option_values table

195: insert_flag;
196: end if;
197:
198: -- Call FND API to update/insert the profile option value in the
199: -- fnd_profile_option_values table
200: -- Note that for setting profiles at the SITE level
201: -- the last 3 parameters defined in the SAVE api are not required.
202:
203: ret_value := FND_PROFILE.SAVE(p_profile_option_name,

Line 203: ret_value := FND_PROFILE.SAVE(p_profile_option_name,

199: -- fnd_profile_option_values table
200: -- Note that for setting profiles at the SITE level
201: -- the last 3 parameters defined in the SAVE api are not required.
202:
203: ret_value := FND_PROFILE.SAVE(p_profile_option_name,
204: p_profile_value,
205: level_name);
206: else
207: str:= 'select count(*)

Line 248: -- fnd_profile_option_values table

244: insert_flag, p_level_value2;
245: end if;
246:
247: -- Call FND API to update/insert the profile option value in the
248: -- fnd_profile_option_values table
249:
250: ret_value := FND_PROFILE.SAVE(p_profile_option_name,
251: p_profile_value,
252: level_name,

Line 250: ret_value := FND_PROFILE.SAVE(p_profile_option_name,

246:
247: -- Call FND API to update/insert the profile option value in the
248: -- fnd_profile_option_values table
249:
250: ret_value := FND_PROFILE.SAVE(p_profile_option_name,
251: p_profile_value,
252: level_name,
253: p_level_value,
254: p_level_value_app_id,