APPS.ADX_PRF_PKG dependencies on FND_PROFILE_OPTION_VALUES

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 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 188: -- fnd_profile_option_values table

184: insert_flag;
185: end if;
186:
187: -- Call FND API to update/insert the profile option value in the
188: -- fnd_profile_option_values table
189: -- Note that for setting profiles at the SITE level
190: -- the last 3 parameters defined in the SAVE api are not required.
191:
192: ret_value := FND_PROFILE.SAVE(p_profile_option_name,

Line 237: -- fnd_profile_option_values table

233: insert_flag, p_level_value2;
234: end if;
235:
236: -- Call FND API to update/insert the profile option value in the
237: -- fnd_profile_option_values table
238:
239: ret_value := FND_PROFILE.SAVE(p_profile_option_name,
240: p_profile_value,
241: level_name,