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 245: if l_automerge_flag = 'N' or (l_automerge_flag = 'Y' and nvl(fnd_profile.value('HZ_PROF_ATTR_DEFAULT'), 'MASTER') <> 'MASTER')

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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