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_ENTITY_ATTRI_PVT dependencies on FND_PROFILE

Line 537: IF (NVL(FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE'), '-222') <> 'HR API') THEN

533: -- out NOCOPY the columns are not supported in hz_party_v2pub.person_rec
534:
535: IF (NVL(p_orig_sys_ref,'X') LIKE 'PER:%') THEN -- bug no: 4193165
536:
537: IF (NVL(FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE'), '-222') <> 'HR API') THEN
538:
539: IF (NVL(FND_PROFILE.VALUE('HZ_PROTECT_HR_PERSON_INFO'),'N') ='Y') THEN --Update HR sensitive columns
540:
541: IF L_ATTRIBUTE_NAME = 'GENDER' THEN

Line 539: IF (NVL(FND_PROFILE.VALUE('HZ_PROTECT_HR_PERSON_INFO'),'N') ='Y') THEN --Update HR sensitive columns

535: IF (NVL(p_orig_sys_ref,'X') LIKE 'PER:%') THEN -- bug no: 4193165
536:
537: IF (NVL(FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE'), '-222') <> 'HR API') THEN
538:
539: IF (NVL(FND_PROFILE.VALUE('HZ_PROTECT_HR_PERSON_INFO'),'N') ='Y') THEN --Update HR sensitive columns
540:
541: IF L_ATTRIBUTE_NAME = 'GENDER' THEN
542: L_PERSON_REC.GENDER := L_ATTRIBUTE_VALUE;
543: ELSIF L_ATTRIBUTE_NAME = 'DATE_OF_BIRTH' THEN

Line 584: END IF; --For IF (NVL(FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE'), '-222') <> 'HR API')

580: ELSIF L_ATTRIBUTE_NAME = 'MARITAL_STATUS' THEN
581: L_PERSON_REC.MARITAL_STATUS := L_ATTRIBUTE_VALUE;
582: END IF;
583:
584: END IF; --For IF (NVL(FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE'), '-222') <> 'HR API')
585:
586: ELSE --orig_sys_ref other than 'PER:%'
587: IF L_ATTRIBUTE_NAME = 'PERSON_FIRST_NAME' THEN
588: L_PERSON_REC.PERSON_FIRST_NAME := L_ATTRIBUTE_VALUE;

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

856: close get_automerge_flag_csr;
857:
858: if p_entity_name = 'HZ_ORGANIZATION_PROFILES'
859: then
860: if l_automerge_flag = 'N' or (l_automerge_flag = 'Y' and nvl(fnd_profile.value('HZ_PROF_ATTR_DEFAULT'), 'MASTER') <> 'MASTER')
861: then
862: open get_obj_version_csr;
863: fetch get_obj_version_csr into l_object_version_number,l_orig_sys_ref;
864: close get_obj_version_csr;

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

892: where party_id = p_merge_to_party_id
893: and sysdate between effective_start_date and nvl(effective_end_date,sysdate);
894: end if; -- if l_automerge_flag = 'N'
895: elsif p_entity_name = 'HZ_PERSON_PROFILES' then
896: if l_automerge_flag = 'N' or (l_automerge_flag = 'Y' and nvl(fnd_profile.value('HZ_PROF_ATTR_DEFAULT'), 'MASTER') <> 'MASTER')
897: then
898: open get_obj_version_csr;
899: fetch get_obj_version_csr into l_object_version_number, l_orig_sys_ref;
900: close get_obj_version_csr;

Line 1149: -- l_attri_def_prof := nvl(fnd_profile.value('HZ_PROF_ATTR_DEFAULT'), 'MASTER');

1145: l_attri_def_prof varchar2(30);
1146: l_attri_def_next_prof varchar2(30);
1147: begin
1148:
1149: -- l_attri_def_prof := nvl(fnd_profile.value('HZ_PROF_ATTR_DEFAULT'), 'MASTER');
1150: l_attri_def_next_prof := nvl(fnd_profile.value('HZ_PROF_ATTR_DEFAULT_NEXT'), 'LATEST_UPDATE_DATE');
1151:
1152: if p_entity_name = 'HZ_ORGANIZATION_PROFILES'
1153: then

Line 1150: l_attri_def_next_prof := nvl(fnd_profile.value('HZ_PROF_ATTR_DEFAULT_NEXT'), 'LATEST_UPDATE_DATE');

1146: l_attri_def_next_prof varchar2(30);
1147: begin
1148:
1149: -- l_attri_def_prof := nvl(fnd_profile.value('HZ_PROF_ATTR_DEFAULT'), 'MASTER');
1150: l_attri_def_next_prof := nvl(fnd_profile.value('HZ_PROF_ATTR_DEFAULT_NEXT'), 'LATEST_UPDATE_DATE');
1151:
1152: if p_entity_name = 'HZ_ORGANIZATION_PROFILES'
1153: then
1154: open get_leader_attribute_name_csr('ORG_PROFILE_CATEGORY');

Line 1437: l_attri_def_next_prof := nvl(fnd_profile.value('HZ_PROF_ATTR_DEFAULT_NEXT'), 'LATEST_UPDATE_DATE');

1433: l_attri_party_id number;
1434: l_derived_date date;
1435: begin
1436: x_return_status := fnd_api.g_ret_sts_success;
1437: l_attri_def_next_prof := nvl(fnd_profile.value('HZ_PROF_ATTR_DEFAULT_NEXT'), 'LATEST_UPDATE_DATE');
1438: if l_attri_def_next_prof = 'LATEST_UPDATE_DATE'
1439: then
1440: l_date_clause := 'LAST_UPDATE_DATE';
1441: l_order_by_clause := ' order by LAST_UPDATE_DATE DESC';

Line 1620: l_prof_value := nvl(fnd_profile.value('HZ_PROF_ATTR_DEFAULT'), 'MASTER');

1616: FND_MSG_PUB.ADD;
1617: RAISE FND_API.G_EXC_ERROR;
1618: end if;
1619:
1620: l_prof_value := nvl(fnd_profile.value('HZ_PROF_ATTR_DEFAULT'), 'MASTER');
1621: --dbms_output.put_line('profile value '|| l_prof_value);
1622: if l_prof_value = 'MASTER'
1623: then l_selected_party_id := p_merge_to_party_id;
1624: elsif l_prof_value = 'LATEST_UPDATE_DATE'