APPS.HZ_PARTY_MERGE dependencies on FND_PROFILE

Line 612: l_dss_orig_prof_val := NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N');

608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
609: END IF;
610:
611: -- Disable DSS in party merge for sub entities. Will enabled it at the end of the merge.
612: l_dss_orig_prof_val := NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N');
613: if l_dss_orig_prof_val = 'Y'
614: then
615: fnd_profile.put('HZ_DSS_ENABLED','N');
616: end if;

Line 615: fnd_profile.put('HZ_DSS_ENABLED','N');

611: -- Disable DSS in party merge for sub entities. Will enabled it at the end of the merge.
612: l_dss_orig_prof_val := NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N');
613: if l_dss_orig_prof_val = 'Y'
614: then
615: fnd_profile.put('HZ_DSS_ENABLED','N');
616: end if;
617:
618: open c_dict_no_fktype;
619: loop

Line 1233: fnd_profile.put('HZ_DSS_ENABLED',l_dss_orig_prof_val);

1229: END IF;
1230: END IF;
1231:
1232: -- set back orig. DSS profile
1233: fnd_profile.put('HZ_DSS_ENABLED',l_dss_orig_prof_val);
1234:
1235: hz_common_pub.enable_cont_source_security;
1236:
1237: IF g_inv_merge_dict is not null THEN

Line 1674: IF FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') IS NOT NULL THEN

1670: then
1671: l_pmerge_apps := G_TCA_APP_ID;
1672: else
1673:
1674: IF FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') IS NOT NULL THEN
1675: l_pmerge_apps := '(' || G_TCA_APP_ID || ', ' ||
1676: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';
1677: END IF;
1678: END IF;

Line 1676: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';

1672: else
1673:
1674: IF FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') IS NOT NULL THEN
1675: l_pmerge_apps := '(' || G_TCA_APP_ID || ', ' ||
1676: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';
1677: END IF;
1678: END IF;
1679:
1680: IF l_pmerge_apps IS NOT NULL THEN

Line 2176: IF FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') IS NOT NULL THEN

2172: RETURN;
2173: END IF;
2174:
2175: IF lockstr IS NOT NULL THEN
2176: IF FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') IS NOT NULL THEN
2177: l_pmerge_apps := '(' || G_TCA_APP_ID || ', ' ||
2178: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';
2179: OPEN c_dict_details FOR
2180: 'SELECT ENTITY_NAME, PK_COLUMN_NAME, FK_COLUMN_NAME, JOIN_CLAUSE, DICT_APPLICATION_ID'||

Line 2178: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';

2174:
2175: IF lockstr IS NOT NULL THEN
2176: IF FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') IS NOT NULL THEN
2177: l_pmerge_apps := '(' || G_TCA_APP_ID || ', ' ||
2178: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';
2179: OPEN c_dict_details FOR
2180: 'SELECT ENTITY_NAME, PK_COLUMN_NAME, FK_COLUMN_NAME, JOIN_CLAUSE, DICT_APPLICATION_ID'||
2181: 'FROM HZ_MERGE_DICTIONARY ' ||
2182: 'WHERE PARENT_ENTITY_NAME = :pentity' ||