APPS.CAC_SYNC_CONTACT_DQM_PVT dependencies on FND_PROFILE

Line 12: FROM fnd_profile_options_vl

8: RETURN VARCHAR2
9: IS
10: CURSOR c_profile IS
11: SELECT user_profile_option_name
12: FROM fnd_profile_options_vl
13: WHERE profile_option_name = p_profile_option_name;
14:
15: l_user_profile_option_name fnd_profile_options_tl.user_profile_option_name%TYPE;
16: BEGIN

Line 15: l_user_profile_option_name fnd_profile_options_tl.user_profile_option_name%TYPE;

11: SELECT user_profile_option_name
12: FROM fnd_profile_options_vl
13: WHERE profile_option_name = p_profile_option_name;
14:
15: l_user_profile_option_name fnd_profile_options_tl.user_profile_option_name%TYPE;
16: BEGIN
17: OPEN c_profile;
18: FETCH c_profile INTO l_user_profile_option_name;
19: CLOSE c_profile;

Line 272: l_rule_id := fnd_profile.value('HZ_ORG_DUP_PREV_MATCHRULE');

268: THEN
269: fnd_msg_pub.initialize;
270: END IF;
271:
272: l_rule_id := fnd_profile.value('HZ_ORG_DUP_PREV_MATCHRULE');
273:
274: IF l_rule_id IS NULL THEN
275: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_MATCH_RULE_NF');
276: fnd_message.set_token ('P_PROFILE', get_user_profile_name('HZ_ORG_DUP_PREV_MATCHRULE'));

Line 391: l_rule_id := fnd_profile.value('HZ_CON_DUP_PREV_MATCHRULE');

387: END IF;
388:
389: x_return_status := fnd_api.g_ret_sts_success;
390:
391: l_rule_id := fnd_profile.value('HZ_CON_DUP_PREV_MATCHRULE');
392: IF l_rule_id IS NULL THEN
393: fnd_message.set_name ('JTF', 'CAC_SYNC_CONTACT_MATCH_RULE_NF');
394: fnd_message.set_token ('P_PROFILE', get_user_profile_name('HZ_CON_DUP_PREV_MATCHRULE'));
395: fnd_msg_pub.add;