eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MERGE_DUP_PVT dependencies on FND_PROFILE

Line 246: if l_automerge_flag = 'N' or (l_automerge_flag = 'Y' and nvl(fnd_profile.value('HZ_PROF_ATTR_DEFAULT'), 'MASTER') <> 'MASTER')

242: open get_automerge_flag_csr;
243: fetch get_automerge_flag_csr into l_automerge_flag;
244: close get_automerge_flag_csr;
245:
246: if l_automerge_flag = 'N' or (l_automerge_flag = 'Y' and nvl(fnd_profile.value('HZ_PROF_ATTR_DEFAULT'), 'MASTER') <> 'MASTER')
247: then
248:
249: SELECT decode(party_type,'PERSON','HZ_PERSON_PROFILES',
250: 'ORGANIZATION','HZ_ORGANIZATION_PROFILES',

Line 301: l_addr_match_rule := fnd_profile.value('HZ_SUGG_ADDR_MATCH_RULE');

297: -- suggested default mapping at the beginning
298: -- or if automerge profile is on(pass 'Y' to p_default_mapping)
299: -- and it's an automerge dupset.
300:
301: l_addr_match_rule := fnd_profile.value('HZ_SUGG_ADDR_MATCH_RULE');
302: l_reln_match_rule := fnd_profile.value('HZ_SUGG_RELN_MATCH_RULE');
303:
304: -- Address
305: IF(fnd_profile.value('HZ_SHOW_SUGG_ADDR') = 'Y'

Line 302: l_reln_match_rule := fnd_profile.value('HZ_SUGG_RELN_MATCH_RULE');

298: -- or if automerge profile is on(pass 'Y' to p_default_mapping)
299: -- and it's an automerge dupset.
300:
301: l_addr_match_rule := fnd_profile.value('HZ_SUGG_ADDR_MATCH_RULE');
302: l_reln_match_rule := fnd_profile.value('HZ_SUGG_RELN_MATCH_RULE');
303:
304: -- Address
305: IF(fnd_profile.value('HZ_SHOW_SUGG_ADDR') = 'Y'
306: or (l_automerge_flag = 'Y' and l_addr_match_rule <>0 and l_addr_match_rule is not null )) THEN

Line 305: IF(fnd_profile.value('HZ_SHOW_SUGG_ADDR') = 'Y'

301: l_addr_match_rule := fnd_profile.value('HZ_SUGG_ADDR_MATCH_RULE');
302: l_reln_match_rule := fnd_profile.value('HZ_SUGG_RELN_MATCH_RULE');
303:
304: -- Address
305: IF(fnd_profile.value('HZ_SHOW_SUGG_ADDR') = 'Y'
306: or (l_automerge_flag = 'Y' and l_addr_match_rule <>0 and l_addr_match_rule is not null )) THEN
307: apply_suggested_default(l_batch_id, 'HZ_PARTY_SITES', x_return_status, x_msg_count, x_msg_data);
308: END IF;
309: -- Relationship

Line 310: IF(fnd_profile.value('HZ_SHOW_SUGG_RELN') = 'Y'

306: or (l_automerge_flag = 'Y' and l_addr_match_rule <>0 and l_addr_match_rule is not null )) THEN
307: apply_suggested_default(l_batch_id, 'HZ_PARTY_SITES', x_return_status, x_msg_count, x_msg_data);
308: END IF;
309: -- Relationship
310: IF(fnd_profile.value('HZ_SHOW_SUGG_RELN') = 'Y'
311: or (l_automerge_flag = 'Y' and l_reln_match_rule <>0 and l_reln_match_rule is not null)) THEN
312: apply_suggested_default(l_batch_id, 'HZ_PARTY_RELATIONSHIPS', x_return_status, x_msg_count, x_msg_data);
313: END IF;
314:

Line 2263: l_addr_match_rule := nvl(fnd_profile.value('HZ_SUGG_ADDR_MATCH_RULE'),l_default_addr_rule);

2259: select min(match_rule_id) into l_default_relat_rule
2260: from HZ_MATCH_RULES_VL
2261: where rule_name = 'DL RELATIONSHIP DEFAULT';
2262:
2263: l_addr_match_rule := nvl(fnd_profile.value('HZ_SUGG_ADDR_MATCH_RULE'),l_default_addr_rule);
2264: l_reln_match_rule := nvl(fnd_profile.value('HZ_SUGG_RELN_MATCH_RULE'),l_default_relat_rule);
2265:
2266: if((l_addr_match_rule = 0) OR (l_reln_match_rule = 0)) then
2267: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_MATCH_RULE');

Line 2264: l_reln_match_rule := nvl(fnd_profile.value('HZ_SUGG_RELN_MATCH_RULE'),l_default_relat_rule);

2260: from HZ_MATCH_RULES_VL
2261: where rule_name = 'DL RELATIONSHIP DEFAULT';
2262:
2263: l_addr_match_rule := nvl(fnd_profile.value('HZ_SUGG_ADDR_MATCH_RULE'),l_default_addr_rule);
2264: l_reln_match_rule := nvl(fnd_profile.value('HZ_SUGG_RELN_MATCH_RULE'),l_default_relat_rule);
2265:
2266: if((l_addr_match_rule = 0) OR (l_reln_match_rule = 0)) then
2267: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_MATCH_RULE');
2268: FND_MSG_PUB.ADD;

Line 3908: IF (NVL(FND_PROFILE.VALUE('HZ_DL_CREATE_SUGG_MERGE_REQ'), 'Y') = 'Y') THEN

3904: BEGIN
3905:
3906: x_return_status := FND_API.G_RET_STS_SUCCESS;
3907:
3908: IF (NVL(FND_PROFILE.VALUE('HZ_DL_CREATE_SUGG_MERGE_REQ'), 'Y') = 'Y') THEN
3909:
3910: open is_sugg_request_done_csr;
3911: fetch is_sugg_request_done_csr into l_count;
3912: close is_sugg_request_done_csr;

Line 4071: end if; -- (NVL(FND_PROFILE.VALUE('HZ_DL_CREATE_SUGG_MERGE_REQ')

4067:
4068: END LOOP;
4069: CLOSE get_reln_party_sp;
4070: END IF;
4071: end if; -- (NVL(FND_PROFILE.VALUE('HZ_DL_CREATE_SUGG_MERGE_REQ')
4072:
4073: EXCEPTION
4074:
4075: WHEN FND_API.G_EXC_ERROR THEN