APPS.HZ_PARTY_MERGE dependencies on FND_PROFILE

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

585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
586: END IF;
587:
588: -- Disable DSS in party merge for sub entities. Will enabled it at the end of the merge.
589: l_dss_orig_prof_val := NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N');
590: if l_dss_orig_prof_val = 'Y'
591: then
592: fnd_profile.put('HZ_DSS_ENABLED','N');
593: end if;

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

588: -- Disable DSS in party merge for sub entities. Will enabled it at the end of the merge.
589: l_dss_orig_prof_val := NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N');
590: if l_dss_orig_prof_val = 'Y'
591: then
592: fnd_profile.put('HZ_DSS_ENABLED','N');
593: end if;
594:
595: open c_dict_no_fktype;
596: loop

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

1192: END IF;
1193: END IF;
1194:
1195: -- set back orig. DSS profile
1196: fnd_profile.put('HZ_DSS_ENABLED',l_dss_orig_prof_val);
1197:
1198: hz_common_pub.enable_cont_source_security;
1199:
1200: IF g_inv_merge_dict is not null THEN

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

1630: then
1631: l_pmerge_apps := G_TCA_APP_ID;
1632: else
1633:
1634: IF FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') IS NOT NULL THEN
1635: l_pmerge_apps := '(' || G_TCA_APP_ID || ', ' ||
1636: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';
1637: END IF;
1638: END IF;

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

1632: else
1633:
1634: IF FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') IS NOT NULL THEN
1635: l_pmerge_apps := '(' || G_TCA_APP_ID || ', ' ||
1636: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';
1637: END IF;
1638: END IF;
1639:
1640: IF l_pmerge_apps IS NOT NULL THEN

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

2132: RETURN;
2133: END IF;
2134:
2135: IF lockstr IS NOT NULL THEN
2136: IF FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') IS NOT NULL THEN
2137: l_pmerge_apps := '(' || G_TCA_APP_ID || ', ' ||
2138: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';
2139: OPEN c_dict_details FOR
2140: 'SELECT ENTITY_NAME, PK_COLUMN_NAME, FK_COLUMN_NAME, JOIN_CLAUSE, DICT_APPLICATION_ID'||

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

2134:
2135: IF lockstr IS NOT NULL THEN
2136: IF FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') IS NOT NULL THEN
2137: l_pmerge_apps := '(' || G_TCA_APP_ID || ', ' ||
2138: FND_PROFILE.VALUE('HZ_PARTY_MERGE_APPLICATIONS') || ')';
2139: OPEN c_dict_details FOR
2140: 'SELECT ENTITY_NAME, PK_COLUMN_NAME, FK_COLUMN_NAME, JOIN_CLAUSE, DICT_APPLICATION_ID'||
2141: 'FROM HZ_MERGE_DICTIONARY ' ||
2142: 'WHERE PARENT_ENTITY_NAME = :pentity' ||